DBA Data[Home] [Help]

APPS.PER_RI_MNG_CFG_PKG dependencies on PER_RI_CONFIG_LOCATIONS

Line 20: from per_ri_config_locations

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:

Line 87: from per_ri_config_locations loc1,per_ri_config_locations loc2

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;

Line 188: from per_ri_config_locations

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: