APPS.SSP_SMP_SUPPORT_PKG dependencies on PAY_INPUT_VALUES_F

Line 171: pay_input_values_f inp,

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

Line 419: from pay_input_values_f

415: return number is
416: --
417: cursor csr_input_value is
418: select input_value_id
419: from pay_input_values_f
420: where name = p_input_value_name
421: and element_type_id = p_element_type_id;
422: --
423: l_input_value csr_input_value%rowtype;

Line 1101: from pay_input_values_f piv,

1097: function ssp_entries_already_updated return boolean is
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'

Line 1113: pay_input_values_f piv,

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
1117: where piv.input_value_id = peev1.input_value_id

Line 1130: from pay_input_values_f piv,

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

Line 1244: pay_input_values_f piv,

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
1248: where piv.input_value_id = peev1.input_value_id

Line 1260: from pay_input_values_f piv

1256: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
1257: -- Time restriction - only rows after tax year end
1258: and peev2.input_value_id =
1259: (select input_value_id
1260: from pay_input_values_f piv
1261: where petf.element_type_id = piv.element_type_id
1262: and upper(piv.name) = upper('Week commencing')
1263: )
1264: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 1284: from pay_input_values_f piv

1280: and nvl(pps.final_process_date,to_date('31/12/4712','DD/MM/YYYY')) >= sysdate
1281: )
1282: and peev3.input_value_id =
1283: (select input_value_id
1284: from pay_input_values_f piv
1285: where petf.element_type_id = piv.element_type_id
1286: and upper(piv.name) = upper('Rate'))
1287: -- Rate restriction - only retrieve entries on LOW rate for SMP
1288: and upper(peev3.screen_entry_value) = upper('Low')

Line 1374: pay_input_values_f piv,

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
1378: where piv.input_value_id = peev1.input_value_id

Line 1389: from pay_input_values_f piv

1385: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
1386: -- Time restriction - only rows after tax year end
1387: and peev2.input_value_id =
1388: (select input_value_id
1389: from pay_input_values_f piv
1390: where petf.element_type_id = piv.element_type_id
1391: and upper(piv.name) = upper('Week commencing')
1392: )
1393: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 1490: pay_input_values_f piv,

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
1494: where piv.input_value_id = peev1.input_value_id

Line 1505: from pay_input_values_f piv

1501: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
1502: -- Time restriction - only rows after tax year end
1503: and peev2.input_value_id =
1504: (select input_value_id
1505: from pay_input_values_f piv
1506: where petf.element_type_id = piv.element_type_id
1507: and upper(piv.name) = upper('Week commencing')
1508: )
1509: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 1605: pay_input_values_f piv,

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
1609: where piv.input_value_id = peev1.input_value_id

Line 1620: from pay_input_values_f piv

1616: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
1617: -- Time restriction - only rows after tax year end
1618: and peev2.input_value_id =
1619: (select input_value_id
1620: from pay_input_values_f piv
1621: where petf.element_type_id = piv.element_type_id
1622: and upper(piv.name) = upper('Week commencing')
1623: )
1624: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 2402: from pay_input_values_f piv,

2398: function ssp_entries_already_updated return boolean is
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'

Line 2414: pay_input_values_f piv,

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
2418: where piv.input_value_id = peev1.input_value_id

Line 2431: from pay_input_values_f piv,

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

Line 2545: pay_input_values_f piv,

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
2549: where piv.input_value_id = peev1.input_value_id

Line 2561: from pay_input_values_f piv

2557: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
2558: -- Time restriction - only rows after tax year end
2559: and peev2.input_value_id =
2560: (select input_value_id
2561: from pay_input_values_f piv
2562: where petf.element_type_id = piv.element_type_id
2563: and upper(piv.name) = upper('Week commencing')
2564: )
2565: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 2585: from pay_input_values_f piv

2581: and nvl(pps.final_process_date,to_date('31/12/4712','DD/MM/YYYY')) >= sysdate
2582: )
2583: and peev3.input_value_id =
2584: (select input_value_id
2585: from pay_input_values_f piv
2586: where petf.element_type_id = piv.element_type_id
2587: and upper(piv.name) = upper('Rate'))
2588: -- Rate restriction - only retrieve entries on LOW rate for SMP
2589: and upper(peev3.screen_entry_value) = upper('Low')

Line 2675: pay_input_values_f piv,

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
2679: where piv.input_value_id = peev1.input_value_id

Line 2690: from pay_input_values_f piv

2686: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
2687: -- Time restriction - only rows after tax year end
2688: and peev2.input_value_id =
2689: (select input_value_id
2690: from pay_input_values_f piv
2691: where petf.element_type_id = piv.element_type_id
2692: and upper(piv.name) = upper('Week commencing')
2693: )
2694: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 2791: pay_input_values_f piv,

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
2795: where piv.input_value_id = peev1.input_value_id

Line 2806: from pay_input_values_f piv

2802: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
2803: -- Time restriction - only rows after tax year end
2804: and peev2.input_value_id =
2805: (select input_value_id
2806: from pay_input_values_f piv
2807: where petf.element_type_id = piv.element_type_id
2808: and upper(piv.name) = upper('Week commencing')
2809: )
2810: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 2906: pay_input_values_f piv,

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
2910: where piv.input_value_id = peev1.input_value_id

Line 2921: from pay_input_values_f piv

2917: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
2918: -- Time restriction - only rows after tax year end
2919: and peev2.input_value_id =
2920: (select input_value_id
2921: from pay_input_values_f piv
2922: where petf.element_type_id = piv.element_type_id
2923: and upper(piv.name) = upper('Week commencing')
2924: )
2925: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)