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 PQP_GAP_ABSENCE_PLANS

Line 334: ,pqp_gap_absence_plans plans

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
338: AND attnd.absence_attendance_id = p_absence_attendance_id

Line 369: ,pqp_gap_absence_plans plans

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
373: AND attnd.absence_attendance_id = p_absence_attendance_id

Line 398: ,pqp_gap_absence_plans plans

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
402: AND attnd.absence_attendance_id = p_absence_attendance_id

Line 440: ,pqp_gap_absence_plans pgap

436: )
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

Line 460: ,pqp_gap_absence_plans pgap

456: )
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

Line 480: ,pqp_gap_absence_plans pgap

476: )
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