APPS.PQP_ABSVAL_PKG dependencies on PQP_GAP_ABSENCE_PLANS

Line 117: FROM pqp_gap_absence_plans gap

113: IS
114: SELECT gap.gap_absence_plan_id
115: ,gap.last_gap_daily_absence_date
116: ,gap.object_version_number
117: FROM pqp_gap_absence_plans gap
118: WHERE gap.absence_attendance_id = p_absence_attendance_id
119: AND gap.pl_id = p_pl_id;
120: --
121: CURSOR csr_gap_daily_absences_exists

Line 181: ,pqp_gap_absence_plans gap

177: ) cnt
178: FROM hr_lookups hrl
179: ,ben_pl_f bp
180: ,per_absence_attendances paa
181: ,pqp_gap_absence_plans gap
182: WHERE hrl.lookup_type = p_lookup_type --'PQP_GAP_PLAN_TYPES_TO_EXTEND'
183: and (p_period_start_date between
184: NVL(hrl.start_date_active, p_period_start_date)
185: and NVL(hrl.end_date_active, p_period_end_date)

Line 234: ,pqp_gap_absence_plans plans

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
238: AND gda.absence_date <= p_absence_date ;

Line 356: ,p_gap_absence_plan_id IN pqp_gap_absence_plans.gap_absence_plan_id%TYPE

352: );
353:
354: PROCEDURE write_daily_absences
355: (p_daily_absences IN pqp_absval_pkg.t_daily_absences
356: ,p_gap_absence_plan_id IN pqp_gap_absence_plans.gap_absence_plan_id%TYPE
357: );
358:
359: PROCEDURE create_absence_plan_details
360: (p_assignment_id IN NUMBER