DBA Data[Home] [Help]

APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_AP_TDS_TH_VSITE_V

Line 863: from JAI_AP_TDS_TH_VSITE_V

859:
860: cursor c_get_threshold
861: (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
862: select threshold_hdr_id
863: from JAI_AP_TDS_TH_VSITE_V
864: where vendor_id = p_vendor_id
865: and vendor_site_id = p_vendor_site_id
866: and section_type = p_section_type --rchandan for bug#4428980
867: and section_code = p_tds_section_code;

Line 2831: from JAI_AP_TDS_TH_VSITE_V

2827: where invoice_id=cp_invoice_id;
2828:
2829: cursor c_get_threshold(p_vendor_id number, p_vendor_site_id number, p_tds_section_code varchar2) is
2830: select threshold_hdr_id
2831: from JAI_AP_TDS_TH_VSITE_V
2832: where vendor_id = p_vendor_id
2833: and vendor_site_id = p_vendor_site_id
2834: and section_type = 'TDS_SECTION'
2835: and section_code = p_tds_section_code;

Line 4582: FROM jai_ap_tds_th_vsite_v

4578: p_section_type VARCHAR2,
4579: p_section_code VARCHAR2)
4580: IS
4581: SELECT threshold_hdr_id
4582: FROM jai_ap_tds_th_vsite_v
4583: WHERE vendor_id = p_vendor_id
4584: AND tan_no = p_org_tan_num
4585: AND pan_no = p_pan_num
4586: AND section_type = p_section_type