APPS.OZF_SD_REQUEST_PUB dependencies on AMS_CUSTOM_SETUPS_VL

Line 2152: FROM ams_custom_setups_vl

2148: FROM dual;
2149:
2150: CURSOR c_code_prefix(p_request_type_setup_id IN NUMBER) IS
2151: SELECT source_code_suffix
2152: FROM ams_custom_setups_vl
2153: WHERE custom_setup_id = p_request_type_setup_id;
2154:
2155: BEGIN
2156:

Line 2874: FROM ams_custom_setups_vl

2870:
2871: CURSOR c_request_type_setup(p_request_type_setup_id IN NUMBER)IS
2872: SELECT custom_setup_id,
2873: activity_type_code
2874: FROM ams_custom_setups_vl
2875: WHERE object_type = 'SDREQUEST'
2876: AND enabled_flag = 'Y'
2877: AND custom_setup_id = p_request_type_setup_id;
2878: