[Home] [Help]
123:
124:
125: /*Start Additions by mmurtuza for bug 13620923*/
126: cursor c_chk_tds_deducted(cp_invoice_id number) is
127: select count(1) from jai_ap_tds_thhold_trxs
128: where invoice_id = cp_invoice_id
129: and tds_event = 'INVOICE VALIDATE';
130:
131: ln_cnt_thrshold number := 0;
456: * prepayment unapplication
457: */
458: invoice_id,
459: tax_id
460: from jai_ap_tds_thhold_trxs
461: where threshold_trx_id = p_threshold_trx_id;
462: --Added by Wenqiong for bug13359892 begin
463: CURSOR c_get_tax_cat_section_code (p_invoice_distribution_id NUMBER) IS
464: SELECT tt.tax_category_id, tt.actual_section_code
493: ln_after_threshold_slab_id jai_ap_tds_thhold_slabs.threshold_slab_id%TYPE;
494: lv_after_threshold_type jai_ap_tds_thhold_types.threshold_type%TYPE;
495: ln_temp_threshold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
496: ln_temp_threshold_hdr_id jai_ap_tds_thhold_hdrs.threshold_hdr_id%TYPE;
497: lv_slab_transition_tds_event jai_ap_tds_thhold_trxs.tds_event%type;
498: lv_ppu_tds_inv_num ap_invoices_all.invoice_num%type;
499: lv_ppu_tds_cm_num ap_invoices_all.invoice_num%type;
500: /*Bug 5751783 - End*/
501: -- Bug 6031679. Added by Lakshmi Gopalsami
728: END IF; --n_threshold_trx_id IS NULL
729: ----------------------------------------------------------------------
730: --Added by Chong for bug#16414088 eTDS ER End
731:
732: /*Bug 9132694 - Only one Unapplication entry would be created in jai_ap_tds_thhold_trxs for one unapplication*/
733:
734: /* Bug 5751783
735: * Call to procedure - get_tds_threshold_slab,
736: * Store the current Threshold slab and type
1217: FROM jai_ap_tds_inv_taxes
1218: WHERE invoice_id = p_pre_pay_inv_id
1219: AND invoice_distribution_id = p_invoice_distribution_id ;
1220:
1221: lv_si_thhold_trx_id jai_ap_tds_thhold_trxs.threshold_trx_id%TYPE;
1222: lv_pp_thhold_trx_id jai_ap_tds_thhold_trxs.threshold_trx_id%TYPE;
1223: \* Bug 5751783 - End*\
1224:
1225: lv_applicable_flag varchar2(1);
1218: WHERE invoice_id = p_pre_pay_inv_id
1219: AND invoice_distribution_id = p_invoice_distribution_id ;
1220:
1221: lv_si_thhold_trx_id jai_ap_tds_thhold_trxs.threshold_trx_id%TYPE;
1222: lv_pp_thhold_trx_id jai_ap_tds_thhold_trxs.threshold_trx_id%TYPE;
1223: \* Bug 5751783 - End*\
1224:
1225: lv_applicable_flag varchar2(1);
1226: lv_is_si_validated_flag varchar2(1);
1547: \*Fetch the taxable amount for which TDS is generated*\
1548: CURSOR c_taxable_amount(p_invoice_id NUMBER)
1549: IS
1550: SELECT nvl(sum(taxable_amount), 0)
1551: FROM jai_ap_tds_thhold_trxs
1552: WHERE invoice_id = p_invoice_id
1553: AND tds_event = 'INVOICE VALIDATE'
1554: group by invoice_id;
1555:
1915: FOR get_si_det IN (SELECT jattt.*,
1916: jatp.tds_prepayment_id tds_prepayment_id,
1917: jatp.application_amount tds_taxable_basis,
1918: jatp.invoice_distribution_id tax_dist
1919: FROM jai_ap_tds_thhold_trxs jattt,
1920: jai_ap_tds_prepayments jatp
1921: WHERE jattt.invoice_id = jatp.invoice_id
1922: AND jattt.tds_event = 'INVOICE VALIDATE'
1923: AND jatp.tds_applicable_flag ='Y'
3163: /*Fetch the taxable amount for which TDS is generated*/
3164: CURSOR c_taxable_amount(p_invoice_id NUMBER)
3165: IS
3166: SELECT nvl(sum(taxable_amount), 0)
3167: FROM jai_ap_tds_thhold_trxs
3168: WHERE invoice_id = p_invoice_id
3169: AND tds_event = 'INVOICE VALIDATE'
3170: group by invoice_id;
3171:
3480: FOR get_si_det IN (SELECT jattt.*,
3481: jatp.tds_prepayment_id tds_prepayment_id,
3482: jatp.application_amount * nvl(p_exchange_rate,1) tds_taxable_basis,
3483: jatp.invoice_distribution_id tax_dist
3484: FROM jai_ap_tds_thhold_trxs jattt,
3485: jai_ap_tds_prepayments jatp
3486: WHERE jattt.invoice_id = jatp.invoice_id
3487: AND (jattt.tds_event = 'INVOICE VALIDATE'
3488: OR jattt.tds_event LIKE 'THRESHOLD TRANSITION(%' --Added threshold transition by Chong for issue120920-66 2012/10/09