APPS.AR_RECEIPT_VAL_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 1536: FROM ar_receivable_applications

1532: p_return_status := FND_API.G_RET_STS_SUCCESS;
1533:
1534: SELECT amount_applied,
1535: amount_applied_from INTO l_amount_applied,l_amount_applied_from
1536: FROM ar_receivable_applications
1537: WHERE receivable_application_id = p_receivable_application_id;
1538:
1539: l_remaining_unapp_rct_amt := p_cr_unapp_amount + nvl(l_amount_applied_from, l_amount_applied);
1540:

Line 2168: from ar_receivable_applications

2164: p_return_status := FND_API.G_RET_STS_SUCCESS;
2165:
2166: Select max(apply_date) , max(gl_date)
2167: into l_apply_date , l_gl_date
2168: from ar_receivable_applications
2169: where cash_receipt_id = p_cash_receipt_id;
2170:
2171: IF p_reversal_gl_date < l_gl_date THEN
2172: FND_MESSAGE.SET_NAME('AR','AR_RW_BEF_RCPT_APP_GL_DATE');

Line 2222: FROM AR_RECEIVABLE_APPLICATIONS ra

2218: ar_receipt_api_pub.Original_unapp_info.receivable_application_id IS NOT NULL
2219: THEN
2220: SELECT count(*)
2221: INTO l_valid
2222: FROM AR_RECEIVABLE_APPLICATIONS ra
2223: WHERE ra.receivable_application_id = p_receivable_application_id
2224: and ra.display = 'Y'
2225: and ra.status = p_application_type
2226: and ra.application_type = 'CASH';

Line 2392: FROM ar_receivable_applications ra

2388: --check if there is a SHORT TERM DEBT application on the receipt
2389: BEGIN
2390: SELECT 'Y'
2391: INTO l_std_appln
2392: FROM ar_receivable_applications ra
2393: WHERE ra.cash_receipt_id = p_cash_receipt_id
2394: AND ra.status = 'ACTIVITY'
2395: AND ra.applied_payment_schedule_id = -2
2396: AND display = 'Y'

Line 2422: ar_receivable_applications ra

2418: BEGIN
2419: SELECT 'Y'
2420: INTO l_reserved
2421: FROM ar_payment_schedules ps,
2422: ar_receivable_applications ra
2423: WHERE ra.cash_receipt_id = p_cash_receipt_id
2424: AND ra.applied_payment_schedule_id = ps.payment_schedule_id
2425: AND ps.reserved_type IS NOT NULL
2426: AND ps.reserved_value IS NOT NULL

Line 2950: SELECT /*+ index(ra AR_RECEIVABLE_APPLICATIONS_N1) */SUM(AMOUNT_APPLIED)

2946: --get the existing write-off amount on the receipt.
2947:
2948: BEGIN
2949: -- Bug 11729918
2950: SELECT /*+ index(ra AR_RECEIVABLE_APPLICATIONS_N1) */SUM(AMOUNT_APPLIED)
2951: --sum(amount_applied)
2952: INTO l_existing_wo_amount
2953: FROM ar_receivable_applications ra
2954: WHERE applied_payment_schedule_id = -3

Line 2953: FROM ar_receivable_applications ra

2949: -- Bug 11729918
2950: SELECT /*+ index(ra AR_RECEIVABLE_APPLICATIONS_N1) */SUM(AMOUNT_APPLIED)
2951: --sum(amount_applied)
2952: INTO l_existing_wo_amount
2953: FROM ar_receivable_applications ra
2954: WHERE applied_payment_schedule_id = -3
2955: AND status = 'ACTIVITY'
2956: AND NVL(confirmed_flag,'Y') = 'Y'
2957: AND cash_receipt_id = p_cash_receipt_id;

Line 3787: FROM ar_receivable_applications

3783: IF l_cash_receipt_id IS NOT NULL THEN
3784:
3785: SELECT sum(nvl(amount_applied,0))
3786: INTO l_prepay_amount
3787: FROM ar_receivable_applications
3788: WHERE cash_receipt_id = p_cash_receipt_id
3789: AND applied_payment_schedule_id = p_applied_ps_id
3790: AND display = 'Y'
3791: AND status = 'OTHER ACC';

Line 3799: FROM ar_receivable_applications

3795: IF p_receivable_application_id IS NOT NULL THEN
3796:
3797: SELECT sum(nvl(amount_applied,0))
3798: INTO l_prepay_amount
3799: FROM ar_receivable_applications
3800: WHERE receivable_application_id = p_receivable_application_id
3801: AND display = 'Y'
3802: AND applied_payment_schedule_id = p_applied_ps_id
3803: AND status = 'OTHER ACC';

Line 3864: ar_receivable_applications app

3860: SELECT NVL(payment_channel_code,'CASH')
3861: INTO l_payment_type_code
3862: FROM ar_receipt_methods arm,
3863: ar_cash_receipts cr,
3864: ar_receivable_applications app
3865: WHERE cr.receipt_method_id = arm.receipt_method_id
3866: AND app.cash_receipt_id=cr.cash_receipt_id
3867: AND app.receivable_application_id = p_receivable_application_id;
3868:

Line 4154: FROM ar_receivable_applications

4150: WHERE cash_receipt_id = p_applied_cash_receipt_id;
4151:
4152: SELECT NVL(SUM(amount_applied),0)
4153: INTO l_amount_applied
4154: FROM ar_receivable_applications
4155: WHERE cash_receipt_id = p_applied_cash_receipt_id
4156: AND display = 'Y';
4157:
4158: IF PG_DEBUG in ('Y', 'C') THEN

Line 4290: llca_ra_rec ar_receivable_applications%rowtype;

4286: ll_msg_count number;
4287: l_gt_count NUMBER :=0;
4288:
4289: l_ctl_id number;
4290: llca_ra_rec ar_receivable_applications%rowtype;
4291:
4292: -- LLCA - LINE LEVEL
4293: l_rowid rowid;
4294: l_group_id ra_customer_trx_lines.source_data_key4%type;