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_ABSVAL_PKG dependencies on PQP_GAP_DAILY_ABSENCES

Line 126: FROM pqp_gap_daily_absences gda

122: (p_gap_absence_plan_id IN NUMBER
123: )
124: IS
125: SELECT gda.gap_absence_plan_id
126: FROM pqp_gap_daily_absences gda
127: WHERE gda.gap_absence_plan_id = p_gap_absence_plan_id
128: AND ROWNUM < 2;
129: --
130: CURSOR csr_first_entitled_day_of_band

Line 136: FROM pqp_gap_daily_absences gda

132: ,p_level_of_entitlement IN VARCHAR2
133: )
134: IS
135: SELECT gda.absence_date
136: FROM pqp_gap_daily_absences gda
137: WHERE gda.gap_absence_plan_id = p_gap_absence_plan_id
138: AND gda.level_of_entitlement = p_level_of_entitlement
139: ORDER BY gda.absence_date ASC;
140:

Line 233: FROM pqp_gap_daily_absences gda

229: ,p_absence_date IN DATE
230: )
231: IS
232: SELECT SUM(gda.duration)
233: FROM pqp_gap_daily_absences gda
234: ,pqp_gap_absence_plans plans
235: WHERE gda.gap_absence_plan_id = plans.gap_absence_plan_id
236: AND plans.absence_attendance_id = p_gap_absence_id
237: AND gda.level_of_entitlement = p_level_of_entitlement