[Home] [Help]
1494: p_attribute17 =>HLTH_INS_REC.attribute17 ,
1495: p_attribute18 =>HLTH_INS_REC.attribute18 ,
1496: p_attribute19 =>HLTH_INS_REC.attribute19 ,
1497: p_attribute20 =>HLTH_INS_REC.attribute20 ,
1498: p_desc_flex_name =>'IGS_PE_HLTH_INS_ALL_FLEX' ) THEN
1499:
1500: p_error_code := 'E255';
1501: RAISE NO_DATA_FOUND;
1502: END IF;
1558: match_ind = cst_mi_val_19
1559: WHERE mi.interface_run_id = l_interface_run_id
1560: AND mi.status = cst_stat_val_2
1561: AND EXISTS ( SELECT '1'
1562: FROM igs_pe_hlth_ins_all pe, igs_ad_interface_all ii
1563: WHERE ii.interface_run_id = l_interface_run_id
1564: AND ii.interface_id = mi.interface_id
1565: AND ii.person_id = pe.person_id
1566: AND pe.insurance_cd = UPPER(mi.insurance_cd)
1595: WHERE mi.interface_run_id = l_interface_run_id
1596: AND mi.match_ind IS NULL
1597: AND mi.status = cst_stat_val_2
1598: AND EXISTS ( SELECT '1'
1599: FROM igs_pe_hlth_ins_all pe, igs_ad_interface_all ii
1600: WHERE ii.interface_run_id = l_interface_run_id
1601: AND ii.interface_id = mi.interface_id
1602: AND ii.person_id = pe.person_id
1603: AND pe.insurance_cd = UPPER(mi.insurance_cd)
1633: UPDATE igs_ad_hlth_ins_int_all mi
1634: SET status = cst_stat_val_3,
1635: match_ind = cst_mi_val_20,
1636: dup_hlth_ins_id = (SELECT health_ins_id
1637: FROM igs_pe_hlth_ins_all pe, igs_ad_interface_all ii
1638: WHERE ii.interface_run_id = l_interface_run_id
1639: AND ii.interface_id = mi.interface_id
1640: AND ii.person_id = pe.person_id
1641: AND pe.insurance_cd = UPPER(mi.insurance_cd)
1643: WHERE mi.interface_run_id = l_interface_run_id
1644: AND mi.match_ind IS NULL
1645: AND mi.status = cst_stat_val_2
1646: AND EXISTS (SELECT '1'
1647: FROM igs_pe_hlth_ins_all pe, igs_ad_interface_all ii
1648: WHERE ii.interface_run_id = l_interface_run_id
1649: AND ii.interface_id = mi.interface_id
1650: AND ii.person_id = pe.person_id
1651: AND pe.insurance_cd = UPPER(mi.insurance_cd)