APPS.PER_HU_EMP_CERT_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 397: FROM pay_element_entries_f pee

393: ||decode(addr.loc_information15, NULL, NULL, addr.loc_information15||'.')
394: ||decode(addr.loc_information16, NULL, NULL, addr.loc_information16||'.')
395: ||decode(addr.loc_information17, NULL, NULL, addr.loc_information17||'.') address
396: ,pee.personal_payment_method_id payment_method_id
397: FROM pay_element_entries_f pee
398: ,pay_element_entry_values_f eev
399: ,pay_input_values_f piv
400: ,pay_element_types_f pet
401: ,pay_element_type_extra_info pei

Line 435: FROM pay_element_entries_f pee

431:
432: --
433: CURSOR csr_element_start_date(p_element_entry_id NUMBER) IS
434: SELECT min(pee.effective_start_date)
435: FROM pay_element_entries_f pee
436: WHERE pee.element_entry_id = p_element_entry_id;
437: --
438: CURSOR csr_absence_days(c_person_id NUMBER
439: ,c_termination_year VARCHAR2) IS

Line 498: l_ele_entry_start_date pay_element_entries_f.effective_start_date%TYPE;

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