DBA Data[Home] [Help]

APPS.BEN_PGM_BUS dependencies on BEN_PTIP_DPNT_CVG_CTFN_F

Line 5569: -- BEN_APLD_DPNT_CVG_ELIG_PRFL_F, BEN_PTIP_DPNT_CVG_CTFN_F.

5565: --
5566: -- Description
5567: -- If dependent designation level is not 'Plan Type' the following tables must
5568: -- contain no records for that plan type: BEN_LER_CHG_DPNT_CVG_F,
5569: -- BEN_APLD_DPNT_CVG_ELIG_PRFL_F, BEN_PTIP_DPNT_CVG_CTFN_F.
5570: --
5571: -- Pre Conditions
5572: -- None.
5573: --

Line 5628: BEN_PTIP_DPNT_CVG_CTFN_F pyd

5624: and ade.effective_end_date;
5625: --
5626: cursor c3 is select null
5627: from BEN_PTIP_F ctp,
5628: BEN_PTIP_DPNT_CVG_CTFN_F pyd
5629: where ctp.pgm_id = p_pgm_id
5630: and ctp.business_group_id +0 = p_business_group_id
5631: and p_effective_date between ctp.effective_start_date
5632: and ctp.effective_end_date