APPS.BEN_USE_CVG_RT_DATE dependencies on BEN_PLIP_F

Line 51: from ben_plip_f plip

47:
48:
49: cursor c_pgm is
50: select /*+ first_rows(1) */ 'x' -- 5095721
51: from ben_plip_f plip
52: where plip.pgm_id = p_pgm_id
53: and plip.USE_CSD_RSD_PRCCNG_CD is not null
54: and plip.plip_stat_cd = 'A'
55: and p_effective_date between plip.effective_start_date

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 81: from ben_plip_f plip

77: ;
78:
79: cursor c_plip is
80: select 'x'
81: from ben_plip_f plip
82: where plip.plip_id = p_plip_id
83: and plip.USE_CSD_RSD_PRCCNG_CD is not null
84: and plip.plip_stat_cd = 'A'
85: and p_effective_date between plip.effective_start_date