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 7544: FROM pqp_gap_absence_plans gap

7540: ,p_pl_id IN NUMBER
7541: ) IS
7542: SELECT gap.gap_absence_plan_id id
7543: ,gap.last_gap_daily_absence_date
7544: FROM pqp_gap_absence_plans gap
7545: WHERE gap.absence_attendance_id = p_absence_attendance_id
7546: AND gap.pl_id = p_pl_id;
7547:
7548: l_gap_absence_plan csr_gap_absence_plan%ROWTYPE;

Line 10460: FROM pqp_gap_absence_plans gap

10456: ,p_range_start_date IN DATE
10457: ,p_range_end_date IN DATE
10458: ) IS
10459: SELECT NVL(SUM(gda.duration),0) days
10460: FROM pqp_gap_absence_plans gap
10461: ,pqp_gap_daily_absences gda
10462: WHERE gap.assignment_id = p_assignment_id
10463: AND gap.pl_id = p_plan_id
10464: AND gda.gap_absence_plan_id = gap.gap_absence_plan_id

Line 10499: FROM pqp_gap_absence_plans gap

10495: ,p_range_start_date IN DATE
10496: ,p_range_end_date IN DATE
10497: ) IS
10498: SELECT MAX(ABSENCE_DATE) NB_END_DT, MIN(ABSENCE_DATE) NB_START_DT
10499: FROM pqp_gap_absence_plans gap
10500: ,pqp_gap_daily_absences gda
10501: WHERE gap.assignment_id = p_assignment_id
10502: AND gap.pl_id = p_plan_id
10503: AND gda.gap_absence_plan_id = gap.gap_absence_plan_id