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

Line 43: FROM per_absence_attendances paa

39:
40: CURSOR csr_absence_info ( p_absence_id IN NUMBER ) IS
41: SELECT paa.date_start
42: ,paa.date_end
43: FROM per_absence_attendances paa
44: WHERE paa.absence_attendance_id = p_absence_id ;
45:
46: -- The Cursor gets the used Entitlements Band wise
47: CURSOR csr_get_band_bal ( p_assignment_id IN NUMBER

Line 57: ,per_absence_attendances paa

53: ,SUM (pgda.duration) consumed
54: ,SUM (pgda.duration_in_hours) consumed_in_hours
55: FROM pqp_gap_daily_absences pgda
56: ,pqp_gap_absence_plans pgap
57: ,per_absence_attendances paa
58: ,ben_pl_f bpf
59: WHERE pgda.gap_absence_plan_id = pgap.gap_absence_plan_id
60: AND pgap.absence_attendance_id = paa.absence_attendance_id
61: AND pgap.assignment_id = p_assignment_id

Line 84: FROM per_absence_attendances

80: CURSOR c_part_days ( p_absence_id IN NUMBER
81: ,p_lookup_type IN VARCHAR2 ) IS
82: SELECT NVL(abs_information1,1) part_st_dt
83: ,NVL(abs_information2,1) Part_end_dt
84: FROM per_absence_attendances
85: WHERE abs_information_category = p_lookup_type
86: AND absence_attendance_id = p_absence_id ;
87:
88: