APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 39: ,pay_element_links_f l

35: FROM pay_element_entries_f e
36: ,pay_input_values_f i
37: ,pay_element_entry_values_f v
38: ,pay_element_types_f t
39: ,pay_element_links_f l
40: WHERE e.element_entry_id = v.element_entry_id
41: AND v.input_value_id = i.input_value_id
42: AND i.legislation_code = 'ES'
43: AND i.element_type_id = t.element_type_id

Line 467: ,pay_element_links_f pel

463: FROM pay_element_entry_values_f pev
464: ,pay_input_values_f piv
465: ,pay_element_types_f pet
466: ,pay_element_entries_f pee
467: ,pay_element_links_f pel
468: ,per_all_assignments_f paf
469: WHERE paf.person_id = c_person_id
470: AND pee.assignment_id = paf.assignment_id
471: AND pev.element_entry_id = pee.element_entry_id

Line 494: ,pay_element_links_f pel

490: FROM pay_element_entry_values_f pev
491: ,pay_input_values_f piv
492: ,pay_element_types_f pet
493: ,pay_element_entries_f pee
494: ,pay_element_links_f pel
495: WHERE pee.assignment_id = c_assignment_id
496: AND pev.element_entry_id = pee.element_entry_id
497: AND piv.input_value_id = pev.input_value_id
498: AND piv.name = 'Social Security Identifier'

Line 520: ,pay_element_links_f l

516: FROM pay_element_entries_f e
517: ,pay_input_values_f i
518: ,pay_element_entry_values_f v
519: ,pay_element_types_f t
520: ,pay_element_links_f l
521: WHERE e.element_entry_id = v.element_entry_id
522: AND v.input_value_id = i.input_value_id
523: AND i.element_type_id = t.element_type_id
524: AND i.legislation_code = 'ES'

Line 779: ,pay_element_links_f pel

775: FROM pay_element_entry_values_f pev
776: ,pay_input_values_f piv
777: ,pay_element_types_f pet
778: ,pay_element_entries_f pee
779: ,pay_element_links_f pel
780: WHERE pev.element_entry_id = pee.element_entry_id
781: AND pee.assignment_id = c_assignment_id
782: AND pev.input_value_id = piv.input_value_id
783: AND piv.element_type_id = pet.element_type_id