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.PAY_NO_ABSENCE dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 79: FROM per_absence_attendances paa, per_absence_attendance_types pat

75: SELECT paa.absence_attendance_id
76: ,paa.date_start
77: ,paa.date_end,
78: DECODE(paa.date_start, paa.date_end, 1, (paa.date_end-paa.date_start)+1) AS days_diff
79: FROM per_absence_attendances paa, per_absence_attendance_types pat
80: WHERE paa.person_id = l_person_id
81: AND paa.date_start < p_abs_start_date
82: AND paa.date_end < p_abs_start_date
83: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 185: FROM per_absence_attendances paa, per_absence_attendance_types pat

181: SELECT paa.absence_attendance_id
182: ,paa.date_start
183: ,paa.date_end,
184: DECODE(paa.date_start, paa.date_end, 1, (paa.date_end-paa.date_start)+1) AS days_diff
185: FROM per_absence_attendances paa, per_absence_attendance_types pat
186: WHERE paa.person_id = l_person_id
187: AND paa.date_start < p_abs_start_date
188: AND paa.date_end < p_abs_start_date
189: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 829: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

825: WHEN PAA.DATE_START = PAA.DATE_END THEN
826: 1
827: ELSE (PAA.DATE_END - PAA.DATE_START) END ) AS DAYS
828: INTO l_abs_unauthor
829: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
830: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
831: AND PAT.ABSENCE_CATEGORY = 'UN'
832: AND PAA.DATE_START <= l_dateofjoin_28
833: AND PAA.DATE_END >= l_dateofjoin

Line 843: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

839: WHEN PAA.DATE_START = PAA.DATE_END THEN
840: 1
841: ELSE (PAA.DATE_END - PAA.DATE_START) + 1 END ) AS DAYS
842: INTO l_abs_unauthor
843: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
844: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
845: AND PAT.ABSENCE_CATEGORY = 'UN'
846: AND PAA.DATE_START <= (p_abs_start_date-1)
847: AND PAA.DATE_END >= l_dateofjoin

Line 872: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

868: -- 14 days within 28 days then no sickness will be paid.
869: BEGIN
870: SELECT COUNT(1)
871: INTO l_abs_count
872: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
873: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
874: AND PAT.ABSENCE_CATEGORY IN ( 'CMS','PA','PTP','M','PTM','IE_AL' ,'PTA')
875: AND PAA.DATE_END BETWEEN (p_abs_start_date - (p_abs_min_gap+1)) AND p_abs_start_date
876: AND ( PAA.DATE_END - PAA.DATE_START ) > p_abs_link_period

Line 2533: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

2529: WHEN PAA.DATE_START = PAA.DATE_END THEN
2530: 1
2531: ELSE (PAA.DATE_END - PAA.DATE_START) END ) AS DAYS
2532: INTO l_abs_unauthor
2533: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
2534: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
2535: AND PAT.ABSENCE_CATEGORY = 'UN'
2536: AND PAA.DATE_START <= l_dateofjoin_28
2537: AND PAA.DATE_END >= l_dateofjoin

Line 2547: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

2543: WHEN PAA.DATE_START = PAA.DATE_END THEN
2544: 1
2545: ELSE (PAA.DATE_END - PAA.DATE_START) + 1 END ) AS DAYS
2546: INTO l_abs_unauthor
2547: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
2548: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
2549: AND PAT.ABSENCE_CATEGORY = 'UN'
2550: AND PAA.DATE_START <= (p_abs_start_date-1)
2551: AND PAA.DATE_END >= l_dateofjoin

Line 2574: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

2570: -- 14 days within 28 days then no Child Minder Sickness will be paid.
2571: BEGIN
2572: SELECT COUNT(1)
2573: INTO l_abs_count
2574: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
2575: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
2576: AND PAT.ABSENCE_CATEGORY IN ( 'S','PTS','PA','PTP','M','PTM','IE_AL','PTA' )
2577: AND PAA.DATE_END BETWEEN (p_abs_start_date - (p_abs_min_gap+1)) AND p_abs_start_date
2578: AND ( PAA.DATE_END - PAA.DATE_START ) > p_abs_link_period

Line 3823: FROM per_absence_attendances paa, per_absence_attendance_types pat

3819: BEGIN
3820: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
3821: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
3822: INTO l_paternity_sum
3823: FROM per_absence_attendances paa, per_absence_attendance_types pat
3824: WHERE paa.person_id = p_person_id
3825: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
3826: AND paa.date_end < p_abs_start_date
3827: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 4272: FROM per_absence_attendances paa, per_absence_attendance_types pat

4268: BEGIN
4269: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
4270: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
4271: INTO l_pt_paternity_sum
4272: FROM per_absence_attendances paa, per_absence_attendance_types pat
4273: WHERE paa.person_id = p_person_id
4274: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
4275: AND paa.date_end < p_abs_start_date
4276: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 4746: FROM per_absence_attendances paa, per_absence_attendance_types pat

4742: BEGIN
4743: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
4744: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
4745: INTO l_maternity_sum
4746: FROM per_absence_attendances paa, per_absence_attendance_types pat
4747: WHERE paa.person_id = p_person_id
4748: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
4749: AND paa.date_end < p_abs_start_date
4750: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 5204: FROM per_absence_attendances paa, per_absence_attendance_types pat

5200: BEGIN
5201: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
5202: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
5203: INTO l_pt_maternity_sum
5204: FROM per_absence_attendances paa, per_absence_attendance_types pat
5205: WHERE paa.person_id = p_person_id
5206: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
5207: AND paa.date_end < p_abs_start_date
5208: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 5720: FROM per_absence_attendances paa, per_absence_attendance_types pat

5716: BEGIN
5717: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
5718: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
5719: INTO l_adopt_sum
5720: FROM per_absence_attendances paa, per_absence_attendance_types pat
5721: WHERE paa.person_id = p_person_id
5722: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
5723: AND paa.date_end < p_abs_start_date
5724: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 6232: FROM per_absence_attendances paa, per_absence_attendance_types pat

6228: BEGIN
6229: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
6230: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
6231: INTO l_adopt_sum
6232: FROM per_absence_attendances paa, per_absence_attendance_types pat
6233: WHERE paa.person_id = p_person_id
6234: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
6235: AND paa.date_end < p_abs_start_date
6236: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL