APPS.IGS_DA_UTILS_PKG dependencies on IGS_DA_CNFG_FTR

Line 174: FROM igs_da_cnfg_ftr cf,

170:
171: CURSOR c_req_ftrs (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
172: SELECT cf.feature_code,
173: cf.feature_value
174: FROM igs_da_cnfg_ftr cf,
175: igs_da_rqst dr
176: WHERE dr.request_type_id = cf.request_type_id
177: AND dr.batch_id = cp_batch_id
178: AND cf.feature_code IN (SELECT feature_code

Line 179: FROM igs_da_cnfg_ftr cf_in

175: igs_da_rqst dr
176: WHERE dr.request_type_id = cf.request_type_id
177: AND dr.batch_id = cp_batch_id
178: AND cf.feature_code IN (SELECT feature_code
179: FROM igs_da_cnfg_ftr cf_in
180: WHERE cf_in.request_type_id = dr.request_type_id
181: MINUS
182: SELECT feature_code
183: FROM igs_da_req_ftrs rf_in

Line 424: now insert the records (IGS_DA_CNFG_FTR) not shown to the user

420: END LOOP;
421: CLOSE c_igs_da_rqst;
422:
423: /*
424: now insert the records (IGS_DA_CNFG_FTR) not shown to the user
425: in the table IGS_DA_REQ_FTRS
426: */
427: FOR rec_req_ftrs IN c_req_ftrs(p_batch_id)
428: LOOP