APPS.IEX_CUST_OVERVIEW_PVT dependencies on RA_CM_REQUESTS

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

583: AND status not in ('CURRENT', 'CLOSE');
584:
585: l_cnt_cur_codes number; --added for MOAC
586:
587: l_amount_in_dispute ra_cm_requests_all.total_amount%type; --Added for bug 7612000 gnramasa 4th Dec 08
588:
589: BEGIN
590: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
591: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':p_object_source=' || p_object_source ||

Line 696: from ra_cm_requests cm

692: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
693: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
694: select nvl(sum(cm.total_amount * -1),0)
695: into l_amount_in_dispute
696: from ra_cm_requests cm
697: where cm.customer_trx_id in (select distinct ps.customer_trx_id
698: from ar_payment_schedules ps,
699: hz_cust_accounts ca
700: where ca.party_id = l_party_id

Line 754: from ra_cm_requests cm

750: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
751: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
752: select nvl(sum(cm.total_amount * -1),0)
753: into l_amount_in_dispute
754: from ra_cm_requests cm
755: where cm.customer_trx_id in (select distinct ps.customer_trx_id
756: from ar_payment_schedules ps,
757: ar_system_parameters parm
758: where ps.customer_id = p_object_id

Line 874: from ra_cm_requests cm

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

Line 971: from ra_cm_requests cm

967: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
968: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
969: select nvl(sum(cm.total_amount * -1),0)
970: into l_amount_in_dispute
971: from ra_cm_requests cm
972: where cm.customer_trx_id in (select distinct ps.customer_trx_id
973: FROM ar_payment_schedules ps,
974: ar_system_parameters parm
975: WHERE ps.customer_site_use_id = p_object_id

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

2088:
2089: l_cnt_cur_codes number; --added for MOAC
2090: l_calc_cust_stats VARCHAR2(1);
2091:
2092: l_amount_in_dispute ra_cm_requests_all.total_amount%type; --Added for bug 7612000 gnramasa 4th Dec 08
2093:
2094: BEGIN
2095: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':begin');
2096:

Line 2157: from ra_cm_requests cm

2153: -- then calculate the Amount thats in dispute and substract it from the amount overdue.
2154: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
2155: select nvl(sum(cm.total_amount * -1),0)
2156: into l_amount_in_dispute
2157: from ra_cm_requests cm
2158: where cm.customer_trx_id in (select distinct customer_trx_id
2159: from ar_payment_schedules ps,
2160: hz_cust_accounts ca
2161: where ca.party_id = p_party_id