DBA Data[Home] [Help]

APPS.HZ_DQM_SYNC dependencies on HZ_CUST_ACCOUNTS

Line 937: FROM HZ_CUST_ACCOUNTS c, HZ_PARTIES p

933: ) IS
934:
935: CURSOR c_cust_party IS
936: SELECT c.PARTY_ID, p.PARTY_TYPE
937: FROM HZ_CUST_ACCOUNTS c, HZ_PARTIES p
938: WHERE c.cust_account_id = p_cust_acct_id
939: AND p.party_id = c.party_id
940: AND NOT EXISTS (
941: SELECT d.PARTY_ID