DBA Data[Home] [Help]

APPS.AMS_TCOP_UTIL_PKG dependencies on AMS_ACT_LISTS

Line 39: ,ams_act_lists act_list

35: is
36: select list_header.apply_traffic_cop,
37: list_header.list_header_id
38: from ams_list_headers_all list_header
39: ,ams_act_lists act_list
40: where act_list.LIST_ACT_TYPE = 'TARGET'
41: and act_list.LIST_USED_BY = 'CSCH'
42: and act_list.LIST_USED_BY_ID = p_schedule_id
43: and act_list.LIST_HEADER_ID = list_header.LIST_HEADER_ID;