APPS.BEN_ERL_BUS dependencies on BEN_ELIGY_PRFL_RL_F

Line 134: FROM ben_eligy_prfl_rl_f

130: and ff.effective_end_date;
131:
132: cursor c3 is
133: SELECT 'x'
134: FROM ben_eligy_prfl_rl_f
135: WHERE eligy_prfl_rl_id <> nvl(p_eligy_prfl_rl_id, hr_api.g_number)
136: AND eligy_prfl_id = p_eligy_prfl_id
137: AND formula_id = p_formula_id
138: AND p_validation_start_date <= effective_end_date

Line 239: FROM ben_eligy_prfl_rl_f

235: ,p_business_group_id number
236: ,p_validation_start_date date
237: ,p_validation_end_date date) IS
238: SELECT 'x'
239: FROM ben_eligy_prfl_rl_f
240: WHERE eligy_prfl_rl_id <> nvl(p_eligy_prfl_rl_id, hr_api.g_number)
241: AND eligy_prfl_id = p_eligy_prfl_id
242: AND business_group_id + 0 = p_business_group_id
243: AND ordr_to_aply_num = nvl(p_ordr_to_aply_num,hr_api.g_number)

Line 658: ben_eligy_prfl_rl_f b

654: --
655: cursor csr_leg_code is
656: select a.legislation_code
657: from per_business_groups a,
658: ben_eligy_prfl_rl_f b
659: where b.eligy_prfl_rl_id = p_eligy_prfl_rl_id
660: and a.business_group_id = b.business_group_id;
661: --
662: -- Declare local variables