APPS.AMS_ACTMETRICS_SEED_PVT dependencies on AMS_INFMET_RESP_GT

Line 3206: INSERT INTO AMS_INFMET_RESP_GT(PRIMARY_PARTY_ID, CONTACT_REL_PARTY_ID,

3202:
3203:
3204: IF l_has_enabled > 0 THEN
3205:
3206: INSERT INTO AMS_INFMET_RESP_GT(PRIMARY_PARTY_ID, CONTACT_REL_PARTY_ID,
3207: LAST_ACTIVATION_DATE, ACTIVITY_METRIC_ID, SOURCE_CATEGORY)
3208: SELECT decode(SRC.SOURCE_CATEGORY, 'B2C', ENTRY.PARTY_ID,
3209: 'B2B', REL.OBJECT_ID, null) PRIMARY_PARTY_ID,
3210: decode(SRC.SOURCE_CATEGORY,'B2C', NULL,

Line 3242: from AMS_INFMET_RESP_GT csch_parties

3238: BULK COLLECT INTO l_actual_values_table, l_activity_metric_id_table
3239: from (select actual_value, actmet.activity_metric_id, func_actual_value
3240: FROM (
3241: select count(1) actual_value, ACTIVITY_METRIC_ID
3242: from AMS_INFMET_RESP_GT csch_parties
3243: where exists (select /*+ use_concat */ 1
3244: from jtf_ih_interactions inter, jtf_ih_results_b result
3245: WHERE result.positive_response_flag = 'Y'
3246: AND result.result_id = inter.result_id