DBA Data[Home] [Help]

APPS.BEN_ELPRO_CHECK_ELIGIBILITY dependencies on BEN_PTIP_F

Line 59: ben_ptip_f ctp,

55: select /*+ bendtlep.check_elig_othr_ptip_prte.pilc1 */
56: null
57: from ben_pl_f pln,
58: ben_plip_f cpp,
59: ben_ptip_f ctp,
60: ben_pl_regn_f prg,
61: ben_regn_f reg,
62: ben_elig_per_f epo
63: where pln.pl_id = cpp.pl_id

Line 107: ben_ptip_f ctp,

103: select /*+ first_rows bendtlep.check_elig_othr_ptip_prte.c1 */ --Bug 5200242
104: null
105: from ben_pl_f pln,
106: ben_plip_f cpp,
107: ben_ptip_f ctp,
108: ben_pl_regn_f prg,
109: ben_regn_f reg,
110: ben_elig_per_f epo,
111: ben_per_in_ler pil

Line 385: ben_ptip_f ctp,

381: select /*+ bendtlep.check_elig_dpnt_othr_ptip.c1 */
382: null
383: from ben_pl_f pln,
384: ben_plip_f cpp,
385: ben_ptip_f ctp,
386: ben_elig_per_f epo,
387: ben_elig_dpnt edp,
388: ben_per_in_ler pil
389: --per_contact_relationships pcr -- bug 6811004 fix reverted for bug 9900419