APPS.BEN_CEL_CACHE dependencies on BEN_ELIGY_PRFL_F

Line 54: ben_eligy_prfl_f elp

50: and pln.effective_end_date
51: and exists(select null
52: from ben_prtn_elig_f epa,
53: ben_prtn_elig_prfl_f cep,
54: ben_eligy_prfl_f elp
55: where elp.eligy_prfl_id = cep.eligy_prfl_id
56: and elp.business_group_id = cep.business_group_id
57: and cep.prtn_elig_id = epa.prtn_elig_id
58: and cep.business_group_id = epa.business_group_id

Line 78: ben_eligy_prfl_f elp

74: cep.mndtry_flag,
75: elp.eligy_prfl_id
76: from ben_prtn_elig_f epa,
77: ben_prtn_elig_prfl_f cep,
78: ben_eligy_prfl_f elp
79: where elp.eligy_prfl_id = cep.eligy_prfl_id
80: and elp.business_group_id = cep.business_group_id
81: and cep.prtn_elig_id = epa.prtn_elig_id
82: and cep.business_group_id = epa.business_group_id

Line 325: ben_eligy_prfl_f elp

321: and pgm.effective_end_date
322: and exists(select null
323: from ben_prtn_elig_f epa,
324: ben_prtn_elig_prfl_f cep,
325: ben_eligy_prfl_f elp
326: where elp.eligy_prfl_id = cep.eligy_prfl_id
327: and elp.business_group_id = cep.business_group_id
328: and cep.prtn_elig_id = epa.prtn_elig_id
329: and cep.business_group_id = epa.business_group_id

Line 349: ben_eligy_prfl_f elp

345: cep.mndtry_flag,
346: elp.eligy_prfl_id
347: from ben_prtn_elig_f epa,
348: ben_prtn_elig_prfl_f cep,
349: ben_eligy_prfl_f elp
350: where elp.eligy_prfl_id = cep.eligy_prfl_id
351: and elp.business_group_id = cep.business_group_id
352: and cep.prtn_elig_id = epa.prtn_elig_id
353: and cep.business_group_id = epa.business_group_id

Line 598: ben_eligy_prfl_f elp

594: and cop.effective_end_date
595: and exists(select null
596: from ben_prtn_elig_f epa,
597: ben_prtn_elig_prfl_f cep,
598: ben_eligy_prfl_f elp
599: where elp.eligy_prfl_id = cep.eligy_prfl_id
600: and elp.business_group_id = cep.business_group_id
601: and cep.prtn_elig_id = epa.prtn_elig_id
602: and cep.business_group_id = epa.business_group_id

Line 622: ben_eligy_prfl_f elp

618: cep.mndtry_flag,
619: elp.eligy_prfl_id
620: from ben_prtn_elig_f epa,
621: ben_prtn_elig_prfl_f cep,
622: ben_eligy_prfl_f elp
623: where elp.eligy_prfl_id = cep.eligy_prfl_id
624: and elp.business_group_id = cep.business_group_id
625: and cep.prtn_elig_id = epa.prtn_elig_id
626: and cep.business_group_id = epa.business_group_id

Line 870: ben_eligy_prfl_f elp

866: and cpp.effective_end_date
867: and exists(select null
868: from ben_prtn_elig_f epa,
869: ben_prtn_elig_prfl_f cep,
870: ben_eligy_prfl_f elp
871: where elp.eligy_prfl_id = cep.eligy_prfl_id
872: and elp.business_group_id = cep.business_group_id
873: and cep.prtn_elig_id = epa.prtn_elig_id
874: and cep.business_group_id = epa.business_group_id

Line 894: ben_eligy_prfl_f elp

890: cep.mndtry_flag,
891: elp.eligy_prfl_id
892: from ben_prtn_elig_f epa,
893: ben_prtn_elig_prfl_f cep,
894: ben_eligy_prfl_f elp
895: where elp.eligy_prfl_id = cep.eligy_prfl_id
896: and elp.business_group_id = cep.business_group_id
897: and cep.prtn_elig_id = epa.prtn_elig_id
898: and cep.business_group_id = epa.business_group_id

Line 1142: ben_eligy_prfl_f elp

1138: and ctp.effective_end_date
1139: and exists(select null
1140: from ben_prtn_elig_f epa,
1141: ben_prtn_elig_prfl_f cep,
1142: ben_eligy_prfl_f elp
1143: where elp.eligy_prfl_id = cep.eligy_prfl_id
1144: and elp.business_group_id = cep.business_group_id
1145: and cep.prtn_elig_id = epa.prtn_elig_id
1146: and cep.business_group_id = epa.business_group_id

Line 1166: ben_eligy_prfl_f elp

1162: cep.mndtry_flag,
1163: elp.eligy_prfl_id
1164: from ben_prtn_elig_f epa,
1165: ben_prtn_elig_prfl_f cep,
1166: ben_eligy_prfl_f elp
1167: where elp.eligy_prfl_id = cep.eligy_prfl_id
1168: and elp.business_group_id = cep.business_group_id
1169: and cep.prtn_elig_id = epa.prtn_elig_id
1170: and cep.business_group_id = epa.business_group_id