DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_BO_PUB dependencies on HZ_CUST_PROF_CLASS_AMTS

Line 200: FROM HZ_CUST_PROF_CLASS_AMTS

196: l_default_profile_class_id NUMBER :=0;
197: i number := 0;
198: CURSOR c_profile_class_amts IS
199: SELECT PROFILE_CLASS_AMOUNT_ID
200: FROM HZ_CUST_PROF_CLASS_AMTS
201: WHERE PROFILE_CLASS_ID = l_default_profile_class_id;
202: l_cp_obj HZ_CUST_PROFILE_AMT_OBJ;
203:
204: begin

Line 214: HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (

210: EXIT WHEN c_profile_class_amts%NOTFOUND;
211: i:=i+1;
212: x_cpa_objs.EXTEND;
213: x_cpa_objs(i) := l_cp_obj;
214: HZ_CUST_PROF_CLASS_AMTS_PKG.Select_Row (
215: X_PROFILE_CLASS_AMOUNT_ID => l_profile_class_amount_id,
216: X_PROFILE_CLASS_ID => l_default_profile_class_id,
217: X_CURRENCY_CODE => x_cpa_objs(i).currency_code,
218: X_TRX_CREDIT_LIMIT => x_cpa_objs(i).trx_credit_limit,