APPS.IGS_AD_IMP_013 dependencies on IGS_AD_ACAD_HISTORY_V

Line 982: FROM igs_ad_acad_history_v ah

978: AND a.interface_acadhis_id BETWEEN cp_min_interface_acadhis_id AND cp_max_interface_acadhis_id;
979:
980: CURSOR c_dup_cur (acad_hist_rec acad_hist%ROWTYPE ) IS
981: SELECT ah.*
982: FROM igs_ad_acad_history_v ah
983: WHERE
984: ( acad_hist_rec.update_education_id IS NULL
985: AND person_id = acad_hist_rec.person_id
986: AND institution_code = acad_hist_rec.institution_code

Line 1003: FROM igs_ad_acad_history_v ah

999: dup_cur_rec c_dup_cur %ROWTYPE;
1000: --This cursor will opened in case of first record updates.
1001: CURSOR c_dup_cur_first (acad_hist_rec acad_hist%ROWTYPE ) IS
1002: SELECT ah.*
1003: FROM igs_ad_acad_history_v ah
1004: WHERE person_id = acad_hist_rec.person_id
1005: AND institution_code = acad_hist_rec.institution_code
1006: AND CREATION_DATE =
1007: (SELECT MIN(he.creation_date) FROM hz_education he, hz_parties hz

Line 1015: FROM igs_ad_acad_history_v ah

1011:
1012:
1013: CURSOR c_dup_cur_partial (acad_hist_rec acad_hist%ROWTYPE ) IS
1014: SELECT ah.*
1015: FROM igs_ad_acad_history_v ah
1016: WHERE person_id = acad_hist_rec.person_id
1017: AND institution_code = acad_hist_rec.institution_code;
1018:
1019:

Line 1897: AND EXISTS (SELECT 1 FROM igs_ad_acad_history_v WHERE

1893: , match_ind = '23'
1894: WHERE interface_run_id = p_interface_run_id
1895: AND status = '2'
1896: AND NVL (match_ind, '15') = '15'
1897: AND EXISTS (SELECT 1 FROM igs_ad_acad_history_v WHERE
1898: person_id = acad.person_id
1899: AND NVL(current_inst, 'X') = NVL(NVL(acad.current_inst, current_inst), 'X')
1900: AND STATUS = acad.status
1901: AND NVL(degree_attempted, 'X') = NVL(NVL(acad.degree_attempted , degree_attempted ), 'X')