[Home] [Help]
814: null POU_LPB_BRDN_COST,
815: MIN(time.START_DATE) MIN_START_DATE,
816: MAX(time.END_DATE) MAX_END_DATE
817: FROM
818: pa_res_list_map_tmp4 tmp4,
819: pji_fm_aggr_fin8 accum,
820: pji_time_cal_period_v time,
821: pji_org_extr_info info
822: WHERE
889: null POU_LPB_BRDN_COST,
890: MIN(time.START_DATE) MIN_START_DATE,
891: MAX(time.END_DATE) MAX_END_DATE
892: FROM
893: pa_res_list_map_tmp4 tmp4,
894: pji_fm_aggr_fin8 accum ,
895: pji_time_cal_period_v time --, pji_org_extr_info info
896: WHERE
897: tmp4.TXN_SOURCE_ID = accum.TXN_ACCUM_HEADER_ID AND
994: null POU_LPB_BRDN_COST,
995: MIN(time.START_DATE) MIN_START_DATE,
996: MAX(time.END_DATE) MAX_END_DATE
997: FROM
998: pa_res_list_map_tmp4 tmp4,
999: pji_fm_aggr_fin8 fin,
1000: pji_time_cal_period_v time,
1001: pji_org_extr_info info
1002: WHERE
1069: null POU_LPB_BRDN_COST,
1070: MIN(time.START_DATE) MIN_START_DATE,
1071: MAX(time.END_DATE) MAX_END_DATE
1072: FROM
1073: pa_res_list_map_tmp4 tmp4,
1074: pji_fm_aggr_fin8 fin ,
1075: pji_time_cal_period_v time --, pji_org_extr_info info
1076: WHERE
1077: tmp4.TXN_SOURCE_ID = fin.TXN_ACCUM_HEADER_ID AND
1213: null INCR_POU_BRDN_COST,
1214: time.START_DATE,
1215: time.END_DATE
1216: FROM
1217: pa_res_list_map_tmp4 tmp4,
1218: pji_fp_txn_accum accum,
1219: pji_time_cal_period_v time,
1220: pji_org_extr_info info
1221: WHERE
1326: null INCR_POU_BRDN_COST,
1327: time.START_DATE,
1328: time.END_DATE
1329: FROM
1330: pa_res_list_map_tmp4 tmp4,
1331: pji_fp_txn_accum accum,
1332: pji_time_cal_period_v time
1333: WHERE
1334: tmp4.TXN_SOURCE_ID = accum.TXN_ACCUM_HEADER_ID AND
1351: END IF;/*p_calling_context*/
1352:
1353: print_time ( ' get_summarized_data 0004.4 ' ) ;
1354:
1355: delete from pa_res_list_map_tmp4;
1356:
1357: /* Added for populating periodic actuals till as_of_data parameter */
1358: /* Bug 5349102 :shifted the code to delete_fin8
1359: IF p_calling_context in ('P', 'W') THEN