APPS.CE_BANK_STATEMENT_LOADER dependencies on CE_BANK_STMT_MAP_LINE

Line 1378: FROM ce_bank_stmt_map_line_v

1374: SELECT nvl(position,0),
1375: format,
1376: include_format_ind,
1377: concatenate_format_flag
1378: FROM ce_bank_stmt_map_line_v
1379: WHERE map_id = G_map_id
1380: AND column_name = X_column;
1381:
1382: l_pos NUMBER;

Line 1489: FROM CE_BANK_STMT_MAP_LINE

1485: AND rec_id_no = X_rec_id;
1486:
1487: SELECT count(*)
1488: INTO l_line
1489: FROM CE_BANK_STMT_MAP_LINE
1490: WHERE map_id = G_map_id
1491: AND rec_id_no = X_rec_id;
1492:
1493: IF (l_hdr > 0 AND l_line > 0) THEN

Line 2205: FROM ce_bank_stmt_map_line

2201: SELECT column_name,
2202: format,
2203: include_format_ind,
2204: concatenate_format_flag
2205: FROM ce_bank_stmt_map_line
2206: WHERE map_id = G_map_id
2207: AND position = -1;
2208:
2209: l_control_total_cr NUMBER := 0; -- Calculate total credit amount.

Line 2888: FROM ce_bank_stmt_map_line

2884:
2885: FUNCTION Get_Main_Rec_ID (X_hdr_or_line VARCHAR2) RETURN VARCHAR2 IS
2886: CURSOR C_line_rec_id IS
2887: SELECT distinct(rec_id_no) recID
2888: FROM ce_bank_stmt_map_line
2889: WHERE map_id = G_map_id;
2890:
2891: CURSOR C_hdr_rec_id IS
2892: SELECT distinct(rec_id_no) recID

Line 2971: FROM CE_BANK_STMT_MAP_LINE

2967: AND rec_id_no = p_rec_id;
2968:
2969: CURSOR C_line_tbl(p_rec_id VARCHAR2) IS
2970: SELECT column_name, position
2971: FROM CE_BANK_STMT_MAP_LINE
2972: WHERE map_id = G_map_id
2973: AND rec_id_no = p_rec_id;
2974:
2975: l_hdr_flag NUMBER := 0;