DBA Data[Home] [Help]

APPS.BEN_ELIG_RL_CACHE dependencies on BEN_PRTN_ELIG_F

Line 70: from ben_prtn_elig_f tab1,

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

Line 97: from ben_prtn_elig_f tab1,

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

Line 122: from ben_prtn_elig_f tab1,

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

Line 147: from ben_prtn_elig_f tab1,

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

Line 172: from ben_prtn_elig_f tab1,

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