APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_PE_PERSON_TYPES

Line 385: FROM IGS_PE_PERSON_TYPES_V

381:
382: CURSOR cur_per_type IS
383:
384: SELECT person_type_code
385: FROM IGS_PE_PERSON_TYPES_V
386: WHERE system_type = 'STAFF';
387:
388: BEGIN
389:

Line 904: FROM igs_pe_person_types

900: pti.END_DATE IS NULL;
901:
902: CURSOR cur_pers_type(p_system_type varchar2) IS
903: SELECT PERSON_TYPE_CODE
904: FROM igs_pe_person_types
905: WHERE SYSTEM_TYPE = p_system_type AND
906: CLOSED_IND = 'N';
907:
908: -- Cursor used to fetch the Person Type Instance record which is being opened

Line 913: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE) IS

909: -- irrespective of the system person type is closed or not.
910: -- Cursor is being created for the bug fix: 2389552
911: CURSOR cur_pe_typ_inst( p_person_id igs_pe_typ_instances.PERSON_ID%TYPE,
912: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
913: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE) IS
914: SELECT pti.rowid row_id ,pti.*
915: FROM igs_pe_typ_instances_all pti,
916: igs_pe_person_types pty
917: WHERE pti.person_id = p_person_id AND

Line 916: igs_pe_person_types pty

912: p_course_cd igs_pe_typ_instances.course_cd%TYPE,
913: p_system_type igs_pe_person_types.SYSTEM_TYPE%TYPE) IS
914: SELECT pti.rowid row_id ,pti.*
915: FROM igs_pe_typ_instances_all pti,
916: igs_pe_person_types pty
917: WHERE pti.person_id = p_person_id AND
918: pti.course_cd = p_course_cd AND
919: pti.end_date IS NULL AND
920: pty.person_type_code = pti.person_type_code AND

Line 953: l_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE;

949: v_message_name VARCHAR2(30);
950: v_save_row BOOLEAN := FALSE;
951: r_sca IGS_EN_STDNT_PS_ATT_ALL%ROWTYPE;
952: l_method igs_pe_typ_instances.CREATE_METHOD%TYPE;
953: l_person_type igs_pe_person_types.PERSON_TYPE_CODE%TYPE;
954: l_rowid VARCHAR2(25);
955: l_TYPE_INSTANCE_ID igs_pe_typ_instances.TYPE_INSTANCE_ID%TYPE;
956: cur_typ_id_inst_rec cur_typ_id_inst%ROWTYPE;
957: l_cur_find_interm cur_find_interm%ROWTYPE;