APPS.JAI_AP_TDS_TAX_DEFAULTATION dependencies on JAI_AP_TDS_THHOLD_TAXES

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

1126: )
1127: and nvl(to_amount, p_amount) >= p_amount
1128: order by from_amount asc;
1129:
1130: cursor c_jai_ap_tds_thhold_taxes(p_threshold_slab_id number, p_org_id number) is
1131: select tax_id
1132: from jai_ap_tds_thhold_taxes
1133: where threshold_slab_id = p_threshold_slab_id
1134: and operating_unit_id = p_org_id;

Line 1132: from jai_ap_tds_thhold_taxes

1128: order by from_amount asc;
1129:
1130: cursor c_jai_ap_tds_thhold_taxes(p_threshold_slab_id number, p_org_id number) is
1131: select tax_id
1132: from jai_ap_tds_thhold_taxes
1133: where threshold_slab_id = p_threshold_slab_id
1134: and operating_unit_id = p_org_id;
1135:
1136: lv_attr_code VARCHAR2(25);

Line 1184: r_jai_ap_tds_thhold_taxes c_jai_ap_tds_thhold_taxes%rowtype;

1180: and fin_year = p_fin_year;
1181:
1182: r_get_threshold c_get_threshold%rowtype;
1183: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%rowtype;
1184: r_jai_ap_tds_thhold_taxes c_jai_ap_tds_thhold_taxes%rowtype;
1185:
1186: lv_pan_no jai_ap_tds_vendor_hdrs.pan_no%type;
1187: 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
1188:

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

1304:
1305: end if; /* Cumulative or single threshold amount */
1306:
1307: /* Get the tax id attached to the slab */
1308: open c_jai_ap_tds_thhold_taxes(nvl(p_single_threshold_slab_id, p_cumulative_threshold_slab_id), p_org_id);
1309: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
1310: close c_jai_ap_tds_thhold_taxes;
1311:
1312: p_tds_tax_id := r_jai_ap_tds_thhold_taxes.tax_id;

Line 1309: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;

1305: end if; /* Cumulative or single threshold amount */
1306:
1307: /* Get the tax id attached to the slab */
1308: open c_jai_ap_tds_thhold_taxes(nvl(p_single_threshold_slab_id, p_cumulative_threshold_slab_id), p_org_id);
1309: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
1310: close c_jai_ap_tds_thhold_taxes;
1311:
1312: p_tds_tax_id := r_jai_ap_tds_thhold_taxes.tax_id;
1313:

Line 1310: close c_jai_ap_tds_thhold_taxes;

1306:
1307: /* Get the tax id attached to the slab */
1308: open c_jai_ap_tds_thhold_taxes(nvl(p_single_threshold_slab_id, p_cumulative_threshold_slab_id), p_org_id);
1309: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
1310: close c_jai_ap_tds_thhold_taxes;
1311:
1312: p_tds_tax_id := r_jai_ap_tds_thhold_taxes.tax_id;
1313:
1314: << exit_from_procedure >>

Line 1312: p_tds_tax_id := r_jai_ap_tds_thhold_taxes.tax_id;

1308: open c_jai_ap_tds_thhold_taxes(nvl(p_single_threshold_slab_id, p_cumulative_threshold_slab_id), p_org_id);
1309: fetch c_jai_ap_tds_thhold_taxes into r_jai_ap_tds_thhold_taxes;
1310: close c_jai_ap_tds_thhold_taxes;
1311:
1312: p_tds_tax_id := r_jai_ap_tds_thhold_taxes.tax_id;
1313:
1314: << exit_from_procedure >>
1315: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath, null, 'END'); /* 13 */
1316: return;