DBA Data[Home] [Help]

APPS.AMS_TCOP_ENGINE_PKG dependencies on AMS_ACT_LISTS

Line 493: ,AMS_ACT_LISTS act_list

489: CURSOR C_Get_List_Header(p_schedule_id NUMBER)
490: IS
491: SELECT header.LIST_HEADER_ID
492: FROM AMS_LIST_HEADERS_ALL header
493: ,AMS_ACT_LISTS act_list
494: WHERE header.LIST_HEADER_ID = act_list.LIST_HEADER_ID
495: and act_list.LIST_ACT_TYPE = 'TARGET'
496: and act_list.LIST_USED_BY = 'CSCH'
497: and act_list.LIST_USED_BY_ID = p_schedule_id;