APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_CMN_TAXES_ALL

Line 98: p_tax_type_code JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ,

94:
95: /*csahoo for bug#5879769...end*/
96:
97: procedure get_regime_info ( p_regime_code JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE ,
98: p_tax_type_code JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ,
99: p_regime_id OUT NOCOPY JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
100: p_error_flag OUT NOCOPY VARCHAR2 ,
101: p_error_message OUT NOCOPY VARCHAR2
102: )

Line 137: CURSOR c_chk_service_tax ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ,

133: /*
134: || Check whether a tax type exists in the regime registrations table for the
135: || tax types attached to a invoice tax line.
136: */
137: CURSOR c_chk_service_tax ( cp_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE ,
138: cp_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE
139: )
140: IS
141: SELECT

Line 504: JAI_CMN_TAXES_ALL jtc

500: JAI_AR_TRXS jtrx ,
501: ra_cust_trx_types_all trx_types ,
502: JAI_AR_TRX_LINES jtrxl ,
503: JAI_AR_TRX_TAX_LINES jtrxtl ,
504: JAI_CMN_TAXES_ALL jtc
505: WHERE
506: trx.org_id = nvl(p_org_id,trx.org_id) AND
507: trx.complete_flag ='Y' AND
508: trx.customer_trx_id = jtrx.customer_trx_id AND

Line 1291: , jai_cmn_taxes_all tax

1287: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt
1288: FROM
1289: JAI_AR_TRX_LINES jrtl
1290: , JAI_AR_TRX_TAX_LINES jrttl
1291: , jai_cmn_taxes_all tax
1292: WHERE jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id
1293: AND jrtl.customer_trx_id = pn_cm_customer_trx_id
1294: AND jrttl.tax_id = tax.tax_id
1295: AND NVL(tax.inclusive_tax_flag,'N') = 'Y' ;

Line 1981: , jai_cmn_taxes_all tax

1977: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt
1978: FROM
1979: JAI_AR_TRX_LINES jrtl
1980: , JAI_AR_TRX_TAX_LINES jrttl
1981: , jai_cmn_taxes_all tax
1982: WHERE jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id
1983: AND jrtl.customer_trx_id = pn_inv_customer_trx_id
1984: AND jrttl.tax_id = tax.tax_id
1985: AND NVL(tax.inclusive_tax_flag,'N') = 'Y' ;