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_SSP_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 297: from per_absence_attendances

293: --
294: -- Get the details of an absence, given its ID.
295: --
296: select *
297: from per_absence_attendances
298: where absence_attendance_id = p_absence_attendance_id;
299: --
300: g_absence per_absence_attendances%rowtype;
301: --

Line 300: g_absence per_absence_attendances%rowtype;

296: select *
297: from per_absence_attendances
298: where absence_attendance_id = p_absence_attendance_id;
299: --
300: g_absence per_absence_attendances%rowtype;
301: --
302: cursor PIW is
303: --
304: -- Get all the PIWs which link to this one

Line 313: from per_absence_attendances

309: nvl(sickness_end_date,hr_general.end_of_time) sickness_end_date,
310: business_group_id,
311: absence_attendance_id,
312: pregnancy_related_illness
313: from per_absence_attendances
314: where (g_PIW_id = absence_attendance_id and linked_absence_id is null)
315: or g_PIW_ID = linked_absence_id
316: order by sickness_start_date;
317: --

Line 614: from per_absence_attendances ABSENCE,

610: --
611: -- Get all the absences affected by the current transaction.
612: --
613: select absence.*
614: from per_absence_attendances ABSENCE,
615: ssp_temp_affected_rows TRANSACTION
616: where
617: ( (transaction.PIW_ID = absence.absence_attendance_id and
618: absence.linked_absence_id IS NULL)

Line 650: update per_absence_attendances

646: then
647: --
648: -- update the absence's linked absence ID to the calculated one
649: --
650: update per_absence_attendances
651: set linked_absence_id = l_new_linked_absence_id
652: where absence_attendance_id = new_link.absence_attendance_id;
653: --
654: if l_new_linked_absence_id is not null

Line 689: from per_absence_attendances

685: cursor csr_contiguous_absences is
686: select absence_attendance_id,
687: sickness_start_date,
688: sickness_end_date
689: from per_absence_attendances
690: where person_id = p_person_id
691: and sickness_start_date is not null
692: and sickness_start_date < p_sickness_start_date
693: and linked_absence_id is null

Line 699: from per_absence_attendances

695: for update;
696: --
697: cursor csr_linked_absence (x_sickness_start_date date) is
698: select absence_attendance_id
699: from per_absence_attendances
700: where sickness_start_date = x_sickness_start_date
701: and person_id = p_person_id;
702: --
703: l_PIW_id number := null;

Line 757: update per_absence_attendances

753: exit when(previous.sickness_end_date <> l_current_sickness_start - 1 or
754: previous.absence_attendance_id = l_PIW_ID);
755: --
756: -- Set the PIW ID of the previous absence the same as the current one
757: update per_absence_attendances
758: set linked_absence_id = l_PIW_ID
759: where current of csr_contiguous_absences;
760: --
761: l_current_sickness_start := previous.sickness_start_date;

Line 788: from per_absence_attendances

784: --for which the person has absences
785: cursor csr_abs_days(p_start date, p_end date) is
786: select nvl(sum(nvl(least(sickness_end_date,p_end),p_end) -
787: greatest(sickness_start_date,p_start) + 1),0)
788: from per_absence_attendances
789: where person_id = p_person_id
790: and sickness_start_date <= p_end
791: and nvl(sickness_end_date,hr_general.end_of_time) >= p_start;
792: --

Line 799: from per_absence_attendances

795: -- select the dates for the continuous absence formed by the parameter
796: -- absence and any absences adjacent to it.
797: select least(min(sickness_start_date),p_start),
798: greatest(max(nvl(sickness_end_date,hr_general.end_of_time)),p_end)
799: from per_absence_attendances
800: where person_id = p_person_id
801: and (sickness_end_date = p_start2 or sickness_start_date = p_end2);
802: --
803: l_days_absent number := 0;

Line 885: from per_absence_attendances

881: --for which the person has absences
882: cursor csr_abs_days(p_start date, p_end date) is
883: select nvl(sum(nvl(least(sickness_end_date,p_end),p_end) -
884: greatest(sickness_start_date,p_start) + 1),0)
885: from per_absence_attendances
886: where person_id = p_person_id
887: and sickness_start_date <= p_end
888: and nvl(sickness_end_date,hr_general.end_of_time) >= p_start;
889: --

Line 896: from per_absence_attendances

892: -- select the dates for the continuous absence formed by the parameter
893: -- absence and any absences adjacent to it.
894: select least(min(sickness_start_date),p_start),
895: greatest(max(nvl(sickness_end_date,hr_general.end_of_time)),p_end)
896: from per_absence_attendances
897: where person_id = p_person_id
898: and (sickness_end_date = p_start2 or sickness_start_date = p_end2);
899: --
900: cursor csr_linked_id is

Line 902: from per_absence_attendances

898: and (sickness_end_date = p_start2 or sickness_start_date = p_end2);
899: --
900: cursor csr_linked_id is
901: select linked_absence_id
902: from per_absence_attendances
903: where absence_attendance_id = p_absence_attendance_id;
904: --
905: l_days_absent number := 0;
906: l_linked number := null;

Line 1004: from per_absence_attendances ABS

1000: --
1001: select abs.linked_absence_id,
1002: abs.sickness_start_date,
1003: abs.sickness_end_date
1004: from per_absence_attendances ABS
1005: where abs.sickness_start_date is not null
1006: and person_id = p_person_id
1007: and abs.sickness_start_date = (
1008: --

Line 1010: from per_absence_attendances ABS2

1006: and person_id = p_person_id
1007: and abs.sickness_start_date = (
1008: --
1009: select min (abs2.sickness_start_date)
1010: from per_absence_attendances ABS2
1011: where abs2.sickness_start_date >= p_old_sickness_end_date
1012: and person_id = p_person_id);
1013: --
1014: l_proc varchar2 (72) := g_package||'check_sickness_date_change';

Line 1116: from per_absence_attendances

1112: -- Return a row if there are any sickness absences in a series of
1113: -- which this absence is first.
1114: --
1115: select 1
1116: from per_absence_attendances
1117: where linked_absence_id = p_absence_attendance_id;
1118: --
1119: cursor csr_next_absence is
1120: --

Line 1125: from per_absence_attendances

1121: -- Get the absence which is next in the linked series of which this
1122: -- absence is a part.
1123: --
1124: select max (sickness_end_date)
1125: from per_absence_attendances
1126: where p_linked_absence_id = linked_absence_id
1127: and sickness_end_date <= p_sickness_start_date;
1128: --
1129: cursor csr_previous_absence is

Line 1135: from per_absence_attendances

1131: -- Get the absence which is the previous one in the linked series of
1132: -- which this absence is a part.
1133: --
1134: select min (sickness_start_date)
1135: from per_absence_attendances
1136: where (l_PIW_id = linked_absence_id and absence_attendance_id is null)
1137: or (l_PIW_id = absence_attendance_id and linked_absence_id is null)
1138: and sickness_start_date >= p_sickness_end_date;
1139: --

Line 1286: from per_absence_attendances

1282: --
1283: -- Get the linked ID from the absence
1284: cursor csr_linked_id(p_absence_id number) is
1285: select linked_absence_id
1286: from per_absence_attendances
1287: where absence_attendance_id = p_absence_id;
1288: --
1289: cursor csr_start_date(p_absence_id number) is
1290: select sickness_start_date

Line 1291: from per_absence_attendances

1287: where absence_attendance_id = p_absence_id;
1288: --
1289: cursor csr_start_date(p_absence_id number) is
1290: select sickness_start_date
1291: from per_absence_attendances
1292: where absence_attendance_id = p_absence_id;
1293: --
1294: cursor csr_end_date(p_absence_id number) is
1295: select sickness_end_date

Line 1296: from per_absence_attendances

1292: where absence_attendance_id = p_absence_id;
1293: --
1294: cursor csr_end_date(p_absence_id number) is
1295: select sickness_end_date
1296: from per_absence_attendances
1297: where (absence_attendance_id = p_absence_id
1298: or
1299: linked_absence_id = p_absence_id)
1300: order by sickness_end_date desc;

Line 1345: from per_absence_attendances

1341: cursor PIW_series(p_start_date date) is
1342: select sickness_start_date,
1343: sickness_end_date,
1344: absence_attendance_id
1345: from per_absence_attendances
1346: where person_id = p_person_id
1347: and sickness_start_date is not null
1348: and sickness_start_date < p_sickness_start_date
1349: and (p_start_date is null or

Line 1440: from per_absence_attendances

1436: cursor PIW_series(p_start_date date) is
1437: select sickness_start_date,
1438: sickness_end_date,
1439: absence_attendance_id
1440: from per_absence_attendances
1441: where person_id = p_person_id
1442: and sickness_start_date is not null
1443: and sickness_start_date < p_sickness_start_date
1444: and (p_start_date is null or

Line 1537: from per_absence_attendances

1533: cursor PIW_series(p_start_date date) is
1534: select sickness_start_date,
1535: sickness_end_date,
1536: absence_attendance_id
1537: from per_absence_attendances
1538: where person_id = p_person_id
1539: and sickness_start_date is not null
1540: and sickness_start_date < p_sickness_start_date
1541: and (p_start_date is null or

Line 1633: from per_absence_attendances

1629: cursor PIW_series(p_start_date date) is
1630: select sickness_start_date,
1631: sickness_end_date,
1632: absence_attendance_id
1633: from per_absence_attendances
1634: where person_id = p_person_id
1635: and sickness_start_date is not null
1636: and sickness_start_date > p_sickness_start_date
1637: and (p_start_date is null or

Line 1698: from per_absence_attendances

1694: cursor PIW_series(p_start_date date) is
1695: select sickness_start_date,
1696: sickness_end_date,
1697: absence_attendance_id
1698: from per_absence_attendances
1699: where person_id = p_person_id
1700: and sickness_start_date is not null
1701: and sickness_start_date > p_sickness_start_date
1702: and (p_start_date is null or

Line 1767: from per_absence_attendances

1763: cursor PIW_series(p_start_date date) is
1764: select sickness_start_date,
1765: sickness_end_date,
1766: absence_attendance_id
1767: from per_absence_attendances
1768: where person_id = p_person_id
1769: and sickness_start_date is not null
1770: and sickness_start_date > p_sickness_start_date
1771: and (p_start_date is null or

Line 2133: function ENTITLED_TO_SSP(p_absence per_absence_attendances%rowtype)

2129: --
2130: end SSP_is_installed;
2131: --------------------------------------------------------------------------------
2132: --------------------------------------------------------------------------------
2133: function ENTITLED_TO_SSP(p_absence per_absence_attendances%rowtype)
2134: --
2135: -- See header for description of this function.
2136: --
2137: return boolean is

Line 2234: from per_absence_attendances

2230: l_end_date date;
2231:
2232: cursor get_end_date is
2233: select nvl(sickness_end_date, l_01_October_06 - 1)
2234: from per_absence_attendances
2235: where ((sickness_end_date is null and sickness_start_date < l_01_October_06)
2236: or
2237: sickness_end_date < l_01_October_06)
2238: and person_id = p_absence.person_id

Line 2412: per_absence_attendances paa

2408: ))
2409: union all
2410: select withhold_from, withhold_to
2411: from ssp_stoppages ss,
2412: per_absence_attendances paa
2413: where paa.linked_absence_id = g_PIW_id
2414: and paa.absence_attendance_id = ss.absence_attendance_id
2415: and override_stoppage = 'N'
2416: and withhold_to is not null

Line 4054: from per_absence_attendances

4050: --
4051: -- Get any PIW which may have been linked to the prior employment SSP.
4052: --
4053: select nvl (linked_absence_id, absence_attendance_id) PIW_ID
4054: from per_absence_attendances
4055: where sickness_start_date
4056: <= (p_date_start + g_SSP_legislation.linking_period_days)
4057: and person_id = p_person_id;
4058: --

Line 4117: from per_absence_attendances

4113: select linked_absence_id,
4114: absence_attendance_id,
4115: sickness_start_date,
4116: sickness_end_date
4117: from per_absence_attendances
4118: where person_id = p_person_id
4119: and sickness_start_date is not null;
4120: --
4121: l_proc varchar2(72) := g_package||'person_control';

Line 4265: from per_absence_attendances

4261: -- Find the PIW whose start date is the same as the date of the
4262: -- average earnings calculation.
4263: --
4264: select *
4265: from per_absence_attendances
4266: where sickness_start_date = p_effective_date
4267: and person_id = p_person_id;
4268: --
4269: l_proc varchar2 (72) := g_package||'earnings_control';