DBA Data[Home] [Help]

APPS.PAY_WF_PKG dependencies on PAY_PAYMENT_TYPES

Line 940: FROM PAY_PAYMENT_TYPES PPT,

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)

Line 958: FROM PAY_PAYMENT_TYPES PPT,

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)

Line 2663: FROM PAY_PAYMENT_TYPES PPT,

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)

Line 2681: FROM PAY_PAYMENT_TYPES PPT,

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)