DBA Data[Home] [Help]

APPS.BEN_LRR_BUS dependencies on BEN_LEE_RSN_RL_F

Line 123: from ben_lee_rsn_rl_f

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

Line 225: from ben_lee_rsn_rl_f

221: -- unique in bg, parent, and eff dates
222: --
223: cursor chk_unique is
224: select null
225: from ben_lee_rsn_rl_f
226: where formula_id = p_formula_id
227: and lee_rsn_rl_id <> nvl(p_lee_rsn_rl_id, hr_api.g_number)
228: and lee_rsn_id = p_lee_rsn_id --parent
229: and business_group_id + 0 = p_business_group_id

Line 643: ben_lee_rsn_rl_f b

639: --
640: cursor csr_leg_code is
641: select a.legislation_code
642: from per_business_groups a,
643: ben_lee_rsn_rl_f b
644: where b.lee_rsn_rl_id = p_lee_rsn_rl_id
645: and a.business_group_id = b.business_group_id;
646: --
647: -- Declare local variables