eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_OM_RG_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 823: FROM JAI_AR_TRX_TAX_LINES jrctl ,

819: This was done because if there is no cess amount, there is no need to call the insert row procedure
820: */
821: CURSOR c_tax_type_rec IS
822: SELECT jtc.tax_type , sum(jrctl.func_tax_amount) tax_amount
823: FROM JAI_AR_TRX_TAX_LINES jrctl ,
824: JAI_CMN_TAXES_ALL jtc
825: WHERE jtc.tax_id = jrctl.tax_id
826: AND link_to_cust_trx_line_id = p_customer_trx_id -- added, aiyer for Bug 4541303 /*Bug 5989740 bduvarag*/
827: AND (( upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS) and p_cess_type = 'EXC')

Line 938: Based on the customer_trx_line_id , pick up the customer_trx_id , organization id and get the taxes from JAI_AR_TRX_TAX_LINES

934: p_source_name := 'Receivables India'
935: p_category_name := 'RG Register Data Entry'
936: p_transaction_hdr_id := customer_trx_line_id from JAI_AR_TRX_LINES table
937:
938: Based on the customer_trx_line_id , pick up the customer_trx_id , organization id and get the taxes from JAI_AR_TRX_TAX_LINES
939:
940: */
941: if p_source_type = 2 then
942: ln_customer_trx_id := p_transaction_hdr_id;

Line 4005: from JAI_AR_TRX_TAX_LINES jrctl ,

4001:
4002:
4003: cursor c_get_ar_cess_amount(cp_customer_trx_id number) is
4004: select nvl(sum(jrctl.func_tax_amount),0) tax_amount
4005: from JAI_AR_TRX_TAX_LINES jrctl ,
4006: JAI_CMN_TAXES_ALL jtc
4007: where jtc.tax_id = jrctl.tax_id
4008: and link_to_cust_trx_line_id in
4009: (select customer_trx_line_id

Line 4017: from JAI_AR_TRX_TAX_LINES jrctl ,

4013: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS) ;
4014: /*Bug 5989740 bduvarag*/
4015: cursor c_get_ar_sh_cess_amount(cp_customer_trx_id number) is
4016: select nvl(sum(jrctl.func_tax_amount),0) tax_amount
4017: from JAI_AR_TRX_TAX_LINES jrctl ,
4018: JAI_CMN_TAXES_ALL jtc
4019: where jtc.tax_id = jrctl.tax_id
4020: and link_to_cust_trx_line_id in
4021: (select customer_trx_line_id

Line 4029: from JAI_AR_TRX_TAX_LINES jrctl ,

4025: and upper(jtc.tax_type) in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess) ;
4026:
4027: cursor c_ar_cess_ctr(cp_customer_trx_id number) is
4028: select count(1)
4029: from JAI_AR_TRX_TAX_LINES jrctl ,
4030: JAI_CMN_TAXES_ALL jtc
4031: where jtc.tax_id = jrctl.tax_id
4032: and link_to_cust_trx_line_id in
4033: (select customer_trx_line_id

Line 4041: from JAI_AR_TRX_TAX_LINES jrctl ,

4037: and upper(jtc.tax_type) in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS) ;
4038: /*Bug 5989740 bduvarag*/
4039: cursor c_ar_sh_cess_ctr(cp_customer_trx_id number) is
4040: select count(1)
4041: from JAI_AR_TRX_TAX_LINES jrctl ,
4042: JAI_CMN_TAXES_ALL jtc
4043: where jtc.tax_id = jrctl.tax_id
4044: and link_to_cust_trx_line_id in
4045: (select customer_trx_line_id

Line 4138: from JAI_AR_TRX_TAX_LINES jrctl ,

4134: jrctl.precedence_7,
4135: jrctl.precedence_8,
4136: jrctl.precedence_9,
4137: jrctl.precedence_10
4138: from JAI_AR_TRX_TAX_LINES jrctl ,
4139: JAI_CMN_TAXES_ALL jtc
4140: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4141: and jtc.tax_id = jrctl.tax_id
4142: and jtc.tax_type in (jai_constants.TAX_TYPE_CVD_EDU_CESS,jai_constants.TAX_TYPE_EXC_EDU_CESS)

Line 4152: from JAI_AR_TRX_TAX_LINES

4148: decode(tax_amount, 0,
4149: (base_tax_amount * ( tax_rate / 100) )
4150: , tax_amount
4151: ) cess_amt
4152: from JAI_AR_TRX_TAX_LINES
4153: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4154: and tax_line_no in
4155: (cess_rec.precedence_1,
4156: cess_rec.precedence_2,

Line 4203: from JAI_AR_TRX_TAX_LINES jrctl ,

4199: jrctl.precedence_7,
4200: jrctl.precedence_8,
4201: jrctl.precedence_9,
4202: jrctl.precedence_10
4203: from JAI_AR_TRX_TAX_LINES jrctl ,
4204: JAI_CMN_TAXES_ALL jtc
4205: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4206: and jtc.tax_id = jrctl.tax_id
4207: and jtc.tax_type in (JAI_CONSTANTS.tax_type_sh_cvd_edu_cess,JAI_CONSTANTS.tax_type_sh_exc_edu_cess)

Line 4217: from JAI_AR_TRX_TAX_LINES

4213: decode(tax_amount, 0,
4214: (base_tax_amount * ( tax_rate / 100) )
4215: , tax_amount
4216: ) sh_cess_amt
4217: from JAI_AR_TRX_TAX_LINES
4218: where link_to_cust_trx_line_id = line_rec.customer_trx_line_id
4219: and tax_line_no in
4220: (cess_rec.precedence_1,
4221: cess_rec.precedence_2,