DBA Data[Home] [Help]

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