APPS.FTE_CAT_VALIDATE_PKG dependencies on FTE_LANES

Line 77: from fte_lanes fl,

73:
74:
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

Line 92: from fte_lanes fl,

88: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
89: and nvl(wrb.state_code,'XX') = nvl(hl.state,wrb.state_code)
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

Line 114: from fte_lanes fl,

110:
111:
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

Line 129: from fte_lanes fl,

125: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
126: and nvl(wrb.state_code,'XX') = nvl(hl.state,wrb.state_code)
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

Line 150: from fte_lanes fl,

146:
147:
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

Line 165: from fte_lanes fl,

161: and nvl(wr.postal_code_to,'99') <= decode(wr.postal_code_to, NULL, '99',nvl(hl.postal_code,wr.postal_code_to))
162: and nvl(wrb.state_code,'XX') = nvl(hl.state,wrb.state_code)
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)