668:
669:
670: Begin
671: SELECT to_char(PPT.PAYMENT_TYPE_ID) into ln_nacha_payment_type_id
672: FROM PAY_PAYMENT_TYPES PPT,
673: PER_BUSINESS_GROUPS BG
674: WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
675: AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
676: OR PPT.TERRITORY_CODE IS NULL)
686:
687: Begin
688: SELECT to_char(PPT.PAYMENT_TYPE_ID)
689: into ln_check_payment_type_id
690: FROM PAY_PAYMENT_TYPES PPT,
691: PER_BUSINESS_GROUPS BG
692: WHERE ( ((PPT.TERRITORY_CODE IS NOT NULL
693: AND PPT.TERRITORY_CODE=BG.LEGISLATION_CODE)
694: OR PPT.TERRITORY_CODE IS NULL)