APPS.IEX_PROFILE dependencies on HZ_CUST_ACCOUNTS

Line 51: hz_cust_accounts hzca

47: INTO p_unpaid_inv,
48: p_ontime_inv,
49: p_late_inv
50: from ar_payment_schedules aps,
51: hz_cust_accounts hzca
52: where aps.customer_id = hzca.cust_account_id
53: and aps.class IN ('INV', 'DM', 'CB')
54: and aps.due_date between g_curr_rec.past_year_from and g_curr_rec.past_year_to
55: and hzca.party_id IN

Line 72: hz_cust_accounts hzca

68: INTO p_unpaid_inv,
69: p_ontime_inv,
70: p_late_inv
71: from ar_payment_schedules aps,
72: hz_cust_accounts hzca
73: where aps.customer_id = hzca.cust_account_id
74: and aps.class IN ('INV', 'DM', 'CB')
75: and aps.due_date between g_curr_rec.past_year_from and g_curr_rec.past_year_to
76: and hzca.party_id = p_filter_id ;

Line 97: hz_cust_accounts hzca

93: INTO p_unpaid_inv,
94: p_ontime_inv,
95: p_late_inv
96: from ar_payment_schedules aps,
97: hz_cust_accounts hzca
98: where aps.customer_id = hzca.cust_account_id
99: and aps.class IN ('INV', 'DM', 'CB')
100: and aps.due_date between g_curr_rec.past_year_from and g_curr_rec.past_year_to
101: and hzca.cust_account_id = p_filter_id ;

Line 576: HZ_CUST_ACCOUNTS HZCA,

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

Line 598: HZ_CUST_ACCOUNTS HZCA,

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
602: AND trunc(IPD.CREATION_DATE) BETWEEN g_curr_rec.past_year_from AND g_curr_rec.past_year_to

Line 614: HZ_CUST_ACCOUNTS HZCA,

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
618: AND trunc(IPD.CREATION_DATE) BETWEEN g_curr_rec.past_year_from AND g_curr_rec.past_year_to