DBA Data[Home] [Help]

APPS.JAI_AP_TDS_PREPAYMENTS_PKG dependencies on JAI_CMN_TAXES_ALL

Line 1423: from JAI_CMN_TAXES_ALL

1419:
1420:
1421: cursor c_ja_in_tax_codes(p_tax_id number) is
1422: select nvl(tax_rate, 0) tax_rate
1423: from JAI_CMN_TAXES_ALL
1424: where tax_id = p_tax_id;
1425:
1426: --Add parameter p_pre_pay_inv_id in cursor c_get_prepayment_throup by Jia for FP bug6929483, Begin
1427: cursor c_get_prepayment_thgroup(p_pre_pay_inv_id number, p_prepay_distribution_id number,cp_section_type jai_ap_tds_inv_taxes.section_type%type) IS --rchandan for bug#4428980

Line 1605: ln_tax_rate_basis JAI_CMN_TAXES_ALL.tax_rate%TYPE ;

1601: ln_pp_section_invoice_id NUMBER ;
1602: /*Bug 5751783 - End*/
1603: /*Bug 6363056 - Start*/
1604: r_ja_in_tax_codes_prepay c_ja_in_tax_codes%rowtype;
1605: ln_tax_rate_basis JAI_CMN_TAXES_ALL.tax_rate%TYPE ;
1606: ln_si_wct_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1607: ln_si_essi_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1608: ln_si_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1609: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;

Line 1606: ln_si_wct_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;

1602: /*Bug 5751783 - End*/
1603: /*Bug 6363056 - Start*/
1604: r_ja_in_tax_codes_prepay c_ja_in_tax_codes%rowtype;
1605: ln_tax_rate_basis JAI_CMN_TAXES_ALL.tax_rate%TYPE ;
1606: ln_si_wct_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1607: ln_si_essi_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1608: ln_si_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1609: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1610: ln_parent_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;

Line 1607: ln_si_essi_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;

1603: /*Bug 6363056 - Start*/
1604: r_ja_in_tax_codes_prepay c_ja_in_tax_codes%rowtype;
1605: ln_tax_rate_basis JAI_CMN_TAXES_ALL.tax_rate%TYPE ;
1606: ln_si_wct_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1607: ln_si_essi_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1608: ln_si_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1609: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1610: ln_parent_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1611: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;

Line 1610: ln_parent_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;

1606: ln_si_wct_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1607: ln_si_essi_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1608: ln_si_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1609: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
1610: ln_parent_tax_id JAI_CMN_TAXES_ALL.tax_id%TYPE ;
1611: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
1612: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1613: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1614: /*Bug 6363056 - End*/