APPS.CE_CP_OA_XTR_PKG SQL Statements

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

Line: 9

    SELECT party_code
    INTO   result
    FROM   XTR_BANK_ACCOUNTS
    WHERE  nvl(ap_bank_account_id, dummy_bank_account_id) = X_bank_account_id;

Line: 78

    SELECT indicative_flag
    INTO   l_indic
    FROM   CE_CP_WORKSHEET_LINES
    WHERE  worksheet_header_id = X_WS_ID
    AND    source_type = X_SRC_TYPE
    AND    (trx_type is null OR trx_type = 'EXP');

Line: 125

PROCEDURE update_projected_balances(
			p_bank_account_id NUMBER,
			p_balance_date DATE,
			p_balance_amount NUMBER)
IS
BEGIN
	DELETE FROM ce_projected_balances
	WHERE bank_account_id=p_bank_account_id
	AND balance_date=p_balance_date;

Line: 135

	INSERT INTO ce_projected_balances
		(projected_balance_id,
		 bank_Account_id,
		 balance_date,
		 projected_balance,
		 last_update_date,
		 last_updated_by,
		 creation_date,
		 created_by,
		 last_update_login,
		 object_version_number)
	VALUES (ce_projected_Balances_s.nextval,
		p_bank_account_id,
		p_balance_date,
		p_balance_amount,
		sysdate,
		NVL(FND_GLOBAL.user_id,-1),
		sysdate,
		NVL(FND_GLOBAL.user_id,-1),
		NVL(FND_GLOBAL.user_id,-1),
		1);

Line: 157

END update_projected_balances;