APPS.AMS_LISTIMPORT_PVT dependencies on AMS_IMP_LIST_IMPORT_TYPES

Line 3058: SELECT concurrent_program FROM ams_imp_list_import_types

3054: select import_type,VALIDATE_FILE,NUMBER_OF_INSTANCES from ams_imp_list_headers_all
3055: where import_list_header_id = p_import_list_header_id;
3056:
3057: cursor c_conc_name is
3058: SELECT concurrent_program FROM ams_imp_list_import_types
3059: where import_type = l_import_type;
3060:
3061: cursor c_error_exist is
3062: select 'Y' from ams_list_import_errors

Line 4002: SELECT concurrent_program FROM ams_imp_list_import_types

3998: from ams_imp_list_headers_all
3999: where import_list_header_id = p_import_list_header_id;
4000:
4001: cursor c_conc_name is
4002: SELECT concurrent_program FROM ams_imp_list_import_types
4003: where import_type = 'LEAD';
4004:
4005: cursor c_lead_process is
4006: SELECT batch_id, VALIDATE_FILE, EXECUTE_MODE FROM ams_imp_list_headers_all

Line 13685: SELECT concurrent_program FROM ams_imp_list_import_types

13681: from ams_imp_list_headers_all
13682: where import_list_header_id = p_import_list_header_id;
13683:
13684: cursor c_conc_name is
13685: SELECT concurrent_program FROM ams_imp_list_import_types
13686: where import_type = 'LEAD';
13687:
13688: cursor c_error_exist is
13689: select 'Y' from ams_list_import_errors

Line 13718: SELECT concurrent_program FROM ams_imp_list_import_types

13714: where import_list_header_id = p_import_list_header_id
13715: and load_status = G_STATUS_ERROR;
13716:
13717: cursor c_prog_name (x_imp_type varchar2) is
13718: SELECT concurrent_program FROM ams_imp_list_import_types
13719: where import_type = x_imp_type;
13720:
13721: cursor c_file_type is
13722: select file_type from ams_imp_documents where import_list_header_id = p_import_list_header_id;