APPS.BEN_DOP_BUS dependencies on BEN_DPNT_CVRD_OTHR_PGM_RT_F

Line 268: from ben_dpnt_cvrd_othr_pgm_rt_f

264: l_exists varchar2(1);
265: --
266: cursor c_dup is
267: select null
268: from ben_dpnt_cvrd_othr_pgm_rt_f
269: where pgm_id = p_pgm_id
270: and enrl_det_dt_cd = p_enrl_det_dt_cd
271: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
272: and dpnt_cvrd_othr_pgm_rt_id <> nvl(p_dpnt_cvrd_othr_pgm_rt_id,hr_api.g_number)

Line 424: from ben_dpnt_cvrd_othr_pgm_rt_f

420: is
421: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
422: l_dummy char(1);
423: cursor c1 is select null
424: from ben_dpnt_cvrd_othr_pgm_rt_f
425: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
426: -- changed against bug: 5113011
427: and dpnt_cvrd_othr_pgm_rt_id <> nvl(p_dpnt_cvrd_othr_pgm_rt_id ,-1)
428: -- and pgm_id <> nvl(p_pgm_id ,-1)

Line 851: ben_dpnt_cvrd_othr_pgm_rt_f b

847: --
848: cursor csr_leg_code is
849: select a.legislation_code
850: from per_business_groups a,
851: ben_dpnt_cvrd_othr_pgm_rt_f b
852: where b.dpnt_cvrd_othr_pgm_rt_id = p_dpnt_cvrd_othr_pgm_rt_id
853: and a.business_group_id = b.business_group_id;
854: --
855: -- Declare local variables