DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PKG dependencies on PO_VENDOR_SITES_ALL

Line 667: FROM po_vendor_sites_all

663: WHERE set_of_books_id = p_sob;
664:
665: CURSOR checking_for_packing_slip(ven_id NUMBER, ven_site_id NUMBER, v_org_id NUMBER) IS
666: SELECT pay_on_code, pay_on_receipt_summary_code
667: FROM po_vendor_sites_all
668: WHERE vendor_id = ven_id
669: AND vendor_site_id = ven_site_id
670: AND NVL(org_id, -1) = NVL(v_org_id, -1);
671:

Line 7240: FROM po_vendor_sites_all

7236: WHERE set_of_books_id = p_sob;
7237:
7238: CURSOR checking_for_packing_slip(ven_id NUMBER, ven_site_id NUMBER, v_org_id NUMBER) IS
7239: SELECT pay_on_code, pay_on_receipt_summary_code
7240: FROM po_vendor_sites_all
7241: WHERE vendor_id = ven_id
7242: AND vendor_site_id = ven_site_id
7243: AND NVL(org_id, 0) = NVL(v_org_id, 0);
7244: