DBA Data[Home] [Help]

APPS.JAI_AP_TDS_TAX_DEFAULTATION dependencies on JAI_AP_TDS_TH_VSITE_V

Line 783: from JAI_AP_TDS_TH_VSITE_V

779: and vendor_site_id = p_vendor_site_id;
780:
781: cursor c_check_section_applicable(p_vendor_id number, p_vendor_site_id number, p_tds_section_code varchar2,p_section_type JAI_CMN_TAXES_ALL.section_type%type) is--rchandan for bug#4428980
782: select 'Y'
783: from JAI_AP_TDS_TH_VSITE_V
784: where vendor_id = p_vendor_id
785: and vendor_site_id = p_vendor_site_id
786: and section_type = p_section_type--rchandan for bug#4428980
787: and section_code = p_tds_section_code;

Line 1383: from jai_ap_tds_th_vsite_v

1379:
1380: cursor c_get_threshold
1381: (p_vendor_id number, p_vendor_site_id number, p_tds_section_code varchar2,p_section_type jai_cmn_taxes_all.section_type%type) is--rchandan for bug#4428980
1382: select threshold_hdr_id
1383: from jai_ap_tds_th_vsite_v
1384: where vendor_id = p_vendor_id
1385: and vendor_site_id = p_vendor_site_id
1386: and section_type = p_section_type--rchandan for bug#4428980
1387: and section_code = p_tds_section_code;