APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_RECEIVABLE_APPLICATIONS

Line 551: ar_receivable_applications ra,

547:
548: SELECT COUNT(DISTINCT ps.payment_schedule_id)
549: INTO l_auto_rec_approved_count
550: FROM ar_payment_schedules ps,
551: ar_receivable_applications ra,
552: ar_cash_receipt_history crh
553: WHERE ps.customer_trx_id = p_customer_trx_id
554: AND ra.applied_payment_schedule_id = ps.payment_schedule_id
555: AND ra.cash_receipt_id = crh.cash_receipt_id

Line 781: FROM ar_receivable_applications app

777: SELECT DECODE( MAX( receivable_application_id ),
778: NULL, 'N',
779: 'Y' )
780: INTO l_activity_flag
781: FROM ar_receivable_applications app
782: WHERE app.customer_trx_id = p_customer_trx_id
783: OR app.applied_customer_trx_id = p_customer_trx_id;
784:
785: IF (l_activity_flag = 'Y')

Line 2564: FROM ar_receivable_applications

2560:
2561: BEGIN
2562: SELECT nvl(sum(nvl(amount_applied,0) + nvl(earned_discount_taken,0) + nvl(unearned_discount_taken,0)), 0)
2563: INTO p_amount_applied
2564: FROM ar_receivable_applications
2565: WHERE applied_payment_schedule_id = p_applied_payment_schedule_id
2566: AND status = 'APP'
2567: AND nvl(confirmed_flag,'Y') = 'Y'
2568: AND apply_date <= p_as_of_date;

Line 2574: FROM ar_receivable_applications

2570: /* Added the query to take care of On-Account CM applications Bug 2610716*/
2571: IF p_class = 'CM' THEN
2572: SELECT nvl(sum(amount_applied),0)
2573: INTO p_cm_amount_applied
2574: FROM ar_receivable_applications
2575: WHERE payment_schedule_id = p_applied_payment_schedule_id
2576: AND apply_date <= p_as_of_date;
2577: END IF;
2578: