APPS.AMS_LISTGENERATION_PKG dependencies on AMS_IMP_LIST_HEADERS_VL

Line 8081: from ams_imp_list_headers_vl

8077: where list_name = p_list_name ;
8078: cursor c_get_source_type
8079: is select decode(import_type,'B2C','PERSON_LIST','ORGANIZATION_CONTACT_LIST'),
8080: name
8081: from ams_imp_list_headers_vl
8082: where import_list_header_id = p_imp_list_header_id ;
8083: l_source_type varchar2(100);
8084: l_var varchar2(1);
8085: BEGIN

Line 8102: from ams_imp_list_headers_vl

8098: end if;
8099: if l_var is not null then
8100: select l_import_list_name|| ' -:'|| to_char(sysdate,'DD-MON-YY HH:MM:SS')
8101: into l_import_list_name
8102: from ams_imp_list_headers_vl
8103: where import_list_header_id = p_imp_list_header_id ;
8104: else
8105: l_import_list_name := p_list_name ;
8106: end if;