APPS.BEN_LDC_BUS dependencies on BEN_LER_CHG_DPNT_CVG_F

Line 125: from ben_ler_chg_dpnt_cvg_f

121: -- unique in bg, parent, and eff dates
122: --
123: cursor chk_unique is
124: select null
125: from ben_ler_chg_dpnt_cvg_f
126: where ler_id = p_ler_id
127: and ler_chg_dpnt_cvg_id <> nvl(p_ler_chg_dpnt_cvg_id, hr_api.g_number)
128: and (ptip_id = p_ptip_id or pgm_id = p_pgm_id or pl_id = p_pl_id)
129: and business_group_id + 0 = p_business_group_id

Line 1629: ben_ler_chg_dpnt_cvg_f b

1625: --
1626: cursor csr_leg_code is
1627: select a.legislation_code
1628: from per_business_groups a,
1629: ben_ler_chg_dpnt_cvg_f b
1630: where b.ler_chg_dpnt_cvg_id = p_ler_chg_dpnt_cvg_id
1631: and a.business_group_id = b.business_group_id;
1632: --
1633: -- Declare local variables