APPS.BEN_BATCH_REPORTING dependencies on BEN_BENEFIT_ACTIONS

Line 167: from ben_benefit_actions bft,

163: nvl(org2.name,l_all),
164: nvl(pay.payroll_name,l_all),
165: conc.user_concurrent_program_name,
166: fnd1.meaning
167: from ben_benefit_actions bft,
168: hr_lookups hr,
169: hr_lookups hr1,
170: hr_lookups hr2,
171: hr_lookups hr3,

Line 397: from ben_benefit_actions bft

393:
394: --
395: cursor c0 is
396: select benefit_action_id
397: from ben_benefit_actions bft
398: where bft.request_id = p_concurrent_request_id ;
399: --
400: l_c0 c0%rowtype;
401: --

Line 405: ben_benefit_actions bft,

401: --
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

Line 423: BEN_BENEFIT_ACTIONS BFT,

419: cursor c1 is
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

Line 442: ben_benefit_actions bft

438: --
439: cursor c2 is
440: select count(*)
441: from ben_person_actions pac,
442: ben_benefit_actions bft
443: where bft.benefit_action_id = pac.benefit_action_id
444: /* and bft.request_id = p_concurrent_request_id */
445: and bft.benefit_action_id = l_c0.benefit_action_id
446: and pac.action_status_cd = 'P'

Line 456: ben_benefit_actions bft

452: --
453: cursor c3 is
454: select count(*)
455: from ben_person_actions pac,
456: ben_benefit_actions bft
457: where bft.benefit_action_id = pac.benefit_action_id
458: /* and bft.request_id = p_concurrent_request_id */
459: and bft.benefit_action_id = l_c0.benefit_action_id
460: and pac.action_status_cd = 'P'

Line 625: ben_benefit_actions bft

621: bpi.per_unproc,
622: bpi.per_proc_succ,
623: bpi.per_err
624: from ben_batch_proc_info bpi,
625: ben_benefit_actions bft
626: where bft.benefit_action_id = bpi.benefit_action_id
627: and bft.request_id = p_concurrent_request_id;
628: --
629: l_proc_info c_proc_info%rowtype;

Line 674: from ben_benefit_actions bft

670: l_proc varchar2(80) := g_package||'.activity_summary_by_action';
671: --
672: cursor c0 is
673: select benefit_action_id
674: from ben_benefit_actions bft
675: where bft.request_id = p_concurrent_request_id ;
676: --
677: l_c0 c0%rowtype;
678: --

Line 689: ben_benefit_actions bft,

685: open_and_clsd_flag,
686: bli.benefit_action_id,
687: bli.person_id
688: from ben_batch_ler_info bli,
689: ben_benefit_actions bft,
690: ben_person_actions bpa
691: where bft.benefit_action_id = bli.benefit_action_id
692: and bli.tmprl_flag = 'N'
693: and bft.benefit_action_id = l_c0.benefit_action_id

Line 879: ben_benefit_actions bft,

875: clsn_flag,
876: bli.benefit_action_id,
877: bli.person_id
878: from ben_batch_ler_info bli,
879: ben_benefit_actions bft,
880: /* Bug 2243050: Check whether the person has errored out nocopy */
881: ben_person_actions bpa
882: /* Bug 2243050: Check whether the person has errored out nocopy */
883: where bft.benefit_action_id = bli.benefit_action_id

Line 1177: ben_benefit_actions bft,

1173: clsd_flag,
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