APPS.AR_IDEP_UTILS dependencies on RA_CUST_TRX_TYPES

Line 112: l_commitment_class ra_cust_trx_types.type%type;

108: | 02-May-2002 krmenon Created
109: *=======================================================================*/
110: FUNCTION get_applied_commitment_amt (p_customer_trx_id in NUMBER) RETURN NUMBER IS
111:
112: l_commitment_class ra_cust_trx_types.type%type;
113: l_currency_code ra_customer_trx_all.invoice_currency_code%type;
114: l_applied_amount NUMBER := 0;
115: l_invoiced_amount NUMBER := 0;
116: l_credit_memo_amount NUMBER := 0;

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