APPS.GCS_CURR_TREATMENTS_PKG dependencies on GCS_CURR_TREATMENTS_B

Line 45: FROM gcs_curr_treatments_b cb

41: ) IS
42:
43: CURSOR curtreat_row IS
44: SELECT rowid
45: FROM gcs_curr_treatments_b cb
46: WHERE cb.CURR_TREATMENT_ID= insert_row.CURR_TREATMENT_ID;
47:
48: BEGIN
49: IF CURR_TREATMENT_ID IS NULL THEN

Line 53: INSERT INTO gcs_curr_treatments_b

49: IF CURR_TREATMENT_ID IS NULL THEN
50: raise no_data_found;
51: END IF;
52:
53: INSERT INTO gcs_curr_treatments_b
54: (
55: CURR_TREATMENT_ID,
56: ENDING_RATE_TYPE,
57: AVERAGE_RATE_TYPE,

Line 122: FROM gcs_curr_treatments_b cb

118: OBJECT_VERSION_NUMBER
119: FROM dual
120: WHERE NOT EXISTS
121: (SELECT 1
122: FROM gcs_curr_treatments_b cb
123: WHERE cb.CURR_TREATMENT_ID= insert_row.CURR_TREATMENT_ID);
124:
125: INSERT INTO gcs_curr_treatments_tl
126: (

Line 209: UPDATE gcs_curr_treatments_b cb

205: DESCRIPTION VARCHAR2
206: ) IS
207: BEGIN
208:
209: UPDATE gcs_curr_treatments_b cb
210: SET
211: ENDING_RATE_TYPE=update_row.ENDING_RATE_TYPE,
212: AVERAGE_RATE_TYPE=update_row.AVERAGE_RATE_TYPE,
213: EQUITY_MODE_CODE=update_row.EQUITY_MODE_CODE,

Line 357: FROM GCS_CURR_TREATMENTS_B cb

353:
354: BEGIN
355: SELECT cb.last_updated_by, cb.last_update_date
356: INTO db_luby, db_ludate
357: FROM GCS_CURR_TREATMENTS_B cb
358: WHERE cb.CURR_TREATMENT_ID = load_row.CURR_TREATMENT_ID;
359:
360: -- Test for customization information
361: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,