...
Code Block | ||
---|---|---|
| ||
SELECT 'FA561210' || stvterm.STVTERM_MIS_TERM_ID || gv_mis_global_bp.f_get_identifier ( tbraccd_PIDM, gb_common.f_get_id (tbraccd_PIDM), goksels.f_name_bio_value (tbraccd_PIDM, 'SSN')) || 'GW01000 ' AS FA_LINE FROM tbraccd INNER JOIN stvterm ON stvterm_code = tbraccd_Term_code WHERE tbraccd_detail_code = 'CRFD' AND tbraccd_term_code = '202210' |