APPS.EDW_GEOGRAPHY_PKG dependencies on EDW_LOCAL_INSTANCE

Line 20: from edw_local_instance;

16: IF (p_instance_code is NOT NULL) then
17: l_instance := p_instance_code;
18: ELSE
19: select instance_code into l_instance
20: from edw_local_instance;
21: END IF;
22:
23: l_location := p_location_id || '-' || l_instance
24: || '-' || 'HR_LOC';

Line 91: from edw_local_instance;

87:
88: ELSE
89:
90: select instance_code into l_instance
91: from edw_local_instance;
92:
93: END IF;
94:
95: select party_site_id into l_party_site_id

Line 135: from edw_local_instance;

131: IF (p_instance_code is NOT NULL) then
132: l_instance := p_instance_code;
133: ELSE
134: select instance_code into l_instance
135: from edw_local_instance;
136: END IF;
137:
138: l_location := p_vendor_site_id || '-' || p_org_id
139: || '-' || l_instance

Line 170: from edw_local_instance;

166: IF (p_instance_code is NOT NULL) then
167: l_instance := p_instance_code;
168: ELSE
169: select instance_code into l_instance
170: from edw_local_instance;
171: END IF;
172:
173: l_location := p_party_site_id || '-' || l_instance
174: || '-' || 'PARTY_SITE';