APPS.PER_HU_EMP_CERT_ARCHIVE dependencies on HR_LOOKUPS

Line 479: FROM hr_lookups hrl

475:
476: --
477: CURSOR csr_pension_provider_code(c_meaning VARCHAR)IS
478: SELECT hrl.lookup_code
479: FROM hr_lookups hrl
480: WHERE hrl.lookup_type = 'HU_PENSION_PROVIDERS'
481: AND hrl.meaning = c_meaning
482: AND hrl.enabled_flag = 'Y' ;
483: --

Line 497: l_pension_provider_code hr_lookups.lookup_code%TYPE;

493: l_start_date DATE;
494: l_end_date DATE;
495: l_business_group_id NUMBER;
496: l_issue_date DATE;
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;