APPS.OTA_TFH_API_BUSINESS_RULES dependencies on OTA_CUSTOMER_CONTACTS_V

Line 298: from ota_customer_contacts_v con

294: v_proc varchar2(72) := g_package||'check_customer_contact';
295: --
296: cursor sel_customer_contact is
297: select 'Y'
298: from ota_customer_contacts_v con
299: where con.customer_id = p_customer_id
300: and con.contact_id = p_contact_id;
301: --
302: Begin

Line 433: from ota_customer_contacts_v con

429: v_proc varchar2(72) := g_package||'set_invoice_contact';
430: --
431: cursor sel_invoice_contact is
432: select con.full_name
433: from ota_customer_contacts_v con
434: where con.customer_id = p_customer_id
435: and con.contact_id = p_contact_id;
436: --
437: Begin