DBA Data[Home] [Help]

APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 566: FROM pay_element_entries_f peef

562:
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'

Line 742: FROM pay_element_entries_f pee

738: ,min(decode(piv.name, 'Regular Situation Base', eev.screen_entry_value, null)) rs_cont_base
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