APPS.PAY_NZ_EFT dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 59: ,pay_personal_payment_methods_f ppmf

55: ,c_effective_date DATE)
56: IS
57: SELECT SUBSTR(pea.segment1,3,4)||SUBSTR(LPAD(pea.segment2,8,'0'),2,7)
58: FROM pay_pre_payments ppp
59: ,pay_personal_payment_methods_f ppmf
60: ,pay_external_accounts pea
61: WHERE ppp.pre_payment_id = c_pre_payment_id
62: AND ppp.personal_payment_method_id = ppmf.personal_payment_method_id
63: AND ppmf.external_account_id = pea.external_account_id