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.PQP_GB_OSP_FUNCTIONS dependencies on PER_ABSENCE_ATTENDANCES

Line 42: ,per_absence_attendances paa

38: IS
39: SELECT absence_attendance_id
40: FROM per_all_assignments_f asg,
41: ben_per_in_ler pil
42: ,per_absence_attendances paa
43: WHERE asg.assignment_id = p_assignment_id
44: AND p_effective_date BETWEEN asg.effective_start_date
45: AND asg.effective_end_date
46: AND pil.person_id = asg.person_id

Line 61: FROM per_absence_attendances

57: -- Cursor to get Maternity Id for a given Absence Attendance Id.
58: CURSOR csr_maternity_id(p_absence_id IN NUMBER)
59: IS
60: SELECT maternity_id
61: FROM per_absence_attendances
62: WHERE absence_attendance_id = p_absence_id;
63:
64: -- Cursor to get Absence Type for a Absence Id.
65: CURSOR csr_abs_type(p_absence_attendance_id IN NUMBER)

Line 68: FROM per_absence_attendances ABS, per_absence_attendance_types TYPE

64: -- Cursor to get Absence Type for a Absence Id.
65: CURSOR csr_abs_type(p_absence_attendance_id IN NUMBER)
66: IS
67: SELECT TYPE.NAME
68: FROM per_absence_attendances ABS, per_absence_attendance_types TYPE
69: WHERE ABS.absence_attendance_type_id = TYPE.absence_attendance_type_id
70: AND ABS.absence_attendance_id = p_absence_attendance_id;
71:
72: -- Cursor to get absence Category for a Absence Id.

Line 76: FROM per_absence_attendances ABS

72: -- Cursor to get absence Category for a Absence Id.
73: CURSOR csr_abs_cat(p_absence_attendance_id IN NUMBER)
74: IS
75: SELECT lkp.meaning
76: FROM per_absence_attendances ABS
77: ,per_absence_attendance_types TYPE
78: ,hr_lookups lkp
79: WHERE ABS.absence_attendance_type_id = TYPE.absence_attendance_type_id
80: AND TYPE.absence_category = lkp.lookup_code

Line 88: FROM per_absence_attendances ABS

84: -- Cursor to get Absence Reason for a Absence Id.
85: CURSOR csr_abs_rea(p_absence_attendance_id IN NUMBER)
86: IS
87: SELECT lkp.meaning
88: FROM per_absence_attendances ABS
89: ,per_abs_attendance_reasons rea
90: ,hr_lookups lkp
91: WHERE ABS.abs_attendance_reason_id = rea.abs_attendance_reason_id
92: AND rea.NAME = lkp.lookup_code

Line 333: FROM per_absence_attendances attnd

329: )
330: IS
331: SELECT NVL(SUM(daily.DURATION), 0) days
332: ,NVL(SUM(daily.duration_in_hours),0) hours
333: FROM per_absence_attendances attnd
334: ,pqp_gap_absence_plans plans
335: ,pqp_gap_daily_absences daily
336: WHERE attnd.absence_attendance_id = plans.absence_attendance_id
337: AND plans.gap_absence_plan_id = daily.gap_absence_plan_id

Line 368: FROM per_absence_attendances attnd

364: IS
365: SELECT NVL(SUM(daily.duration),0) days
366: -----Added For Hours
367: ,NVL(SUM(daily.duration_in_hours),0) hours
368: FROM per_absence_attendances attnd
369: ,pqp_gap_absence_plans plans
370: ,pqp_gap_daily_absences daily
371: WHERE attnd.absence_attendance_id = plans.absence_attendance_id
372: AND plans.gap_absence_plan_id = daily.gap_absence_plan_id

Line 397: FROM per_absence_attendances attnd

393: ,p_work_pattern_day_type IN VARCHAR2
394: )
395: IS
396: SELECT NVL(SUM(daily.DURATION), 0)
397: FROM per_absence_attendances attnd
398: ,pqp_gap_absence_plans plans
399: ,pqp_gap_daily_absences daily
400: WHERE attnd.absence_attendance_id = plans.absence_attendance_id
401: AND plans.gap_absence_plan_id = daily.gap_absence_plan_id

Line 441: ,per_absence_attendances paa

437: IS
438: SELECT NVL(SUM(pgda.DURATION), 0) balance
439: FROM pqp_gap_daily_absences pgda
440: ,pqp_gap_absence_plans pgap
441: ,per_absence_attendances paa
442: WHERE pgda.gap_absence_plan_id = pgap.gap_absence_plan_id
443: AND pgap.absence_attendance_id = paa.absence_attendance_id
444: AND pgda.absence_date BETWEEN p_search_start_date AND p_search_end_date
445: AND pgap.assignment_id = p_assignment_id

Line 461: ,per_absence_attendances paa

457: IS
458: SELECT NVL(SUM(pgda.DURATION), 0) balance
459: FROM pqp_gap_daily_absences pgda
460: ,pqp_gap_absence_plans pgap
461: ,per_absence_attendances paa
462: WHERE pgda.gap_absence_plan_id = pgap.gap_absence_plan_id
463: AND pgap.absence_attendance_id = paa.absence_attendance_id
464: AND pgda.absence_date BETWEEN p_search_start_date AND p_search_end_date
465: AND pgap.assignment_id = p_assignment_id

Line 481: ,per_absence_attendances paa

477: IS
478: SELECT NVL(SUM(pgda.DURATION), 0) balance
479: FROM pqp_gap_daily_absences pgda
480: ,pqp_gap_absence_plans pgap
481: ,per_absence_attendances paa
482: WHERE pgda.gap_absence_plan_id = pgap.gap_absence_plan_id
483: AND pgap.absence_attendance_id = paa.absence_attendance_id
484: AND pgda.absence_date BETWEEN p_search_start_date AND p_search_end_date
485: AND pgap.assignment_id = p_assignment_id

Line 820: FROM per_absence_attendances abs

816: ,date_projected_start
817: ,date_projected_end
818: ,maternity_id -- needed to find SMP element entries
819: ,linked_absence_id -- needed to find SSP element entries
820: FROM per_absence_attendances abs
821: WHERE abs.absence_attendance_id = p_absence_attendance_id;
822: --
823: --
824: --

Line 842: FROM per_absence_attendances abs

838: CURSOR csr_absence_primary_assignment
839: (p_absence_id IN NUMBER
840: ) IS
841: SELECT asg.assignment_id
842: FROM per_absence_attendances abs
843: ,per_all_assignments_f asg
844: WHERE abs.absence_attendance_id = p_absence_id
845: AND asg.person_id = abs.person_id
846: AND NVL(abs.date_start,NVL(abs.sickness_start_date,SYSDATE))