[Home] [Help]
823: --OLAP
824: accum.cbs_element_id CBS_ELEMENT_ID
825: -- End OLAP
826: FROM
827: pa_res_list_map_tmp4 tmp4,
828: pji_fm_aggr_fin8 accum,
829: pji_time_cal_period_v time,
830: pji_org_extr_info info
831: WHERE
905: --OLAP
906: accum.CBS_ELEMENT_ID CBS_ELEMENT_ID
907: -- End OLAP
908: FROM
909: pa_res_list_map_tmp4 tmp4,
910: pji_fm_aggr_fin8 accum ,
911: pji_time_cal_period_v time --, pji_org_extr_info info
912: WHERE
913: tmp4.TXN_SOURCE_ID = accum.TXN_ACCUM_HEADER_ID AND
1023: --OLAP
1024: fin.CBS_ELEMENT_ID CBS_ELEMENT_ID
1025: -- End OLAP
1026: FROM
1027: pa_res_list_map_tmp4 tmp4,
1028: pji_fm_aggr_fin8 fin,
1029: pji_time_cal_period_v time,
1030: pji_org_extr_info info
1031: WHERE
1105: --OLAP
1106: fin.CBS_ELEMENT_ID
1107: -- End OLAP
1108: FROM
1109: pa_res_list_map_tmp4 tmp4,
1110: pji_fm_aggr_fin8 fin ,
1111: pji_time_cal_period_v time --, pji_org_extr_info info
1112: WHERE
1113: tmp4.TXN_SOURCE_ID = fin.TXN_ACCUM_HEADER_ID AND
1266: --OLAP
1267: accum.CBS_ELEMENT_ID
1268: --End OLAP
1269: FROM
1270: pa_res_list_map_tmp4 tmp4,
1271: pji_fp_txn_accum accum,
1272: pji_time_cal_period_v time,
1273: pji_org_extr_info info
1274: WHERE
1387: --OLAP
1388: accum.CBS_ELEMENT_ID
1389: -- End OLAP
1390: FROM
1391: pa_res_list_map_tmp4 tmp4,
1392: pji_fp_txn_accum accum,
1393: pji_time_cal_period_v time
1394: WHERE
1395: tmp4.TXN_SOURCE_ID = accum.TXN_ACCUM_HEADER_ID AND
1414: END IF;/*p_calling_context*/
1415:
1416: print_time ( ' get_summarized_data 0004.4 ' ) ;
1417:
1418: delete from pa_res_list_map_tmp4;
1419:
1420: /* Added for populating periodic actuals till as_of_data parameter */
1421: /* Bug 5349102 :shifted the code to delete_fin8
1422: IF p_calling_context in ('P', 'W') THEN