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_TYPES_F

Line 38: ,pay_element_types_f t

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

Line 465: ,pay_element_types_f pet

461: CURSOR csr_get_ss_identifier_per (c_person_id NUMBER,c_reporting_date DATE) IS
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

Line 492: ,pay_element_types_f pet

488: CURSOR csr_get_ss_identifier_asg (c_assignment_id NUMBER,c_reporting_date DATE) IS
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

Line 519: ,pay_element_types_f t

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
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

Line 777: ,pay_element_types_f pet

773: ,min(decode(piv.name,'SS Epigraph Code',nvl(pev.screen_entry_value, 'X'),NULL)) AS epigraph_code
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

Line 1009: ,pay_element_types_f pet

1005: ,pap.date_of_birth date_of_birth
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

Line 1108: ,pay_element_types_f pet

1104: ,pap.date_of_birth date_of_birth
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

Line 1602: ,pay_element_types_f pet

1598: SELECT count(pev.screen_entry_value), min(pev.effective_start_date)
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

Line 1670: ,pay_element_types_f pet

1666: SELECT count(pev.screen_entry_value), min(pev.effective_start_date)
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

Line 1756: ,pay_element_types_f pet

1752: SELECT count(pev.screen_entry_value), min(pev.effective_start_date)
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

Line 1824: ,pay_element_types_f pet

1820: SELECT count(pev.screen_entry_value), min(pev.effective_start_date)
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