APPS.IGR_IMP_003 dependencies on IGS_PE_PERSON_TYPES

Line 136: igs_pe_person_types pt

132: SELECT
133: pti.rowid,pti.*
134: FROM
135: igs_pe_typ_instances_all pti,
136: igs_pe_person_types pt
137: WHERE
138: pti.person_id = cp_person_id
139: AND pti.person_type_code = pt.person_type_code
140: AND pt.system_type = cst_PROSPECT

Line 197: CURSOR c_sys_person_type (p_person_type_code igs_pe_person_types.person_type_code%TYPE) IS

193: igs_pe_src_types
194: WHERE
195: source_type_id = cp_source_type_id;
196:
197: CURSOR c_sys_person_type (p_person_type_code igs_pe_person_types.person_type_code%TYPE) IS
198: SELECT
199: system_type
200: FROM
201: igs_pe_person_types

Line 201: igs_pe_person_types

197: CURSOR c_sys_person_type (p_person_type_code igs_pe_person_types.person_type_code%TYPE) IS
198: SELECT
199: system_type
200: FROM
201: igs_pe_person_types
202: WHERE
203: person_type_code = p_person_type_code ;
204:
205: l_sys_person_type igs_pe_person_types.system_type%TYPE;

Line 205: l_sys_person_type igs_pe_person_types.system_type%TYPE;

201: igs_pe_person_types
202: WHERE
203: person_type_code = p_person_type_code ;
204:
205: l_sys_person_type igs_pe_person_types.system_type%TYPE;
206:
207: -----------------End Cursor Declarations----------------------------------------------------
208: BEGIN
209: