APPS.IGS_PE_NONIMG_FORM_PKG dependencies on IGS_PE_TYP_INSTANCES_ALL

Line 170: FROM igs_pe_typ_instances_all typ , igs_pe_person_types per_typ

166: AND closed_ind = cp_closed_ind; --'N';
167:
168: CURSOR person_type(cp_system_type igs_pe_person_types.system_type%TYPE)IS
169: SELECT typ.rowid,typ.*
170: FROM igs_pe_typ_instances_all typ , igs_pe_person_types per_typ
171: WHERE per_typ.system_type = cp_system_type --'NONIMG_STUDENT'
172: AND typ.person_id = new_references.person_id
173: AND typ.person_type_code = per_typ.person_type_code
174: AND typ.end_date IS NULL ;

Line 252: CURSOR c_per_inst_rowids ( cp_person_id igs_pe_typ_instances_all.person_ID%TYPE,cp_create_method igs_pe_typ_instances_all.create_method%TYPE ) IS

248:
249: (reverse chronological order - newest change first)
250: ***************************************************************/
251:
252: CURSOR c_per_inst_rowids ( cp_person_id igs_pe_typ_instances_all.person_ID%TYPE,cp_create_method igs_pe_typ_instances_all.create_method%TYPE ) IS
253: SELECT rowid
254: FROM igs_pe_typ_instances_all
255: WHERE person_id = cp_person_id
256: AND create_method = cp_create_method --'CREATE_NONIMG_STUDENT'

Line 254: FROM igs_pe_typ_instances_all

250: ***************************************************************/
251:
252: CURSOR c_per_inst_rowids ( cp_person_id igs_pe_typ_instances_all.person_ID%TYPE,cp_create_method igs_pe_typ_instances_all.create_method%TYPE ) IS
253: SELECT rowid
254: FROM igs_pe_typ_instances_all
255: WHERE person_id = cp_person_id
256: AND create_method = cp_create_method --'CREATE_NONIMG_STUDENT'
257: AND end_method IS NULL ;
258:

Line 259: l_per_inst_rowid c_per_inst_rowids%ROWTYPE ; --igs_pe_typ_instances_all.row_id%TYPE;

255: WHERE person_id = cp_person_id
256: AND create_method = cp_create_method --'CREATE_NONIMG_STUDENT'
257: AND end_method IS NULL ;
258:
259: l_per_inst_rowid c_per_inst_rowids%ROWTYPE ; --igs_pe_typ_instances_all.row_id%TYPE;
260:
261: BEGIN
262:
263: FOR l_per_inst_rowid IN c_per_inst_rowids ( old_references.person_id,'CREATE_NONIMG_STUDENT')