APPS.PQP_GB_CSS_DAILY_ABSENCES dependencies on PQP_GAP_ABSENCE_PLANS

Line 894: ,pqp_gap_absence_plans gap

890: -- for Civil Service Scheme, as in 4 years
891: CURSOR csr_css_no_pay_days IS
892: select NVL(SUM(gda.duration),0)
893: from pqp_gap_daily_absences gda
894: ,pqp_gap_absence_plans gap
895: ,ben_pl_f pl
896: where pl.pl_id = gap.pl_id
897: and pl.pl_typ_id = p_pl_typ_id
898: and gap.gap_absence_plan_id = gda.gap_absence_plan_id