APPS.IBY_EVAL_AR_FACTORS_PKG dependencies on HZ_CUST_PROFILE_AMTS

Line 28: hz_cust_profile_amts p

24: cursor c_get_trxn_limit(ci_accountnumber varchar2,
25: ci_currency_code in varchar2) is
26: select p.trx_credit_limit
27: from hz_cust_accounts a,
28: hz_cust_profile_amts p
29: where a.account_number = ci_accountnumber and
30: a.status = 'A' and
31: p.currency_code = ci_currency_code and
32: p.site_use_id is null and

Line 105: hz_cust_profile_amts p

101: cursor c_get_overall_credit_limit(ci_accountnumber in varchar2,
102: ci_currency_code in varchar2) is
103: select p.overall_credit_limit,a.party_id
104: from hz_cust_accounts a,
105: hz_cust_profile_amts p
106: where a.account_number = ci_accountnumber and
107: a.status = 'A' and
108: p.currency_code = ci_currency_code and
109: p.site_use_id is null and