DBA Data[Home] [Help]

APPS.CE_XML_BS_LOADER dependencies on CE_STATEMENT_HEADERS_V

Line 118: FROM CE_STATEMENT_HEADERS_V

114: fnd_client_info.set_org_context(l_org_id);
115:
116: SELECT count(1)
117: INTO l_bs_count
118: FROM CE_STATEMENT_HEADERS_V
119: WHERE bank_account_id = l_bank_account_id
120: AND statement_number = l_statement_number;
121:
122: CE_AUTO_BANK_REC.statement(

Line 143: FROM CE_STATEMENT_HEADERS_V

139:
140: /* check if there is error during import */
141: SELECT count(1)
142: INTO l_bs_count2
143: FROM CE_STATEMENT_HEADERS_V
144: WHERE bank_account_id = l_bank_account_id
145: AND statement_number = l_statement_number;
146:
147: if (l_bs_count = 0 AND l_bs_count2 = 1) then