APPS.IEX_CUST_OVERVIEW_PVT dependencies on RA_CM_REQUESTS

Line 540: l_amount_in_dispute ra_cm_requests_all.total_amount%type; --Added for bug 7612000 gnramasa 4th Dec 08

536: AND status not in ('CURRENT', 'CLOSE');
537:
538: l_cnt_cur_codes number; --added for MOAC
539:
540: l_amount_in_dispute ra_cm_requests_all.total_amount%type; --Added for bug 7612000 gnramasa 4th Dec 08
541:
542: BEGIN
543: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
544: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_object_source=' || p_object_source ||

Line 618: from ra_cm_requests cm

614: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
615: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
616: select nvl(sum(cm.total_amount * -1),0)
617: into l_amount_in_dispute
618: from ra_cm_requests cm
619: where cm.customer_trx_id in (select distinct ps.customer_trx_id
620: from ar_payment_schedules ps,
621: hz_cust_accounts ca
622: where ca.party_id = l_party_id

Line 674: from ra_cm_requests cm

670: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
671: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
672: select nvl(sum(cm.total_amount * -1),0)
673: into l_amount_in_dispute
674: from ra_cm_requests cm
675: where cm.customer_trx_id in (select distinct ps.customer_trx_id
676: from ar_payment_schedules ps,
677: ar_system_parameters parm
678: where ps.customer_id = p_object_id

Line 780: from ra_cm_requests cm

776: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
777: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
778: select nvl(sum(cm.total_amount * -1),0)
779: into l_amount_in_dispute
780: from ra_cm_requests cm
781: where cm.customer_trx_id in
782: (
783: SELECT distinct ps.customer_trx_id
784: FROM ar_payment_schedules ps, iex_delinquencies del

Line 873: from ra_cm_requests cm

869: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
870: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
871: select nvl(sum(cm.total_amount * -1),0)
872: into l_amount_in_dispute
873: from ra_cm_requests cm
874: where cm.customer_trx_id in (select distinct ps.customer_trx_id
875: FROM ar_payment_schedules ps,
876: ar_system_parameters parm
877: WHERE ps.customer_site_use_id = p_object_id

Line 1960: l_amount_in_dispute ra_cm_requests_all.total_amount%type; --Added for bug 7612000 gnramasa 4th Dec 08

1956:
1957: l_cnt_cur_codes number; --added for MOAC
1958: l_calc_cust_stats VARCHAR2(1);
1959:
1960: l_amount_in_dispute ra_cm_requests_all.total_amount%type; --Added for bug 7612000 gnramasa 4th Dec 08
1961:
1962: BEGIN
1963: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
1964:

Line 2016: from ra_cm_requests cm

2012: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
2013: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
2014: select nvl(sum(cm.total_amount * -1),0)
2015: into l_amount_in_dispute
2016: from ra_cm_requests cm
2017: where cm.customer_trx_id in (select distinct customer_trx_id
2018: from ar_payment_schedules ps,
2019: hz_cust_accounts ca
2020: where ca.party_id = p_party_id