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 6150: from ams_imp_list_headers_all imp,

6146: end;
6147: procedure update_import_list_entries(p_list_header_id in number) is
6148: cursor c1 is
6149: select imp.import_type
6150: from ams_imp_list_headers_all imp,
6151: ams_list_select_actions ail,
6152: ams_list_headers_all alh
6153: where alh.list_header_id = p_list_header_id
6154: and alh.list_header_id = ail.action_used_by_id

Line 12283: from ams_imp_list_headers_all

12279: ) is
12280: l_list_entry_source_type varchar2(30);
12281: cursor c_get_source_type
12282: is select decode(import_type,'B2C','PERSON_LIST','ORGANIZATION_CONTACT_LIST')
12283: from ams_imp_list_headers_all
12284: where import_list_header_id = p_incl_object_id;
12285: l_no_of_chunks number;
12286: BEGIN
12287: write_to_act_log('Executing procedure process_run_total_imph', 'LIST', g_list_header_id,'LOW');