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 170: from pay_element_entry_values_f entry,

166: select entry.screen_entry_value,
167: inp.uom,
168: ele.input_currency_code,
169: inp.input_value_id
170: from pay_element_entry_values_f entry,
171: pay_input_values_f inp,
172: pay_element_types_f ele
173: where entry.element_entry_id = p_element_entry_id
174: and inp.name = p_input_value_name

Line 1111: from pay_element_entry_values_f peev1,

1107:
1108:
1109: cursor csr_first_new_ssp_entry is
1110: select peev1.screen_entry_value
1111: from pay_element_entry_values_f peev1,
1112: pay_element_entry_values_f peev2,
1113: pay_input_values_f piv,
1114: pay_element_entries_f peef,
1115: pay_element_links_f pelf,

Line 1112: pay_element_entry_values_f peev2,

1108:
1109: cursor csr_first_new_ssp_entry is
1110: select peev1.screen_entry_value
1111: from pay_element_entry_values_f peev1,
1112: pay_element_entry_values_f peev2,
1113: pay_input_values_f piv,
1114: pay_element_entries_f peef,
1115: pay_element_links_f pelf,
1116: pay_element_types_f petf

Line 1127: from pay_element_entry_values_f peev3

1123: and petf.element_name = 'Statutory Sick Pay'
1124: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate)
1125: and peev2.element_entry_value_id =
1126: (select peev3.element_entry_value_id
1127: from pay_element_entry_values_f peev3
1128: where input_value_id =
1129: (select distinct input_value_id
1130: from pay_input_values_f piv,
1131: pay_element_types_f petf

Line 1241: from pay_element_entry_values_f peev1,

1237: and to compare it with new smp rate to detect the change.
1238:
1239: cursor csr_first_new_smp_entry is
1240: select peev1.screen_entry_value
1241: from pay_element_entry_values_f peev1,
1242: pay_element_entry_values_f peev2,
1243: pay_element_entry_values_f peev3,
1244: pay_input_values_f piv,
1245: pay_element_entries_f peef,

Line 1242: pay_element_entry_values_f peev2,

1238:
1239: cursor csr_first_new_smp_entry is
1240: select peev1.screen_entry_value
1241: from pay_element_entry_values_f peev1,
1242: pay_element_entry_values_f peev2,
1243: pay_element_entry_values_f peev3,
1244: pay_input_values_f piv,
1245: pay_element_entries_f peef,
1246: pay_element_links_f pelf,

Line 1243: pay_element_entry_values_f peev3,

1239: cursor csr_first_new_smp_entry is
1240: select peev1.screen_entry_value
1241: from pay_element_entry_values_f peev1,
1242: pay_element_entry_values_f peev2,
1243: pay_element_entry_values_f peev3,
1244: pay_input_values_f piv,
1245: pay_element_entries_f peef,
1246: pay_element_links_f pelf,
1247: pay_element_types_f petf

Line 1372: from pay_element_entry_values_f peev1,

1368: and to compare it with new sap rate to detect the change.
1369:
1370: cursor csr_first_new_sap_entry is
1371: select peev1.screen_entry_value
1372: from pay_element_entry_values_f peev1,
1373: pay_element_entry_values_f peev2,
1374: pay_input_values_f piv,
1375: pay_element_entries_f peef,
1376: pay_element_links_f pelf,

Line 1373: pay_element_entry_values_f peev2,

1369:
1370: cursor csr_first_new_sap_entry is
1371: select peev1.screen_entry_value
1372: from pay_element_entry_values_f peev1,
1373: pay_element_entry_values_f peev2,
1374: pay_input_values_f piv,
1375: pay_element_entries_f peef,
1376: pay_element_links_f pelf,
1377: pay_element_types_f petf

Line 1488: from pay_element_entry_values_f peev1,

1484: and to compare it with new SPP Adoption rate to detect the change.
1485:
1486: cursor csr_first_new_sppa_entry is
1487: select peev1.screen_entry_value
1488: from pay_element_entry_values_f peev1,
1489: pay_element_entry_values_f peev2,
1490: pay_input_values_f piv,
1491: pay_element_entries_f peef,
1492: pay_element_links_f pelf,

Line 1489: pay_element_entry_values_f peev2,

1485:
1486: cursor csr_first_new_sppa_entry is
1487: select peev1.screen_entry_value
1488: from pay_element_entry_values_f peev1,
1489: pay_element_entry_values_f peev2,
1490: pay_input_values_f piv,
1491: pay_element_entries_f peef,
1492: pay_element_links_f pelf,
1493: pay_element_types_f petf

Line 1603: from pay_element_entry_values_f peev1,

1599: and to compare it with new SPP Birth rate to detect the change.
1600:
1601: cursor csr_first_new_sppb_entry is
1602: select peev1.screen_entry_value
1603: from pay_element_entry_values_f peev1,
1604: pay_element_entry_values_f peev2,
1605: pay_input_values_f piv,
1606: pay_element_entries_f peef,
1607: pay_element_links_f pelf,

Line 1604: pay_element_entry_values_f peev2,

1600:
1601: cursor csr_first_new_sppb_entry is
1602: select peev1.screen_entry_value
1603: from pay_element_entry_values_f peev1,
1604: pay_element_entry_values_f peev2,
1605: pay_input_values_f piv,
1606: pay_element_entries_f peef,
1607: pay_element_links_f pelf,
1608: pay_element_types_f petf

Line 2412: from pay_element_entry_values_f peev1,

2408:
2409:
2410: cursor csr_first_new_ssp_entry is
2411: select peev1.screen_entry_value
2412: from pay_element_entry_values_f peev1,
2413: pay_element_entry_values_f peev2,
2414: pay_input_values_f piv,
2415: pay_element_entries_f peef,
2416: pay_element_links_f pelf,

Line 2413: pay_element_entry_values_f peev2,

2409:
2410: cursor csr_first_new_ssp_entry is
2411: select peev1.screen_entry_value
2412: from pay_element_entry_values_f peev1,
2413: pay_element_entry_values_f peev2,
2414: pay_input_values_f piv,
2415: pay_element_entries_f peef,
2416: pay_element_links_f pelf,
2417: pay_element_types_f petf

Line 2428: from pay_element_entry_values_f peev3

2424: and petf.element_name = 'Statutory Sick Pay'
2425: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate)
2426: and peev2.element_entry_value_id =
2427: (select peev3.element_entry_value_id
2428: from pay_element_entry_values_f peev3
2429: where input_value_id =
2430: (select distinct input_value_id
2431: from pay_input_values_f piv,
2432: pay_element_types_f petf

Line 2542: from pay_element_entry_values_f peev1,

2538: and to compare it with new smp rate to detect the change.
2539:
2540: cursor csr_first_new_smp_entry is
2541: select peev1.screen_entry_value
2542: from pay_element_entry_values_f peev1,
2543: pay_element_entry_values_f peev2,
2544: pay_element_entry_values_f peev3,
2545: pay_input_values_f piv,
2546: pay_element_entries_f peef,

Line 2543: pay_element_entry_values_f peev2,

2539:
2540: cursor csr_first_new_smp_entry is
2541: select peev1.screen_entry_value
2542: from pay_element_entry_values_f peev1,
2543: pay_element_entry_values_f peev2,
2544: pay_element_entry_values_f peev3,
2545: pay_input_values_f piv,
2546: pay_element_entries_f peef,
2547: pay_element_links_f pelf,

Line 2544: pay_element_entry_values_f peev3,

2540: cursor csr_first_new_smp_entry is
2541: select peev1.screen_entry_value
2542: from pay_element_entry_values_f peev1,
2543: pay_element_entry_values_f peev2,
2544: pay_element_entry_values_f peev3,
2545: pay_input_values_f piv,
2546: pay_element_entries_f peef,
2547: pay_element_links_f pelf,
2548: pay_element_types_f petf

Line 2673: from pay_element_entry_values_f peev1,

2669: and to compare it with new sap rate to detect the change.
2670:
2671: cursor csr_first_new_sap_entry is
2672: select peev1.screen_entry_value
2673: from pay_element_entry_values_f peev1,
2674: pay_element_entry_values_f peev2,
2675: pay_input_values_f piv,
2676: pay_element_entries_f peef,
2677: pay_element_links_f pelf,

Line 2674: pay_element_entry_values_f peev2,

2670:
2671: cursor csr_first_new_sap_entry is
2672: select peev1.screen_entry_value
2673: from pay_element_entry_values_f peev1,
2674: pay_element_entry_values_f peev2,
2675: pay_input_values_f piv,
2676: pay_element_entries_f peef,
2677: pay_element_links_f pelf,
2678: pay_element_types_f petf

Line 2789: from pay_element_entry_values_f peev1,

2785: and to compare it with new SPP Adoption rate to detect the change.
2786:
2787: cursor csr_first_new_sppa_entry is
2788: select peev1.screen_entry_value
2789: from pay_element_entry_values_f peev1,
2790: pay_element_entry_values_f peev2,
2791: pay_input_values_f piv,
2792: pay_element_entries_f peef,
2793: pay_element_links_f pelf,

Line 2790: pay_element_entry_values_f peev2,

2786:
2787: cursor csr_first_new_sppa_entry is
2788: select peev1.screen_entry_value
2789: from pay_element_entry_values_f peev1,
2790: pay_element_entry_values_f peev2,
2791: pay_input_values_f piv,
2792: pay_element_entries_f peef,
2793: pay_element_links_f pelf,
2794: pay_element_types_f petf

Line 2904: from pay_element_entry_values_f peev1,

2900: and to compare it with new SPP Birth rate to detect the change.
2901:
2902: cursor csr_first_new_sppb_entry is
2903: select peev1.screen_entry_value
2904: from pay_element_entry_values_f peev1,
2905: pay_element_entry_values_f peev2,
2906: pay_input_values_f piv,
2907: pay_element_entries_f peef,
2908: pay_element_links_f pelf,

Line 2905: pay_element_entry_values_f peev2,

2901:
2902: cursor csr_first_new_sppb_entry is
2903: select peev1.screen_entry_value
2904: from pay_element_entry_values_f peev1,
2905: pay_element_entry_values_f peev2,
2906: pay_input_values_f piv,
2907: pay_element_entries_f peef,
2908: pay_element_links_f pelf,
2909: pay_element_types_f petf