DBA Data[Home] [Help]

APPS.IGS_AD_IMP_013 dependencies on IGS_AD_HZ_ACAD_HIST

Line 1951: , dup_acad_history_id = ( SELECT hz_acad_hist_id FROM igs_Ad_Hz_Acad_Hist

1947: UPDATE IGS_AD_ACADHIS_INT_ALL acad
1948: SET
1949: status = '3'
1950: , match_ind = '20'
1951: , dup_acad_history_id = ( SELECT hz_acad_hist_id FROM igs_Ad_Hz_Acad_Hist
1952: WHERE education_id = acad.update_education_id
1953: )
1954: WHERE interface_run_id = p_interface_run_id
1955: AND status = '2'

Line 1965: , dup_acad_history_id = ( SELECT hz_acad_hist_id FROM igs_Ad_Hz_Acad_Hist

1961: UPDATE IGS_AD_ACADHIS_INT_ALL acad
1962: SET
1963: status = '3'
1964: , match_ind = '20'
1965: , dup_acad_history_id = ( SELECT hz_acad_hist_id FROM igs_Ad_Hz_Acad_Hist
1966: WHERE education_id =
1967: (SELECT education_id FROM hz_Education h1, hz_parties h2
1968: WHERE h1.party_id = acad.person_id
1969: AND h2.party_number = acad.institution_code