eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ES_SS_REP_ARCHIVE_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 35: FROM pay_element_entries_f e

31: ,min(decode(i.name,'Contract Indicators',substr(v.screen_entry_value,5,1),NULL)) AS Under_Represented_Women_Code
32: ,min(decode(i.name,'Contract Indicators',substr(v.screen_entry_value,6,1),NULL)) AS After_Childbirth_Code
33: ,min(decode(i.name,'Contract Indicators',substr(v.screen_entry_value,1,1),NULL)) AS Active_Rent_Flag
34: ,min(decode(i.name,'Contract Indicators',substr(v.screen_entry_value,4,1),NULL)) AS Minority_Group_Flag
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

Line 466: ,pay_element_entries_f pee

462: SELECT nvl(pev.screen_entry_value, 'X') screen_entry_value
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

Line 493: ,pay_element_entries_f pee

489: SELECT nvl(pev.screen_entry_value, 'X') screen_entry_value
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

Line 516: FROM pay_element_entries_f e

512: ,p_reporting_date DATE) IS
513: SELECT e.assignment_id AS Assignment_Id
514: ,min(decode(i.name,'Special Relationship Type',v.screen_entry_value,NULL)) AS Active_Rent_Flag
515: ,min(decode(i.name,'Retirement Age Reduction',v.screen_entry_value,NULL)) AS Minority_Group_Flag
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

Line 778: ,pay_element_entries_f pee

774: ,min(decode(piv.name,'Contract Key',nvl(pev.screen_entry_value, 'X'),NULL)) AS Contract_Key
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

Line 1010: ,pay_element_entries_f pee

1006: ,pap.sex sex
1007: from pay_element_entry_values_f pev
1008: ,pay_input_values_f piv
1009: ,pay_element_types_f pet
1010: ,pay_element_entries_f pee
1011: ,per_all_assignments_f paa
1012: ,per_all_people_f pap
1013: where pev.element_entry_id = pee.element_entry_id
1014: and paa.person_id = pap.person_id

Line 1109: ,pay_element_entries_f pee

1105: ,pap.sex sex
1106: from pay_element_entry_values_f pev
1107: ,pay_input_values_f piv
1108: ,pay_element_types_f pet
1109: ,pay_element_entries_f pee
1110: ,per_all_assignments_f paa
1111: ,per_all_people_f pap
1112: where pev.element_entry_id = pee.element_entry_id
1113: and paa.person_id = pap.person_id

Line 1603: ,pay_element_entries_f pee

1599: INTO l_unused_number , l_effective_start_date
1600: FROM pay_element_entry_values_f pev
1601: ,pay_input_values_f piv
1602: ,pay_element_types_f pet
1603: ,pay_element_entries_f pee
1604: WHERE pev.element_entry_id = pee.element_entry_id
1605: AND pev.screen_entry_value <> l_employment_category
1606: AND pee.assignment_id = qualifying_assignments.assignment_id
1607: AND pev.input_value_id = piv.input_value_id

Line 1671: ,pay_element_entries_f pee

1667: INTO l_unused_number , l_effective_start_date
1668: FROM pay_element_entry_values_f pev
1669: ,pay_input_values_f piv
1670: ,pay_element_types_f pet
1671: ,pay_element_entries_f pee
1672: WHERE pev.element_entry_id = pee.element_entry_id
1673: AND pev.screen_entry_value <> l_epigraph_code
1674: AND pee.assignment_id = qualifying_assignments.assignment_id
1675: AND pev.input_value_id = piv.input_value_id

Line 1757: ,pay_element_entries_f pee

1753: INTO l_unused_number , l_effective_start_date
1754: FROM pay_element_entry_values_f pev
1755: ,pay_input_values_f piv
1756: ,pay_element_types_f pet
1757: ,pay_element_entries_f pee
1758: WHERE pev.element_entry_id = pee.element_entry_id
1759: AND pev.screen_entry_value <> l_employment_category
1760: AND pee.assignment_id = qualifying_assignments.assignment_id
1761: AND pev.input_value_id = piv.input_value_id

Line 1825: ,pay_element_entries_f pee

1821: INTO l_unused_number , l_effective_start_date
1822: FROM pay_element_entry_values_f pev
1823: ,pay_input_values_f piv
1824: ,pay_element_types_f pet
1825: ,pay_element_entries_f pee
1826: WHERE pev.element_entry_id = pee.element_entry_id
1827: AND pev.screen_entry_value <> l_epigraph_code
1828: AND pee.assignment_id = qualifying_assignments.assignment_id
1829: AND pev.input_value_id = piv.input_value_id