DBA Data[Home] [Help]

APPS.OE_VERIFY_PAYMENT_PUB dependencies on IBY_TRXN_EXTENSIONS_V

Line 6597: FROM iby_trxn_extensions_v

6593: -- to check if the authorization has been settled
6594: BEGIN
6595: SELECT nvl(settled_flag, 'N')
6596: INTO l_settled_flag
6597: FROM iby_trxn_extensions_v
6598: WHERE trxn_extension_id = p_trxn_extension_id;
6599: EXCEPTION WHEN NO_DATA_FOUND THEN
6600: l_settled_flag := 'N';
6601: END;

Line 8213: from IBY_TRXN_EXTENSIONS_V

8209: -- get assignment id from the payments table
8210: begin
8211: select instr_assignment_id
8212: into l_assign_id
8213: from IBY_TRXN_EXTENSIONS_V
8214: where trxn_extension_id = p_trxn_extension_id;
8215: exception when NO_DATA_FOUND THEN
8216: null;
8217: end;