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.SSP_SMP_SUPPORT_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 162: from pay_element_entry_values_f entry,

158: select entry.screen_entry_value,
159: inp.uom,
160: ele.input_currency_code,
161: inp.input_value_id
162: from pay_element_entry_values_f entry,
163: pay_input_values_f inp,
164: pay_element_types_f ele
165: where entry.element_entry_id = p_element_entry_id
166: and inp.name = p_input_value_name

Line 1058: from pay_element_entry_values_f peev1,

1054:
1055:
1056: cursor csr_first_new_ssp_entry is
1057: select peev1.screen_entry_value
1058: from pay_element_entry_values_f peev1,
1059: pay_element_entry_values_f peev2,
1060: pay_input_values_f piv,
1061: pay_element_entries_f peef,
1062: pay_element_links_f pelf,

Line 1059: pay_element_entry_values_f peev2,

1055:
1056: cursor csr_first_new_ssp_entry is
1057: select peev1.screen_entry_value
1058: from pay_element_entry_values_f peev1,
1059: pay_element_entry_values_f peev2,
1060: pay_input_values_f piv,
1061: pay_element_entries_f peef,
1062: pay_element_links_f pelf,
1063: pay_element_types_f petf

Line 1074: from pay_element_entry_values_f peev3

1070: and petf.element_name = 'Statutory Sick Pay'
1071: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate)
1072: and peev2.element_entry_value_id =
1073: (select peev3.element_entry_value_id
1074: from pay_element_entry_values_f peev3
1075: where input_value_id =
1076: (select distinct input_value_id
1077: from pay_input_values_f piv,
1078: pay_element_types_f petf

Line 1188: from pay_element_entry_values_f peev1,

1184: and to compare it with new smp rate to detect the change.
1185:
1186: cursor csr_first_new_smp_entry is
1187: select peev1.screen_entry_value
1188: from pay_element_entry_values_f peev1,
1189: pay_element_entry_values_f peev2,
1190: pay_element_entry_values_f peev3,
1191: pay_input_values_f piv,
1192: pay_element_entries_f peef,

Line 1189: pay_element_entry_values_f peev2,

1185:
1186: cursor csr_first_new_smp_entry is
1187: select peev1.screen_entry_value
1188: from pay_element_entry_values_f peev1,
1189: pay_element_entry_values_f peev2,
1190: pay_element_entry_values_f peev3,
1191: pay_input_values_f piv,
1192: pay_element_entries_f peef,
1193: pay_element_links_f pelf,

Line 1190: pay_element_entry_values_f peev3,

1186: cursor csr_first_new_smp_entry is
1187: select peev1.screen_entry_value
1188: from pay_element_entry_values_f peev1,
1189: pay_element_entry_values_f peev2,
1190: pay_element_entry_values_f peev3,
1191: pay_input_values_f piv,
1192: pay_element_entries_f peef,
1193: pay_element_links_f pelf,
1194: pay_element_types_f petf

Line 1319: from pay_element_entry_values_f peev1,

1315: and to compare it with new sap rate to detect the change.
1316:
1317: cursor csr_first_new_sap_entry is
1318: select peev1.screen_entry_value
1319: from pay_element_entry_values_f peev1,
1320: pay_element_entry_values_f peev2,
1321: pay_input_values_f piv,
1322: pay_element_entries_f peef,
1323: pay_element_links_f pelf,

Line 1320: pay_element_entry_values_f peev2,

1316:
1317: cursor csr_first_new_sap_entry is
1318: select peev1.screen_entry_value
1319: from pay_element_entry_values_f peev1,
1320: pay_element_entry_values_f peev2,
1321: pay_input_values_f piv,
1322: pay_element_entries_f peef,
1323: pay_element_links_f pelf,
1324: pay_element_types_f petf

Line 1435: from pay_element_entry_values_f peev1,

1431: and to compare it with new SPP Adoption rate to detect the change.
1432:
1433: cursor csr_first_new_sppa_entry is
1434: select peev1.screen_entry_value
1435: from pay_element_entry_values_f peev1,
1436: pay_element_entry_values_f peev2,
1437: pay_input_values_f piv,
1438: pay_element_entries_f peef,
1439: pay_element_links_f pelf,

Line 1436: pay_element_entry_values_f peev2,

1432:
1433: cursor csr_first_new_sppa_entry is
1434: select peev1.screen_entry_value
1435: from pay_element_entry_values_f peev1,
1436: pay_element_entry_values_f peev2,
1437: pay_input_values_f piv,
1438: pay_element_entries_f peef,
1439: pay_element_links_f pelf,
1440: pay_element_types_f petf

Line 1550: from pay_element_entry_values_f peev1,

1546: and to compare it with new SPP Birth rate to detect the change.
1547:
1548: cursor csr_first_new_sppb_entry is
1549: select peev1.screen_entry_value
1550: from pay_element_entry_values_f peev1,
1551: pay_element_entry_values_f peev2,
1552: pay_input_values_f piv,
1553: pay_element_entries_f peef,
1554: pay_element_links_f pelf,

Line 1551: pay_element_entry_values_f peev2,

1547:
1548: cursor csr_first_new_sppb_entry is
1549: select peev1.screen_entry_value
1550: from pay_element_entry_values_f peev1,
1551: pay_element_entry_values_f peev2,
1552: pay_input_values_f piv,
1553: pay_element_entries_f peef,
1554: pay_element_links_f pelf,
1555: pay_element_types_f petf

Line 2108: from pay_element_entry_values_f peev1,

2104:
2105:
2106: cursor csr_first_new_ssp_entry is
2107: select peev1.screen_entry_value
2108: from pay_element_entry_values_f peev1,
2109: pay_element_entry_values_f peev2,
2110: pay_input_values_f piv,
2111: pay_element_entries_f peef,
2112: pay_element_links_f pelf,

Line 2109: pay_element_entry_values_f peev2,

2105:
2106: cursor csr_first_new_ssp_entry is
2107: select peev1.screen_entry_value
2108: from pay_element_entry_values_f peev1,
2109: pay_element_entry_values_f peev2,
2110: pay_input_values_f piv,
2111: pay_element_entries_f peef,
2112: pay_element_links_f pelf,
2113: pay_element_types_f petf

Line 2124: from pay_element_entry_values_f peev3

2120: and petf.element_name = 'Statutory Sick Pay'
2121: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate)
2122: and peev2.element_entry_value_id =
2123: (select peev3.element_entry_value_id
2124: from pay_element_entry_values_f peev3
2125: where input_value_id =
2126: (select distinct input_value_id
2127: from pay_input_values_f piv,
2128: pay_element_types_f petf

Line 2238: from pay_element_entry_values_f peev1,

2234: and to compare it with new smp rate to detect the change.
2235:
2236: cursor csr_first_new_smp_entry is
2237: select peev1.screen_entry_value
2238: from pay_element_entry_values_f peev1,
2239: pay_element_entry_values_f peev2,
2240: pay_element_entry_values_f peev3,
2241: pay_input_values_f piv,
2242: pay_element_entries_f peef,

Line 2239: pay_element_entry_values_f peev2,

2235:
2236: cursor csr_first_new_smp_entry is
2237: select peev1.screen_entry_value
2238: from pay_element_entry_values_f peev1,
2239: pay_element_entry_values_f peev2,
2240: pay_element_entry_values_f peev3,
2241: pay_input_values_f piv,
2242: pay_element_entries_f peef,
2243: pay_element_links_f pelf,

Line 2240: pay_element_entry_values_f peev3,

2236: cursor csr_first_new_smp_entry is
2237: select peev1.screen_entry_value
2238: from pay_element_entry_values_f peev1,
2239: pay_element_entry_values_f peev2,
2240: pay_element_entry_values_f peev3,
2241: pay_input_values_f piv,
2242: pay_element_entries_f peef,
2243: pay_element_links_f pelf,
2244: pay_element_types_f petf

Line 2369: from pay_element_entry_values_f peev1,

2365: and to compare it with new sap rate to detect the change.
2366:
2367: cursor csr_first_new_sap_entry is
2368: select peev1.screen_entry_value
2369: from pay_element_entry_values_f peev1,
2370: pay_element_entry_values_f peev2,
2371: pay_input_values_f piv,
2372: pay_element_entries_f peef,
2373: pay_element_links_f pelf,

Line 2370: pay_element_entry_values_f peev2,

2366:
2367: cursor csr_first_new_sap_entry is
2368: select peev1.screen_entry_value
2369: from pay_element_entry_values_f peev1,
2370: pay_element_entry_values_f peev2,
2371: pay_input_values_f piv,
2372: pay_element_entries_f peef,
2373: pay_element_links_f pelf,
2374: pay_element_types_f petf

Line 2485: from pay_element_entry_values_f peev1,

2481: and to compare it with new SPP Adoption rate to detect the change.
2482:
2483: cursor csr_first_new_sppa_entry is
2484: select peev1.screen_entry_value
2485: from pay_element_entry_values_f peev1,
2486: pay_element_entry_values_f peev2,
2487: pay_input_values_f piv,
2488: pay_element_entries_f peef,
2489: pay_element_links_f pelf,

Line 2486: pay_element_entry_values_f peev2,

2482:
2483: cursor csr_first_new_sppa_entry is
2484: select peev1.screen_entry_value
2485: from pay_element_entry_values_f peev1,
2486: pay_element_entry_values_f peev2,
2487: pay_input_values_f piv,
2488: pay_element_entries_f peef,
2489: pay_element_links_f pelf,
2490: pay_element_types_f petf

Line 2600: from pay_element_entry_values_f peev1,

2596: and to compare it with new SPP Birth rate to detect the change.
2597:
2598: cursor csr_first_new_sppb_entry is
2599: select peev1.screen_entry_value
2600: from pay_element_entry_values_f peev1,
2601: pay_element_entry_values_f peev2,
2602: pay_input_values_f piv,
2603: pay_element_entries_f peef,
2604: pay_element_links_f pelf,

Line 2601: pay_element_entry_values_f peev2,

2597:
2598: cursor csr_first_new_sppb_entry is
2599: select peev1.screen_entry_value
2600: from pay_element_entry_values_f peev1,
2601: pay_element_entry_values_f peev2,
2602: pay_input_values_f piv,
2603: pay_element_entries_f peef,
2604: pay_element_links_f pelf,
2605: pay_element_types_f petf