APPS.IGS_AD_IMP_008 dependencies on IGS_AD_ACAD_HISTORY_V

Line 2342: FROM IGS_AD_ACAD_HISTORY_V a

2338: P_Rel_Person_ID NUMBER,
2339: p_end_Date Igs_Ad_Relacad_Int.end_Date%TYPE
2340: ) IS
2341: SELECT *
2342: FROM IGS_AD_ACAD_HISTORY_V a
2343: WHERE a.institution_code = P_Institution_Code
2344: AND ((TRUNC(a.Start_Date) = TRUNC(P_Start_Date)) OR (a.start_date IS NULL AND P_Start_Date IS NULL))
2345: AND ((TRUNC(a.end_Date) = TRUNC(p_end_date)) OR (a.end_date IS NULL AND p_end_date IS NULL))
2346: AND a.person_id = P_Rel_Person_ID;

Line 2393: FROM igs_ad_acad_history_v ah

2389: h1.last_date_attended) IS NOT NULL;
2390: l_Academic_His_partial c_Academic_His_partial%ROWTYPE;
2391: CURSOR c_dup_cur_first (Relacad_Rec Relacad_Rec_C%ROWTYPE, P_Rel_Person_ID NUMBER ) IS
2392: SELECT ah.rowid, ah.*
2393: FROM igs_ad_acad_history_v ah
2394: WHERE person_id = P_Rel_Person_ID
2395: AND institution_code = Relacad_Rec.institution_code
2396: AND creation_date = ( SELECT min(creation_date) FROM igs_ad_acad_history_v
2397: WHERE person_id = P_Rel_Person_ID

Line 2396: AND creation_date = ( SELECT min(creation_date) FROM igs_ad_acad_history_v

2392: SELECT ah.rowid, ah.*
2393: FROM igs_ad_acad_history_v ah
2394: WHERE person_id = P_Rel_Person_ID
2395: AND institution_code = Relacad_Rec.institution_code
2396: AND creation_date = ( SELECT min(creation_date) FROM igs_ad_acad_history_v
2397: WHERE person_id = P_Rel_Person_ID
2398: AND institution_code = Relacad_Rec.institution_code);
2399:
2400: dup_cur_first_rec c_dup_cur_first%ROWTYPE;

Line 2410: l_row_id IGS_AD_ACAD_HISTORY_V.ROW_ID%TYPE;--VARCHAR2(30);

2406: -- Person ID is added to check whether that person has academic history details.( 16-MAR-2002)
2407:
2408: l_Academic_His_Rec Academic_His_C%ROWTYPE;
2409:
2410: l_row_id IGS_AD_ACAD_HISTORY_V.ROW_ID%TYPE;--VARCHAR2(30);
2411: l_education_id NUMBER;
2412: l_object_version_number HZ_EDUCATION.OBJECT_VERSION_NUMBER%TYPE;
2413: l_return_status IGS_AD_RELATIONS_INT.STATUS%TYPE;
2414: l_msg_count NUMBER;

Line 2691: FROM Igs_Ad_Acad_History_V pe

2687: match_ind = '19'
2688: WHERE mi.Interface_Relations_Id = P_Interface_Relations_Id
2689: AND mi.status = '2'
2690: AND EXISTS ( SELECT 1
2691: FROM Igs_Ad_Acad_History_V pe
2692: WHERE pe.Institution_Code = mi.institution_code
2693: AND ((TRUNC(pe.Start_Date) = TRUNC(mi.Start_Date)) OR (pe.start_date IS NULL AND mi.Start_date IS NULL))
2694: AND ((TRUNC(pe.end_Date) = TRUNC(mi.end_date)) OR (pe.end_date IS NULL AND mi.end_date IS NULL))
2695: AND pe.person_id = P_Rel_Person_ID);

Line 2727: FROM Igs_Ad_Acad_History_V pe

2723: WHERE mi.Interface_Relations_Id = P_Interface_Relations_Id
2724: AND mi.match_ind IS NULL
2725: AND mi.status = '2'
2726: AND EXISTS ( SELECT '1'
2727: FROM Igs_Ad_Acad_History_V pe
2728: WHERE pe.person_id = P_Rel_Person_ID
2729: AND UPPER(pe.current_inst) = UPPER(mi.current_inst)
2730: AND ( (TRUNC(pe.Start_Date) = TRUNC(mi.Start_Date)) OR (pe.start_date IS NULL AND mi.Start_date is null) )
2731: AND ( (UPPER(pe.program_code) = UPPER(mi.program_code)) OR (pe.program_code IS NULL AND mi.program_code is null) )

Line 2749: FROM Igs_Ad_Acad_History_V pe

2745: WHERE mi.Interface_Relations_Id = P_Interface_Relations_Id
2746: AND mi.match_ind IS NULL
2747: AND mi.status = '2'
2748: AND EXISTS ( SELECT 1
2749: FROM Igs_Ad_Acad_History_V pe
2750: WHERE pe.Institution_Code = mi.institution_code
2751: AND ((TRUNC(pe.Start_Date) = TRUNC(mi.Start_Date)) OR (pe.start_date IS NULL AND mi.Start_date IS NULL))
2752: AND ((TRUNC(pe.end_Date) = TRUNC(mi.end_date)) OR (pe.end_date IS NULL AND mi.end_date IS NULL))
2753: AND pe.person_id = P_Rel_Person_ID);

Line 3095: FROM IGS_AD_ACAD_HISTORY_V acad

3091: FETCH c_Academic_His_partial INTO l_Academic_His_partial;
3092: CLOSE c_Academic_His_partial;
3093: IF l_Academic_His_partial.a IS NOT NULL THEN --PARTIAL
3094: SELECT COUNT(*) INTO l_count
3095: FROM IGS_AD_ACAD_HISTORY_V acad
3096: WHERE acad.person_id = p_rel_person_id
3097: AND acad.institution_code = RELACAD_REC.INSTITUTION_CODE;
3098: IF l_count >1 THEN
3099: UPDATE Igs_Ad_Relacad_Int_all