DBA Data[Home] [Help]

APPS.BEN_PET_BUS dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 124: from ben_popl_enrt_typ_cycl_f

120: l_exists varchar2(1);
121: --
122: cursor chk_unique is
123: select null
124: from ben_popl_enrt_typ_cycl_f
125: where enrt_typ_cycl_cd = p_enrt_typ_cycl_cd
126: and popl_enrt_typ_cycl_id <> nvl(p_popl_enrt_typ_cycl_id, hr_api.g_number)
127: and (pgm_id = p_pgm_id or pl_id = p_pl_id)
128: and business_group_id + 0 = p_business_group_id

Line 596: ben_popl_enrt_typ_cycl_f b

592: --
593: cursor csr_leg_code is
594: select a.legislation_code
595: from per_business_groups a,
596: ben_popl_enrt_typ_cycl_f b
597: where b.popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id
598: and a.business_group_id = b.business_group_id;
599: --
600: -- Declare local variables