APPS.JAI_AR_TRX_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 111: ra_customer_trx_lines_all rctl ,

107: rctl.interface_line_attribute3 ,
108: rctl.interface_line_attribute6
109: FROM
110: ra_customer_trx_all trx ,
111: ra_customer_trx_lines_all rctl ,
112: jai_ar_trx_lines jrctl, -- Changed for Bug 5894175
113: -- ja_in_ra_customer_trx_lines jrctl
114: JAI_AR_TRXS jrct --bug#5194107
115: WHERE

Line 327: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,

323: || rallamse bug#4931630 changed the cp_loc_tax_code from ar_vat_tax_all.tax_code%type
324: || to zx_rates_b.tax
325: */
326: CURSOR cur_chk_non_il_taxes(cp_loc_tax_code ZX_RATES_B.TAX%TYPE,
327: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
328: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
329: cp_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE
330: /*Variable datatype changed from number to
331: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */

Line 328: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,

324: || to zx_rates_b.tax
325: */
326: CURSOR cur_chk_non_il_taxes(cp_loc_tax_code ZX_RATES_B.TAX%TYPE,
327: cp_line_type_tax RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
328: cp_line_type_freight RA_CUSTOMER_TRX_LINES_ALL.LINE_TYPE%TYPE,
329: cp_tax_regime_code ZX_RATES_B.TAX_REGIME_CODE%TYPE
330: /*Variable datatype changed from number to
331: ZX_RATES_B.TAX_REGIME_CODE%TYPE for the bug 5021243 */
332: ) --rchandan for bug#4428980

Line 336: FROM ra_customer_trx_lines_all rctl,

332: ) --rchandan for bug#4428980
333: IS
334: SELECT
335: 1
336: FROM ra_customer_trx_lines_all rctl,
337: zx_rates_b zrb,
338: zx_party_tax_profile zptp
339: WHERE
340: zrb.tax = 'LOCALIZATION' -- 'Localization' , Harshita for Bug 4907217

Line 363: ra_customer_trx_lines_all

359: IS
360: SELECT
361: 1
362: FROM
363: ra_customer_trx_lines_all
364: WHERE
365: customer_trx_id = p_customer_trx_id AND
366: accounting_rule_id IS NOT NULL;
367: