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