APPS.SSP_SMP_SUPPORT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 164: pay_element_types_f ele

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

Line 1049: pay_element_types_f petf

1045:
1046: cursor csr_new_ssp_rate is
1047: select piv.default_value
1048: from pay_input_values_f piv,
1049: pay_element_types_f petf
1050: where petf.element_type_id = piv.element_type_id
1051: and piv.name = 'Rate'
1052: and petf.element_name = 'Statutory Sick Pay'
1053: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate);

Line 1063: pay_element_types_f petf

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
1064: where piv.input_value_id = peev1.input_value_id
1065: and peev1.element_entry_id = peev2.element_entry_id
1066: and peev1.element_entry_id = peef.element_entry_id
1067: and peef.element_link_id = pelf.element_link_id

Line 1078: pay_element_types_f petf

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
1079: where petf.element_type_id = piv.element_type_id
1080: and petf.element_name = 'Statutory Sick Pay'
1081: and piv.name = 'From')
1082: and peev3.screen_entry_value >

Line 1173: from pay_element_types_f petf

1169:
1170: /* Check for SMP rates beginning on or after April 1st */
1171: cursor csr_new_smp_rate is
1172: select petf.element_information10, petf.element_information9, petf.element_information16
1173: from pay_element_types_f petf
1174: where petf.element_name = 'Statutory Maternity Pay'
1175: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1176: order by effective_start_date;
1177:

Line 1194: pay_element_types_f petf

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
1195: where piv.input_value_id = peev1.input_value_id
1196: and peev1.element_entry_id = peev2.element_entry_id
1197: and peev1.element_entry_id = peev3.element_entry_id
1198: and peev1.element_entry_id = peef.element_entry_id

Line 1242: from pay_element_types_f petf

1238: */
1239:
1240: cursor csr_old_smp_rate is
1241: select petf.element_information10, petf.element_information9, petf.element_information16
1242: from pay_element_types_f petf
1243: where petf.element_name = 'Statutory Maternity Pay'
1244: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1245: order by effective_start_date desc;
1246:

Line 1305: from pay_element_types_f petf

1301:
1302: /* Check for SAP rates beginning on or after April 1st */
1303: cursor csr_new_sap_rate is
1304: select petf.element_information5, petf.element_information7
1305: from pay_element_types_f petf
1306: where petf.element_name = 'Statutory Adoption Pay'
1307: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1308: order by effective_start_date;
1309: --

Line 1324: pay_element_types_f petf

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
1325: where piv.input_value_id = peev1.input_value_id
1326: and peev1.element_entry_id = peev2.element_entry_id
1327: and peev1.element_entry_id = peef.element_entry_id
1328: and peef.element_link_id = pelf.element_link_id

Line 1364: from pay_element_types_f petf

1360: */
1361: --
1362: cursor csr_old_sap_rate is
1363: select petf.element_information5, petf.element_information7
1364: from pay_element_types_f petf
1365: where petf.element_name = 'Statutory Adoption Pay'
1366: and petf.effective_start_date < hr_gbnicar.uk_tax_yr_end(sysdate) - 4
1367: order by effective_start_date desc;
1368: --

Line 1421: from pay_element_types_f petf

1417:
1418: /* Check for SPPA rates beginning on or after April 1st */
1419: cursor csr_new_sppa_rate is
1420: select petf.element_information6, petf.element_information8
1421: from pay_element_types_f petf
1422: where petf.element_name = 'Statutory Paternity Pay Adoption'
1423: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1424: order by effective_start_date;
1425: --

Line 1440: pay_element_types_f petf

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
1441: where piv.input_value_id = peev1.input_value_id
1442: and peev1.element_entry_id = peev2.element_entry_id
1443: and peev1.element_entry_id = peef.element_entry_id
1444: and peef.element_link_id = pelf.element_link_id

Line 1480: from pay_element_types_f petf

1476: */
1477: --
1478: cursor csr_old_sppa_rate is
1479: select petf.element_information6, petf.element_information8
1480: from pay_element_types_f petf
1481: where petf.element_name = 'Statutory Paternity Pay Adoption'
1482: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1483: order by effective_start_date desc;
1484:

Line 1536: from pay_element_types_f petf

1532:
1533: /* Check for SPPB rates beginning on or after April 1st */
1534: cursor csr_new_sppb_rate is
1535: select petf.element_information6, petf.element_information9
1536: from pay_element_types_f petf
1537: where petf.element_name = 'Statutory Paternity Pay Birth'
1538: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1539: order by effective_start_date;
1540: --

Line 1555: pay_element_types_f petf

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
1556: where piv.input_value_id = peev1.input_value_id
1557: and peev1.element_entry_id = peev2.element_entry_id
1558: and peev1.element_entry_id = peef.element_entry_id
1559: and peef.element_link_id = pelf.element_link_id

Line 1595: from pay_element_types_f petf

1591: */
1592: --
1593: cursor csr_old_sppb_rate is
1594: select petf.element_information6, petf.element_information9
1595: from pay_element_types_f petf
1596: where petf.element_name = 'Statutory Paternity Pay Birth'
1597: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
1598: order by effective_start_date desc;
1599: --

Line 2099: pay_element_types_f petf

2095:
2096: cursor csr_new_ssp_rate is
2097: select piv.default_value
2098: from pay_input_values_f piv,
2099: pay_element_types_f petf
2100: where petf.element_type_id = piv.element_type_id
2101: and piv.name = 'Rate'
2102: and petf.element_name = 'Statutory Sick Pay'
2103: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate);

Line 2113: pay_element_types_f petf

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
2114: where piv.input_value_id = peev1.input_value_id
2115: and peev1.element_entry_id = peev2.element_entry_id
2116: and peev1.element_entry_id = peef.element_entry_id
2117: and peef.element_link_id = pelf.element_link_id

Line 2128: pay_element_types_f petf

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
2129: where petf.element_type_id = piv.element_type_id
2130: and petf.element_name = 'Statutory Sick Pay'
2131: and piv.name = 'From')
2132: and peev3.screen_entry_value >

Line 2223: from pay_element_types_f petf

2219:
2220: /* Check for SMP rates beginning on or after April 1st */
2221: cursor csr_new_smp_rate is
2222: select petf.element_information10, petf.element_information9, petf.element_information16
2223: from pay_element_types_f petf
2224: where petf.element_name = 'Statutory Maternity Pay'
2225: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2226: order by effective_start_date;
2227:

Line 2244: pay_element_types_f petf

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
2245: where piv.input_value_id = peev1.input_value_id
2246: and peev1.element_entry_id = peev2.element_entry_id
2247: and peev1.element_entry_id = peev3.element_entry_id
2248: and peev1.element_entry_id = peef.element_entry_id

Line 2292: from pay_element_types_f petf

2288: */
2289:
2290: cursor csr_old_smp_rate is
2291: select petf.element_information10, petf.element_information9, petf.element_information16
2292: from pay_element_types_f petf
2293: where petf.element_name = 'Statutory Maternity Pay'
2294: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2295: order by effective_start_date desc;
2296:

Line 2355: from pay_element_types_f petf

2351:
2352: /* Check for SAP rates beginning on or after April 1st */
2353: cursor csr_new_sap_rate is
2354: select petf.element_information5, petf.element_information7
2355: from pay_element_types_f petf
2356: where petf.element_name = 'Statutory Adoption Pay'
2357: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2358: order by effective_start_date;
2359: --

Line 2374: pay_element_types_f petf

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
2375: where piv.input_value_id = peev1.input_value_id
2376: and peev1.element_entry_id = peev2.element_entry_id
2377: and peev1.element_entry_id = peef.element_entry_id
2378: and peef.element_link_id = pelf.element_link_id

Line 2414: from pay_element_types_f petf

2410: */
2411: --
2412: cursor csr_old_sap_rate is
2413: select petf.element_information5, petf.element_information7
2414: from pay_element_types_f petf
2415: where petf.element_name = 'Statutory Adoption Pay'
2416: and petf.effective_start_date < hr_gbnicar.uk_tax_yr_end(sysdate) - 4
2417: order by effective_start_date desc;
2418: --

Line 2471: from pay_element_types_f petf

2467:
2468: /* Check for SPPA rates beginning on or after April 1st */
2469: cursor csr_new_sppa_rate is
2470: select petf.element_information6, petf.element_information8
2471: from pay_element_types_f petf
2472: where petf.element_name = 'Statutory Paternity Pay Adoption'
2473: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2474: order by effective_start_date;
2475: --

Line 2490: pay_element_types_f petf

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
2491: where piv.input_value_id = peev1.input_value_id
2492: and peev1.element_entry_id = peev2.element_entry_id
2493: and peev1.element_entry_id = peef.element_entry_id
2494: and peef.element_link_id = pelf.element_link_id

Line 2530: from pay_element_types_f petf

2526: */
2527: --
2528: cursor csr_old_sppa_rate is
2529: select petf.element_information6, petf.element_information8
2530: from pay_element_types_f petf
2531: where petf.element_name = 'Statutory Paternity Pay Adoption'
2532: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2533: order by effective_start_date desc;
2534:

Line 2586: from pay_element_types_f petf

2582:
2583: /* Check for SPPB rates beginning on or after April 1st */
2584: cursor csr_new_sppb_rate is
2585: select petf.element_information6, petf.element_information9
2586: from pay_element_types_f petf
2587: where petf.element_name = 'Statutory Paternity Pay Birth'
2588: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2589: order by effective_start_date;
2590: --

Line 2605: pay_element_types_f petf

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
2606: where piv.input_value_id = peev1.input_value_id
2607: and peev1.element_entry_id = peev2.element_entry_id
2608: and peev1.element_entry_id = peef.element_entry_id
2609: and peef.element_link_id = pelf.element_link_id

Line 2645: from pay_element_types_f petf

2641: */
2642: --
2643: cursor csr_old_sppb_rate is
2644: select petf.element_information6, petf.element_information9
2645: from pay_element_types_f petf
2646: where petf.element_name = 'Statutory Paternity Pay Birth'
2647: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4
2648: order by effective_start_date desc;
2649: --