DBA Data[Home] [Help]

APPS.FTE_CAT_VALIDATE_PKG dependencies on HZ_LOCATIONS

Line 79: hz_locations hl,

75: cursor c_origin_exists_cursor is
76: select 'Y'
77: from fte_lanes fl,
78: wsh_regions_tl wr,
79: hz_locations hl,
80: wsh_regions wrb
81: where fl.origin_id = wr.region_id
82: and wr.region_id = wrb.region_id
83: and fl.lane_id = p_lane_id

Line 116: hz_locations hl,

112: cursor c_dest_exists_cursor is
113: select 'Y'
114: from fte_lanes fl,
115: wsh_regions_tl wr,
116: hz_locations hl,
117: wsh_regions wrb
118: where fl.destination_id = wr.region_id
119: and wr.region_id = wrb.region_id
120: and fl.lane_id = p_lane_id

Line 152: hz_locations hl,

148: cursor c_any_exists_cursor is
149: select 'Y'
150: from fte_lanes fl,
151: wsh_regions_tl wr,
152: hz_locations hl,
153: wsh_regions wrb
154: where fl.destination_id = wr.region_id
155: and wr.region_id = wrb.region_id
156: and fl.lane_id = p_lane_id