DBA Data[Home] [Help]

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;