APPS.IEX_PROFILE dependencies on IEX_PROMISE_DETAILS

Line 575: FROM IEX_PROMISE_DETAILS IPD,

571: SUM(DECODE(IPD.STATUS, 'COLLECTABLE', 1, 'PENDING', 1, 'FULLFILLED', 1, 'IN_QUESTION', 1, 'OPEN', 1, 0))
572: Into l_profile_rec.Total_Promises,
573: l_profile_rec.Broken_Promises,
574: l_profile_rec.Open_Promises
575: FROM IEX_PROMISE_DETAILS IPD,
576: HZ_CUST_ACCOUNTS HZCA,
577: IEX_DELINQUENCIES DEL -- Moac Change Added Delinquency
578: WHERE IPD.cust_account_id = HZCA.cust_Account_id
579: AND IPD.DELINQUENCY_ID = DEL.DELINQUENCY_ID

Line 597: FROM IEX_PROMISE_DETAILS IPD,

593: SUM(DECODE(IPD.STATUS, 'COLLECTABLE', 1, 'PENDING', 1, 'FULLFILLED', 1, 'IN_QUESTION', 1, 'OPEN', 1, 0))
594: Into l_profile_rec.Total_Promises,
595: l_profile_rec.Broken_Promises,
596: l_profile_rec.Open_Promises
597: FROM IEX_PROMISE_DETAILS IPD,
598: HZ_CUST_ACCOUNTS HZCA,
599: IEX_DELINQUENCIES DEL
600: WHERE IPD.cust_account_id = HZCA.cust_Account_id
601: AND IPD.DELINQUENCY_ID = DEL.DELINQUENCY_ID

Line 613: FROM IEX_PROMISE_DETAILS IPD,

609: SUM(DECODE(IPD.STATUS, 'COLLECTABLE', 1, 'PENDING', 1, 'FULLFILLED', 1, 'IN_QUESTION', 1, 'OPEN', 1, 0))
610: Into l_profile_rec.Total_Promises,
611: l_profile_rec.Broken_Promises,
612: l_profile_rec.Open_Promises
613: FROM IEX_PROMISE_DETAILS IPD,
614: HZ_CUST_ACCOUNTS HZCA,
615: IEX_DELINQUENCIES DEL -- Moac Change Added Delinquency
616: WHERE IPD.cust_account_id = HZCA.cust_Account_id
617: AND IPD.DELINQUENCY_ID = DEL.DELINQUENCY_ID

Line 628: FROM IEX_PROMISE_DETAILS IPD

624: SUM(DECODE(IPD.STATUS, 'COLLECTABLE', 1, 'PENDING', 1, 'FULLFILLED', 1, 'IN_QUESTION', 1, 'OPEN', 1, 0))
625: Into l_profile_rec.Total_Promises,
626: l_profile_rec.Broken_Promises,
627: l_profile_rec.Open_Promises
628: FROM IEX_PROMISE_DETAILS IPD
629: WHERE trunc(IPD.CREATION_DATE) BETWEEN g_curr_rec.past_year_from AND g_curr_rec.past_year_to
630: AND IPD.delinquency_id = p_delinquency_id;
631:
632: ELSIF p_filter_mode = 'BILL_TO' then -- added by jypark

Line 639: FROM IEX_PROMISE_DETAILS IPD,

635: SUM(DECODE(IPD.STATUS, 'COLLECTABLE', 1, 'PENDING', 1, 'FULLFILLED', 1, 'IN_QUESTION', 1, 'OPEN', 1, 0))
636: Into l_profile_rec.Total_Promises,
637: l_profile_rec.Broken_Promises,
638: l_profile_rec.Open_Promises
639: FROM IEX_PROMISE_DETAILS IPD,
640: IEX_DELINQUENCIES DEL
641: WHERE trunc(IPD.CREATION_DATE) BETWEEN g_curr_rec.past_year_from AND g_curr_rec.past_year_to
642: AND IPD.delinquency_id = DEL.delinquency_id
643: AND DEL.customer_site_use_id = p_customer_site_use_id;