APPS.JAI_AR_HCA_TRIGGER_PKG SQL Statements

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

Line: 18

  Select count(*)
  From   JAI_CMN_CUS_ADDRESSES
  Where  Customer_Id = v_customer_id;

Line: 24

/*    FILENAME: JA_IN_CUSTOMER_DELETE_TRG.sql

 CHANGE HISTORY:
S.No      Date     Author and Details
1.  2001/07/12    Anuradha Parthasarathy
                  Code added to ensure that this trigger doesnt fire for Non Indian OU.

2. 26-05-2005     rallamse bug#4384239
                  The trigger is previously based on AR.RA_CUSTOMERS
                  which does not have a synonym in APPS and GSCC does not allow hardcoded
                  schema name AR as per File.Sql.6
                  As per discussion with CBABU, changed the trigger to table HZ_CUST_ACCOUNTS
                  and used pr_old.cust_account_id instead of pr_old.customer_id

3. 08-Jun-2005    File Version 116.2. This Object is Modified to refer to New DB Entity names in place of Old
                  DB Entity as required for CASE COMPLAINCE.

4. 13-Jun-2005    Ramananda for bug#4428980. File Version: 116.2
                  Removal of SQL LITERALs is done

--------------------------------------------------------------------------------------------*/
  v_customer_id  := pr_old.cust_account_id; --Ramananda for File.Sql.35

Line: 54

    Delete JAI_CMN_CUS_ADDRESSES
      Where  Customer_ID = v_customer_id;