[Home] [Help]
1: package body ben_batch_reporting as
2: /* $Header: benrepor.pkb 120.1 2007/05/04 11:09:59 nhunur noship $ */
3: --------------------------------------------------------------------------------
4: /*
5: +==============================================================================+
81: outer join for lookup_type BEN_DTCT_TMPRL_LER_TYP
82: 15-apr-05 nhunur 115.32 Performance changes to use benefit_action_id instead of request_id
83: */
84: -----------------------------------------------------------------------
85: g_package varchar2(30) := 'ben_batch_reporting.';
86: -----------------------------------------------------------------------
87: procedure standard_header
88: (p_concurrent_request_id in number,
89: p_concurrent_program_name out nocopy varchar2,
416: and bpa.action_status_cd <> 'E'
417: group by ler.typ_cd;
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
1161: end submit_request;
1162: -----------------------------------------------------------------------
1163: procedure event_summary(
1164: p_concurrent_request_id in number,
1165: p_life_event_totals out nocopy ben_batch_reporting.le_total
1166: ) is
1167: --
1168: cursor c_ler_detail_info is
1169: select replcd_flag,
1182: and trunc(sysdate) between
1183: ler.effective_start_date and ler.effective_end_date
1184: ;
1185: --
1186: l_life_event_totals ben_batch_reporting.le_total;
1187: l_number_rows number:=0;
1188: l_new_closed_cd varchar2(1);
1189: l_found boolean;
1190: --
1224: end loop;
1225: p_life_event_totals:=l_life_event_totals;
1226: end event_summary;
1227: -----------------------------------------------------------------------
1228: end ben_batch_reporting;