APPS.BEN_USE_CVG_RT_DATE dependencies on BEN_PLIP_F

Line 53: from ben_plip_f plip

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

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

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