APPS.BEN_BATCH_REPORTING dependencies on BEN_BATCH_LER_INFO

Line 45: table ben_batch_ler_info only.

41: c_rate_prem_cvg_change in
42: both versions of overloaded
43: procedure activity_summary_
44: by_action to be based on
45: table ben_batch_ler_info only.
46: 11 Jan 02 Pbodla 115.10 CWB Change : Extend the C mode
47: to W (Comp Workbench mode)
48: in procedure batch_reports
49: 11 Jan 02 Pbodla 115.11 Added Commit at the end

Line 404: from ben_batch_ler_info bli,

400: l_c0 c0%rowtype;
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

Line 422: FROM BEN_BATCH_LER_INFO BLI,

418: */
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

Line 448: from ben_batch_ler_info bli

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'
447: and exists (select null
448: from ben_batch_ler_info bli
449: where bli.benefit_action_id = bft.benefit_action_id
450: and bli.person_id = pac.person_id
451: and bli.tmprl_flag = 'Y');
452: --

Line 462: from ben_batch_ler_info bli

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'
461: and not exists (select null
462: from ben_batch_ler_info bli
463: where bli.benefit_action_id = bft.benefit_action_id
464: and bli.person_id = pac.person_id
465: and bli.tmprl_flag = 'Y');
466: --

Line 688: from ben_batch_ler_info bli,

684: clsd_flag,
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'

Line 714: from ben_batch_ler_info bli

710: and epe1.elctbl_flag='Y'
711: and rownum=1;
712: cursor c_rate_prem_cvg_change is
713: select NULL
714: from ben_batch_ler_info bli
715: where bli.benefit_action_id = l_ler_info.benefit_action_id
716: and bli.person_id = l_ler_info.person_id
717: and exists (
718: select null

Line 878: from ben_batch_ler_info bli,

874: clpsd_flag,
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 */

Line 907: from ben_batch_ler_info bli

903: and epe1.elctbl_flag='Y'
904: and rownum=1;
905: cursor c_rate_prem_cvg_change is
906: select NULL
907: from ben_batch_ler_info bli
908: where bli.benefit_action_id = l_ler_info.benefit_action_id
909: and bli.person_id = l_ler_info.person_id
910: and exists (
911: select null

Line 1176: from ben_batch_ler_info bli,

1172: stl_actv_flag,
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