DBA Data[Home] [Help]

APPS.HR_NZ_BANK_ACCT_VALIDATION SQL Statements

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

Line: 591

	SELECT MEANING
	FROM HR_LOOKUPS
	WHERE LOOKUP_TYPE = 'NZ_BANK' AND
	      LOOKUP_CODE = p_bank_no AND
		  ENABLED_FLAG = 'Y';
Line: 645

		-- Select the correct validation routine for the bank

		IF (l_bank_no = '08')
		THEN
			IF (validate_08(l_bank_no, l_branch_no, l_acct_no, p_account_suffix))
			THEN
				RAISE validation_failed;