APPS.AMS_LISTIMPORT_PVT dependencies on AMS_IMP_LIST_IMPORT_TYPES

Line 3057: SELECT concurrent_program FROM ams_imp_list_import_types

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

Line 4001: SELECT concurrent_program FROM ams_imp_list_import_types

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

Line 13684: SELECT concurrent_program FROM ams_imp_list_import_types

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

Line 13717: SELECT concurrent_program FROM ams_imp_list_import_types

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