APPS.AS_TCA_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 39

  SELECT  1
  FROM  AS_PARTY_CUSTOMERS_V
  WHERE party_id = X_Party_Id;

Line: 93

  SELECT  1
  FROM  AS_PARTY_ADDRESSES_V
  WHERE party_id = X_Party_Id
  AND party_site_id = X_Party_Site_Id;

Line: 147

  SELECT 1
  FROM  AS_PARTY_PHONES_V
  WHERE contact_point_id = X_Contact_Point_Id
  AND owner_table_id = X_Party_Id
  AND owner_table_name = 'HZ_PARTIES';

Line: 154

  SELECT 1
  FROM JTF_PARTY_PHONES_V
  WHERE org_contact_id = X_Org_Contact_Id
  AND contact_point_id = X_Contact_Point_Id;

Line: 235

  SELECT  1
  FROM  AS_PARTY_ORG_CONTACTS_V
  WHERE contact_id = X_Contact_Id
  AND party_id = X_Party_Id;