DBA Data[Home] [Help]

APPS.HZ_DQM_SYNC dependencies on HZ_CUST_ACCOUNTS

Line 948: FROM HZ_CUST_ACCOUNTS c, HZ_PARTIES p

944: ) IS
945:
946: CURSOR c_cust_party IS
947: SELECT c.PARTY_ID, p.PARTY_TYPE
948: FROM HZ_CUST_ACCOUNTS c, HZ_PARTIES p
949: WHERE c.cust_account_id = p_cust_acct_id
950: AND p.party_id = c.party_id
951: AND NOT EXISTS (
952: SELECT d.PARTY_ID