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 856: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

852: WHEN PAA.DATE_START = PAA.DATE_END THEN
853: 1
854: ELSE (PAA.DATE_END - PAA.DATE_START) END ) AS DAYS
855: INTO l_abs_unauthor
856: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
857: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
858: AND PAT.ABSENCE_CATEGORY = 'UN'
859: AND PAA.DATE_START <= l_dateofjoin_28
860: AND PAA.DATE_END >= l_dateofjoin

Line 870: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

866: WHEN PAA.DATE_START = PAA.DATE_END THEN
867: 1
868: ELSE (PAA.DATE_END - PAA.DATE_START) + 1 END ) AS DAYS
869: INTO l_abs_unauthor
870: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
871: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
872: AND PAT.ABSENCE_CATEGORY = 'UN'
873: AND PAA.DATE_START <= (p_abs_start_date-1)
874: AND PAA.DATE_END >= l_dateofjoin

Line 899: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

895: -- 14 days within 28 days then no sickness will be paid.
896: BEGIN
897: SELECT COUNT(1)
898: INTO l_abs_count
899: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
900: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
901: AND PAT.ABSENCE_CATEGORY IN ( 'CMS','PA','PTP','M','PTM','IE_AL' ,'PTA')
902: AND PAA.DATE_END BETWEEN (p_abs_start_date - (p_abs_min_gap+1)) AND p_abs_start_date
903: AND ( PAA.DATE_END - PAA.DATE_START ) > p_abs_link_period

Line 2577: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

2573: WHEN PAA.DATE_START = PAA.DATE_END THEN
2574: 1
2575: ELSE (PAA.DATE_END - PAA.DATE_START) END ) AS DAYS
2576: INTO l_abs_unauthor
2577: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
2578: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
2579: AND PAT.ABSENCE_CATEGORY = 'UN'
2580: AND PAA.DATE_START <= l_dateofjoin_28
2581: AND PAA.DATE_END >= l_dateofjoin

Line 2591: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

2587: WHEN PAA.DATE_START = PAA.DATE_END THEN
2588: 1
2589: ELSE (PAA.DATE_END - PAA.DATE_START) + 1 END ) AS DAYS
2590: INTO l_abs_unauthor
2591: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
2592: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
2593: AND PAT.ABSENCE_CATEGORY = 'UN'
2594: AND PAA.DATE_START <= (p_abs_start_date-1)
2595: AND PAA.DATE_END >= l_dateofjoin

Line 2618: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT

2614: -- 14 days within 28 days then no Child Minder Sickness will be paid.
2615: BEGIN
2616: SELECT COUNT(1)
2617: INTO l_abs_count
2618: FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
2619: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
2620: AND PAT.ABSENCE_CATEGORY IN ( 'S','PTS','PA','PTP','M','PTM','IE_AL','PTA' )
2621: AND PAA.DATE_END BETWEEN (p_abs_start_date - (p_abs_min_gap+1)) AND p_abs_start_date
2622: AND ( PAA.DATE_END - PAA.DATE_START ) > p_abs_link_period

Line 3903: FROM per_absence_attendances paa, per_absence_attendance_types pat

3899: BEGIN
3900: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
3901: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
3902: INTO l_paternity_sum
3903: FROM per_absence_attendances paa, per_absence_attendance_types pat
3904: WHERE paa.person_id = p_person_id
3905: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
3906: AND paa.date_end < p_abs_start_date
3907: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 4353: FROM per_absence_attendances paa, per_absence_attendance_types pat

4349: BEGIN
4350: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
4351: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
4352: INTO l_pt_paternity_sum
4353: FROM per_absence_attendances paa, per_absence_attendance_types pat
4354: WHERE paa.person_id = p_person_id
4355: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
4356: AND paa.date_end < p_abs_start_date
4357: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 4828: FROM per_absence_attendances paa, per_absence_attendance_types pat

4824: BEGIN
4825: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
4826: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
4827: INTO l_maternity_sum
4828: FROM per_absence_attendances paa, per_absence_attendance_types pat
4829: WHERE paa.person_id = p_person_id
4830: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
4831: AND paa.date_end < p_abs_start_date
4832: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 5287: FROM per_absence_attendances paa, per_absence_attendance_types pat

5283: BEGIN
5284: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
5285: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
5286: INTO l_pt_maternity_sum
5287: FROM per_absence_attendances paa, per_absence_attendance_types pat
5288: WHERE paa.person_id = p_person_id
5289: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
5290: AND paa.date_end < p_abs_start_date
5291: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 5804: FROM per_absence_attendances paa, per_absence_attendance_types pat

5800: BEGIN
5801: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
5802: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
5803: INTO l_adopt_sum
5804: FROM per_absence_attendances paa, per_absence_attendance_types pat
5805: WHERE paa.person_id = p_person_id
5806: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
5807: AND paa.date_end < p_abs_start_date
5808: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL

Line 6317: FROM per_absence_attendances paa, per_absence_attendance_types pat

6313: BEGIN
6314: SELECT SUM(DECODE(paa.date_start, paa.date_end, 1,
6315: get_weekdays(greatest(p_pay_start_date, paa.date_start), paa.date_end, p_work_pattern) )) AS days_diff
6316: INTO l_adopt_sum
6317: FROM per_absence_attendances paa, per_absence_attendance_types pat
6318: WHERE paa.person_id = p_person_id
6319: AND paa.date_end BETWEEN p_pay_start_date AND p_pay_end_date
6320: AND paa.date_end < p_abs_start_date
6321: AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL