APPS.PER_HU_EMP_CERT_ARCHIVE dependencies on PAY_EXTERNAL_ACCOUNTS

Line 426: ,pay_external_accounts pea

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
430: AND ppp.effective_end_date;

Line 501: l_account_no pay_external_accounts.segment2%TYPE;

497: l_pension_provider_code hr_lookups.lookup_code%TYPE;
498: l_ele_entry_start_date pay_element_entries_f.effective_start_date%TYPE;
499: l_pre_emp_sickness_holiday per_previous_employers.pem_information1%TYPE;
500: l_total_sickness_holiday NUMBER;
501: l_account_no pay_external_accounts.segment2%TYPE;
502: l_absence_days NUMBER;
503:
504: TYPE t_vpp_name IS TABLE OF hr_organization_units.name%type INDEX BY BINARY_INTEGER;
505: l_vpp_name t_vpp_name;