APPS.IEX_PROFILE dependencies on IEX_PROMISE_DETAILS

Line 693: FROM IEX_PROMISE_DETAILS IPD,

689: SUM(DECODE(IPD.STATUS, 'COLLECTABLE', 1, 'PENDING', 1, 'FULLFILLED', 1, 'IN_QUESTION', 1, 'OPEN', 1, 0))
690: Into l_profile_rec.Total_Promises,
691: l_profile_rec.Broken_Promises,
692: l_profile_rec.Open_Promises
693: FROM IEX_PROMISE_DETAILS IPD,
694: HZ_CUST_ACCOUNTS HZCA,
695: IEX_DELINQUENCIES DEL -- Moac Change Added Delinquency
696: WHERE IPD.cust_account_id = HZCA.cust_Account_id
697: AND IPD.DELINQUENCY_ID = DEL.DELINQUENCY_ID

Line 715: FROM IEX_PROMISE_DETAILS IPD,

711: SUM(DECODE(IPD.STATUS, 'COLLECTABLE', 1, 'PENDING', 1, 'FULLFILLED', 1, 'IN_QUESTION', 1, 'OPEN', 1, 0))
712: Into l_profile_rec.Total_Promises,
713: l_profile_rec.Broken_Promises,
714: l_profile_rec.Open_Promises
715: FROM IEX_PROMISE_DETAILS IPD,
716: HZ_CUST_ACCOUNTS HZCA,
717: IEX_DELINQUENCIES DEL
718: WHERE IPD.cust_account_id = HZCA.cust_Account_id
719: AND IPD.DELINQUENCY_ID = DEL.DELINQUENCY_ID

Line 731: FROM IEX_PROMISE_DETAILS IPD,

727: SUM(DECODE(IPD.STATUS, 'COLLECTABLE', 1, 'PENDING', 1, 'FULLFILLED', 1, 'IN_QUESTION', 1, 'OPEN', 1, 0))
728: Into l_profile_rec.Total_Promises,
729: l_profile_rec.Broken_Promises,
730: l_profile_rec.Open_Promises
731: FROM IEX_PROMISE_DETAILS IPD,
732: HZ_CUST_ACCOUNTS HZCA,
733: IEX_DELINQUENCIES DEL -- Moac Change Added Delinquency
734: WHERE IPD.cust_account_id = HZCA.cust_Account_id
735: AND IPD.DELINQUENCY_ID = DEL.DELINQUENCY_ID

Line 746: FROM IEX_PROMISE_DETAILS IPD

742: SUM(DECODE(IPD.STATUS, 'COLLECTABLE', 1, 'PENDING', 1, 'FULLFILLED', 1, 'IN_QUESTION', 1, 'OPEN', 1, 0))
743: Into l_profile_rec.Total_Promises,
744: l_profile_rec.Broken_Promises,
745: l_profile_rec.Open_Promises
746: FROM IEX_PROMISE_DETAILS IPD
747: WHERE trunc(IPD.CREATION_DATE) BETWEEN g_curr_rec.past_year_from AND g_curr_rec.past_year_to
748: AND IPD.delinquency_id = p_delinquency_id;
749:
750: ELSIF p_filter_mode = 'BILL_TO' then -- added by jypark

Line 757: FROM IEX_PROMISE_DETAILS IPD,

753: SUM(DECODE(IPD.STATUS, 'COLLECTABLE', 1, 'PENDING', 1, 'FULLFILLED', 1, 'IN_QUESTION', 1, 'OPEN', 1, 0))
754: Into l_profile_rec.Total_Promises,
755: l_profile_rec.Broken_Promises,
756: l_profile_rec.Open_Promises
757: FROM IEX_PROMISE_DETAILS IPD,
758: IEX_DELINQUENCIES DEL
759: WHERE trunc(IPD.CREATION_DATE) BETWEEN g_curr_rec.past_year_from AND g_curr_rec.past_year_to
760: AND IPD.delinquency_id = DEL.delinquency_id
761: AND DEL.customer_site_use_id = p_customer_site_use_id;