DBA Data[Home] [Help]

APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 567: ,pay_element_entry_values_f peev

563:
564: CURSOR csr_get_ss_id(c_assignment_id number, c_effective_date date) IS
565: SELECT screen_entry_value ss_id
566: FROM pay_element_entries_f peef
567: ,pay_element_entry_values_f peev
568: ,pay_input_values_f piv
569: ,pay_element_types_f pet
570: WHERE pet.element_name = 'Social Security Details'
571: AND piv.element_type_id = pet.element_type_id

Line 743: ,pay_element_entry_values_f eev

739: ,min(decode(piv.name, 'IA ID Contribution', eev.screen_entry_value, null)) ia_id_contribution
740: ,min(decode(piv.name, 'Note', eev.screen_entry_value, null)) note
741: ,min(decode(p_type,'S',decode(piv.name, 'Last TD Report Paid', eev.screen_entry_value, null),null)) last_TD_date
742: FROM pay_element_entries_f pee
743: ,pay_element_entry_values_f eev
744: ,pay_input_values_f piv
745: ,pay_element_types_f pet
746: WHERE pee.element_entry_id = eev.element_entry_id
747: AND c_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date