eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CEL_CACHE dependencies on BEN_PRTN_ELIG_F

Line 52: from ben_prtn_elig_f epa,

48: where p_effective_date
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

Line 76: from ben_prtn_elig_f epa,

72: select epa.pl_id,
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

Line 323: from ben_prtn_elig_f epa,

319: where p_effective_date
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

Line 347: from ben_prtn_elig_f epa,

343: select epa.pgm_id,
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

Line 596: from ben_prtn_elig_f epa,

592: where p_effective_date
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

Line 620: from ben_prtn_elig_f epa,

616: select epa.oipl_id,
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

Line 868: from ben_prtn_elig_f epa,

864: where p_effective_date
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

Line 892: from ben_prtn_elig_f epa,

888: select epa.plip_id,
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

Line 1140: from ben_prtn_elig_f epa,

1136: where p_effective_date
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

Line 1164: from ben_prtn_elig_f epa,

1160: select epa.ptip_id,
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