APPS.JAI_AP_TDS_TAX_DEFAULTATION dependencies on JAI_AP_TDS_THHOLD_GRPS

Line 1389: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is

1385: and vendor_site_id = p_vendor_site_id
1386: and section_type = p_section_type--rchandan for bug#4428980
1387: and section_code = p_tds_section_code;
1388:
1389: cursor c_jai_ap_tds_thhold_grps(p_threshold_grp_id number) is
1390: select (
1391: nvl(total_invoice_amount, 0) -
1392: nvl(total_invoice_cancel_amount, 0) -
1393: nvl(total_invoice_apply_amount, 0) +

Line 1397: from jai_ap_tds_thhold_grps

1393: nvl(total_invoice_apply_amount, 0) +
1394: nvl(total_invoice_unapply_amount, 0)
1395: )
1396: total_invoice_amount
1397: from jai_ap_tds_thhold_grps
1398: where threshold_grp_id = p_threshold_grp_id;
1399:
1400: cursor c_jai_ap_tds_thhold_slabs
1401: ( p_threshold_hdr_id number, p_threshold_type varchar2, p_amount number) is

Line 1460: (p_vendor_id number, p_tan_no varchar2, p_pan_no varchar2, p_tds_section_code varchar2 , p_fin_year number,p_section_type jai_ap_tds_thhold_grps.section_type%type) is--rchandan for bug#4428980

1456: and a.vendor_id = p_vendor_id
1457: and b.vendor_site_id = p_vendor_site_id;
1458:
1459: cursor c_get_threshold_group
1460: (p_vendor_id number, p_tan_no varchar2, p_pan_no varchar2, p_tds_section_code varchar2 , p_fin_year number,p_section_type jai_ap_tds_thhold_grps.section_type%type) is--rchandan for bug#4428980
1461: select threshold_grp_id
1462: from jai_ap_tds_thhold_grps
1463: where vendor_id = p_vendor_id
1464: and section_type = p_section_type --rchandan for bug#4428980

Line 1462: from jai_ap_tds_thhold_grps

1458:
1459: cursor c_get_threshold_group
1460: (p_vendor_id number, p_tan_no varchar2, p_pan_no varchar2, p_tds_section_code varchar2 , p_fin_year number,p_section_type jai_ap_tds_thhold_grps.section_type%type) is--rchandan for bug#4428980
1461: select threshold_grp_id
1462: from jai_ap_tds_thhold_grps
1463: where vendor_id = p_vendor_id
1464: and section_type = p_section_type --rchandan for bug#4428980
1465: and section_code = p_tds_section_code
1466: and org_tan_num = p_tan_no

Line 1552: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);

1548: /* if there is no threshold group details,
1549: it means no transaction has happened for that section and vendor combination */
1550: if ln_threshold_grp_id is not null then
1551: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1552: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1553: fetch c_jai_ap_tds_thhold_grps into ln_total_invoice_amount;
1554: close c_jai_ap_tds_thhold_grps;
1555: p_threshold_grp_id := ln_threshold_grp_id;
1556: end if;

Line 1553: fetch c_jai_ap_tds_thhold_grps into ln_total_invoice_amount;

1549: it means no transaction has happened for that section and vendor combination */
1550: if ln_threshold_grp_id is not null then
1551: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1552: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1553: fetch c_jai_ap_tds_thhold_grps into ln_total_invoice_amount;
1554: close c_jai_ap_tds_thhold_grps;
1555: p_threshold_grp_id := ln_threshold_grp_id;
1556: end if;
1557:

Line 1554: close c_jai_ap_tds_thhold_grps;

1550: if ln_threshold_grp_id is not null then
1551: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1552: open c_jai_ap_tds_thhold_grps(ln_threshold_grp_id);
1553: fetch c_jai_ap_tds_thhold_grps into ln_total_invoice_amount;
1554: close c_jai_ap_tds_thhold_grps;
1555: p_threshold_grp_id := ln_threshold_grp_id;
1556: end if;
1557:
1558: ln_total_invoice_amount := nvl(ln_total_invoice_amount, 0 ) ;