DBA Data[Home] [Help]

APPS.IGS_PE_EV_FORM_STAT_PKG dependencies on IGS_PE_PERSON_TYPES

Line 88: igs_pe_typ_instances_all typ , igs_pe_person_types per_typ

84: PROCEDURE afterrowinsertupdate(p_insert BOOLEAN ,p_update BOOLEAN) AS
85:
86: CURSOR person_type(l_person_id igs_pe_ev_form.person_id%TYPE) IS
87: SELECT typ.rowid,typ.* FROM
88: igs_pe_typ_instances_all typ , igs_pe_person_types per_typ
89: WHERE
90: typ.person_id = l_person_id AND
91: per_typ.system_type = 'EXCHG_VISITOR' AND
92: typ.person_type_code = per_typ.person_type_code AND