936:
937:
938: Begin
939: SELECT to_char(PPT.PAYMENT_TYPE_ID) into ln_nacha_payment_type_id
940: FROM PAY_PAYMENT_TYPES PPT,
941: PER_BUSINESS_GROUPS BG
942: WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
943: AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
944: OR PPT.TERRITORY_CODE IS NULL)
954:
955: Begin
956: SELECT to_char(PPT.PAYMENT_TYPE_ID)
957: into ln_check_payment_type_id
958: FROM PAY_PAYMENT_TYPES PPT,
959: PER_BUSINESS_GROUPS BG
960: WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
961: AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
962: OR PPT.TERRITORY_CODE IS NULL)
2659:
2660:
2661: Begin
2662: SELECT to_char(PPT.PAYMENT_TYPE_ID) into ln_nacha_payment_type_id
2663: FROM PAY_PAYMENT_TYPES PPT,
2664: PER_BUSINESS_GROUPS BG
2665: WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
2666: AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
2667: OR PPT.TERRITORY_CODE IS NULL)
2677:
2678: Begin
2679: SELECT to_char(PPT.PAYMENT_TYPE_ID)
2680: into ln_check_payment_type_id
2681: FROM PAY_PAYMENT_TYPES PPT,
2682: PER_BUSINESS_GROUPS BG
2683: WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
2684: AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
2685: OR PPT.TERRITORY_CODE IS NULL)