APPS.AMS_ACTMETRICS_SEED_PVT dependencies on AMS_INFMET_LEAD_GT

Line 3502: INSERT INTO AMS_INFMET_LEAD_GT(PRIMARY_PARTY_ID, CONTACT_REL_PARTY_ID,

3498: END IF;
3499:
3500: if l_has_enabled > 0 then
3501:
3502: INSERT INTO AMS_INFMET_LEAD_GT(PRIMARY_PARTY_ID, CONTACT_REL_PARTY_ID,
3503: LAST_ACTIVATION_DATE, ACTIVITY_METRIC_ID, SOURCE_CATEGORY, OBJECT_ID)
3504: SELECT decode(SRC.SOURCE_CATEGORY, 'B2C', ENTRY.PARTY_ID,
3505: 'B2B', REL.OBJECT_ID, null) PRIMARY_PARTY_ID,
3506: decode(SRC.SOURCE_CATEGORY, 'B2C', NULL,

Line 3541: from AMS_INFMET_LEAD_GT csch_parties

3537: BULK COLLECT INTO l_actual_values_table, l_activity_metric_id_table
3538: FROM (select actual_value, am.activity_metric_id, am.func_actual_value
3539: from (
3540: select count(1) actual_value, activity_metric_id
3541: from AMS_INFMET_LEAD_GT csch_parties
3542: where exists (select 1
3543: from as_sales_leads lead, as_statuses_b lead_status
3544: where lead.status_code = lead_status.status_code
3545: AND lead_status.lead_flag = 'Y'