APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on PO_VENDORS

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

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

Line 246: ELSIF p_party_source_table = 'PO_VENDORS' THEN

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

Line 255: FROM po_vendors

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