APPS.AS_RTTAP_ACCOUNT dependencies on AS_CHANGED_ACCOUNTS_ALL

Line 357: INSERT INTO AS_CHANGED_ACCOUNTS_ALL

353: | If REALTIME TAP profile is turned on there is NO need
354: | to insert into changed accounts since the ACCOUNT is
355: | processed immediately.
356: +-------------------------------------------------------*/
357: INSERT INTO AS_CHANGED_ACCOUNTS_ALL
358: ( customer_id,
359: address_id,
360: last_update_date,
361: last_updated_by,

Line 377: FROM AS_CHANGED_ACCOUNTS_ALL ACC

373: 'ACCOUNT'
374: FROM DUAL
375: WHERE NOT EXISTS
376: ( SELECT 'X'
377: FROM AS_CHANGED_ACCOUNTS_ALL ACC
378: WHERE ACC.customer_id = G_PARTY_ID
379: AND ACC.lead_id IS NULL
380: AND ACC.sales_lead_id IS NULL
381: AND ACC.request_id IS NULL );