APPS.BEN_SER_BUS dependencies on BEN_SCHEDD_ENRT_RL_F

Line 123: from ben_schedd_enrt_rl_f

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

Line 211: from ben_schedd_enrt_rl_f

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

Line 602: ben_schedd_enrt_rl_f b

598: --
599: cursor csr_leg_code is
600: select a.legislation_code
601: from per_business_groups a,
602: ben_schedd_enrt_rl_f b
603: where b.schedd_enrt_rl_id = p_schedd_enrt_rl_id
604: and a.business_group_id = b.business_group_id;
605: --
606: -- Declare local variables