APPS.IEX_PROFILE dependencies on IEX_DELINQUENCIES

Line 121: iex_delinquencies del

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

Line 416: FROM iex_delinquencies

412:
413: CURSOR C_DEL(p_delinquency_id NUMBER)
414: IS
415: SELECT cust_account_id, customer_site_use_id
416: FROM iex_delinquencies
417: WHERE delinquency_id = p_delinquency_id;
418:
419: CURSOR C_SITE(p_customer_site_use_id NUMBER)
420: IS

Line 577: IEX_DELINQUENCIES DEL -- Moac Change Added Delinquency

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

Line 599: IEX_DELINQUENCIES DEL

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

Line 615: IEX_DELINQUENCIES DEL -- Moac Change Added Delinquency

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

Line 640: IEX_DELINQUENCIES DEL

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