DBA Data[Home] [Help]

APPS.AR_MCC_MERGE dependencies on HZ_CUST_PROFILE_AMTS

Line 152: FROM HZ_CUST_PROFILE_AMTS

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'

Line 278: FROM HZ_CUST_PROFILE_AMTS

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