APPS.CE_BANK_STATEMENT_LOADER dependencies on CE_BANK_STMT_MAP_LINE

Line 1245: FROM ce_bank_stmt_map_line_v

1241: SELECT nvl(position,0),
1242: format,
1243: include_format_ind,
1244: concatenate_format_flag
1245: FROM ce_bank_stmt_map_line_v
1246: WHERE map_id = G_map_id
1247: AND column_name = X_column;
1248:
1249: l_pos NUMBER;

Line 1354: FROM CE_BANK_STMT_MAP_LINE

1350: AND rec_id_no = X_rec_id;
1351:
1352: SELECT count(*)
1353: INTO l_line
1354: FROM CE_BANK_STMT_MAP_LINE
1355: WHERE map_id = G_map_id
1356: AND rec_id_no = X_rec_id;
1357:
1358: IF (l_hdr > 0 AND l_line > 0) THEN

Line 1910: FROM ce_bank_stmt_map_line

1906: SELECT column_name,
1907: format,
1908: include_format_ind,
1909: concatenate_format_flag
1910: FROM ce_bank_stmt_map_line
1911: WHERE map_id = G_map_id
1912: AND position = -1;
1913:
1914: l_control_total_cr NUMBER := 0; -- Calculate total credit amount.

Line 2417: FROM ce_bank_stmt_map_line

2413:
2414: FUNCTION Get_Main_Rec_ID (X_hdr_or_line VARCHAR2) RETURN VARCHAR2 IS
2415: CURSOR C_line_rec_id IS
2416: SELECT distinct(rec_id_no) recID
2417: FROM ce_bank_stmt_map_line
2418: WHERE map_id = G_map_id;
2419:
2420: CURSOR C_hdr_rec_id IS
2421: SELECT distinct(rec_id_no) recID

Line 2490: FROM CE_BANK_STMT_MAP_LINE

2486: AND rec_id_no = p_rec_id;
2487:
2488: CURSOR C_line_tbl(p_rec_id VARCHAR2) IS
2489: SELECT column_name, position
2490: FROM CE_BANK_STMT_MAP_LINE
2491: WHERE map_id = G_map_id
2492: AND rec_id_no = p_rec_id;
2493:
2494: l_hdr_flag NUMBER := 0;