APPS.JAI_AP_TDS_ETDS_PKG dependencies on PO_VENDORS

Line 3144: FROM po_vendors

3140: -- gives the Deductee code based on Vendor Classification
3141: CURSOR c_deductee_dtls(p_vendor_id IN NUMBER) IS
3142: SELECT vendor_name,
3143: decode( UPPER(organization_type_lookup_code), 'COMPANY', '01', '02')
3144: FROM po_vendors
3145: WHERE vendor_id = p_vendor_id;
3146:
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

Line 3394: v_vendor_name PO_VENDORS.vendor_name%TYPE;

3390: v_deductee_slno NUMBER; --File.Sql.35 Cbabu := 0;
3391: v_deductee_code VARCHAR2(2);
3392: v_deductee_pan VARCHAR2(20);
3393: v_stform_name VARCHAR2(25);
3394: v_vendor_name PO_VENDORS.vendor_name%TYPE;
3395: v_site_dtls c_deductee_site_dtls%ROWTYPE;
3396: v_base_inv_check_dtls c_check_dtls%ROWTYPE;
3397: v_tds_inv_check_dtls c_check_dtls%ROWTYPE;
3398: v_cert_issue_date DATE;

Line 3459: --v_vendor_name PO_VENDORS.vendor_name%TYPE;

3455: v_quart_book_ent_oth VARCHAR2(1); -- Harshita for Bug 4525089,
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