DBA Data[Home] [Help]

APPS.BEN_USE_CVG_RT_DATE dependencies on BEN_PL_F

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

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

Line 94: from ben_pl_f pl

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