DBA Data[Home] [Help]

APPS.FTE_CAT_VALIDATE_PKG dependencies on HR_LOCATIONS_ALL

Line 94: hr_locations_all hl, hr_locations_all_tl hlt,

90: union
91: select 'Y'
92: from fte_lanes fl,
93: wsh_regions_tl wr,
94: hr_locations_all hl, hr_locations_all_tl hlt,
95: wsh_regions wrb
96: where fl.origin_id = wr.region_id
97: and wr.region_id = wrb.region_id
98: and fl.lane_id = p_lane_id

Line 131: hr_locations_all hl, hr_locations_all_tl hlt,

127: union
128: select 'Y'
129: from fte_lanes fl,
130: wsh_regions_tl wr,
131: hr_locations_all hl, hr_locations_all_tl hlt,
132: wsh_regions wrb
133: where fl.destination_id = wr.region_id
134: and wr.region_id = wrb.region_id
135: and fl.lane_id = p_lane_id

Line 167: hr_locations_all hl, hr_locations_all_tl hlt,

163: union
164: select 'Y'
165: from fte_lanes fl,
166: wsh_regions_tl wr,
167: hr_locations_all hl, hr_locations_all_tl hlt,
168: wsh_regions wrb
169: where (fl.origin_id = wr.region_id or fl.DESTINATION_ID = wr.region_id)
170: and wr.region_id = wrb.region_id
171: and fl.lane_id = p_lane_id