DBA Data[Home] [Help]

APPS.PQP_GB_CSS_DAILY_ABSENCES dependencies on PQP_GAP_ABSENCE_PLANS

Line 36: ,pqp_gap_absence_plans gap

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'
40: and bp.pl_typ_id = hrl.lookup_code