APPS.IEX_PROFILE dependencies on IEX_DELINQUENCIES

Line 122: iex_delinquencies del

118: INTO p_unpaid_inv,
119: p_ontime_inv,
120: p_late_inv
121: from ar_payment_schedules aps,
122: iex_delinquencies del
123: where aps.class IN ('INV', 'DM', 'CB')
124: and aps.due_date between g_curr_rec.past_year_from and g_curr_rec.past_year_to
125: and del.payment_schedule_id = aps.payment_schedule_id
126: and del.delinquency_id = p_filter_id;

Line 488: FROM iex_delinquencies

484:
485: CURSOR C_DEL(p_delinquency_id NUMBER)
486: IS
487: SELECT cust_account_id, customer_site_use_id
488: FROM iex_delinquencies
489: WHERE delinquency_id = p_delinquency_id;
490:
491: CURSOR C_SITE(p_customer_site_use_id NUMBER)
492: IS

Line 695: IEX_DELINQUENCIES DEL -- Moac Change Added Delinquency

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
698: AND trunc(IPD.CREATION_DATE) BETWEEN g_curr_rec.past_year_from AND g_curr_rec.past_year_to
699: AND HZCA.Party_id IN

Line 717: IEX_DELINQUENCIES DEL

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
720: AND trunc(IPD.CREATION_DATE) BETWEEN g_curr_rec.past_year_from AND g_curr_rec.past_year_to
721: AND HZCA.Party_id = p_party_id ;

Line 733: IEX_DELINQUENCIES DEL -- Moac Change Added Delinquency

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
736: AND trunc(IPD.CREATION_DATE) BETWEEN g_curr_rec.past_year_from AND g_curr_rec.past_year_to
737: AND HZCA.cust_account_id = p_cust_account_id ;

Line 758: IEX_DELINQUENCIES DEL

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;
762: