APPS.IGS_AD_IMP_007 dependencies on IGS_PE_MIL_SERVICES_ALL

Line 100: l_MILIT_SERVICE_ID igs_pe_mil_services_all.milit_service_id%TYPE;

96: l_rule VARCHAR2(1);
97: l_error_code VARCHAR2(10);
98: l_status VARCHAR2(10);
99: l_check VARCHAR2(10);
100: l_MILIT_SERVICE_ID igs_pe_mil_services_all.milit_service_id%TYPE;
101: l_processed_records NUMBER(5) := 0 ;
102: l_prog_label VARCHAR2(4000);
103: l_label VARCHAR2(4000);
104: l_debug_str VARCHAR2(4000);

Line 344: FROM igs_pe_mil_services_all pe, igs_ad_interface_all ii

340: match_ind = cst_mi_val_19
341: WHERE mi.interface_run_id = l_interface_run_id
342: AND mi.status = cst_stat_val_2
343: AND EXISTS ( SELECT '1'
344: FROM igs_pe_mil_services_all pe, igs_ad_interface_all ii
345: WHERE ii.interface_run_id = l_interface_run_id
346: AND ii.interface_id = mi.interface_id
347: AND ii.person_id = pe.person_id
348: AND pe.military_type_cd = UPPER(mi.military_type_cd)

Line 381: FROM igs_pe_mil_services_all pe, igs_ad_interface_all ii

377: WHERE mi.interface_run_id = l_interface_run_id
378: AND mi.match_ind IS NULL
379: AND mi.status = cst_stat_val_2
380: AND EXISTS ( SELECT '1'
381: FROM igs_pe_mil_services_all pe, igs_ad_interface_all ii
382: WHERE ii.interface_run_id = l_interface_run_id
383: AND ii.interface_id = mi.interface_id
384: AND ii.person_id = pe.person_id
385: AND pe.military_type_cd = UPPER(mi.military_type_cd)

Line 419: FROM igs_pe_mil_services_all pe, igs_ad_interface_all ii

415: UPDATE igs_ad_military_int_all mi
416: SET status = cst_stat_val_3,
417: match_ind = cst_mi_val_20,
418: dup_milit_service_id = (SELECT milit_service_id
419: FROM igs_pe_mil_services_all pe, igs_ad_interface_all ii
420: WHERE mi.interface_run_id = l_interface_run_id
421: AND ii.interface_id = mi.interface_id
422: AND ii.person_id = pe.person_id
423: AND pe.military_type_cd = UPPER(mi.military_type_cd)

Line 429: FROM igs_pe_mil_services_all pe, igs_ad_interface_all ii

425: WHERE mi.interface_run_id = l_interface_run_id
426: AND mi.match_ind IS NULL
427: AND mi.status = cst_stat_val_2
428: AND EXISTS (SELECT '1'
429: FROM igs_pe_mil_services_all pe, igs_ad_interface_all ii
430: WHERE ii.interface_run_id = l_interface_run_id
431: AND ii.interface_id = mi.interface_id
432: AND ii.person_id = pe.person_id
433: AND pe.military_type_cd = UPPER(mi.military_type_cd)