APPS.OKC_REP_QA_CHECK_PVT dependencies on PO_VENDOR_CONTACTS

Line 587: FROM po_vendor_contacts pvc,FND_USER f

583:
584:
585: CURSOR cur_supplier_user(p_contact_id IN number) IS
586: SELECT f.user_name ,(pvc.first_name || ' ' || pvc.middle_name || ' ' || pvc.last_name) contact_name
587: FROM po_vendor_contacts pvc,FND_USER f
588: where pvc.PER_PARTY_ID= f.person_party_id
589: AND pvc.vendor_contact_id=p_contact_id;
590:
591: CURSOR cur_cust_user(p_contact_id IN NUMBER,p_object_id IN number) IS

Line 1255: FROM po_vendor_contacts

1251:
1252: CURSOR vendor_contact_csr IS
1253: SELECT (first_name || ' ' || middle_name || ' ' || last_name) contact_name,
1254: inactive_date
1255: FROM po_vendor_contacts
1256: WHERE vendor_contact_id=p_contact_id;
1257:
1258: vendor_contact_rec vendor_contact_csr%ROWTYPE;
1259: