APPS.IBY_EVAL_AR_FACTORS_PKG dependencies on HZ_CUSTOMER_PROFILES

Line 295: hz_customer_profiles p

291: */
292: cursor c_get_creditratingcode(ci_accountnumber in varchar2) is
293: select p.credit_rating
294: from hz_cust_accounts a,
295: hz_customer_profiles p
296: where a.account_number = ci_accountnumber and
297: p.status = 'A' and
298: a.status = 'A' and
299: p.site_use_id is null and

Line 402: hz_customer_profiles p

398: */
399: cursor c_get_riskcode(ci_accountnumber in varchar2) is
400: select p.risk_code
401: from hz_cust_accounts a,
402: hz_customer_profiles p
403: where a.account_number = ci_accountnumber and
404: p.status = 'A' and
405: a.status = 'A' and
406: p.site_use_id is null and