APPS.AMS_LISTGENERATION_PKG dependencies on AMS_IMP_LIST_HEADERS_ALL

Line 280: from ams_imp_list_headers_all

276: where list_header_id = l_incl_object_id;
277:
278: cursor c_import_type is
279: select decode(import_type,'B2C','PERSON_LIST','ORGANIZATION_CONTACT_LIST')
280: from ams_imp_list_headers_all
281: where import_list_header_id = l_incl_object_id;
282:
283: cursor c_no_of_rows_in_b2b_list is
284: select count(1)

Line 1257: from ams_imp_list_headers_all

1253: ) is
1254: l_list_entry_source_type varchar2(30);
1255: cursor c_get_source_type
1256: is select decode(import_type,'B2C','PERSON_LIST','ORGANIZATION_CONTACT_LIST')
1257: from ams_imp_list_headers_all
1258: where import_list_header_id = p_incl_object_id;
1259: l_no_of_chunks number;
1260:
1261: l_created_by NUMBER;

Line 6143: from ams_imp_list_headers_all imp,

6139: end;
6140: procedure update_import_list_entries(p_list_header_id in number) is
6141: cursor c1 is
6142: select imp.import_type
6143: from ams_imp_list_headers_all imp,
6144: ams_list_select_actions ail,
6145: ams_list_headers_all alh
6146: where alh.list_header_id = p_list_header_id
6147: and alh.list_header_id = ail.action_used_by_id

Line 12182: from ams_imp_list_headers_all

12178: ) is
12179: l_list_entry_source_type varchar2(30);
12180: cursor c_get_source_type
12181: is select decode(import_type,'B2C','PERSON_LIST','ORGANIZATION_CONTACT_LIST')
12182: from ams_imp_list_headers_all
12183: where import_list_header_id = p_incl_object_id;
12184: l_no_of_chunks number;
12185: BEGIN
12186: write_to_act_log('Executing procedure process_run_total_imph', 'LIST', g_list_header_id,'LOW');