APPS.JAI_AR_VALIDATE_DATA_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 35: p_error_table(2).error_description := 'Difference in tax records in ra_cust_trx_line_gl_dist_all and JAI_AR_TRX_TAX_LINES';

31:
32: p_error_table(1).error_description := 'Difference in tax records in ra_customer_trx_lines_all and ja_in_ra_customer_trx_lines_all';
33: p_error_table(1).enable := 'Y';
34:
35: p_error_table(2).error_description := 'Difference in tax records in ra_cust_trx_line_gl_dist_all and JAI_AR_TRX_TAX_LINES';
36: p_error_table(2).enable := 'Y';
37:
38: p_error_table(3).error_description := 'ADO <> Amount in REC of ra_cust_trx_line_gl_dist_all';
39: p_error_table(3).enable := 'Y';

Line 659: FROM JAI_AR_TRX_TAX_LINES jrcttl,

655: IS
656: SELECT rctl.customer_trx_id,
657: jrcttl.customer_trx_line_id,
658: jrcttl.tax_amount
659: FROM JAI_AR_TRX_TAX_LINES jrcttl,
660: JAI_AR_TRX_LINES jrctl,
661: ra_customer_trx_lines_all rctl
662: WHERE jrcttl.link_to_cust_trx_line_id = jrctl.customer_trx_line_id
663: AND jrcttl.customer_Trx_line_id = rctl.customer_trx_line_id

Line 675: FROM JAI_AR_TRX_TAX_LINES jrcttl,

671: SELECT gl_dist.customer_trx_id,
672: jrcttl.customer_trx_line_id,
673: jrcttl.tax_amount ,
674: jrcttl.func_tax_amount
675: FROM JAI_AR_TRX_TAX_LINES jrcttl,
676: JAI_AR_TRX_LINES jrctl,
677: ra_cust_trx_line_gl_dist_all gl_dist
678: WHERE jrcttl.link_to_cust_trx_line_id = jrctl.customer_trx_line_id
679: AND jrcttl.customer_Trx_line_id = gl_dist.customer_trx_line_id

Line 776: JAI_AR_TRX_TAX_LINES jrcttl

772: IS
773: SELECT jrctl.customer_trx_line_id,
774: nvl(sum(jrcttl.tax_amount),0) tax_amount
775: FROM JAI_AR_TRX_LINES jrctl,
776: JAI_AR_TRX_TAX_LINES jrcttl
777: WHERE jrctl.customer_trx_line_id = jrcttl.link_to_cust_trx_line_id
778: AND jrctl.customer_trx_id = cp_customer_trx_id
779: GROUP BY jrctl.customer_trx_line_id
780: HAVING ROUND(nvl(sum(jrcttl.tax_amount),0)) <>( SELECT ROUND(NVL(tax_amount,0))