APPS.BEN_LOR_BUS dependencies on BEN_LER_CHG_PLIP_ENRT_RL_F

Line 123: from ben_ler_chg_plip_enrt_rl_f

119: -- unique in bg, parent, and eff dates
120: --
121: cursor chk_unique is
122: select null
123: from ben_ler_chg_plip_enrt_rl_f
124: where ordr_to_aply_num = p_ordr_to_aply_num
125: and ler_chg_plip_enrt_rl_id <> nvl(p_ler_chg_plip_enrt_rl_id, hr_api.g_number)
126: and ler_chg_plip_enrt_id = p_ler_chg_plip_enrt_id --parent
127: and business_group_id + 0 = p_business_group_id

Line 211: from ben_ler_chg_plip_enrt_rl_f

207: -- unique in bg, parent, and eff dates
208: --
209: cursor chk_unique is
210: select null
211: from ben_ler_chg_plip_enrt_rl_f
212: where formula_id = p_formula_id
213: and ler_chg_plip_enrt_rl_id <> nvl(p_ler_chg_plip_enrt_rl_id, hr_api.g_number)
214: and ler_chg_plip_enrt_id = p_ler_chg_plip_enrt_id --parent
215: and business_group_id + 0 = p_business_group_id

Line 719: ben_ler_chg_plip_enrt_rl_f b

715: --
716: cursor csr_leg_code is
717: select a.legislation_code
718: from per_business_groups a,
719: ben_ler_chg_plip_enrt_rl_f b
720: where b.ler_chg_plip_enrt_rl_id = p_ler_chg_plip_enrt_rl_id
721: and a.business_group_id = b.business_group_id;
722: --
723: -- Declare local variables