517: and Pay_Magtape_Generic.Get_Parameter_Value
518: ('TRANSFER_STATE') = 'FED'
519: UNION ALL
520: select 'TRANSFER_STATE_NAME=P', 'SC'
521: from dual
522: where Pay_Magtape_Generic.Get_Parameter_Value
523: ('TRANSFER_STATE') = 'SC'
524: UNION ALL
525: select 'TRANSFER_STATE_NAME=P', 'ID'
522: where Pay_Magtape_Generic.Get_Parameter_Value
523: ('TRANSFER_STATE') = 'SC'
524: UNION ALL
525: select 'TRANSFER_STATE_NAME=P', 'ID'
526: from dual
527: where Pay_Magtape_Generic.Get_Parameter_Value
528: ('TRANSFER_STATE') = 'ID'
529: UNION ALL
530: select 'TRANSFER_STATE_NAME=P', 'NE'
527: where Pay_Magtape_Generic.Get_Parameter_Value
528: ('TRANSFER_STATE') = 'ID'
529: UNION ALL
530: select 'TRANSFER_STATE_NAME=P', 'NE'
531: from dual
532: where Pay_Magtape_Generic.Get_Parameter_Value
533: ('TRANSFER_STATE') = 'NE'
534: ;
535: