APPS.PER_HU_EMP_CERT_ARCHIVE dependencies on PER_PREVIOUS_EMPLOYERS

Line 470: FROM per_previous_employers

466: CURSOR csr_pre_emp_sickness_holiday(c_person_id NUMBER
467: ,c_termination_year VARCHAR2
468: ,c_business_group_id NUMBER) IS
469: SELECT pem_information1
470: FROM per_previous_employers
471: WHERE business_group_id = c_business_group_id
472: AND person_id = c_person_id
473: AND to_char(end_date,'YYYY') = c_termination_year
474: ORDER BY end_date DESC;

Line 499: l_pre_emp_sickness_holiday per_previous_employers.pem_information1%TYPE;

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;
502: l_absence_days NUMBER;
503: