APPS.BEN_ADE_BUS dependencies on BEN_APLD_DPNT_CVG_ELIG_PRFL_F

Line 125: from ben_apld_dpnt_cvg_elig_prfl_f

121:
122: --
123: cursor chk_unique is
124: select null,effective_start_date
125: from ben_apld_dpnt_cvg_elig_prfl_f
126: where dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
127: and apld_dpnt_cvg_elig_prfl_id <> nvl(p_apld_dpnt_cvg_elig_prfl_id, hr_api.g_number)
128: and (ptip_id = p_ptip_id or pgm_id = p_pgm_id or pl_id = p_pl_id)
129: and business_group_id + 0 = p_business_group_id

Line 743: ben_apld_dpnt_cvg_elig_prfl_f b

739: --
740: cursor csr_leg_code is
741: select a.legislation_code
742: from per_business_groups a,
743: ben_apld_dpnt_cvg_elig_prfl_f b
744: where b.apld_dpnt_cvg_elig_prfl_id = p_apld_dpnt_cvg_elig_prfl_id
745: and a.business_group_id = b.business_group_id;
746: --
747: -- Declare local variables