DBA Data[Home] [Help]

APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_TH_VSITE_V

Line 407: from JAI_AP_TDS_TH_VSITE_V

403:
404: cursor c_get_threshold
405: (p_vendor_id number, p_vendor_site_id number, p_tds_section_code varchar2,p_section_type jai_ap_tds_inv_taxes.section_type%type) IS --rchandan for bug#4428980
406: select threshold_hdr_id
407: from JAI_AP_TDS_TH_VSITE_V
408: where vendor_id = p_vendor_id
409: and vendor_site_id = p_vendor_site_id
410: and section_type = p_section_type --rchandan for bug#4428980
411: and section_code = p_tds_section_code;

Line 3337: FROM jai_ap_tds_th_vsite_v

3333: p_section_type VARCHAR2,
3334: p_section_code VARCHAR2)
3335: IS
3336: SELECT threshold_hdr_id
3337: FROM jai_ap_tds_th_vsite_v
3338: WHERE vendor_id = p_vendor_id
3339: AND tan_no = p_org_tan_num
3340: AND pan_no = p_pan_num
3341: AND section_type = p_section_type