APPS.IGS_PE_EV_FORM_PKG dependencies on IGS_PE_PERSON_TYPES

Line 149: CURSOR per_type(cp_system_type IGS_PE_PERSON_TYPES.system_type%TYPE,cp_closed_ind igs_pe_person_types.closed_ind%TYPE) IS

145: END set_column_values;
146:
147: PROCEDURE afterrowinsertupdatedel(p_insert BOOLEAN ,p_update BOOLEAN,p_delete BOOLEAN) AS
148:
149: CURSOR per_type(cp_system_type IGS_PE_PERSON_TYPES.system_type%TYPE,cp_closed_ind igs_pe_person_types.closed_ind%TYPE) IS
150: SELECT person_type_code FROM
151: IGS_PE_PERSON_TYPES
152: WHERE system_type = cp_system_type
153: AND closed_ind = cp_closed_ind;

Line 151: IGS_PE_PERSON_TYPES

147: PROCEDURE afterrowinsertupdatedel(p_insert BOOLEAN ,p_update BOOLEAN,p_delete BOOLEAN) AS
148:
149: CURSOR per_type(cp_system_type IGS_PE_PERSON_TYPES.system_type%TYPE,cp_closed_ind igs_pe_person_types.closed_ind%TYPE) IS
150: SELECT person_type_code FROM
151: IGS_PE_PERSON_TYPES
152: WHERE system_type = cp_system_type
153: AND closed_ind = cp_closed_ind;
154:
155: CURSOR person_type (cp_system_type igs_pe_person_types.system_type%TYPE)IS

Line 155: CURSOR person_type (cp_system_type igs_pe_person_types.system_type%TYPE)IS

151: IGS_PE_PERSON_TYPES
152: WHERE system_type = cp_system_type
153: AND closed_ind = cp_closed_ind;
154:
155: CURSOR person_type (cp_system_type igs_pe_person_types.system_type%TYPE)IS
156: SELECT typ.rowid,typ.* FROM
157: igs_pe_typ_instances_all typ , igs_pe_person_types per_typ
158: WHERE
159: typ.person_id = old_references.person_id AND

Line 157: igs_pe_typ_instances_all typ , igs_pe_person_types per_typ

153: AND closed_ind = cp_closed_ind;
154:
155: CURSOR person_type (cp_system_type igs_pe_person_types.system_type%TYPE)IS
156: SELECT typ.rowid,typ.* FROM
157: igs_pe_typ_instances_all typ , igs_pe_person_types per_typ
158: WHERE
159: typ.person_id = old_references.person_id AND
160: per_typ.system_type = cp_system_type AND
161: typ.person_type_code = per_typ.person_type_code AND