APPS.IGS_AD_ACAD_HISTORY_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 98: FROM igs_pe_person_base_v

94:
95: CURSOR get_dob_dt_cur(p_person_id igs_pe_hz_parties.party_id%TYPE)
96: IS
97: SELECT birth_date
98: FROM igs_pe_person_base_v
99: WHERE person_id = p_person_id;
100:
101: tmp_var1 VARCHAR2(2000);
102: tmp_var VARCHAR2(2000);

Line 106: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;

102: tmp_var VARCHAR2(2000);
103: lv_school_party_id hz_education.school_party_id%TYPE;
104: lv_school_attended_name hz_parties.party_name%TYPE;
105: lv_degree hz_education.degree_received%TYPE;
106: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
107: /*
108: || Created By : [email protected]
109: || Created On : 07-SEP-2000
110: || Purpose : Handles the INSERT DML logic for the table.

Line 462: FROM igs_pe_person_base_v

458:
459: CURSOR get_dob_dt_cur(p_person_id igs_pe_hz_parties.party_id%TYPE)
460: IS
461: SELECT birth_date
462: FROM igs_pe_person_base_v
463: WHERE person_id = p_person_id;
464:
465: --jchin Bug 4629226 - Cursor added to check external transcripts
466:

Line 486: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;

482: lv_adv_standing_exists VARCHAR2(1) := NULL ;
483: lv_school_attended_name hz_parties.party_name%TYPE;
484: lv_school_party_id hz_education.school_party_id%TYPE ;
485: lv_degree hz_education.degree_received%TYPE;
486: l_birth_dt igs_pe_person_base_v.birth_date%TYPE;
487:
488: l_count NUMBER; --jchin Bug 4629226
489:
490: BEGIN