APPS.JL_INTERFACE_VAL dependencies on HZ_CUST_ACCOUNTS
Line 2083: FROM hz_cust_accounts rc
2079:
2080: BEGIN
2081:
2082: SELECT rc.cust_account_id INTO l_customer_id 2083: FROM hz_cust_accounts rc 2084: WHERE rc.orig_system_reference = p_orig_system_customer_ref;
2085:
2086: EXCEPTION
2087: WHEN NO_DATA_FOUND THEN
Line 2089: arp_util_tax.debug('jl_zz_taxid_customers: ' || 'No data found in hz_cust_accounts table for Update');
2085:
2086: EXCEPTION
2087: WHEN NO_DATA_FOUND THEN
2088: IF PG_DEBUG = 'Y' THEN 2089: arp_util_tax.debug('jl_zz_taxid_customers: ' || 'No data found in hz_cust_accounts table for Update'); 2090: ELSE
2091: NULL;
2092: END IF;
2093: WHEN OTHERS THEN