APPS.ARH_CPCA_PKG dependencies on HZ_CUST_PROF_CLASS_AMTS

Line 58: INSERT INTO HZ_CUST_PROF_CLASS_AMTS

54: X_Jgzz_attribute15 VARCHAR2
55: ) IS
56:
57: BEGIN
58: INSERT INTO HZ_CUST_PROF_CLASS_AMTS
59: (
60: profile_class_id,
61: created_by,
62: creation_date,

Line 177: --IDENTIFY EXISTING ROW WITH NEGATIVE ID IN HZ_CUST_PROF_CLASS_AMTS

173: number_in_update number;
174:
175: BEGIN
176:
177: --IDENTIFY EXISTING ROW WITH NEGATIVE ID IN HZ_CUST_PROF_CLASS_AMTS
178: --RETRIEVE THE MIN id WHERE id BETWEEN -100*ID-99 AND -100*ID-2
179:
180: SELECT count(*), min(profile_class_amount_id) - 1
181: INTO number_in_update, X_Negative_Id

Line 182: FROM HZ_CUST_PROF_CLASS_AMTS

178: --RETRIEVE THE MIN id WHERE id BETWEEN -100*ID-99 AND -100*ID-2
179:
180: SELECT count(*), min(profile_class_amount_id) - 1
181: INTO number_in_update, X_Negative_Id
182: FROM HZ_CUST_PROF_CLASS_AMTS
183: WHERE profile_class_amount_id BETWEEN
184: (X_Cust_Prof_Class_Amount_Id) * (-100) - 99 AND
185: (X_Cust_Prof_Class_Amount_Id) * (-100) - 2;
186:

Line 202: from hz_cust_prof_class_amts

198: ) IS
199:
200: CURSOR C is
201: select *
202: from hz_cust_prof_class_amts
203: where profile_class_amount_id = X_Cust_Prof_Class_Amount_Id
204: FOR UPDATE of profile_class_amount_id NOWAIT;
205: Amountinfo C%ROWTYPE;
206: