DBA Data[Home] [Help]

APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on PO_VENDOR_SITES_ALL

Line 3110: FROM po_vendor_sites_all

3106: WHERE set_of_books_id = p_sob;
3107:
3108: CURSOR checking_for_packing_slip(ven_id NUMBER, ven_site_id NUMBER, v_org_id NUMBER) IS
3109: SELECT pay_on_code, pay_on_receipt_summary_code
3110: FROM po_vendor_sites_all
3111: WHERE vendor_id = ven_id
3112: AND vendor_site_id = ven_site_id
3113: AND NVL(org_id, -1) = NVL(v_org_id, -1);
3114:

Line 5389: FROM po_vendor_sites_all

5385: WHERE set_of_books_id = p_sob;
5386:
5387: CURSOR checking_for_packing_slip(ven_id NUMBER, ven_site_id NUMBER, v_org_id NUMBER) IS
5388: SELECT pay_on_code, pay_on_receipt_summary_code
5389: FROM po_vendor_sites_all
5390: WHERE vendor_id = ven_id
5391: AND vendor_site_id = ven_site_id
5392: AND NVL(org_id, 0) = NVL(v_org_id, 0);
5393: