DBA Data[Home] [Help]

APPS.OTA_TFH_API_BUSINESS_RULES dependencies on OTA_CUSTOMER_ADDRESSES_V

Line 341: from ota_customer_addresses_v adr

337: v_proc varchar2(72) := g_package||'check_customer_address';
338: --
339: cursor sel_customer_address is
340: select 'Y'
341: from ota_customer_addresses_v adr
342: where adr.customer_id = p_customer_id
343: and adr.address_id = p_address_id;
344: --
345: Begin

Line 389: from ota_customer_addresses_v adr

385: v_proc varchar2(72) := g_package||'set_invoice_address';
386: --
387: cursor sel_invoice_address is
388: select adr.address
389: from ota_customer_addresses_v adr
390: where adr.customer_id = p_customer_id
391: and adr.address_id = p_address_id;
392: --
393: Begin