APPS.BEN_PYD_BUS dependencies on BEN_PTIP_DPNT_CVG_CTFN_F

Line 127: from ben_ptip_dpnt_cvg_ctfn_f

123: -- unique in bg, parent, and eff dates
124: --
125: cursor chk_unique is
126: select null
127: from ben_ptip_dpnt_cvg_ctfn_f
128: where nvl(dpnt_cvg_ctfn_typ_cd,0) = nvl(p_dpnt_cvg_ctfn_typ_cd,0)
129: and nvl(rlshp_typ_cd,0) = nvl(p_rlshp_typ_cd,0)
130: and ptip_dpnt_cvg_ctfn_id <>
131: nvl(p_ptip_dpnt_cvg_ctfn_id, hr_api.g_number)

Line 234: from ben_ptip_dpnt_cvg_ctfn_f

230: -- unique in bg, parent, and eff dates
231: --
232: cursor chk_unique is
233: select null
234: from ben_ptip_dpnt_cvg_ctfn_f
235: where rlshp_typ_cd = p_rlshp_typ_cd
236: and ptip_dpnt_cvg_ctfn_id <>
237: nvl(p_ptip_dpnt_cvg_ctfn_id, hr_api.g_number)
238: and ptip_id = p_ptip_id

Line 502: from ben_ptip_dpnt_cvg_ctfn_f

498: -- unique in bg, parent, and eff dates
499: --
500: cursor chk_unique is
501: select null
502: from ben_ptip_dpnt_cvg_ctfn_f
503: where pfd_flag = p_pfd_flag
504: and pfd_flag = 'Y'
505: and ptip_dpnt_cvg_ctfn_id <>
506: nvl(p_ptip_dpnt_cvg_ctfn_id, hr_api.g_number)

Line 947: ben_ptip_dpnt_cvg_ctfn_f b

943: --
944: cursor csr_leg_code is
945: select a.legislation_code
946: from per_business_groups a,
947: ben_ptip_dpnt_cvg_ctfn_f b
948: where b.ptip_dpnt_cvg_ctfn_id = p_ptip_dpnt_cvg_ctfn_id
949: and a.business_group_id = b.business_group_id;
950: --
951: -- Declare local variables