APPS.IGS_AD_IMP_011 dependencies on IGS_PE_RES_DTLS_ALL

Line 619: FROM igs_pe_res_dtls_all hi

615: res_dtl_rec res_cur%ROWTYPE;
616:
617: CURSOR chk_dup_cur ( res_dtls_cur res_cur%ROWTYPE) IS
618: SELECT rowid,hi.*
619: FROM igs_pe_res_dtls_all hi
620: WHERE hi.person_id = res_dtls_cur.person_id AND
621: hi.residency_class_cd = res_dtls_cur.residency_class_cd AND
622: hi.cal_type = res_dtls_cur.cal_type AND
623: hi.sequence_number = res_dtls_cur.sequence_number;

Line 952: FROM igs_pe_res_dtls_all pe, igs_ad_interface_all ii

948: match_ind = cst_mi_val_19
949: WHERE mi.interface_run_id = l_interface_run_id
950: AND mi.status = cst_stat_val_2
951: AND EXISTS ( SELECT '1'
952: FROM igs_pe_res_dtls_all pe, igs_ad_interface_all ii
953: WHERE ii.interface_run_id = l_interface_run_id
954: AND ii.interface_id = mi.interface_id
955: AND ii.person_id = pe.person_id
956: AND UPPER(mi.residency_class_cd) = pe.residency_class_cd

Line 990: FROM igs_pe_res_dtls_all pe, igs_ad_interface_all ii

986: WHERE mi.interface_run_id = l_interface_run_id
987: AND mi.match_ind IS NULL
988: AND mi.status = cst_stat_val_2
989: AND EXISTS ( SELECT '1'
990: FROM igs_pe_res_dtls_all pe, igs_ad_interface_all ii
991: WHERE ii.interface_run_id = l_interface_run_id
992: AND ii.interface_id = mi.interface_id
993: AND ii.person_id = pe.person_id
994: AND pe.residency_class_cd = UPPER(mi.Residency_class_cd)

Line 1031: FROM igs_pe_res_dtls_all pe, igs_ad_interface_all ii

1027: WHERE mi.interface_run_id = l_interface_run_id
1028: AND mi.match_ind IS NULL
1029: AND mi.status = cst_stat_val_2
1030: AND EXISTS (SELECT '1'
1031: FROM igs_pe_res_dtls_all pe, igs_ad_interface_all ii
1032: WHERE ii.interface_run_id = l_interface_run_id
1033: AND ii.interface_id = mi.interface_id
1034: AND ii.person_id = pe.person_id
1035: AND UPPER(mi.residency_class_cd) = pe.residency_class_cd