APPS.CSI_PARTY_RELATIONSHIPS_PUB dependencies on PO_VENDORS

Line 245: ELSIF l_party_source_tbl = 'PO_VENDORS' THEN

241: EXCEPTION
242: WHEN OTHERS THEN
243: NULL;
244: END;
245: ELSIF l_party_source_tbl = 'PO_VENDORS' THEN
246: BEGIN
247: SELECT po.segment1
248: ,cl.meaning --party_type
249: INTO x_party_header_tbl(i).party_number

Line 253: ,po_vendors po

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
256: AND cii.instance_id=x_party_header_tbl(i).instance_id
257: AND po.vendor_id = x_party_header_tbl(i).party_id;

Line 1259: AND (p_party_tbl(p_row).party_source_table IN ('EMPLOYEE', 'PO_VENDORS')))

1255: IF l_old_party_tbl(l_row).instance_party_id = p_party_tbl(p_row).instance_party_id
1256: AND l_old_party_tbl(l_row).party_id <> l_internal_party_id
1257: AND p_party_tbl(p_row).party_id = l_internal_party_id
1258: OR ((l_old_party_tbl(l_row).instance_party_id = p_party_tbl(p_row).instance_party_id)
1259: AND (p_party_tbl(p_row).party_source_table IN ('EMPLOYEE', 'PO_VENDORS')))
1260: THEN
1261: -- Adding for bug 3294748
1262: -- Wrote the following code to expire all non-owner parties and its contacts (if any)
1263: -- in the case of ownership transfer from external-to-internal party,