APPS.AMS_LIST_PURGE_PVT dependencies on AMS_LIST_SELECT_ACTIONS

Line 60: FROM ams_list_select_actions a, ams_list_headers_all b

56: l_upd_status_code VARCHAR2(30);
57:
58: CURSOR c_list_entries_rec_int (c_imp_header_id NUMBER) IS
59: SELECT DISTINCT b.list_header_id
60: FROM ams_list_select_actions a, ams_list_headers_all b
61: WHERE a.incl_object_id = c_imp_header_id
62: AND a.arc_incl_object_from = 'IMPH'
63: AND a.action_used_by_id = b.list_header_id
64: AND (b.list_type <> 'TARGET' OR b.status_code <> 'LOCKED');

Line 68: FROM ams_list_select_actions a, ams_list_headers_all b

64: AND (b.list_type <> 'TARGET' OR b.status_code <> 'LOCKED');
65:
66: CURSOR c_list_entries_force_rec_int (c_imp_header_id NUMBER) IS
67: SELECT DISTINCT b.list_header_id
68: FROM ams_list_select_actions a, ams_list_headers_all b
69: WHERE a.incl_object_id = c_imp_header_id
70: AND a.arc_incl_object_from = 'IMPH'
71: AND a.action_used_by_id = b.list_header_id;
72:

Line 978: DELETE from ams_list_select_actions

974: DELETE from ams_act_logs
975: WHERE act_log_used_by_id = p_id_tbl(i);
976:
977: FORALL i in 1 .. p_id_tbl.count
978: DELETE from ams_list_select_actions
979: WHERE action_used_by_id = p_id_tbl(i);
980:
981: FORALL i in 1 .. p_id_tbl.count
982: DELETE from ams_list_rule_usages

Line 1047: FROM ams_list_select_actions

1043: WHERE list_header_id = p_list_header_id;
1044:
1045: CURSOR c_is_used_in_sel IS
1046: SELECT list_header_id
1047: FROM ams_list_select_actions
1048: WHERE arc_incl_object_from='LIST'
1049: AND incl_object_id = p_list_header_id;
1050:
1051: CURSOR c_is_used_in_act IS