APPS.PN_LOCATION_ALIAS_PKG dependencies on PN_LOCATIONS_ALL

Line 84: FROM pn_locations_all /*sdm14jul*/

80: SELECT location_id,
81: parent_location_id,
82: location_code,
83: location_alias
84: FROM pn_locations_all /*sdm14jul*/
85: START WITH location_id = (SELECT location_id FROM
86: (SELECT location_id
87: FROM pn_locations_all
88: WHERE location_type_lookup_code = p_location_type

Line 87: FROM pn_locations_all

83: location_alias
84: FROM pn_locations_all /*sdm14jul*/
85: START WITH location_id = (SELECT location_id FROM
86: (SELECT location_id
87: FROM pn_locations_all
88: WHERE location_type_lookup_code = p_location_type
89: AND location_code = p_location_code
90: ORDER BY ACTIVE_START_DATE DESC)
91: WHERE ROWNUM = 1)

Line 153: FROM pn_locations_all

149:
150: --Bug#5571818
151: SELECT COUNT(1)
152: INTO l_uniq_loc_count
153: FROM pn_locations_all
154: WHERE location_code = l_new_loc_code
155: and location_code <> p_location_code; --Bug#16098151
156:
157: IF l_uniq_loc_count <> 0 THEN

Line 165: UPDATE pn_locations_all /*Bug 9767441 */

161:
162:
163: l_info := 'updating table with new values ';
164: FORALL i IN 0 .. loc_id_tbl.COUNT - 1
165: UPDATE pn_locations_all /*Bug 9767441 */
166: SET location_code = new_cd_tbl(i),
167: location_alias = als_nm_tbl(i),
168: last_update_date = SYSDATE,
169: last_updated_by = nvl(fnd_profile.value('USER_ID'), -1),