APPS.JAI_AP_TDS_ETDS_PKG dependencies on PO_VENDOR_SITES_ALL

Line 3151: FROM po_vendor_sites_all

3147: -- gives the Deductee code based on Vendor Classification
3148: CURSOR c_deductee_site_dtls(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER) IS
3149: SELECT address_line1 addr1, address_line2 addr2, address_line3 addr3, address_line4 addr4, city,
3150: UPPER(state) state, REPLACE(zip,' ') zip --Removed to_number for Bug 6281440
3151: FROM po_vendor_sites_all
3152: WHERE vendor_id = p_vendor_id
3153: AND vendor_site_id = p_vendor_site_id;
3154:
3155: v_deductee_state_code NUMBER;

Line 3460: v_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;

3456: ln_amt_of_oth number(14);
3457:
3458: -- used variables
3459: --v_vendor_name PO_VENDORS.vendor_name%TYPE;
3460: v_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
3461: v_error_message VARCHAR2(100);
3462: v_conc_request_id NUMBER(15); -- := FND_PROFILE.value('CONC_REQUEST_ID'); File.Sql.35 by Brathod
3463: v_statement_id VARCHAR2(3) ; --:= '0'; File.Sql.35 by Brathod
3464: