APPS.CE_BANK_STATEMENT_LOADER dependencies on CE_STATEMENT_HEADERS_INT

Line 299: FROM ce_statement_headers_int

295: EXIT WHEN l_cursor%NOTFOUND;
296:
297: SELECT count (1)
298: INTO h_rec_cnt
299: FROM ce_statement_headers_int
300: WHERE bank_account_num = l_bank_account_num
301: AND statement_number = l_statement_number;
302:
303: IF h_rec_cnt = 0 THEN

Line 448: FROM ce_statement_headers_int

444: /*
445: IF G_org_id is not null THEN
446: SELECT count(1)
447: INTO l_rec_cnt
448: FROM ce_statement_headers_int
449: WHERE bank_account_num = G_bank_account_num
450: AND statement_number = l_statement_number
451: AND nvl(org_id,G_org_id) = G_org_id;
452: ELSE*/

Line 455: FROM ce_statement_headers_int

451: AND nvl(org_id,G_org_id) = G_org_id;
452: ELSE*/
453: SELECT count(1)
454: INTO l_rec_cnt
455: FROM ce_statement_headers_int
456: WHERE bank_account_num = G_bank_account_num
457: AND statement_number = l_statement_number;
458: --END IF;
459: IF l_rec_cnt > 0 THEN

Line 461: DELETE FROM ce_statement_headers_int

457: AND statement_number = l_statement_number;
458: --END IF;
459: IF l_rec_cnt > 0 THEN
460: /*IF G_org_id is not null THEN
461: DELETE FROM ce_statement_headers_int
462: WHERE bank_account_num = G_bank_account_num
463: AND statement_number = l_statement_number
464: AND nvl(org_id,G_org_id) = G_org_id;
465: ELSE*/

Line 466: DELETE FROM ce_statement_headers_int

462: WHERE bank_account_num = G_bank_account_num
463: AND statement_number = l_statement_number
464: AND nvl(org_id,G_org_id) = G_org_id;
465: ELSE*/
466: DELETE FROM ce_statement_headers_int
467: WHERE bank_account_num = G_bank_account_num
468: AND statement_number = l_statement_number;
469: --END IF;
470: G_total_hdr_deleted := G_total_hdr_deleted + l_rec_cnt;

Line 476: INSERT INTO ce_statement_headers_int(

472:
473: -- bug 4337623 added for subsidiary bank accounts
474: validate_subsidiary_account();
475:
476: INSERT INTO ce_statement_headers_int(
477: STATEMENT_NUMBER,
478: BANK_ACCOUNT_NUM,
479: STATEMENT_DATE,
480: BANK_NAME,