APPS.AS_RTTAP_OPPTY dependencies on AS_CHANGED_ACCOUNTS_ALL

Line 57: INSERT INTO AS_CHANGED_ACCOUNTS_ALL

53: | If REALTIME TAP profile is turned on there is NO need
54: | to insert into changed accounts since the oppty is
55: | processed immediately.
56: +-------------------------------------------------------*/
57: INSERT INTO AS_CHANGED_ACCOUNTS_ALL
58: ( customer_id,
59: address_id,
60: lead_id,
61: last_update_date,

Line 80: FROM AS_CHANGED_ACCOUNTS_ALL ACC

76: FROM AS_LEADS_ALL LDS
77: WHERE lead_id = G_LEAD_ID
78: AND NOT EXISTS
79: ( SELECT 'X'
80: FROM AS_CHANGED_ACCOUNTS_ALL ACC
81: WHERE LDS.customer_id = ACC.customer_id
82: --AND LDS.address_id = ACC.address_id -- fix for bug#5116019
83: AND LDS.lead_id = ACC.lead_id
84: AND ACC.request_id IS NULL );