APPS.AMS_DMSELECTION_PVT dependencies on AMS_LIST_SELECT_ACTIONS

Line 807: FROM ams_list_select_actions

803:
804: CURSOR c_objects (p_arc_object_for IN VARCHAR2, p_object_for_id IN NUMBER) IS
805: SELECT arc_incl_object_from,
806: incl_object_id
807: FROM ams_list_select_actions
808: WHERE arc_action_used_by = p_arc_object_for
809: AND action_used_by_id = p_object_for_id
810: ;
811: l_object_rec c_objects%ROWTYPE;

Line 1424: FROM ams_list_select_actions

1420: l_row_count NUMBER;
1421:
1422: CURSOR c_sources (p_arc_object_for IN VARCHAR2, p_object_for_id IN NUMBER) IS
1423: SELECT list_action_type, arc_incl_object_from, incl_object_id
1424: FROM ams_list_select_actions
1425: WHERE arc_action_used_by = p_arc_object_for
1426: AND action_used_by_id = p_object_for_id
1427: ORDER BY order_number
1428: ;

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 2332: FROM ams_list_select_actions

2328: l_return_status VARCHAR2(1);
2329:
2330: CURSOR c_action_version (p_arc_incl_object IN VARCHAR2, p_incl_object_id IN NUMBER) IS
2331: SELECT list_select_action_id, object_version_number
2332: FROM ams_list_select_actions
2333: WHERE arc_action_used_by = p_arc_object_for
2334: AND action_used_by_id = p_object_for_id
2335: AND arc_incl_object_from = p_arc_incl_object
2336: AND incl_object_id = p_incl_object_id

Line 2485: ams_list_select_actions l

2481: FROM dual
2482: WHERE EXISTS (SELECT 1
2483: FROM ams_campaign_schedules_b c,
2484: jtf_ih_interactions i,
2485: ams_list_select_actions l
2486: WHERE c.schedule_id = l.incl_object_id
2487: AND l.arc_action_used_by = t.arc_used_for_object
2488: AND l.action_used_by_id = t.used_for_object_id
2489: 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