APPS.IGS_DA_PURGE_RQST_PKG dependencies on IGS_DA_CNFG_REQ_TYP

Line 159: igs_da_cnfg_req_typ dacr,

155: dar.requestor_id
156: FROM igs_da_rqst dar,
157: igs_pe_person_base_v pbv1,
158: igs_da_cnfg dac,
159: igs_da_cnfg_req_typ dacr,
160: fnd_lookup_values_vl flv
161: WHERE dacr.request_type_id = dar.request_type_id
162: AND dacr.purgable_ind = 'Y'
163: AND flv.lookup_type = 'IGS_DA_RQST_STATUS'

Line 177: igs_da_cnfg_req_typ.request_type_id%TYPE) IS

173: AND dac.request_type_id(+) = dar.request_type_id ;
174:
175: --
176: CURSOR cur_request_type (cp_request_type_id
177: igs_da_cnfg_req_typ.request_type_id%TYPE) IS
178: SELECT dacr.request_name,
179: dacr.request_type_meaning,
180: dacr.request_mode_meaning
181: FROM igs_da_cnfg_req_typ_v dacr

Line 181: FROM igs_da_cnfg_req_typ_v dacr

177: igs_da_cnfg_req_typ.request_type_id%TYPE) IS
178: SELECT dacr.request_name,
179: dacr.request_type_meaning,
180: dacr.request_mode_meaning
181: FROM igs_da_cnfg_req_typ_v dacr
182: WHERE dacr.request_type_id = cp_request_type_id;
183: --
184: CURSOR cur_req_stdnts (cp_batch_id igs_da_rqst.batch_id%TYPE) IS
185: SELECT ROWID