DBA Data[Home] [Help]

APPS.HZ_BES_BO_RAISE_PKG dependencies on HZ_CUST_ACCOUNTS

Line 760: ( SELECT 1 FROM hz_cust_accounts WHERE party_id = t1.party_id)

756: FROM hz_bes_gt t2
757: WHERE t2.party_id = t1.party_id
758: AND t2.bo_code IN ('PERSON_CUST','ORG_CUST'))
759: AND EXISTS
760: ( SELECT 1 FROM hz_cust_accounts WHERE party_id = t1.party_id)
761: ) r, hz_parties p, HZ_BUS_OBJ_TRACKING bot
762: where
763: p.party_id = r.party_id
764: and bot.event_id(+) IS NULL