APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_AD_ACAD_HISTORY_V

Line 1398: FROM igs_ad_acad_history_v

1394: ***************************************************************/
1395:
1396: CURSOR c_yr IS
1397: SELECT MAX(TO_NUMBER(TO_CHAR(end_date,'YYYY')))
1398: FROM igs_ad_acad_history_v
1399: WHERE person_id = p_person_id
1400: AND end_date < p_com_dt;
1401:
1402: l_end_date NUMBER(4);

Line 5790: FROM igs_ad_acad_history_v

5786: CURSOR c_inst IS
5787: SELECT institution_code,
5788: NVL(end_date, TO_DATE('01-01-1500', 'DD-MM-YYYY')) end_date_al,
5789: creation_date
5790: FROM igs_ad_acad_history_v
5791: WHERE person_id = p_person_id
5792: AND (end_date IS NULL OR end_date < p_com_date)
5793: ORDER BY end_date_al DESC, creation_date DESC;
5794:

Line 5816: l_oss_inst_cd igs_ad_acad_history_v.institution_code%TYPE;

5812: SELECT ihp.oi_govt_institution_cd govt_institution_cd
5813: FROM igs_pe_hz_parties ihp
5814: WHERE ihp.oss_org_unit_cd = p_inst_cd;
5815:
5816: l_oss_inst_cd igs_ad_acad_history_v.institution_code%TYPE;
5817: l_year DATE;
5818: l_creation_date DATE;
5819: l_org_alternate_id igs_or_org_alt_ids_v.org_alternate_id%TYPE;
5820: l_govt_institution_cd igs_pe_hz_parties.oi_govt_institution_cd%TYPE;