APPS.HZ_PROFILE_MERGE_PKG SQL Statements

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

Line: 85

    SELECT cust_acct_profile_amt_id,
           cust_account_profile_id,
           currency_code
      FROM hz_cust_profile_amts
     WHERE cust_account_profile_id = p_to_profile_id;

Line: 113

    SELECT cust_acct_profile_amt_id,
           cust_account_profile_id,
           currency_code
      FROM hz_cust_profile_amts
     WHERE cust_account_profile_id = p_from_profile_id;

Line: 135

         UPDATE hz_cust_profile_amts
            SET cust_account_profile_id = p_to_profile_id,
                last_update_date = hz_utility_pub.last_update_date,
                last_updated_by = hz_utility_pub.user_id,
                last_update_login = hz_utility_pub.last_update_login,
                request_id =  hz_utility_pub.request_id,
                program_application_id = hz_utility_pub.program_application_id,
                program_id = hz_utility_pub.program_id,
                program_update_date = sysdate
          WHERE cust_acct_profile_amt_id = l_rec.cust_acct_profile_amt_id;

Line: 174

    SELECT cust_account_profile_id,
           cust_account_id,
           party_id,
           site_use_id,
           status
      FROM hz_customer_profiles
     WHERE cust_account_profile_id = p_from_id;

Line: 184

    SELECT cust_account_profile_id,
           cust_account_id,
           party_id,
           site_use_id
      FROM hz_customer_profiles
     WHERE party_id        = p_to_fk_id
       AND cust_account_id = -1;

Line: 206

         UPDATE hz_customer_profiles
            SET party_id          = p_to_fk_id,
                last_update_date  = hz_utility_pub.last_update_date,
                last_updated_by   = hz_utility_pub.user_id,
                last_update_login = hz_utility_pub.last_update_login,
                request_id        =  hz_utility_pub.request_id,
                program_application_id = hz_utility_pub.program_application_id,
                program_id        = hz_utility_pub.program_id,
                program_update_date = sysdate
          WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;

Line: 222

         UPDATE hz_customer_profiles
            SET party_id          = p_to_fk_id,
                last_update_date  = hz_utility_pub.last_update_date,
                last_updated_by   = hz_utility_pub.user_id,
                last_update_login = hz_utility_pub.last_update_login,
                request_id        =  hz_utility_pub.request_id,
                program_application_id = hz_utility_pub.program_application_id,
                program_id        = hz_utility_pub.program_id,
                program_update_date = sysdate
          WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;

Line: 242

           UPDATE hz_customer_profiles
              SET party_id          = p_to_fk_id,
                  last_update_date  = hz_utility_pub.last_update_date,
                  last_updated_by   = hz_utility_pub.user_id,
                  last_update_login = hz_utility_pub.last_update_login,
                  request_id        =  hz_utility_pub.request_id,
                  program_application_id = hz_utility_pub.program_application_id,
                  program_id        = hz_utility_pub.program_id,
                  program_update_date = sysdate
            WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;

Line: 261

           UPDATE hz_customer_profiles
              SET status = 'M',
                  last_update_date  = hz_utility_pub.last_update_date,
                  last_updated_by   = hz_utility_pub.user_id,
                  last_update_login = hz_utility_pub.last_update_login,
                  request_id        =  hz_utility_pub.request_id,
                  program_application_id = hz_utility_pub.program_application_id,
                  program_id        = hz_utility_pub.program_id,
                  program_update_date = sysdate
            WHERE cust_account_profile_id = l_from_rec.cust_account_profile_id;