APPS.PQP_GB_OSP_FUNCTIONS dependencies on PQP_GAP_DAILY_ABSENCES

Line 335: ,pqp_gap_daily_absences daily

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
339: AND plans.pl_id = p_pl_id

Line 370: ,pqp_gap_daily_absences daily

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
374: AND plans.pl_id = p_pl_id

Line 399: ,pqp_gap_daily_absences daily

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
403: AND plans.pl_id = p_pl_id

Line 439: FROM pqp_gap_daily_absences pgda

435: ,p_level_of_pay VARCHAR2
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

Line 459: FROM pqp_gap_daily_absences pgda

455: ,p_level_of_ent VARCHAR2
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

Line 479: FROM pqp_gap_daily_absences pgda

475: ,p_wp_day_type VARCHAR2
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