APPS.CS_CH_ACCOUNT_MERGE_PKG SQL Statements

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

Line: 87

         SELECT distinct CUSTOMER_MERGE_HEADER_ID
              ,ESTIMATE_DETAIL_ID
              ,INVOICE_TO_ACCOUNT_ID
              ,SHIP_TO_ACCOUNT_ID
         FROM CS_ESTIMATE_DETAILS yt,
	      ra_customer_merges m
         WHERE (  yt.INVOICE_TO_ACCOUNT_ID = m.DUPLICATE_ID
                 OR yt.SHIP_TO_ACCOUNT_ID = m.DUPLICATE_ID)
         AND    m.process_flag = 'N'
         AND    m.request_id   = req_id
         AND    m.set_number   = set_number;

Line: 100

         SELECT PARTY_ID
         FROM HZ_CUST_ACCOUNTS HCA
         WHERE cust_account_id = p_cust_account_id;

Line: 105

 	 select CUSTOMER_ID, DUPLICATE_ID
	 from   RA_CUSTOMER_MERGES RCM
	 Where  rcm.request_id   = req_id
	 And    rcm.set_number   = set_number
	 And    rcm.process_flag = 'N';

Line: 189

            INSERT INTO HZ_CUSTOMER_MERGE_LOG (
               MERGE_LOG_ID,                        TABLE_NAME,
	       MERGE_HEADER_ID,                     PRIMARY_KEY_ID,
	       NUM_COL1_ORIG,                       NUM_COL1_NEW,
               NUM_COL2_ORIG,                       NUM_COL2_NEW,
	       ACTION_FLAG,                         REQUEST_ID,
               CREATED_BY,                          CREATION_DATE,
	       LAST_UPDATE_LOGIN,                   LAST_UPDATE_DATE,
	       LAST_UPDATED_BY )
            VALUES (
	       HZ_CUSTOMER_MERGE_LOG_s.nextval,     'CS_ESTIMATE_DETAILS',
	       MERGE_HEADER_ID_LIST(I),             PRIMARY_KEY_ID_LIST(I),
	       NUM_COL1_ORIG_LIST(I),               NUM_COL1_NEW_LIST(I),
               NUM_COL2_ORIG_LIST(I),               NUM_COL2_NEW_LIST(I),
	       'U',                                 req_id,
               hz_utility_pub.CREATED_BY,           hz_utility_pub.CREATION_DATE,
	       hz_utility_pub.LAST_UPDATE_LOGIN,    hz_utility_pub.LAST_UPDATE_DATE,
	       hz_utility_pub.LAST_UPDATED_BY );

Line: 211

            UPDATE CS_ESTIMATE_DETAILS  yt SET
               INVOICE_TO_ACCOUNT_ID      = NUM_COL1_NEW_LIST(I)
             , SHIP_TO_ACCOUNT_ID      = NUM_COL2_NEW_LIST(I)
             , LAST_UPDATE_DATE        = SYSDATE
             , last_updated_by         = arp_standard.profile.user_id
             , last_update_login       = arp_standard.profile.last_update_login
         WHERE ESTIMATE_DETAIL_ID=PRIMARY_KEY_ID_LIST(I) ;

Line: 227

       arp_message.set_name('AR','AR_ROWS_UPDATED');