APPS.IBY_EVAL_AR_FACTORS_PKG dependencies on HZ_CUST_ACCOUNTS

Line 27: from hz_cust_accounts a,

23: */
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

Line 104: from hz_cust_accounts a,

100: */
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

Line 116: from hz_cust_accounts

112: ** Get the customer_id
113:
114: cursor c_get_customer_id(ci_accountnumber in varchar2) is
115: select party_id
116: from hz_cust_accounts
117: where account_number = ci_accountnumber;
118: */
119:
120: /*

Line 294: from hz_cust_accounts a,

290: ** Get the creditrating code set up for the account
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

Line 401: from hz_cust_accounts a,

397: ** Get the risk code set up for the account
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