APPS.JAI_AP_TDS_ETDS_PKG dependencies on PO_VENDORS

Line 5081: FROM po_vendors

5077: -- gives the Deductee code based on Vendor Classification
5078: CURSOR c_deductee_dtls(p_vendor_id IN NUMBER) IS
5079: SELECT vendor_name,
5080: decode( UPPER(organization_type_lookup_code), 'COMPANY', '01', '02')
5081: FROM po_vendors
5082: WHERE vendor_id = p_vendor_id;
5083:
5084: -- gives the Deductee code based on Vendor Classification
5085: CURSOR c_deductee_site_dtls(p_vendor_id IN NUMBER, p_vendor_site_id IN NUMBER) IS

Line 5608: v_vendor_name PO_VENDORS.vendor_name%TYPE;

5604: v_deductee_code VARCHAR2(2);
5605: v_deductee_pan VARCHAR2(20);
5606: v_confirm_pan_flag VARCHAR2(1);/*ETDS FVU3.1 Bug 11896260 */
5607: v_stform_name VARCHAR2(25);
5608: v_vendor_name PO_VENDORS.vendor_name%TYPE;
5609: v_base_gl_date ap_invoices_all.gl_date%TYPE;/*Bug 10188600*/
5610: v_site_dtls c_deductee_site_dtls%ROWTYPE;
5611: v_base_inv_check_dtls c_check_dtls%ROWTYPE;
5612: v_tds_inv_check_dtls c_check_dtls%ROWTYPE;

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

5670: v_quart_book_ent_oth VARCHAR2(1); -- Harshita for Bug 4525089,
5671: ln_amt_of_oth number(14);
5672:
5673: -- used variables
5674: --v_vendor_name PO_VENDORS.vendor_name%TYPE;
5675: v_vendor_site_code PO_VENDOR_SITES_ALL.vendor_site_code%TYPE;
5676: v_error_message VARCHAR2(100);
5677: v_conc_request_id NUMBER(15); -- := FND_PROFILE.value('CONC_REQUEST_ID'); File.Sql.35 by Brathod
5678: v_statement_id VARCHAR2(3) ; --:= '0'; File.Sql.35 by Brathod