DBA Data[Home] [Help]

APPS.CE_BANK_STATEMENT_LOADER dependencies on CE_BANK_STMT_MAP_HDR

Line 1236: FROM ce_bank_stmt_map_hdr_v

1232: SELECT nvl(position,0),
1233: format,
1234: include_format_ind,
1235: concatenate_format_flag
1236: FROM ce_bank_stmt_map_hdr_v
1237: WHERE map_id = G_map_id
1238: AND column_name = X_column;
1239:
1240: CURSOR C_l IS

Line 1348: FROM CE_BANK_STMT_MAP_HDR

1344: l_line NUMBER;
1345: BEGIN
1346: SELECT count(*)
1347: INTO l_hdr
1348: FROM CE_BANK_STMT_MAP_HDR
1349: WHERE map_id = G_map_id
1350: AND rec_id_no = X_rec_id;
1351:
1352: SELECT count(*)

Line 2422: FROM ce_bank_stmt_map_hdr

2418: WHERE map_id = G_map_id;
2419:
2420: CURSOR C_hdr_rec_id IS
2421: SELECT distinct(rec_id_no) recID
2422: FROM ce_bank_stmt_map_hdr
2423: WHERE map_id = G_map_id;
2424:
2425: l_lowest_rec_no NUMBER := 10000000;
2426: l_min_rec_no NUMBER;

Line 2484: FROM CE_BANK_STMT_MAP_HDR

2480: ORDER BY rec_no;
2481:
2482: CURSOR C_hdr_tbl(p_rec_id VARCHAR2) IS
2483: SELECT column_name, position
2484: FROM CE_BANK_STMT_MAP_HDR
2485: WHERE map_id = G_map_id
2486: AND rec_id_no = p_rec_id;
2487:
2488: CURSOR C_line_tbl(p_rec_id VARCHAR2) IS