APPS.HZ_EBI_CUST_LOAD dependencies on HZ_CUST_ACCOUNTS

Line 49: from HZ_PARTIES party, HZ_CUST_ACCOUNTS accnt where

45: -- Initialize Event Id to 0
46: l_eventId := 0;
47: INSERT INTO HZ_EBI_CUST_LOAD_LOG( PARTY_ID , EVENT_ID)
48: Select distinct party.PARTY_ID ,NULL
49: from HZ_PARTIES party, HZ_CUST_ACCOUNTS accnt where
50: accnt.status='A' and party.PARTY_ID = accnt.party_id;
51: --Commit records. To check commit frequency
52: COMMIT;
53:

Line 117: FROM HZ_PARTIES party, HZ_CUST_ACCOUNTS accnt

113: DELETE FROM HZ_EBI_CUST_LOAD_LOG
114: WHERE EVENT_ID = p_event_id AND
115: PARTY_ID NOT IN(
116: SELECT DISTINCT party.PARTY_ID
117: FROM HZ_PARTIES party, HZ_CUST_ACCOUNTS accnt
118: WHERE accnt.STATUS='A' and party.PARTY_ID = accnt.PARTY_ID);
119:
120: SELECT MAX(NVL(EVENT_ID,0))+1 into l_eventId FROM HZ_EBI_CUST_LOAD_LOG;
121: