APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_RECEIVABLE_APPLICATIONS

Line 619: ar_receivable_applications ra,

615:
616: SELECT COUNT(DISTINCT ps.payment_schedule_id)
617: INTO l_auto_rec_approved_count
618: FROM ar_payment_schedules ps,
619: ar_receivable_applications ra,
620: ar_cash_receipt_history crh
621: WHERE ps.customer_trx_id = p_customer_trx_id
622: AND ra.applied_payment_schedule_id = ps.payment_schedule_id
623: AND ra.cash_receipt_id = crh.cash_receipt_id

Line 849: FROM ar_receivable_applications app

845: SELECT DECODE( MAX( receivable_application_id ),
846: NULL, 'N',
847: 'Y' )
848: INTO l_activity_flag
849: FROM ar_receivable_applications app
850: WHERE app.customer_trx_id = p_customer_trx_id
851: OR app.applied_customer_trx_id = p_customer_trx_id;
852:
853: IF (l_activity_flag = 'Y')

Line 2683: FROM ar_receivable_applications

2679:
2680: BEGIN
2681: SELECT nvl(sum(nvl(amount_applied,0) + nvl(earned_discount_taken,0) + nvl(unearned_discount_taken,0)), 0)
2682: INTO p_amount_applied
2683: FROM ar_receivable_applications
2684: WHERE applied_payment_schedule_id = p_applied_payment_schedule_id
2685: AND status = 'APP'
2686: AND nvl(confirmed_flag,'Y') = 'Y'
2687: AND apply_date <= p_as_of_date;

Line 2693: FROM ar_receivable_applications

2689: /* Added the query to take care of On-Account CM applications Bug 2610716*/
2690: IF p_class = 'CM' THEN
2691: SELECT nvl(sum(amount_applied),0)
2692: INTO p_cm_amount_applied
2693: FROM ar_receivable_applications
2694: WHERE payment_schedule_id = p_applied_payment_schedule_id
2695: AND apply_date <= p_as_of_date;
2696: END IF;
2697: