APPS.PQP_GB_CSS_DAILY_ABSENCES dependencies on BEN_PL_F

Line 895: ,ben_pl_f pl

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
899: and gap.assignment_id = p_assignment_id

Line 904: l_pl_typ_id ben_pl_f.pl_typ_id%TYPE ;

900: and gda.level_of_pay = 'NOBAND'
901: and gda.absence_date between p_rolling_start_date
902: and p_rolling_end_date ;
903:
904: l_pl_typ_id ben_pl_f.pl_typ_id%TYPE ;
905: BEGIN
906:
907: IF g_debug THEN
908: debug_enter(l_proc_name);