APPS.CN_PAYRUN_PVT dependencies on PO_VENDOR_SITES

Line 1466: po_vendor_sites pvs,

1462: pvc.vendor_site_id supplier_site_id,
1463: currency_code
1464: FROM cn_salesreps cns,
1465: cn_payment_worksheets cnpw,
1466: po_vendor_sites pvs,
1467: po_vendor_contacts pvc
1468: WHERE cnpw.payrun_id = p_payrun_id
1469: AND cnpw.org_id=cns.org_id
1470: AND cnpw.salesrep_id = cns.salesrep_id

Line 1497: po_vendor_sites pvs,

1493: CURSOR get_vendors(p_source_id IN cn_payment_transactions.credited_salesrep_id%TYPE) IS
1494: SELECT pvs.vendor_id supplier_id,
1495: pvc.vendor_site_id supplier_site_id
1496: FROM
1497: po_vendor_sites pvs,
1498: po_vendor_contacts pvc
1499: WHERE
1500: pvc.vendor_site_id = pvs.vendor_site_id
1501: AND pvc.vendor_contact_id = p_source_id;

Line 1535: l_supplier_id po_vendor_sites.vendor_id%TYPE;

1531: l_functional_currency gl_sets_of_books.currency_code%TYPE;
1532:
1533: l_lookup_type VARCHAR2(30) := 'STANDARD';
1534: l_org_id number;
1535: l_supplier_id po_vendor_sites.vendor_id%TYPE;
1536: l_supplier_site_id po_vendor_sites.vendor_site_id%TYPE;
1537:
1538: BEGIN
1539:

Line 1536: l_supplier_site_id po_vendor_sites.vendor_site_id%TYPE;

1532:
1533: l_lookup_type VARCHAR2(30) := 'STANDARD';
1534: l_org_id number;
1535: l_supplier_id po_vendor_sites.vendor_id%TYPE;
1536: l_supplier_site_id po_vendor_sites.vendor_site_id%TYPE;
1537:
1538: BEGIN
1539:
1540: --