APPS.IGS_EN_ADD_UNITS_API dependencies on IGS_PE_TYP_INSTANCES

Line 6: g_person_type igs_pe_typ_instances.person_type_code%TYPE;

2: /* $Header: IGSEN93B.pls 120.39 2006/08/25 13:55:14 bdeviset noship $ */
3:
4: --package variables
5: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: g_person_type igs_pe_typ_instances.person_type_code%TYPE;
7:
8: TYPE l_units_rec IS RECORD (
9: uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
10: ass_ind igs_en_su_attempt.no_assessment_ind%TYPE,

Line 410: l_cur_per_typ igs_pe_typ_instances.person_type_code%TYPE;

406: SELECT person_type_code
407: FROM igs_pe_person_types
408: WHERE system_type = 'OTHER';
409:
410: l_cur_per_typ igs_pe_typ_instances.person_type_code%TYPE;
411: lv_person_type igs_pe_typ_instances.person_type_code%TYPE;
412:
413: BEGIN
414:

Line 411: lv_person_type igs_pe_typ_instances.person_type_code%TYPE;

407: FROM igs_pe_person_types
408: WHERE system_type = 'OTHER';
409:
410: l_cur_per_typ igs_pe_typ_instances.person_type_code%TYPE;
411: lv_person_type igs_pe_typ_instances.person_type_code%TYPE;
412:
413: BEGIN
414:
415: OPEN cur_per_typ;