DBA Data[Home] [Help]

APPS.BEN_USE_CVG_RT_DATE dependencies on BEN_PL_F

Line 62: from ben_plip_f plip, ben_ptip_f ptip, ben_pl_f pl

58: ;
59:
60: cursor c_ptip is
61: select /*+ first_rows(1) */ 'x' -- 5095721
62: from ben_plip_f plip, ben_ptip_f ptip, ben_pl_f pl
63: where ptip.ptip_id = p_ptip_id
64: and ptip.pgm_id = plip.pgm_id
65: and plip.pl_id = pl.pl_id
66: and pl.pl_typ_id = ptip.pl_typ_id

Line 92: from ben_pl_f pl

88:
89:
90: cursor c_pl is
91: select 'x'
92: from ben_pl_f pl
93: where pl.pl_id = p_pl_id
94: and pl.USE_CSD_RSD_PRCCNG_CD is not null
95: and pl.pl_stat_cd = 'A'
96: and p_effective_date between pl.effective_start_date