APPS.SSP_SMP_SUPPORT_PKG dependencies on PAY_INPUT_VALUES_F

Line 163: pay_input_values_f inp,

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

Line 378: from pay_input_values_f

374: return number is
375: --
376: cursor csr_input_value is
377: select input_value_id
378: from pay_input_values_f
379: where name = p_input_value_name
380: and element_type_id = p_element_type_id;
381: --
382: l_input_value csr_input_value%rowtype;

Line 1048: from pay_input_values_f piv,

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

Line 1060: pay_input_values_f piv,

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

Line 1077: from pay_input_values_f piv,

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

Line 1191: pay_input_values_f piv,

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

Line 1207: from pay_input_values_f piv

1203: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
1204: -- Time restriction - only rows after tax year end
1205: and peev2.input_value_id =
1206: (select input_value_id
1207: from pay_input_values_f piv
1208: where petf.element_type_id = piv.element_type_id
1209: and upper(piv.name) = upper('Week commencing')
1210: )
1211: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 1231: from pay_input_values_f piv

1227: and nvl(pps.final_process_date,to_date('31/12/4712','DD/MM/YYYY')) >= sysdate
1228: )
1229: and peev3.input_value_id =
1230: (select input_value_id
1231: from pay_input_values_f piv
1232: where petf.element_type_id = piv.element_type_id
1233: and upper(piv.name) = upper('Rate'))
1234: -- Rate restriction - only retrieve entries on LOW rate for SMP
1235: and upper(peev3.screen_entry_value) = upper('Low')

Line 1321: pay_input_values_f piv,

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

Line 1336: from pay_input_values_f piv

1332: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
1333: -- Time restriction - only rows after tax year end
1334: and peev2.input_value_id =
1335: (select input_value_id
1336: from pay_input_values_f piv
1337: where petf.element_type_id = piv.element_type_id
1338: and upper(piv.name) = upper('Week commencing')
1339: )
1340: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 1437: pay_input_values_f piv,

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

Line 1452: from pay_input_values_f piv

1448: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
1449: -- Time restriction - only rows after tax year end
1450: and peev2.input_value_id =
1451: (select input_value_id
1452: from pay_input_values_f piv
1453: where petf.element_type_id = piv.element_type_id
1454: and upper(piv.name) = upper('Week commencing')
1455: )
1456: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 1552: pay_input_values_f piv,

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

Line 1567: from pay_input_values_f piv

1563: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
1564: -- Time restriction - only rows after tax year end
1565: and peev2.input_value_id =
1566: (select input_value_id
1567: from pay_input_values_f piv
1568: where petf.element_type_id = piv.element_type_id
1569: and upper(piv.name) = upper('Week commencing')
1570: )
1571: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 2098: from pay_input_values_f piv,

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

Line 2110: pay_input_values_f piv,

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

Line 2127: from pay_input_values_f piv,

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

Line 2241: pay_input_values_f piv,

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

Line 2257: from pay_input_values_f piv

2253: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
2254: -- Time restriction - only rows after tax year end
2255: and peev2.input_value_id =
2256: (select input_value_id
2257: from pay_input_values_f piv
2258: where petf.element_type_id = piv.element_type_id
2259: and upper(piv.name) = upper('Week commencing')
2260: )
2261: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 2281: from pay_input_values_f piv

2277: and nvl(pps.final_process_date,to_date('31/12/4712','DD/MM/YYYY')) >= sysdate
2278: )
2279: and peev3.input_value_id =
2280: (select input_value_id
2281: from pay_input_values_f piv
2282: where petf.element_type_id = piv.element_type_id
2283: and upper(piv.name) = upper('Rate'))
2284: -- Rate restriction - only retrieve entries on LOW rate for SMP
2285: and upper(peev3.screen_entry_value) = upper('Low')

Line 2371: pay_input_values_f piv,

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

Line 2386: from pay_input_values_f piv

2382: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
2383: -- Time restriction - only rows after tax year end
2384: and peev2.input_value_id =
2385: (select input_value_id
2386: from pay_input_values_f piv
2387: where petf.element_type_id = piv.element_type_id
2388: and upper(piv.name) = upper('Week commencing')
2389: )
2390: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 2487: pay_input_values_f piv,

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

Line 2502: from pay_input_values_f piv

2498: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
2499: -- Time restriction - only rows after tax year end
2500: and peev2.input_value_id =
2501: (select input_value_id
2502: from pay_input_values_f piv
2503: where petf.element_type_id = piv.element_type_id
2504: and upper(piv.name) = upper('Week commencing')
2505: )
2506: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

Line 2602: pay_input_values_f piv,

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

Line 2617: from pay_input_values_f piv

2613: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5
2614: -- Time restriction - only rows after tax year end
2615: and peev2.input_value_id =
2616: (select input_value_id
2617: from pay_input_values_f piv
2618: where petf.element_type_id = piv.element_type_id
2619: and upper(piv.name) = upper('Week commencing')
2620: )
2621: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)