APPS.IGS_AD_GEN_014 dependencies on IGS_PE_PERSON_TYPES

Line 941: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;

937: v_check_course_encumb VARCHAR2(1) DEFAULT 'N';
938: v_unit_set_appl_ind VARCHAR2(1) DEFAULT 'N';
939:
940: --begin apadegal adtd001 igs.m
941: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
942: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE)
943: IS
944: SELECT person_type_code
945: FROM igs_pe_person_types

Line 942: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE)

938: v_unit_set_appl_ind VARCHAR2(1) DEFAULT 'N';
939:
940: --begin apadegal adtd001 igs.m
941: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
942: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE)
943: IS
944: SELECT person_type_code
945: FROM igs_pe_person_types
946: WHERE system_type=l_system_type;

Line 945: FROM igs_pe_person_types

941: l_person_type_code IGS_PE_PERSON_TYPES.person_type_code%TYPE;
942: CURSOR c_person_type_code(l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE)
943: IS
944: SELECT person_type_code
945: FROM igs_pe_person_types
946: WHERE system_type=l_system_type;
947: lv_rowid2 VARCHAR2(25) ;
948: lv_type_instance_id NUMBER(15);
949: lv_sysdate DATE := TRUNC(SYSDATE);