APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on PO_VENDORS

Line 223: /* po_vendors , employee depending on party_source_table */

219:
220: /*-----------------------------------------------------------*/
221: /* Procedure name: Is_Party_Valid */
222: /* Description : Check if the Party Id exists in hz_parties */
223: /* po_vendors , employee depending on party_source_table */
224: /* value */
225: /*-----------------------------------------------------------*/
226:
227: FUNCTION Is_Party_Valid

Line 244: ELSIF p_party_source_table = 'PO_VENDORS' THEN

240: INTO l_dummy
241: FROM hz_parties
242: WHERE party_id = p_party_id;
243:
244: ELSIF p_party_source_table = 'PO_VENDORS' THEN
245: IF p_contact_flag = 'Y' THEN
246: SELECT 'x'
247: INTO l_dummy
248: FROM po_vendor_contacts

Line 253: FROM po_vendors

249: WHERE vendor_contact_id = p_party_id;
250: ELSE
251: SELECT 'x'
252: INTO l_dummy
253: FROM po_vendors
254: WHERE vendor_id = p_party_id
255: AND ((end_date_active is null) OR (end_date_active >= sysdate));
256: END IF;
257: