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 HR_GBNICAR

Line 931: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))

927: and paat.absence_category = 'S'
928: and
929: /* SSP absences which span tax years or start in old tax year and are open-ended */
930: (
931: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
932: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
933: )
934: or
935: ((paa.sickness_start_date between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))

Line 932: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)

928: and
929: /* SSP absences which span tax years or start in old tax year and are open-ended */
930: (
931: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
932: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
933: )
934: or
935: ((paa.sickness_start_date between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
936: and (paa.sickness_end_date > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.sickness_end_date is null)

Line 935: ((paa.sickness_start_date between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))

931: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
932: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
933: )
934: or
935: ((paa.sickness_start_date between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
936: and (paa.sickness_end_date > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.sickness_end_date is null)
937: )
938: or
939: /* SSP absences which start in the new tax year */

Line 936: and (paa.sickness_end_date > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.sickness_end_date is null)

932: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
933: )
934: or
935: ((paa.sickness_start_date between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
936: and (paa.sickness_end_date > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.sickness_end_date is null)
937: )
938: or
939: /* SSP absences which start in the new tax year */
940: (

Line 941: paa.date_start >= hr_gbnicar.uk_tax_yr_end(sysdate)

937: )
938: or
939: /* SSP absences which start in the new tax year */
940: (
941: paa.date_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
942: or paa.date_projected_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
943: )
944: )
945: /* Do not retrieve terminated employees whose actual termination dates have passed or are null */

Line 942: or paa.date_projected_start >= hr_gbnicar.uk_tax_yr_end(sysdate)

938: or
939: /* SSP absences which start in the new tax year */
940: (
941: paa.date_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
942: or paa.date_projected_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
943: )
944: )
945: /* Do not retrieve terminated employees whose actual termination dates have passed or are null */
946: and not exists

Line 979: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))

975: and nvl(mat.leave_type, 'MA') = p_leave_type
976: and
977: /* SMP absences which span tax years or start in old tax year and are open-ended */
978: (
979: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
980: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
981: )
982: or
983: ((paa.date_projected_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))

Line 980: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)

976: and
977: /* SMP absences which span tax years or start in old tax year and are open-ended */
978: (
979: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
980: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
981: )
982: or
983: ((paa.date_projected_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
984: and (paa.date_projected_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_projected_end is null)

Line 983: ((paa.date_projected_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))

979: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
980: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
981: )
982: or
983: ((paa.date_projected_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
984: and (paa.date_projected_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_projected_end is null)
985: and paa.date_start IS NULL -- use projected dates only when actual dates not available
986: )
987: or

Line 984: and (paa.date_projected_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_projected_end is null)

980: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
981: )
982: or
983: ((paa.date_projected_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
984: and (paa.date_projected_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_projected_end is null)
985: and paa.date_start IS NULL -- use projected dates only when actual dates not available
986: )
987: or
988: /* SMP absences which start in the new tax year */

Line 990: paa.date_start >= hr_gbnicar.uk_tax_yr_end(sysdate)

986: )
987: or
988: /* SMP absences which start in the new tax year */
989: (
990: paa.date_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
991: or (paa.date_projected_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
992: and paa.date_start IS NULL) -- use projected dates only when actual dates not available
993: )
994: )

Line 991: or (paa.date_projected_start >= hr_gbnicar.uk_tax_yr_end(sysdate)

987: or
988: /* SMP absences which start in the new tax year */
989: (
990: paa.date_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
991: or (paa.date_projected_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
992: and paa.date_start IS NULL) -- use projected dates only when actual dates not available
993: )
994: )
995: /* Do not retrieve employees whose final process dates have passed */

Line 1053: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate);

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);
1054:
1055:
1056: cursor csr_first_new_ssp_entry is
1057: select peev1.screen_entry_value

Line 1071: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate)

1067: and peef.element_link_id = pelf.element_link_id
1068: and pelf.element_type_id = petf.element_type_id
1069: and piv.name = 'Rate'
1070: and petf.element_name = 'Statutory Sick Pay'
1071: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate)
1072: and peev2.element_entry_value_id =
1073: (select peev3.element_entry_value_id
1074: from pay_element_entry_values_f peev3
1075: where input_value_id =

Line 1083: fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate))

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 >
1083: fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate))
1084: /* Retrieve only those entries that will be retrieved by main SSP query */
1085: and peev3.element_entry_id in
1086: ( select peef1.element_entry_id
1087: from pay_element_entries_f peef1,

Line 1175: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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:
1178:
1179: /* 09/12/2003 rmakhija - commented out following cursor because element entry value

Line 1203: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5

1199: and peef.element_link_id = pelf.element_link_id
1200: and pelf.element_type_id = petf.element_type_id
1201: and piv.name = 'Amount'
1202: and petf.element_name = 'Statutory Maternity Pay'
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

Line 1211: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

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)
1212: -- Retrieve only those entries that main SMP query will retrieve
1213: and exists
1214: ( select 1
1215: from per_all_assignments_f paf,

Line 1244: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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:
1247: l_new_SMP_rate number;
1248: l_old_SMP_rate number;

Line 1307: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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: --
1310: /* 09/12/2003 rmakhija - commented out following cursor because element entry value
1311: for 'Amount' is a calculated value and it is not same

Line 1332: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5

1328: and peef.element_link_id = pelf.element_link_id
1329: and pelf.element_type_id = petf.element_type_id
1330: and piv.name = 'Amount'
1331: and petf.element_name = 'Statutory Adoption Pay'
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

Line 1340: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

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)
1341: -- Retrieve only those entries that main sap query will retrieve
1342: and exists
1343: ( select 1
1344: from per_all_assignments_f paf,

Line 1366: and petf.effective_start_date < hr_gbnicar.uk_tax_yr_end(sysdate) - 4

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: --
1369: --
1370: l_new_sap_rate number;

Line 1423: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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: --
1426: /* 09/12/2003 rmakhija - commented out following cursor because element entry value
1427: for 'Amount' is a calculated value and it is not same

Line 1448: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5

1444: and peef.element_link_id = pelf.element_link_id
1445: and pelf.element_type_id = petf.element_type_id
1446: and piv.name = 'Amount'
1447: and petf.element_name = 'Statutory Paternity Pay Adoption'
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

Line 1456: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

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)
1457: -- Retrieve only those entries that main sppa query will retrieve
1458: and exists
1459: ( select 1
1460: from per_all_assignments_f paf,

Line 1482: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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:
1485: --
1486: l_new_sppa_rate number;

Line 1538: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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: --
1541: /* 09/12/2003 rmakhija - commented out following cursor because element entry value
1542: for 'Amount' is a calculated value and it is not same

Line 1563: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5

1559: and peef.element_link_id = pelf.element_link_id
1560: and pelf.element_type_id = petf.element_type_id
1561: and piv.name = 'Amount'
1562: and petf.element_name = 'Statutory Paternity Pay Birth'
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

Line 1571: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

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)
1572: -- Retrieve only those entries that main SPPB query will retrieve
1573: and exists
1574: ( select 1
1575: from per_all_assignments_f paf,

Line 1597: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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: --
1600: l_new_sppb_rate number;
1601: l_old_sppb_rate number;

Line 1967: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))

1963: and paat.absence_category = 'S'
1964: and
1965: /* SSP absences which span tax years or start in old tax year and are open-ended */
1966: (
1967: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
1968: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
1969: )
1970: or
1971: ((paa.sickness_start_date between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))

Line 1968: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)

1964: and
1965: /* SSP absences which span tax years or start in old tax year and are open-ended */
1966: (
1967: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
1968: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
1969: )
1970: or
1971: ((paa.sickness_start_date between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
1972: and (paa.sickness_end_date > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.sickness_end_date is null)

Line 1971: ((paa.sickness_start_date between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))

1967: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
1968: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
1969: )
1970: or
1971: ((paa.sickness_start_date between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
1972: and (paa.sickness_end_date > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.sickness_end_date is null)
1973: )
1974: or
1975: /* SSP absences which start in the new tax year */

Line 1972: and (paa.sickness_end_date > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.sickness_end_date is null)

1968: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
1969: )
1970: or
1971: ((paa.sickness_start_date between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
1972: and (paa.sickness_end_date > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.sickness_end_date is null)
1973: )
1974: or
1975: /* SSP absences which start in the new tax year */
1976: (

Line 1977: paa.date_start >= hr_gbnicar.uk_tax_yr_end(sysdate)

1973: )
1974: or
1975: /* SSP absences which start in the new tax year */
1976: (
1977: paa.date_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
1978: or paa.date_projected_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
1979: )
1980: )
1981: /* Do not retrieve terminated employees whose actual termination dates have passed or are null */

Line 1978: or paa.date_projected_start >= hr_gbnicar.uk_tax_yr_end(sysdate)

1974: or
1975: /* SSP absences which start in the new tax year */
1976: (
1977: paa.date_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
1978: or paa.date_projected_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
1979: )
1980: )
1981: /* Do not retrieve terminated employees whose actual termination dates have passed or are null */
1982: and not exists

Line 2015: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))

2011: and nvl(mat.leave_type, 'MA') = p_leave_type
2012: and
2013: /* SMP absences which span tax years or start in old tax year and are open-ended */
2014: (
2015: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
2016: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
2017: )
2018: or
2019: ((paa.date_projected_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))

Line 2016: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)

2012: and
2013: /* SMP absences which span tax years or start in old tax year and are open-ended */
2014: (
2015: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
2016: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
2017: )
2018: or
2019: ((paa.date_projected_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
2020: and (paa.date_projected_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_projected_end is null)

Line 2019: ((paa.date_projected_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))

2015: ((paa.date_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
2016: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
2017: )
2018: or
2019: ((paa.date_projected_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
2020: and (paa.date_projected_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_projected_end is null)
2021: and paa.date_start IS NULL -- use projected dates only when actual dates not available
2022: )
2023: or

Line 2020: and (paa.date_projected_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_projected_end is null)

2016: and (paa.date_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_end is null)
2017: )
2018: or
2019: ((paa.date_projected_start between hr_gbnicar.uk_tax_yr_start(sysdate) and hr_gbnicar.uk_tax_yr_end(sysdate))
2020: and (paa.date_projected_end > hr_gbnicar.uk_tax_yr_end(sysdate) or paa.date_projected_end is null)
2021: and paa.date_start IS NULL -- use projected dates only when actual dates not available
2022: )
2023: or
2024: /* SMP absences which start in the new tax year */

Line 2026: paa.date_start >= hr_gbnicar.uk_tax_yr_end(sysdate)

2022: )
2023: or
2024: /* SMP absences which start in the new tax year */
2025: (
2026: paa.date_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
2027: or (paa.date_projected_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
2028: and paa.date_start IS NULL) -- use projected dates only when actual dates not available
2029: )
2030: )

Line 2027: or (paa.date_projected_start >= hr_gbnicar.uk_tax_yr_end(sysdate)

2023: or
2024: /* SMP absences which start in the new tax year */
2025: (
2026: paa.date_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
2027: or (paa.date_projected_start >= hr_gbnicar.uk_tax_yr_end(sysdate)
2028: and paa.date_start IS NULL) -- use projected dates only when actual dates not available
2029: )
2030: )
2031: /* Do not retrieve employees whose final process dates have passed */

Line 2103: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate);

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);
2104:
2105:
2106: cursor csr_first_new_ssp_entry is
2107: select peev1.screen_entry_value

Line 2121: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate)

2117: and peef.element_link_id = pelf.element_link_id
2118: and pelf.element_type_id = petf.element_type_id
2119: and piv.name = 'Rate'
2120: and petf.element_name = 'Statutory Sick Pay'
2121: and piv.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate)
2122: and peev2.element_entry_value_id =
2123: (select peev3.element_entry_value_id
2124: from pay_element_entry_values_f peev3
2125: where input_value_id =

Line 2133: fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate))

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 >
2133: fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate))
2134: /* Retrieve only those entries that will be retrieved by main SSP query */
2135: and peev3.element_entry_id in
2136: ( select peef1.element_entry_id
2137: from pay_element_entries_f peef1,

Line 2225: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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:
2228:
2229: /* 09/12/2003 rmakhija - commented out following cursor because element entry value

Line 2253: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5

2249: and peef.element_link_id = pelf.element_link_id
2250: and pelf.element_type_id = petf.element_type_id
2251: and piv.name = 'Amount'
2252: and petf.element_name = 'Statutory Maternity Pay'
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

Line 2261: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

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)
2262: -- Retrieve only those entries that main SMP query will retrieve
2263: and exists
2264: ( select 1
2265: from per_all_assignments_f paf,

Line 2294: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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:
2297: l_new_SMP_rate number;
2298: l_old_SMP_rate number;

Line 2357: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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: --
2360: /* 09/12/2003 rmakhija - commented out following cursor because element entry value
2361: for 'Amount' is a calculated value and it is not same

Line 2382: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5

2378: and peef.element_link_id = pelf.element_link_id
2379: and pelf.element_type_id = petf.element_type_id
2380: and piv.name = 'Amount'
2381: and petf.element_name = 'Statutory Adoption Pay'
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

Line 2390: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

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)
2391: -- Retrieve only those entries that main sap query will retrieve
2392: and exists
2393: ( select 1
2394: from per_all_assignments_f paf,

Line 2416: and petf.effective_start_date < hr_gbnicar.uk_tax_yr_end(sysdate) - 4

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: --
2419: --
2420: l_new_sap_rate number;

Line 2473: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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: --
2476: /* 09/12/2003 rmakhija - commented out following cursor because element entry value
2477: for 'Amount' is a calculated value and it is not same

Line 2498: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5

2494: and peef.element_link_id = pelf.element_link_id
2495: and pelf.element_type_id = petf.element_type_id
2496: and piv.name = 'Amount'
2497: and petf.element_name = 'Statutory Paternity Pay Adoption'
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

Line 2506: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

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)
2507: -- Retrieve only those entries that main sppa query will retrieve
2508: and exists
2509: ( select 1
2510: from per_all_assignments_f paf,

Line 2532: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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:
2535: --
2536: l_new_sppa_rate number;

Line 2588: and petf.effective_start_date >= trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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: --
2591: /* 09/12/2003 rmakhija - commented out following cursor because element entry value
2592: for 'Amount' is a calculated value and it is not same

Line 2613: and petf.effective_start_date > hr_gbnicar.uk_tax_yr_end(sysdate) - 5

2609: and peef.element_link_id = pelf.element_link_id
2610: and pelf.element_type_id = petf.element_type_id
2611: and piv.name = 'Amount'
2612: and petf.element_name = 'Statutory Paternity Pay Birth'
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

Line 2621: and peev2.screen_entry_value > fnd_date.date_to_canonical(hr_gbnicar.uk_tax_yr_end(sysdate) - 5)

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)
2622: -- Retrieve only those entries that main SPPB query will retrieve
2623: and exists
2624: ( select 1
2625: from per_all_assignments_f paf,

Line 2647: and petf.effective_start_date < trunc(hr_gbnicar.uk_tax_yr_end(sysdate)) - 4

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: --
2650: l_new_sppb_rate number;
2651: l_old_sppb_rate number;