APPS.IGS_PE_EV_FORM_STAT_PKG dependencies on IGS_PE_TYP_INSTANCES_ALL

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

Line 97: l_end_method igs_pe_typ_instances_all.end_method%TYPE;

93: typ.end_date IS NULL ;
94:
95: l_person_type person_type%ROWTYPE;
96: l_end_date DATE;
97: l_end_method igs_pe_typ_instances_all.end_method%TYPE;
98: lv_userid NUMBER := NULL;
99:
100: BEGIN
101: IF p_insert = TRUE THEN