DBA Data[Home] [Help]

APPS.JAI_JMCR_TRIGGER_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 77: where customer_trx_id in (select customer_trx_id from ra_customer_trx_lines_all

73:
74: cursor customer is
75: select bill_to_customer_id
76: from ra_customer_trx_all
77: where customer_trx_id in (select customer_trx_id from ra_customer_trx_lines_all
78: where customer_trx_line_id =pr_new.ref_line_id);
79:
80: CURSOR Tax_Amount_Cur IS
81: SELECT sum(a.tax_amount) tax_amount