APPS.BEN_PGC_BUS dependencies on BEN_PGM_DPNT_CVG_CTFN_F

Line 124: from ben_pgm_dpnt_cvg_ctfn_f

120: -- unique in bg, parent, and eff dates
121: --
122: cursor chk_unique is
123: select null
124: from ben_pgm_dpnt_cvg_ctfn_f
125: where nvl(dpnt_cvg_ctfn_typ_cd,0) = nvl(p_dpnt_cvg_ctfn_typ_cd,0)
126: and nvl(rlshp_typ_cd,0) = nvl(p_rlshp_typ_cd,0)
127: and pgm_dpnt_cvg_ctfn_id<> nvl(p_pgm_dpnt_cvg_ctfn_id, hr_api.g_number)
128: and pgm_id = p_pgm_id

Line 228: from ben_pgm_dpnt_cvg_ctfn_f

224: -- Only one 'Y' allowed per parent
225: --
226: cursor chk_unique is
227: select null
228: from ben_pgm_dpnt_cvg_ctfn_f
229: where pfd_flag = p_pfd_flag
230: and pfd_flag = 'Y'
231: and pgm_dpnt_cvg_ctfn_id<> nvl(p_pgm_dpnt_cvg_ctfn_id, hr_api.g_number)
232: and pgm_id = p_pgm_id

Line 916: ben_pgm_dpnt_cvg_ctfn_f b

912: --
913: cursor csr_leg_code is
914: select a.legislation_code
915: from per_business_groups a,
916: ben_pgm_dpnt_cvg_ctfn_f b
917: where b.pgm_dpnt_cvg_ctfn_id = p_pgm_dpnt_cvg_ctfn_id
918: and a.business_group_id = b.business_group_id;
919: --
920: -- Declare local variables