APPS.AR_CM_APP_VAL_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 93: FROM ar_receivable_applications

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

Line 179: FROM AR_RECEIVABLE_APPLICATIONS ra

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

Line 260: FROM ar_receivable_applications

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