APPS.OE_COMMITMENT_PVT dependencies on RA_CUSTOMER_TRX

Line 32: FROM RA_CUSTOMER_TRX

28: IS
29:
30: cursor c_trx_number_cur IS
31: select TRX_NUMBER
32: FROM RA_CUSTOMER_TRX
33: WHERE CUSTOMER_TRX_ID = p_commitment_id;
34:
35: l_api_name CONSTANT VARCHAR2(30) := 'Evaluate_Commitment';
36: l_commitment_bal NUMBER;

Line 186: ,ra_customer_trx_all rcta

182: v_SelectStmt :=
183: 'SELECT allocate_tax_freight
184: INTO :allocate_fax_freight
185: FROM ra_cust_trx_types_all rctt
186: ,ra_customer_trx_all rcta
187: WHERE rctt.cust_trx_type_id = rcta.cust_trx_type_id
188: AND rcta.customer_trx_id = :commitment_id';
189:
190: DBMS_SQL.PARSE(v_CursorID, v_SelectStmt, DBMS_SQL.V7);

Line 221: ,ra_customer_trx_all rcta

217: /***
218: SELECT NVL(allocate_tax_freight, 'N')
219: INTO l_allocate_tax_freight
220: FROM ra_cust_trx_types_all rctt
221: ,ra_customer_trx_all rcta
222: WHERE rctt.cust_trx_type_id = rcta.cust_trx_type_id
223: AND rcta.customer_trx_id = p_line_rec.commitment_id;
224: ***/
225: