DBA Data[Home] [Help]

APPS.BEN_ELIG_RL_CACHE dependencies on BEN_PRTN_ELIG_F

Line 69: from ben_prtn_elig_f tab1,

65: tab1.ptip_id,
66: tab2.formula_id,
67: tab2.mndtry_flag,
68: tab2.ordr_to_aply_num
69: from ben_prtn_elig_f tab1,
70: ben_prtn_eligy_rl_f tab2
71: where tab1.pgm_id = c_pgm_id
72: and tab1.prtn_elig_id = tab2.prtn_elig_id
73: and c_effective_date

Line 96: from ben_prtn_elig_f tab1,

92: tab1.ptip_id,
93: tab2.formula_id,
94: tab2.mndtry_flag,
95: tab2.ordr_to_aply_num
96: from ben_prtn_elig_f tab1,
97: ben_prtn_eligy_rl_f tab2
98: where tab1.ptip_id = c_ptip_id
99: and tab1.prtn_elig_id = tab2.prtn_elig_id
100: and c_effective_date

Line 121: from ben_prtn_elig_f tab1,

117: tab1.ptip_id,
118: tab2.formula_id,
119: tab2.mndtry_flag,
120: tab2.ordr_to_aply_num
121: from ben_prtn_elig_f tab1,
122: ben_prtn_eligy_rl_f tab2
123: where tab1.plip_id = c_plip_id
124: and tab1.prtn_elig_id = tab2.prtn_elig_id
125: and c_effective_date

Line 146: from ben_prtn_elig_f tab1,

142: tab1.ptip_id,
143: tab2.formula_id,
144: tab2.mndtry_flag,
145: tab2.ordr_to_aply_num
146: from ben_prtn_elig_f tab1,
147: ben_prtn_eligy_rl_f tab2
148: where tab1.pl_id = c_pl_id
149: and tab1.prtn_elig_id = tab2.prtn_elig_id
150: and c_effective_date

Line 171: from ben_prtn_elig_f tab1,

167: tab1.ptip_id,
168: tab2.formula_id,
169: tab2.mndtry_flag,
170: tab2.ordr_to_aply_num
171: from ben_prtn_elig_f tab1,
172: ben_prtn_eligy_rl_f tab2
173: where tab1.oipl_id = c_oipl_id
174: and tab1.prtn_elig_id = tab2.prtn_elig_id
175: and c_effective_date