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_TYPES_F

Line 172: pay_element_types_f ele

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
175: and entry.input_value_id = inp.input_value_id
176: and ele.element_type_id = inp.element_type_id

Line 1102: pay_element_types_f petf

1098:
1099: cursor csr_new_ssp_rate is
1100: select piv.default_value
1101: from pay_input_values_f piv,
1102: pay_element_types_f petf
1103: where petf.element_type_id = piv.element_type_id
1104: and piv.name = 'Rate'
1105: and petf.element_name = 'Statutory Sick Pay'
1106: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate);

Line 1116: pay_element_types_f petf

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
1117: where piv.input_value_id = peev1.input_value_id
1118: and peev1.element_entry_id = peev2.element_entry_id
1119: and peev1.element_entry_id = peef.element_entry_id
1120: and peef.element_link_id = pelf.element_link_id

Line 1131: pay_element_types_f petf

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
1132: where petf.element_type_id = piv.element_type_id
1133: and petf.element_name = 'Statutory Sick Pay'
1134: and piv.name = 'From')
1135: and peev3.screen_entry_value >

Line 1226: from pay_element_types_f petf

1222:
1223: /* Check for SMP rates beginning on or after April 1st */
1224: cursor csr_new_smp_rate is
1225: select petf.element_information10, petf.element_information9, petf.element_information16
1226: from pay_element_types_f petf
1227: where petf.element_name = 'Statutory Maternity Pay'
1228: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1229: order by effective_start_date;
1230:

Line 1247: pay_element_types_f petf

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
1248: where piv.input_value_id = peev1.input_value_id
1249: and peev1.element_entry_id = peev2.element_entry_id
1250: and peev1.element_entry_id = peev3.element_entry_id
1251: and peev1.element_entry_id = peef.element_entry_id

Line 1295: from pay_element_types_f petf

1291: */
1292:
1293: cursor csr_old_smp_rate is
1294: select petf.element_information10, petf.element_information9, petf.element_information16
1295: from pay_element_types_f petf
1296: where petf.element_name = 'Statutory Maternity Pay'
1297: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1298: order by effective_start_date desc;
1299:

Line 1358: from pay_element_types_f petf

1354:
1355: /* Check for SAP rates beginning on or after April 1st */
1356: cursor csr_new_sap_rate is
1357: select petf.element_information5, petf.element_information7
1358: from pay_element_types_f petf
1359: where petf.element_name = 'Statutory Adoption Pay'
1360: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1361: order by effective_start_date;
1362: --

Line 1377: pay_element_types_f petf

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
1378: where piv.input_value_id = peev1.input_value_id
1379: and peev1.element_entry_id = peev2.element_entry_id
1380: and peev1.element_entry_id = peef.element_entry_id
1381: and peef.element_link_id = pelf.element_link_id

Line 1417: from pay_element_types_f petf

1413: */
1414: --
1415: cursor csr_old_sap_rate is
1416: select petf.element_information5, petf.element_information7
1417: from pay_element_types_f petf
1418: where petf.element_name = 'Statutory Adoption Pay'
1419: and petf.effective_start_date < hr_gbnicar.uk_tax_yr_end(sysdate) - 4
1420: order by effective_start_date desc;
1421: --

Line 1474: from pay_element_types_f petf

1470:
1471: /* Check for SPPA rates beginning on or after April 1st */
1472: cursor csr_new_sppa_rate is
1473: select petf.element_information6, petf.element_information8
1474: from pay_element_types_f petf
1475: where petf.element_name = 'Statutory Paternity Pay Adoption'
1476: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1477: order by effective_start_date;
1478: --

Line 1493: pay_element_types_f petf

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
1494: where piv.input_value_id = peev1.input_value_id
1495: and peev1.element_entry_id = peev2.element_entry_id
1496: and peev1.element_entry_id = peef.element_entry_id
1497: and peef.element_link_id = pelf.element_link_id

Line 1533: from pay_element_types_f petf

1529: */
1530: --
1531: cursor csr_old_sppa_rate is
1532: select petf.element_information6, petf.element_information8
1533: from pay_element_types_f petf
1534: where petf.element_name = 'Statutory Paternity Pay Adoption'
1535: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1536: order by effective_start_date desc;
1537:

Line 1589: from pay_element_types_f petf

1585:
1586: /* Check for SPPB rates beginning on or after April 1st */
1587: cursor csr_new_sppb_rate is
1588: select petf.element_information6, petf.element_information9
1589: from pay_element_types_f petf
1590: where petf.element_name = 'Statutory Paternity Pay Birth'
1591: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1592: order by effective_start_date;
1593: --

Line 1608: pay_element_types_f petf

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
1609: where piv.input_value_id = peev1.input_value_id
1610: and peev1.element_entry_id = peev2.element_entry_id
1611: and peev1.element_entry_id = peef.element_entry_id
1612: and peef.element_link_id = pelf.element_link_id

Line 1648: from pay_element_types_f petf

1644: */
1645: --
1646: cursor csr_old_sppb_rate is
1647: select petf.element_information6, petf.element_information9
1648: from pay_element_types_f petf
1649: where petf.element_name = 'Statutory Paternity Pay Birth'
1650: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1651: order by effective_start_date desc;
1652: --

Line 1703: from pay_element_types_f petf

1699:
1700: /* Check for ASPPB rates beginning on or after April 1st */
1701: cursor csr_new_asppb_rate is
1702: select petf.element_information6, petf.element_information9
1703: from pay_element_types_f petf
1704: where petf.element_name = 'Additional Statutory Paternity Pay Birth'
1705: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1706: order by effective_start_date;
1707:

Line 1711: from pay_element_types_f petf

1707:
1708:
1709: cursor csr_old_asppb_rate is
1710: select petf.element_information6, petf.element_information9
1711: from pay_element_types_f petf
1712: where petf.element_name = 'Additional Statutory Paternity Pay Birth'
1713: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1714: order by effective_start_date desc;
1715: --

Line 1764: from pay_element_types_f petf

1760:
1761: /* Check for ASPPB rates beginning on or after April 1st */
1762: cursor csr_new_asppa_rate is
1763: select petf.element_information6, petf.element_information8
1764: from pay_element_types_f petf
1765: where petf.element_name = 'Additional Statutory Paternity Pay Adoption'
1766: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1767: order by effective_start_date;
1768:

Line 1772: from pay_element_types_f petf

1768:
1769:
1770: cursor csr_old_asppa_rate is
1771: select petf.element_information6, petf.element_information8
1772: from pay_element_types_f petf
1773: where petf.element_name = 'Additional Statutory Paternity Pay Adoption'
1774: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1775: order by effective_start_date desc;
1776:

Line 2403: pay_element_types_f petf

2399:
2400: cursor csr_new_ssp_rate is
2401: select piv.default_value
2402: from pay_input_values_f piv,
2403: pay_element_types_f petf
2404: where petf.element_type_id = piv.element_type_id
2405: and piv.name = 'Rate'
2406: and petf.element_name = 'Statutory Sick Pay'
2407: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate);

Line 2417: pay_element_types_f petf

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
2418: where piv.input_value_id = peev1.input_value_id
2419: and peev1.element_entry_id = peev2.element_entry_id
2420: and peev1.element_entry_id = peef.element_entry_id
2421: and peef.element_link_id = pelf.element_link_id

Line 2432: pay_element_types_f petf

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
2433: where petf.element_type_id = piv.element_type_id
2434: and petf.element_name = 'Statutory Sick Pay'
2435: and piv.name = 'From')
2436: and peev3.screen_entry_value >

Line 2527: from pay_element_types_f petf

2523:
2524: /* Check for SMP rates beginning on or after April 1st */
2525: cursor csr_new_smp_rate is
2526: select petf.element_information10, petf.element_information9, petf.element_information16
2527: from pay_element_types_f petf
2528: where petf.element_name = 'Statutory Maternity Pay'
2529: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2530: order by effective_start_date;
2531:

Line 2548: pay_element_types_f petf

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
2549: where piv.input_value_id = peev1.input_value_id
2550: and peev1.element_entry_id = peev2.element_entry_id
2551: and peev1.element_entry_id = peev3.element_entry_id
2552: and peev1.element_entry_id = peef.element_entry_id

Line 2596: from pay_element_types_f petf

2592: */
2593:
2594: cursor csr_old_smp_rate is
2595: select petf.element_information10, petf.element_information9, petf.element_information16
2596: from pay_element_types_f petf
2597: where petf.element_name = 'Statutory Maternity Pay'
2598: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2599: order by effective_start_date desc;
2600:

Line 2659: from pay_element_types_f petf

2655:
2656: /* Check for SAP rates beginning on or after April 1st */
2657: cursor csr_new_sap_rate is
2658: select petf.element_information5, petf.element_information7
2659: from pay_element_types_f petf
2660: where petf.element_name = 'Statutory Adoption Pay'
2661: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2662: order by effective_start_date;
2663: --

Line 2678: pay_element_types_f petf

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
2679: where piv.input_value_id = peev1.input_value_id
2680: and peev1.element_entry_id = peev2.element_entry_id
2681: and peev1.element_entry_id = peef.element_entry_id
2682: and peef.element_link_id = pelf.element_link_id

Line 2718: from pay_element_types_f petf

2714: */
2715: --
2716: cursor csr_old_sap_rate is
2717: select petf.element_information5, petf.element_information7
2718: from pay_element_types_f petf
2719: where petf.element_name = 'Statutory Adoption Pay'
2720: and petf.effective_start_date < hr_gbnicar.uk_tax_yr_end(sysdate) - 4
2721: order by effective_start_date desc;
2722: --

Line 2775: from pay_element_types_f petf

2771:
2772: /* Check for SPPA rates beginning on or after April 1st */
2773: cursor csr_new_sppa_rate is
2774: select petf.element_information6, petf.element_information8
2775: from pay_element_types_f petf
2776: where petf.element_name = 'Statutory Paternity Pay Adoption'
2777: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2778: order by effective_start_date;
2779: --

Line 2794: pay_element_types_f petf

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
2795: where piv.input_value_id = peev1.input_value_id
2796: and peev1.element_entry_id = peev2.element_entry_id
2797: and peev1.element_entry_id = peef.element_entry_id
2798: and peef.element_link_id = pelf.element_link_id

Line 2834: from pay_element_types_f petf

2830: */
2831: --
2832: cursor csr_old_sppa_rate is
2833: select petf.element_information6, petf.element_information8
2834: from pay_element_types_f petf
2835: where petf.element_name = 'Statutory Paternity Pay Adoption'
2836: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2837: order by effective_start_date desc;
2838:

Line 2890: from pay_element_types_f petf

2886:
2887: /* Check for SPPB rates beginning on or after April 1st */
2888: cursor csr_new_sppb_rate is
2889: select petf.element_information6, petf.element_information9
2890: from pay_element_types_f petf
2891: where petf.element_name = 'Statutory Paternity Pay Birth'
2892: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2893: order by effective_start_date;
2894: --

Line 2909: pay_element_types_f petf

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
2910: where piv.input_value_id = peev1.input_value_id
2911: and peev1.element_entry_id = peev2.element_entry_id
2912: and peev1.element_entry_id = peef.element_entry_id
2913: and peef.element_link_id = pelf.element_link_id

Line 2949: from pay_element_types_f petf

2945: */
2946: --
2947: cursor csr_old_sppb_rate is
2948: select petf.element_information6, petf.element_information9
2949: from pay_element_types_f petf
2950: where petf.element_name = 'Statutory Paternity Pay Birth'
2951: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2952: order by effective_start_date desc;
2953: --

Line 3005: from pay_element_types_f petf

3001:
3002: /* Check for ASPPB rates beginning on or after April 1st */
3003: cursor csr_new_asppb_rate is
3004: select petf.element_information6, petf.element_information9
3005: from pay_element_types_f petf
3006: where petf.element_name = 'Additional Statutory Paternity Pay Birth'
3007: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
3008: order by effective_start_date;
3009:

Line 3013: from pay_element_types_f petf

3009:
3010:
3011: cursor csr_old_asppb_rate is
3012: select petf.element_information6, petf.element_information9
3013: from pay_element_types_f petf
3014: where petf.element_name = 'Additional Statutory Paternity Pay Birth'
3015: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
3016: order by effective_start_date desc;
3017: --

Line 3066: from pay_element_types_f petf

3062:
3063: /* Check for ASPPB rates beginning on or after April 1st */
3064: cursor csr_new_asppa_rate is
3065: select petf.element_information6, petf.element_information8
3066: from pay_element_types_f petf
3067: where petf.element_name = 'Additional Statutory Paternity Pay Adoption'
3068: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
3069: order by effective_start_date;
3070:

Line 3074: from pay_element_types_f petf

3070:
3071:
3072: cursor csr_old_asppa_rate is
3073: select petf.element_information6, petf.element_information8
3074: from pay_element_types_f petf
3075: where petf.element_name = 'Additional Statutory Paternity Pay Adoption'
3076: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
3077: order by effective_start_date desc;
3078: --