DBA Data[Home] [Help]

APPS.JAI_AR_GLDIST_TRIGGER_PKG dependencies on JAI_CMN_TAXES_ALL

Line 119: JAI_CMN_TAXES_ALL b

115: a.customer_trx_line_id line_id ,
116: a.tax_line_no tax_line_no
117: FROM
118: JAI_AR_TRX_TAX_LINES a ,
119: JAI_CMN_TAXES_ALL b
120: WHERE link_to_cust_trx_line_id = pr_new.customer_trx_line_id
121: AND a.tax_id = b.tax_id
122: AND NVL(b.inclusive_tax_flag,'N') = 'N'
123: ORDER BY tax_line_no;

Line 138: JAI_CMN_TAXES_ALL b

134: a.customer_trx_line_id line_id ,
135: a.tax_line_no tax_line_no
136: FROM
137: JAI_AR_TRX_TAX_LINES a ,
138: JAI_CMN_TAXES_ALL b
139: WHERE customer_trx_line_id = pr_new.customer_trx_line_id
140: AND a.tax_id = b.tax_id
141: ORDER BY tax_line_no;
142:

Line 143: CURSOR cur_chk_rgm ( pv_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE )

139: WHERE customer_trx_line_id = pr_new.customer_trx_line_id
140: AND a.tax_id = b.tax_id
141: ORDER BY tax_line_no;
142:
143: CURSOR cur_chk_rgm ( pv_tax_type JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE )
144: IS
145: SELECT
146: regime_id ,
147: regime_code