APPS.JAI_AP_TDS_TAX_DEFAULTATION dependencies on JAI_AP_TDS_THHOLD_TAXES

Line 1418: cursor c_jai_ap_tds_thhold_taxes(p_threshold_slab_id number, p_org_id number) is

1414: )
1415: and nvl(to_amount, p_amount) >= p_amount
1416: order by from_amount asc;
1417:
1418: cursor c_jai_ap_tds_thhold_taxes(p_threshold_slab_id number, p_org_id number) is
1419: select tax_id
1420: from jai_ap_tds_thhold_taxes
1421: where threshold_slab_id = p_threshold_slab_id
1422: and operating_unit_id = p_org_id;

Line 1420: from jai_ap_tds_thhold_taxes

1416: order by from_amount asc;
1417:
1418: cursor c_jai_ap_tds_thhold_taxes(p_threshold_slab_id number, p_org_id number) is
1419: select tax_id
1420: from jai_ap_tds_thhold_taxes
1421: where threshold_slab_id = p_threshold_slab_id
1422: and operating_unit_id = p_org_id;
1423:
1424: lv_attr_code VARCHAR2(25);

Line 1479: r_jai_ap_tds_thhold_taxes c_jai_ap_tds_thhold_taxes%rowtype;

1475: WHERE invoice_id = p_invoice_id;
1476:
1477: r_get_threshold c_get_threshold%rowtype;
1478: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%rowtype;
1479: r_jai_ap_tds_thhold_taxes c_jai_ap_tds_thhold_taxes%rowtype;
1480:
1481: lv_pan_no jai_ap_tds_vendor_hdrs.pan_no%type;
1482: lv_tan_no jai_ap_tds_org_tan_v.org_tan_num %type;--- JAI_AP_TDS_ORG_TANS is changed to view jai_ap_tds_org_tan_v 4323338
1483:

Line 1610: open c_jai_ap_tds_thhold_taxes(nvl(p_single_threshold_slab_id, p_cumulative_threshold_slab_id), p_org_id);

1606:
1607: end if; /* Cumulative or single threshold amount */
1608:
1609: /* Get the tax id attached to the slab */
1610: open c_jai_ap_tds_thhold_taxes(nvl(p_single_threshold_slab_id, p_cumulative_threshold_slab_id), p_org_id);
1611: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
1612: close c_jai_ap_tds_thhold_taxes;
1613:
1614: p_tds_tax_id := r_jai_ap_tds_thhold_taxes.tax_id;

Line 1611: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;

1607: end if; /* Cumulative or single threshold amount */
1608:
1609: /* Get the tax id attached to the slab */
1610: open c_jai_ap_tds_thhold_taxes(nvl(p_single_threshold_slab_id, p_cumulative_threshold_slab_id), p_org_id);
1611: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
1612: close c_jai_ap_tds_thhold_taxes;
1613:
1614: p_tds_tax_id := r_jai_ap_tds_thhold_taxes.tax_id;
1615:

Line 1612: close c_jai_ap_tds_thhold_taxes;

1608:
1609: /* Get the tax id attached to the slab */
1610: open c_jai_ap_tds_thhold_taxes(nvl(p_single_threshold_slab_id, p_cumulative_threshold_slab_id), p_org_id);
1611: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
1612: close c_jai_ap_tds_thhold_taxes;
1613:
1614: p_tds_tax_id := r_jai_ap_tds_thhold_taxes.tax_id;
1615:
1616: << exit_from_procedure >>

Line 1614: p_tds_tax_id := r_jai_ap_tds_thhold_taxes.tax_id;

1610: open c_jai_ap_tds_thhold_taxes(nvl(p_single_threshold_slab_id, p_cumulative_threshold_slab_id), p_org_id);
1611: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
1612: close c_jai_ap_tds_thhold_taxes;
1613:
1614: p_tds_tax_id := r_jai_ap_tds_thhold_taxes.tax_id;
1615:
1616: << exit_from_procedure >>
1617: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath, null, 'END'); /* 13 */
1618: return;