APPS.IGS_AD_IMP_003 dependencies on IGS_AD_APPL_PERSTAT

Line 1414: AND EXISTS (SELECT 1 FROM igs_ad_appl_perstat b

1410: error_text = l_error_text1
1411: WHERE
1412: interface_run_id = p_interface_run_id
1413: AND status = '2'
1414: AND EXISTS (SELECT 1 FROM igs_ad_appl_perstat b
1415: WHERE b.person_id = a.person_id
1416: AND b.admission_appl_number = a.admission_appl_number
1417: AND b.persl_stat_type = a.persl_stat_type
1418: AND TRUNC(b.date_received) = TRUNC(a.date_received));

Line 1425: igs_ad_appl_perstat_pkg.insert_row(

1421: BEGIN
1422:
1423: SAVEPOINT appl_pers_save;
1424: l_rowid := NULL;
1425: igs_ad_appl_perstat_pkg.insert_row(
1426: x_rowid => l_rowid,
1427: x_appl_perstat_id => l_appl_perstat_id,
1428: x_person_id => l_appl_pers_rec.person_id,
1429: x_admission_appl_number => l_appl_pers_rec.admission_appl_number,