[Home] [Help]
1365: SELECT nvl(position,0),
1366: format,
1367: include_format_ind,
1368: concatenate_format_flag
1369: FROM ce_bank_stmt_map_hdr_v
1370: WHERE map_id = G_map_id
1371: AND column_name = X_column;
1372:
1373: CURSOR C_l IS
1479: l_line NUMBER;
1480: BEGIN
1481: SELECT count(*)
1482: INTO l_hdr
1483: FROM CE_BANK_STMT_MAP_HDR
1484: WHERE map_id = G_map_id
1485: AND rec_id_no = X_rec_id;
1486:
1487: SELECT count(*)
2889: WHERE map_id = G_map_id;
2890:
2891: CURSOR C_hdr_rec_id IS
2892: SELECT distinct(rec_id_no) recID
2893: FROM ce_bank_stmt_map_hdr
2894: WHERE map_id = G_map_id;
2895:
2896: l_lowest_rec_no NUMBER := 10000000;
2897: l_min_rec_no NUMBER;
2961: ORDER BY rec_no;
2962:
2963: CURSOR C_hdr_tbl(p_rec_id VARCHAR2) IS
2964: SELECT column_name, position
2965: FROM CE_BANK_STMT_MAP_HDR
2966: WHERE map_id = G_map_id
2967: AND rec_id_no = p_rec_id;
2968:
2969: CURSOR C_line_tbl(p_rec_id VARCHAR2) IS