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_INPUT_VALUES_F

Line 36: ,pay_input_values_f i

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
40: WHERE e.element_entry_id = v.element_entry_id

Line 464: ,pay_input_values_f piv

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

Line 491: ,pay_input_values_f piv

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

Line 517: ,pay_input_values_f i

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
521: WHERE e.element_entry_id = v.element_entry_id

Line 776: ,pay_input_values_f piv

772: SELECT pee.assignment_id AS assignment_Id
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

Line 1008: ,pay_input_values_f piv

1004: ,pev.effective_start_date actual_date
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

Line 1107: ,pay_input_values_f piv

1103: ,pev.effective_start_date actual_date
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

Line 1601: ,pay_input_values_f piv

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

Line 1669: ,pay_input_values_f piv

1665: l_unused_number := 0;
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

Line 1755: ,pay_input_values_f piv

1751: AND assignment_id = qualifying_assignments.assignment_id;*/
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

Line 1823: ,pay_input_values_f piv

1819: l_unused_number := 0;
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