APPS.BEN_BATCH_REPORTING dependencies on BEN_LER_F

Line 182: ben_ler_f ler,

178: per_business_groups pbg,
179: ben_pl_f pln,
180: ff_formulas_f ff,
181: ff_formulas_f ff2,
182: ben_ler_f ler,
183: hr_all_organization_units_vl org,
184: ben_rptg_grp_v bnr,
185: ben_pl_typ_f ptp,
186: ben_opt_f opt,

Line 406: ben_ler_f ler,

402: /* cursor c1 is
403: select count(*) amount,ler.typ_cd
404: from ben_batch_ler_info bli,
405: ben_benefit_actions bft,
406: ben_ler_f ler,
407: ben_person_actions bpa
408: where bft.benefit_action_id = bli.benefit_action_id
409: and bft.benefit_action_id = l_c0.benefit_action_id
410: and bpa.benefit_action_id = bft.benefit_action_id

Line 424: BEN_LER_F LER

420: SELECT /*+ BEN_BATCH_REPORTING.temporal_life_events.c1 */
421: COUNT(*) AMOUNT,LER.TYP_CD
422: FROM BEN_BATCH_LER_INFO BLI,
423: BEN_BENEFIT_ACTIONS BFT,
424: BEN_LER_F LER
425: WHERE BFT.BENEFIT_ACTION_ID = BLI.BENEFIT_ACTION_ID
426: AND BLI.BENEFIT_ACTION_ID = l_c0.benefit_action_id
427: AND LER.LER_ID = BLI.LER_ID
428: AND BFT.PROCESS_DATE BETWEEN LER.EFFECTIVE_START_DATE AND LER.EFFECTIVE_END_DATE

Line 1178: ben_ler_f ler

1174: open_and_clsd_flag,
1175: ler.name
1176: from ben_batch_ler_info bli,
1177: ben_benefit_actions bft,
1178: ben_ler_f ler
1179: where bft.benefit_action_id = bli.benefit_action_id
1180: and bft.request_id = p_concurrent_request_id
1181: and bli.ler_id=ler.ler_id
1182: and trunc(sysdate) between