DBA Data[Home] [Help]

APPS.PQP_GB_CSS_DAILY_ABSENCES dependencies on BEN_PL_F

Line 35: ,ben_pl_f bp

31: + 1
32: ) cnt
33: FROM per_absence_attendances paa
34: ,hr_lookups hrl
35: ,ben_pl_f bp
36: ,pqp_gap_absence_plans gap
37: WHERE gap.assignment_id = p_assignment_id
38: and gap.pl_id = bp.pl_id
39: and hrl.lookup_type = p_lookup_type --'PQP_GAP_PLAN_TYPES_TO_EXTEND'