148: FROM
149: HZ_CREDIT_USAGES
150: WHERE cust_acct_profile_amt_id IN
151: (SELECT cust_acct_profile_amt_id
152: FROM HZ_CUST_PROFILE_AMTS
153: WHERE cust_account_id IN
154: (SELECT DISTINCT duplicate_id
155: FROM RA_CUSTOMER_MERGES
156: WHERE process_flag = 'N'
274: , l_credit_usage_rule_set_ids
275: FROM HZ_CREDIT_USAGES
276: WHERE cust_acct_profile_amt_id IN
277: (SELECT cust_acct_profile_amt_id
278: FROM HZ_CUST_PROFILE_AMTS
279: WHERE cust_account_id = l_duplicate_id );
280:
281: IF SQL%FOUND THEN
282: -- set the delete flag