APPS.AMS_LISTGENERATION_PKG dependencies on AMS_IMP_LIST_HEADERS_VL

Line 8169: from ams_imp_list_headers_vl

8165: where list_name = p_list_name ;
8166: cursor c_get_source_type
8167: is select decode(import_type,'B2C','PERSON_LIST','ORGANIZATION_CONTACT_LIST'),
8168: name
8169: from ams_imp_list_headers_vl
8170: where import_list_header_id = p_imp_list_header_id ;
8171: l_source_type varchar2(100);
8172: l_var varchar2(1);
8173: BEGIN

Line 8190: from ams_imp_list_headers_vl

8186: end if;
8187: if l_var is not null then
8188: select l_import_list_name|| ' -:'|| to_char(sysdate,'DD-MON-YY HH:MM:SS')
8189: into l_import_list_name
8190: from ams_imp_list_headers_vl
8191: where import_list_header_id = p_imp_list_header_id ;
8192: else
8193: l_import_list_name := p_list_name ;
8194: end if;