APPS.PAY_US_NACHA_TAPE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 877: from PAY_PERSONAL_PAYMENT_METHODS_F b

873: g_effective_date)
874: where a.PRENOTE_DATE is null
875: and a.EXTERNAL_ACCOUNT_ID =
876: ( select b.EXTERNAL_ACCOUNT_ID
877: from PAY_PERSONAL_PAYMENT_METHODS_F b
878: where b.PERSONAL_PAYMENT_METHOD_ID =
879: g_personal_payment_method_id
880: and g_effective_date between b.EFFECTIVE_START_DATE
881: and b.EFFECTIVE_END_DATE);

Line 1500: FROM pay_external_accounts pea, pay_personal_payment_methods_f ppm,

1496: IS
1497:
1498: CURSOR csr_get_payee_bank_details IS
1499: SELECT pea.segment1,pea.segment3,pea.segment5,pea.segment6
1500: FROM pay_external_accounts pea, pay_personal_payment_methods_f ppm,
1501: pay_payroll_actions ppa
1502: WHERE ppa.payroll_action_id = p_payroll_action_id
1503: AND ppm.personal_payment_method_id = p_personal_payment_method_id
1504: AND ppa.effective_date BETWEEN ppm.effective_start_date AND ppm.effective_end_date