APPS.IEX_DISPUTE_PVT dependencies on RA_CUSTOMER_TRX

Line 60: from ra_customer_trx

56: l_disp_component VARCHAR2(150);
57:
58: Cursor Get_Currency_Code Is
59: select invoice_currency_code, org_id
60: from ra_customer_trx
61: where customer_trx_id = l_disp_header_rec.cust_trx_id;
62:
63: BEGIN
64:

Line 141: ra_customer_trx TRX

137:
138: -- figure out NOCOPY creation sign
139: select TRX_TYPE.creation_sign, TRX_TYPE.CREDIT_MEMO_TYPE_ID into l_creationSign, l_credit_memo_type_id
140: from ra_cust_trx_types TRX_TYPE,
141: ra_customer_trx TRX
142: where TRX.CUST_TRX_TYPE_ID = TRX_TYPE.CUST_TRX_TYPE_ID and
143: TRX.Customer_Trx_ID = l_disp_header_rec.cust_trx_id;
144:
145: if l_credit_memo_type_id is not null then

Line 187: FROM ra_customer_trx_lines

183:
184: -- price should be positive no matter what
185: SELECT UNIT_SELLING_PRICE
186: INTO l_disp_line_tbl(i).price
187: FROM ra_customer_trx_lines
188: WHERE customer_trx_line_id = l_disp_line_tbl(i).customer_trx_line_id;
189: EXCEPTION
190: WHEN NO_DATA_FOUND THEN
191: FND_MESSAGE.SET_NAME('IEX', 'IEX_NO_UNIT_PRICE');

Line 501: from ra_customer_trx

497: where cust_account_id = p_cust_acct_id;
498:
499: Cursor Get_billto(p_cust_trx_id number) Is
500: select bill_to_site_use_id
501: from ra_customer_trx
502: where customer_trx_id = p_cust_trx_id;
503:
504: Cursor Get_paymentid(p_cust_trx_id number) Is
505: select customer_id,payment_schedule_id