APPS.AR_CM_APP_VAL_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 94: FROM ar_receivable_applications

90: p_return_status := FND_API.G_RET_STS_SUCCESS;
91:
92: SELECT amount_applied,
93: amount_applied_from INTO l_amount_applied,l_amount_applied_from
94: FROM ar_receivable_applications
95: WHERE receivable_application_id = p_receivable_application_id;
96:
97: l_remaining_unapp_cm_amt := p_cm_unapp_amount + nvl(l_amount_applied_from, l_amount_applied);
98:

Line 183: FROM AR_RECEIVABLE_APPLICATIONS ra

179: IF p_receivable_application_id IS NOT NULL
180: THEN
181: SELECT count(*)
182: INTO l_valid
183: FROM AR_RECEIVABLE_APPLICATIONS ra
184: WHERE ra.receivable_application_id = p_receivable_application_id
185: and ra.display = 'Y'
186: and ra.status = p_application_type
187: and ra.application_type = 'CM';

Line 264: FROM ar_receivable_applications

260:
261: BEGIN
262: SELECT sum(amount_applied)
263: INTO l_existing_cmref_amount
264: FROM ar_receivable_applications
265: WHERE applied_payment_schedule_id = -8
266: AND status = 'ACTIVITY'
267: AND NVL(confirmed_flag,'Y') = 'Y'
268: AND customer_trx_id = p_customer_trx_id;