APPS.IGS_GR_GEN_001 dependencies on IGS_PE_PERSON_BASE_V

Line 500: v_surname igs_pe_person_base_v.last_name%TYPE DEFAULT NULL;

496: cst_person CONSTANT VARCHAR2 (6) := 'PERSON';
497: cst_title CONSTANT VARCHAR2 (5) := 'TITLE';
498: cst_given_names CONSTANT VARCHAR2 (11) := 'GIVEN_NAMES';
499: cst_surname CONSTANT VARCHAR2 (7) := 'SURNAME';
500: v_surname igs_pe_person_base_v.last_name%TYPE DEFAULT NULL;
501: v_given_names igs_pe_person_base_v.first_name%TYPE DEFAULT NULL;
502: v_title igs_pe_person_base_v.title%TYPE DEFAULT NULL;
503: v_graduation_name igs_gr_graduand_all.graduation_name%TYPE DEFAULT '';
504: --

Line 501: v_given_names igs_pe_person_base_v.first_name%TYPE DEFAULT NULL;

497: cst_title CONSTANT VARCHAR2 (5) := 'TITLE';
498: cst_given_names CONSTANT VARCHAR2 (11) := 'GIVEN_NAMES';
499: cst_surname CONSTANT VARCHAR2 (7) := 'SURNAME';
500: v_surname igs_pe_person_base_v.last_name%TYPE DEFAULT NULL;
501: v_given_names igs_pe_person_base_v.first_name%TYPE DEFAULT NULL;
502: v_title igs_pe_person_base_v.title%TYPE DEFAULT NULL;
503: v_graduation_name igs_gr_graduand_all.graduation_name%TYPE DEFAULT '';
504: --
505: CURSOR c_pe IS

Line 502: v_title igs_pe_person_base_v.title%TYPE DEFAULT NULL;

498: cst_given_names CONSTANT VARCHAR2 (11) := 'GIVEN_NAMES';
499: cst_surname CONSTANT VARCHAR2 (7) := 'SURNAME';
500: v_surname igs_pe_person_base_v.last_name%TYPE DEFAULT NULL;
501: v_given_names igs_pe_person_base_v.first_name%TYPE DEFAULT NULL;
502: v_title igs_pe_person_base_v.title%TYPE DEFAULT NULL;
503: v_graduation_name igs_gr_graduand_all.graduation_name%TYPE DEFAULT '';
504: --
505: CURSOR c_pe IS
506: SELECT pe.last_name,

Line 509: FROM igs_pe_person_base_v pe

505: CURSOR c_pe IS
506: SELECT pe.last_name,
507: pe.first_name,
508: pe.title
509: FROM igs_pe_person_base_v pe
510: WHERE pe.person_id = p_person_id;
511: --
512: --
513: --