APPS.BEN_DCE_BUS dependencies on BEN_DPNT_CVG_ELIGY_PRFL_F

Line 287: from BEN_DPNT_CVG_ELIGY_PRFL_F

283: l_exists varchar2(1);
284: --
285: cursor csr_name is
286: select null
287: from BEN_DPNT_CVG_ELIGY_PRFL_F
288: where name = p_name
289: and dpnt_cvg_eligy_prfl_id <> nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number)
290: and business_group_id + 0 = p_business_group_id
291: and p_validate_start_date <= effective_end_date

Line 961: ben_dpnt_cvg_eligy_prfl_f b

957: --
958: cursor csr_leg_code is
959: select a.legislation_code
960: from per_business_groups a,
961: ben_dpnt_cvg_eligy_prfl_f b
962: where b.dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
963: and a.business_group_id = b.business_group_id;
964: --
965: -- Declare local variables