Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
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'