APPS.PER_HU_EMP_CERT_ARCHIVE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 425: FROM pay_personal_payment_methods_f ppp

421: AND pee.effective_end_date;
422: --
423: CURSOR csr_account_details(c_effective_date date,c_payment_method_id number)IS
424: SELECT pea.segment2 bank_ac_no
425: FROM pay_personal_payment_methods_f ppp
426: ,pay_external_accounts pea
427: WHERE ppp.personal_payment_method_id = c_payment_method_id
428: AND ppp.external_account_id = pea.external_account_id
429: AND c_effective_date BETWEEN ppp.effective_start_date