523: and Pay_Magtape_Generic.Get_Parameter_Value
524: ('TRANSFER_STATE') = 'FED'
525: UNION ALL
526: select 'TRANSFER_STATE_NAME=P', 'SC'
527: from dual
528: where Pay_Magtape_Generic.Get_Parameter_Value
529: ('TRANSFER_STATE') = 'SC'
530: UNION ALL
531: select 'TRANSFER_STATE_NAME=P', 'ID'
528: where Pay_Magtape_Generic.Get_Parameter_Value
529: ('TRANSFER_STATE') = 'SC'
530: UNION ALL
531: select 'TRANSFER_STATE_NAME=P', 'ID'
532: from dual
533: where Pay_Magtape_Generic.Get_Parameter_Value
534: ('TRANSFER_STATE') = 'ID'
535: UNION ALL
536: select 'TRANSFER_STATE_NAME=P', 'NE'
533: where Pay_Magtape_Generic.Get_Parameter_Value
534: ('TRANSFER_STATE') = 'ID'
535: UNION ALL
536: select 'TRANSFER_STATE_NAME=P', 'NE'
537: from dual
538: where Pay_Magtape_Generic.Get_Parameter_Value
539: ('TRANSFER_STATE') = 'NE'
540: UNION ALL
541: select 'TRANSFER_STATE_NAME=P', 'VT'
538: where Pay_Magtape_Generic.Get_Parameter_Value
539: ('TRANSFER_STATE') = 'NE'
540: UNION ALL
541: select 'TRANSFER_STATE_NAME=P', 'VT'
542: from dual
543: where Pay_Magtape_Generic.Get_Parameter_Value
544: ('TRANSFER_STATE') = 'VT'
545: ;
546: