APPS.BEN_ELIG_RL_CACHE dependencies on BEN_PRTN_ELIGY_RL_F

Line 70: ben_prtn_eligy_rl_f tab2

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
74: between tab1.effective_start_date and tab1.effective_end_date

Line 97: ben_prtn_eligy_rl_f tab2

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
101: between tab1.effective_start_date and tab1.effective_end_date

Line 122: ben_prtn_eligy_rl_f tab2

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
126: between tab1.effective_start_date and tab1.effective_end_date

Line 147: ben_prtn_eligy_rl_f tab2

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
151: between tab1.effective_start_date and tab1.effective_end_date

Line 172: ben_prtn_eligy_rl_f tab2

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
176: between tab1.effective_start_date and tab1.effective_end_date