APPS.IEX_PROFILE dependencies on HZ_CUST_ACCOUNTS

Line 52: hz_cust_accounts hzca

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

Line 73: hz_cust_accounts hzca

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

Line 98: hz_cust_accounts hzca

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

Line 694: HZ_CUST_ACCOUNTS HZCA,

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

Line 716: HZ_CUST_ACCOUNTS HZCA,

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

Line 732: HZ_CUST_ACCOUNTS HZCA,

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