APPS.HR_COLLECTIVE_AGREEMENT_API dependencies on BEN_PL_TYP_F
Line 321: FROM ben_pl_typ_f
317: l_pl_typ_ovn NUMBER;
318: --
319: CURSOR csr_get_plan_type IS
320: SELECT pl_typ_id 321: FROM ben_pl_typ_f 322: WHERE name = 'Collective Agreement Plan Type'
323: AND business_group_id = p_business_group_id
324: AND l_effective_date BETWEEN effective_start_date
325: AND effective_end_date;