APPS.JAI_AR_TRX_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 170: ra_customer_trx_lines_all rctl ,

166: rctl.interface_line_attribute3 ,
167: rctl.interface_line_attribute6
168: FROM
169: ra_customer_trx_all trx ,
170: ra_customer_trx_lines_all rctl ,
171: jai_ar_trx_lines jrctl, -- Changed for Bug 5894175
172: -- ja_in_ra_customer_trx_lines jrctl
173: JAI_AR_TRXS jrct --bug#5194107
174: WHERE

Line 474: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,

470: || rallamse bug#4931630 changed the cp_loc_tax_code from ar_vat_tax_all.tax_code%type
471: || to zx_rates_b.tax
472: */
473: CURSOR cur_chk_non_il_taxes(cp_loc_tax_code ZX_RATES_B.TAX%TYPE,
474: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
475: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
476: cp_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE
477: /*Variable datatype changed from number to
478: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */

Line 475: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,

471: || to zx_rates_b.tax
472: */
473: CURSOR cur_chk_non_il_taxes(cp_loc_tax_code ZX_RATES_B.TAX%TYPE,
474: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
475: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
476: cp_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE
477: /*Variable datatype changed from number to
478: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */
479: ) --rchandan for bug#4428980

Line 483: FROM ra_customer_trx_lines_all rctl,

479: ) --rchandan for bug#4428980
480: IS
481: SELECT
482: 1
483: FROM ra_customer_trx_lines_all rctl,
484: zx_rates_b zrb,
485: zx_party_tax_profile zptp
486: WHERE
487: zrb.tax = 'LOCALIZATION' -- 'Localization' , Harshita for Bug 4907217

Line 510: ra_customer_trx_lines_all

506: IS
507: SELECT
508: 1
509: FROM
510: ra_customer_trx_lines_all
511: WHERE
512: customer_trx_id = p_customer_trx_id AND
513: accounting_rule_id IS NOT NULL;
514: