APPS.PQP_GB_CSS_DAILY_ABSENCES dependencies on BEN_PL_F

Line 917: ,ben_pl_f pl

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

Line 926: l_pl_typ_id ben_pl_f.pl_typ_id%TYPE ;

922: and gda.level_of_pay = 'NOBAND'
923: and gda.absence_date between p_rolling_start_date
924: and p_rolling_end_date ;
925:
926: l_pl_typ_id ben_pl_f.pl_typ_id%TYPE ;
927: BEGIN
928:
929: IF g_debug THEN
930: debug_enter(l_proc_name);