APPS.AR_RECEIPT_VAL_PVT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 1527: FROM ar_receivable_applications

1523: p_return_status := FND_API.G_RET_STS_SUCCESS;
1524:
1525: SELECT amount_applied,
1526: amount_applied_from INTO l_amount_applied,l_amount_applied_from
1527: FROM ar_receivable_applications
1528: WHERE receivable_application_id = p_receivable_application_id;
1529:
1530: l_remaining_unapp_rct_amt := p_cr_unapp_amount + nvl(l_amount_applied_from, l_amount_applied);
1531:

Line 2152: FROM AR_RECEIVABLE_APPLICATIONS ra

2148: ar_receipt_api_pub.Original_unapp_info.receivable_application_id IS NOT NULL
2149: THEN
2150: SELECT count(*)
2151: INTO l_valid
2152: FROM AR_RECEIVABLE_APPLICATIONS ra
2153: WHERE ra.receivable_application_id = p_receivable_application_id
2154: and ra.display = 'Y'
2155: and ra.status = p_application_type
2156: and ra.application_type = 'CASH';

Line 2322: FROM ar_receivable_applications ra

2318: --check if there is a SHORT TERM DEBT application on the receipt
2319: BEGIN
2320: SELECT 'Y'
2321: INTO l_std_appln
2322: FROM ar_receivable_applications ra
2323: WHERE ra.cash_receipt_id = p_cash_receipt_id
2324: AND ra.status = 'ACTIVITY'
2325: AND ra.applied_payment_schedule_id = -2
2326: AND display = 'Y'

Line 2352: ar_receivable_applications ra

2348: BEGIN
2349: SELECT 'Y'
2350: INTO l_reserved
2351: FROM ar_payment_schedules ps,
2352: ar_receivable_applications ra
2353: WHERE ra.cash_receipt_id = p_cash_receipt_id
2354: AND ra.applied_payment_schedule_id = ps.payment_schedule_id
2355: AND ps.reserved_type IS NOT NULL
2356: AND ps.reserved_value IS NOT NULL

Line 2822: FROM ar_receivable_applications

2818:
2819: BEGIN
2820: SELECT sum(amount_applied)
2821: INTO l_existing_wo_amount
2822: FROM ar_receivable_applications
2823: WHERE applied_payment_schedule_id = -3
2824: AND status = 'ACTIVITY'
2825: AND NVL(confirmed_flag,'Y') = 'Y'
2826: AND cash_receipt_id = p_cash_receipt_id;

Line 3649: FROM ar_receivable_applications

3645: IF l_cash_receipt_id IS NOT NULL THEN
3646:
3647: SELECT sum(nvl(amount_applied,0))
3648: INTO l_prepay_amount
3649: FROM ar_receivable_applications
3650: WHERE cash_receipt_id = p_cash_receipt_id
3651: AND applied_payment_schedule_id = p_applied_ps_id
3652: AND display = 'Y'
3653: AND status = 'OTHER ACC';

Line 3661: FROM ar_receivable_applications

3657: IF p_receivable_application_id IS NOT NULL THEN
3658:
3659: SELECT sum(nvl(amount_applied,0))
3660: INTO l_prepay_amount
3661: FROM ar_receivable_applications
3662: WHERE receivable_application_id = p_receivable_application_id
3663: AND display = 'Y'
3664: AND applied_payment_schedule_id = p_applied_ps_id
3665: AND status = 'OTHER ACC';

Line 3726: ar_receivable_applications app

3722: SELECT NVL(payment_channel_code,'CASH')
3723: INTO l_payment_type_code
3724: FROM ar_receipt_methods arm,
3725: ar_cash_receipts cr,
3726: ar_receivable_applications app
3727: WHERE cr.receipt_method_id = arm.receipt_method_id
3728: AND app.cash_receipt_id=cr.cash_receipt_id
3729: AND app.receivable_application_id = p_receivable_application_id;
3730:

Line 4016: FROM ar_receivable_applications

4012: WHERE cash_receipt_id = p_applied_cash_receipt_id;
4013:
4014: SELECT NVL(SUM(amount_applied),0)
4015: INTO l_amount_applied
4016: FROM ar_receivable_applications
4017: WHERE cash_receipt_id = p_applied_cash_receipt_id
4018: AND display = 'Y';
4019:
4020: IF PG_DEBUG in ('Y', 'C') THEN

Line 4152: llca_ra_rec ar_receivable_applications%rowtype;

4148: ll_msg_count number;
4149: l_gt_count NUMBER :=0;
4150:
4151: l_ctl_id number;
4152: llca_ra_rec ar_receivable_applications%rowtype;
4153:
4154: -- LLCA - LINE LEVEL
4155: l_rowid rowid;
4156: l_group_id ra_customer_trx_lines.source_data_key4%type;