APPS.OCM_CREDIT_REQ_WITHDRAW_PUB SQL Statements

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

Line: 44

		SELECT 'X'
		INTO   l_status
		FROM   ar_cmgt_credit_requests
		WHERE  credit_request_id = p_credit_request_id
		AND    status NOT IN ('WITHDRAW', 'PROCESSED');

Line: 63

		SELECT 'X'
		INTO   l_ctr
		FROM   ar_lookups
		WHERE  lookup_type = 'AR_CMGT_APP_WITHDRAW_REASONS'
		AND    lookup_code = p_withdrawl_reason_code;

Line: 82

	-- Now update the status of credit request and case folder
	UPDATE ar_cmgt_credit_requests
	  SET  status = 'WITHDRAW'
	WHERE credit_request_id = p_credit_request_id;

Line: 87

	UPDATE ar_cmgt_case_folders
	  SET  status = 'WITHDRAW'
	WHERE credit_request_id = p_credit_request_id;