APPS.CSI_PARTY_RELATIONSHIPS_PUB dependencies on CSI_LOOKUPS

Line 207: ,csi_lookups cl

203: ,cl.meaning --party_type
204: INTO x_party_header_tbl(i).party_number
205: ,x_party_header_tbl(i).party_type
206: FROM per_all_people_f pf
207: ,csi_lookups cl
208: ,csi_item_instances cii
209: WHERE pf.person_id = x_party_header_tbl(i).party_id
210: AND cl.lookup_type=l_pty_lookup_type
211: AND cl.lookup_code=l_party_source_tbl

Line 228: ,csi_lookups cl

224: INTO x_party_header_tbl(i).party_number
225: ,x_party_header_tbl(i).party_type
226: ,l_pty_name
227: FROM hz_parties hz
228: ,csi_lookups cl
229: ,csi_item_instances cii
230: WHERE party_id = x_party_header_tbl(i).party_id
231: AND cl.lookup_type=l_pty_lookup_type
232: AND cl.lookup_code=l_party_source_tbl

Line 251: FROM csi_lookups cl

247: SELECT po.segment1
248: ,cl.meaning --party_type
249: INTO x_party_header_tbl(i).party_number
250: ,x_party_header_tbl(i).party_type
251: FROM csi_lookups cl
252: ,csi_item_instances cii
253: ,po_vendors po
254: WHERE cl.lookup_type=l_pty_lookup_type
255: AND cl.lookup_code=l_party_source_tbl

Line 269: ,csi_lookups cl

265: ,cl.meaning --party_type
266: INTO x_party_header_tbl(i).party_number
267: ,x_party_header_tbl(i).party_type
268: FROM jtf_rs_teams_vl jt
269: ,csi_lookups cl
270: ,csi_item_instances cii
271: WHERE jt.team_id = x_party_header_tbl(i).party_id
272: and cl.lookup_type=l_pty_lookup_type
273: and cl.lookup_code=l_party_source_tbl

Line 286: ,csi_lookups cl

282: ,cl.meaning --party_type
283: INTO x_party_header_tbl(i).party_number
284: ,x_party_header_tbl(i).party_type
285: FROM jtf_rs_groups_vl jg
286: ,csi_lookups cl
287: ,csi_item_instances cii
288: WHERE jg.group_id = x_party_header_tbl(i).party_id
289: and cl.lookup_type=l_pty_lookup_type
290: and cl.lookup_code=l_party_source_tbl