16: where CONFIGURATION_CODE = p_config_code;
17:
18: cursor csr_config_loc is
19: select location_id , OBJECT_VERSION_NUMBER
20: from per_ri_config_locations
21: where CONFIGURATION_CODE = p_config_code;
22:
23: begin
24:
83:
84: cursor csr_get_locid (p_location_id number, p_configuration_code varchar2)
85: is
86: select loc2.location_id
87: from per_ri_config_locations loc1,per_ri_config_locations loc2
88: where loc2.CONFIGURATION_CODE = p_configuration_code
89: and loc1.location_id = p_location_id
90: and loc2.location_code = loc1.location_code
91: and loc1.location_id <> loc2.location_id;
184: LAST_UPDATED_BY ,
185: LAST_UPDATE_LOGIN ,
186: CREATED_BY ,
187: CREATION_DATE
188: from per_ri_config_locations
189: where CONFIGURATION_CODE = p_config_code;
190:
191:
192: