APPS.CE_XML_BS_LOADER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 5

	select	item_key,
		statement_number,
		trading_partner,
		bank_account_num
        from ce_xml_statement_list;

Line: 18

    insert into CE_XML_STATEMENT_LIST
	(ITEM_KEY, STATEMENT_NUMBER, TRADING_PARTNER, BANK_ACCOUNT_NUM)
    values (
	X_ITEM_KEY,
	X_STATEMENT_NUMBER,
	X_TRADING_PARTNER,
	X_BANK_ACCOUNT_NUM);

Line: 56

    DELETE ce_xml_statement_list
    WHERE  item_key = l_item_key;

Line: 62

      SELECT count(1)
      INTO   l_cnt
      FROM   CE_BANK_ACCOUNTS
      WHERE  BANK_ACCOUNT_NUM = l_bank_account_num;

Line: 67

      SELECT count(1)
      INTO   l_cnt
      FROM   CE_BANK_ACCOUNTS BA, CE_BANK_BRANCHES_v BB
      WHERE  BA.bank_account_num = l_bank_account_num
      AND    BB.bank_name = l_trading_partner
      AND    BB.branch_party_id = BA.bank_branch_id;

Line: 95

        SELECT	BB.branch_party_id,
		BA.bank_account_id,
		BA.ACCOUNT_OWNER_org_id,
		BB.bank_name
	INTO	l_bank_branch_id, l_bank_account_id, l_org_id, l_trading_partner
	FROM	CE_BANK_ACCOUNTS BA, CE_BANK_BRANCHES_V BB
	WHERE	BA.bank_account_num = l_bank_account_num
	AND	BB.branch_party_id = BA.bank_branch_id;

Line: 104

	SELECT	BB.branch_party_id,
		BA.bank_account_id,
		BA.ACCOUNT_OWNER_org_id
	INTO	l_bank_branch_id, l_bank_account_id, l_org_id
	FROM	CE_BANK_ACCOUNTS BA, CE_BANK_BRANCHES_V BB
	WHERE	BA.bank_account_num = l_bank_account_num
	AND	BB.bank_name = l_trading_partner
	AND	BB.branch_party_id = BA.bank_branch_id;

Line: 116

      SELECT count(1)
      INTO   l_bs_count
      FROM   CE_STATEMENT_HEADERS_V
      WHERE  bank_account_id = l_bank_account_id
      AND    statement_number = l_statement_number;

Line: 141

      SELECT count(1)
      INTO   l_bs_count2
      FROM   CE_STATEMENT_HEADERS_V
      WHERE  bank_account_id = l_bank_account_id
      AND    statement_number = l_statement_number;