DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PKG dependencies on PO_VENDOR_SITES_ALL

Line 507: FROM po_vendor_sites_all

503: WHERE set_of_books_id = p_sob;
504:
505: CURSOR checking_for_packing_slip(ven_id NUMBER, ven_site_id NUMBER, v_org_id NUMBER) IS
506: SELECT pay_on_code, pay_on_receipt_summary_code
507: FROM po_vendor_sites_all
508: WHERE vendor_id = ven_id
509: AND vendor_site_id = ven_site_id
510: AND NVL(org_id, -1) = NVL(v_org_id, -1);
511:

Line 5691: FROM po_vendor_sites_all

5687: WHERE set_of_books_id = p_sob;
5688:
5689: CURSOR checking_for_packing_slip(ven_id NUMBER, ven_site_id NUMBER, v_org_id NUMBER) IS
5690: SELECT pay_on_code, pay_on_receipt_summary_code
5691: FROM po_vendor_sites_all
5692: WHERE vendor_id = ven_id
5693: AND vendor_site_id = ven_site_id
5694: AND NVL(org_id, 0) = NVL(v_org_id, 0);
5695: