[Home] [Help]
212: and tax.actual_section_code not in
213: (
214:
215: select section_code
216: from JAI_AP_TDS_VENDOR_HDRS
217: where vendor_id = tax.vendor_id
218: and vendor_site_id = tax.vendor_site_id
219: )
220: and tax.threshold_transition is null
1587: --added by Chong for bug#16580553 20130402 Begin
1588: -------------------------------------------------------------
1589: -- cursor to validate accounting date for every threshold type
1590: -- cursor to validate accounting date for every threshold type
1591: cursor c_get_threshold_normal (cp_vendor_tlc JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE,
1592: cp_sec_code varchar2)
1593: is
1594: SELECT threshold_hdr_id
1595: FROM JAI_AP_TDS_TH_VSITE_V JATVV
1609: cursor c_po_vendors(p_vendor_id number) is
1610: select tds_vendor_type_lookup_code
1611: from JAI_AP_TDS_VNDR_TYPE_V
1612: where vendor_id = p_vendor_id;
1613: lv_vendor_type_lookup_code JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE;
1614: lv_valid_flg VARCHAR2(1);
1615: l_api_name CONSTANT VARCHAR2(50) := 'get_threshold_hdr()';
1616: -------------------------------------------------------------
1617: --added by Chong for bug#16580553 20130402 End
2561: -- (actual_tax_id is NOT NULL) --added by Xiao for Bug#7154864
2562: /*FP of QA Bug 12431997 - Included in 11896260 - Tax to be deducted irrespective of Threshold if PAN is not available*/
2563: OR
2564: EXISTS (SELECT 1
2565: FROM jai_ap_tds_vendor_hdrs
2566: WHERE (pan_no IN ('PANAPPLIED','PANNOTAVBL','PANINVALID')
2567: OR (pan_no IS NOT NULL AND confirm_pan_flag IS NULL))
2568: AND vendor_site_id = 0
2569: AND vendor_id = (SELECT vendor_id
2580: d.org_tan_num tan_no,
2581: c.confirm_pan_flag confirm_pan_flag /*Fixing QA Bug 12431997 - Included in 11896260*/
2582: from po_vendors a,
2583: po_vendor_sites_all b,
2584: JAI_AP_TDS_VENDOR_HDRS c,
2585: jai_ap_tds_org_tan_v d --rchandan for bug#4323338
2586: where a.vendor_id = b.vendor_id
2587: and b.vendor_id = c.vendor_id
2588: and b.vendor_site_id = c.vendor_site_id
2769: ln_threshold_trx_id number;
2770: lv_tds_invoice_num ap_invoices_all.invoice_num%type;
2771: lv_tds_cm_num ap_invoices_all.invoice_num%type;
2772:
2773: lv_pan_no JAI_AP_TDS_VENDOR_HDRS.pan_no%type;
2774: lv_tan_no jai_ap_tds_org_tan_v.org_tan_num %type; --rchandan for bug#4323338
2775: lv_confirm_pan_flag JAI_AP_TDS_VENDOR_HDRS.confirm_pan_flag%type; /*Bug 11896260*/
2776: ln_exchange_rate number;
2777: ln_fin_year JAI_AP_TDS_YEARS.fin_year%type;
2771: lv_tds_cm_num ap_invoices_all.invoice_num%type;
2772:
2773: lv_pan_no JAI_AP_TDS_VENDOR_HDRS.pan_no%type;
2774: lv_tan_no jai_ap_tds_org_tan_v.org_tan_num %type; --rchandan for bug#4323338
2775: lv_confirm_pan_flag JAI_AP_TDS_VENDOR_HDRS.confirm_pan_flag%type; /*Bug 11896260*/
2776: ln_exchange_rate number;
2777: ln_fin_year JAI_AP_TDS_YEARS.fin_year%type;
2778: lv_slab_transition_tds_event jai_ap_tds_thhold_trxs.tds_event%type;
2779:
2986: --commented by Chong for bug#16580553 20130402 End*/
2987: --added by Chong for bug#16580553 20130402 Begin
2988: -------------------------------------------------------------
2989: -- cursor to validate accounting date for every threshold type
2990: cursor c_get_threshold_normal (cp_vendor_tlc JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE,
2991: cp_sec_code varchar2)
2992: is
2993: SELECT threshold_hdr_id
2994: FROM JAI_AP_TDS_TH_VSITE_V JATVV
3139: CURSOR c_get_vendor_classification (cv_vendor_id VARCHAR2
3140: ,cv_vendor_site_id VARCHAR2
3141: ) IS
3142: SELECT jatvh.tds_vendor_classification
3143: FROM jai_ap_tds_vendor_hdrs jatvh
3144: WHERE jatvh.vendor_id = cv_vendor_id
3145: AND jatvh.vendor_site_id = cv_vendor_site_id
3146: ;
3147: