DBA Data[Home] [Help]

APPS.JAI_AP_TDS_TAX_DEFAULTATION dependencies on JAI_AP_TDS_TH_VSITE_V

Line 730: from JAI_AP_TDS_TH_VSITE_V

726: and vendor_site_id = p_vendor_site_id;
727:
728: 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
729: select 'Y'
730: from JAI_AP_TDS_TH_VSITE_V
731: where vendor_id = p_vendor_id
732: and vendor_site_id = p_vendor_site_id
733: and section_type = p_section_type--rchandan for bug#4428980
734: and section_code = p_tds_section_code;

Line 1095: from jai_ap_tds_th_vsite_v

1091:
1092: cursor c_get_threshold
1093: (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
1094: select threshold_hdr_id
1095: from jai_ap_tds_th_vsite_v
1096: where vendor_id = p_vendor_id
1097: and vendor_site_id = p_vendor_site_id
1098: and section_type = p_section_type--rchandan for bug#4428980
1099: and section_code = p_tds_section_code;