APPS.AR_IDEP_UTILS dependencies on RA_CUST_TRX_TYPES_ALL

Line 128: ra_cust_trx_types_all type

124: trx.invoice_currency_code
125: INTO l_commitment_class,
126: l_currency_code
127: FROM ra_customer_trx_all trx,
128: ra_cust_trx_types_all type
129: WHERE trx.customer_trx_id = p_customer_trx_id
130: AND trx.cust_trx_type_id = type.cust_trx_type_id
131: AND trx.org_id = type.org_id
132: AND type.type IN ('DEP','GUAR');

Line 149: ra_cust_trx_types_all type,

145: --
146: SELECT ( NVL(SUM( ADJ.AMOUNT),0) * -1)
147: INTO l_invoiced_amount
148: FROM ra_customer_trx_all trx,
149: ra_cust_trx_types_all type,
150: ar_adjustments_all adj
151: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
152: AND trx.org_id = type.org_id
153: AND trx.initial_customer_trx_id = p_customer_trx_id