APPS.PQP_GB_CSS_DAILY_ABSENCES dependencies on PQP_GAP_ABSENCE_PLANS

Line 916: ,pqp_gap_absence_plans gap

912: -- for Civil Service Scheme, as in 4 years
913: CURSOR csr_css_no_pay_days IS
914: select NVL(SUM(gda.duration),0)
915: from pqp_gap_daily_absences gda
916: ,pqp_gap_absence_plans gap
917: ,ben_pl_f pl
918: where pl.pl_id = gap.pl_id
919: and pl.pl_typ_id = p_pl_typ_id
920: and gap.gap_absence_plan_id = gda.gap_absence_plan_id