APPS.IGS_EN_ENROLL_WLST dependencies on IGS_PE_PERSON_TYPES

Line 467: lv_person_type igs_pe_person_types.person_type_code%TYPE;

463:
464: prraj 08-Apr-2002
465:
466: ******************************************************************/
467: lv_person_type igs_pe_person_types.person_type_code%TYPE;
468:
469: CURSOR c_version_number
470: IS
471: SELECT version_number

Line 479: FROM igs_pe_person_types

475: -- Cursor to get the Person Type Code corresponding to the System Type
476: -- Added as per the bug# 2364461.
477: CURSOR cur_per_typ IS
478: SELECT person_type_code
479: FROM igs_pe_person_types
480: WHERE system_type = 'OTHER';
481: l_cur_per_typ cur_per_typ%ROWTYPE;
482:
483: lv_version_number igs_en_stdnt_ps_att.version_number%TYPE;

Line 588: lv_person_type igs_pe_person_types.person_type_code%TYPE;

584: Igs_En_Gen_002.Enrp_Get_Acad_Alt_Cd to get the academic calendar of the given
585: load calendar rather than current academic calendar for the bug fix: 2381603
586:
587: */
588: lv_person_type igs_pe_person_types.person_type_code%TYPE;
589:
590: -- Cursor to get the Person Type Code corresponding to the System Type
591: -- Added as per the bug# 2364461.
592: CURSOR cur_per_typ IS

Line 594: FROM igs_pe_person_types

590: -- Cursor to get the Person Type Code corresponding to the System Type
591: -- Added as per the bug# 2364461.
592: CURSOR cur_per_typ IS
593: SELECT person_type_code
594: FROM igs_pe_person_types
595: WHERE system_type = 'OTHER';
596: l_cur_per_typ cur_per_typ%ROWTYPE;
597:
598: lv_version_number igs_en_stdnt_ps_att.version_number%TYPE;

Line 1965: lv_person_type igs_pe_person_types.person_type_code%TYPE;

1961: Nishikant 01NOV2002 The call to the function igs_ss_enr_details.get_notification got modified to add two new
1962: parameters p_person_id, p_message.
1963: */
1964:
1965: lv_person_type igs_pe_person_types.person_type_code%TYPE;
1966:
1967: -- Cursor to get the Person Type Code corresponding to the System Type
1968: -- Added as per the bug# 2364461.
1969: CURSOR cur_per_typ IS

Line 1971: FROM igs_pe_person_types

1967: -- Cursor to get the Person Type Code corresponding to the System Type
1968: -- Added as per the bug# 2364461.
1969: CURSOR cur_per_typ IS
1970: SELECT person_type_code
1971: FROM igs_pe_person_types
1972: WHERE system_type = 'OTHER';
1973: l_cur_per_typ cur_per_typ%ROWTYPE;
1974:
1975: lv_version_number igs_en_stdnt_ps_att.version_number%TYPE;