[Home] [Help]
2140:
2141:
2142: cursor c_get_fin_year(p_accounting_date date, p_org_id number) is
2143: select fin_year
2144: from JAI_AP_TDS_YEARS
2145: where tan_no in \* where clause and subquery added by ssumaith - bug# 4448789*\
2146: (
2147: SELECT attribute_value
2148: FROM JAI_RGM_ORG_REGNS_V
2160: from ap_invoice_distributions_all
2161: where invoice_distribution_id = cn_invoice_distribution_id;
2162:
2163: rec_dist_info c_get_dist_info%rowtype;
2164: lv_fin_year JAI_AP_TDS_YEARS.fin_year%type;
2165:
2166: cursor c_get_check_id(cn_invoice_id number)
2167: is
2168: select check_id
2628: --Comment by Zhiwei Hou on 20120111 begin
2629: ------------------------------------------------------------------
2630: /*cursor c_get_fin_year(p_accounting_date date, p_org_id number) is
2631: select fin_year
2632: from JAI_AP_TDS_YEARS
2633: where tan_no in \* where clause and subquery added by ssumaith - bug# 4448789*\
2634: (
2635: SELECT attribute_value
2636: FROM JAI_RGM_ORG_REGNS_V
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:
2780: ln_no_of_tds_inv_generated number := 0;
2781: lb_result boolean;
8751:
8752: /*START, Added by Bgowrava for Bug#9214036*/
8753: CURSOR c_get_rnd_factor (p_org_id IN NUMBER, p_inv_date in date ) IS
8754: SELECT nvl(tds_rounding_factor,0), tds_rounding_start_date
8755: FROM jai_ap_tds_years
8756: WHERE legal_entity_id = p_org_id
8757: AND trunc (p_inv_date) between start_date and end_date ;
8758: /*END, Added by Bgowrava for Bug#9214036*/
8759: