DBA Data[Home] [Help]

APPS.AMS_DMSELECTION_PVT dependencies on JTF_IH_RESULTS_B

Line 2042: jtf_ih_results_b r, ams_list_select_actions l

2038: SET target_flag = (SELECT L_POSITIVE_TARGET_VALUE
2039: FROM dual
2040: WHERE EXISTS (SELECT 1
2041: FROM ams_campaign_schedules_b c, jtf_ih_interactions i,
2042: jtf_ih_results_b r, ams_list_select_actions l
2043: WHERE c.schedule_id = l.incl_object_id
2044: AND l.arc_action_used_by = t.arc_object_used_by
2045: AND l.action_used_by_id = t.object_used_by_id
2046: AND i.party_id = t.party_id

Line 2494: jtf_ih_results_b r, ams_list_select_actions l

2490: AND i.source_code = c.source_code
2491: /*** enable this code when positive responses are captured
2492: WHERE EXISTS (SELECT 1
2493: FROM ams_campaign_schedules_b c, jtf_ih_interactions i,
2494: jtf_ih_results_b r, ams_list_select_actions l
2495: WHERE c.schedule_id = l.incl_object_id
2496: AND l.arc_action_used_by = t.arc_used_for_object
2497: AND l.action_used_by_id = t.used_for_object_id
2498: AND i.party_id = t.party_id