APPS.BEN_CEL_CACHE dependencies on BEN_PRTN_ELIG_PRFL_F

Line 53: ben_prtn_elig_prfl_f cep,

49: between pln.effective_start_date
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

Line 77: ben_prtn_elig_prfl_f cep,

73: epa.prtn_elig_id,
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

Line 324: ben_prtn_elig_prfl_f cep,

320: between pgm.effective_start_date
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

Line 348: ben_prtn_elig_prfl_f cep,

344: epa.prtn_elig_id,
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

Line 597: ben_prtn_elig_prfl_f cep,

593: between cop.effective_start_date
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

Line 621: ben_prtn_elig_prfl_f cep,

617: epa.prtn_elig_id,
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

Line 869: ben_prtn_elig_prfl_f cep,

865: between cpp.effective_start_date
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

Line 893: ben_prtn_elig_prfl_f cep,

889: epa.prtn_elig_id,
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

Line 1141: ben_prtn_elig_prfl_f cep,

1137: between ctp.effective_start_date
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

Line 1165: ben_prtn_elig_prfl_f cep,

1161: epa.prtn_elig_id,
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