DBA Data[Home] [Help]

APPS.AR_CM_APP_LIB_PVT dependencies on RA_CUSTOMER_TRX

Line 30: FROM ra_customer_trx

26: IF p_trx_number IS NOT NULL THEN
27: BEGIN
28: SELECT customer_trx_id
29: INTO p_customer_trx_id
30: FROM ra_customer_trx
31: WHERE trx_number = p_trx_number;
32: EXCEPTION
33: WHEN no_data_found THEN
34: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_NUM_INVALID');

Line 114: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

110: END IF;
111: END default_gl_date;
112:
113: PROCEDURE Default_CM_Info(
114: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
115: p_cm_ps_id OUT NOCOPY NUMBER,
116: p_cm_currency_code OUT NOCOPY VARCHAR2,
117: p_trx_date OUT NOCOPY DATE,
118: p_cm_gl_date OUT NOCOPY DATE,

Line 147: ra_customer_trx ct

143: p_cm_gl_date ,
144: p_cm_unapp_amount,
145: p_cm_receipt_method_id
146: FROM
147: ra_customer_trx ct
148: , ar_payment_schedules ps
149: WHERE
150: ps.class = 'CM'
151: AND ct.customer_trx_id(+) = ps.customer_trx_id