APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_AD_HLTH_INS_INT_ALL

Line 617: UPDATE igs_ad_hlth_ins_int_all adhi

613: status = '2' AND
614: INTERFACE_RUN_ID = l_interface_run_id;
615:
616: -- Populating the child interface table with the interface_run_id value.
617: UPDATE igs_ad_hlth_ins_int_all adhi
618: SET
619: interface_run_id=l_interface_run_id
620: WHERE adhi.status='2' AND
621: EXISTS (SELECT 1

Line 630: tabname => 'IGS_AD_HLTH_INS_INT_ALL',

626: ai.interface_run_id=l_interface_run_id);
627:
628: -- gather statistics for the table after populating it's interface_run_id
629: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
630: tabname => 'IGS_AD_HLTH_INS_INT_ALL',
631: cascade => TRUE);
632:
633: UPDATE IGS_AD_HLTH_INS_INT_all SET STATUS = '1'
634: WHERE MATCH_IND = '22' AND STATUS = '2'

Line 633: UPDATE IGS_AD_HLTH_INS_INT_all SET STATUS = '1'

629: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
630: tabname => 'IGS_AD_HLTH_INS_INT_ALL',
631: cascade => TRUE);
632:
633: UPDATE IGS_AD_HLTH_INS_INT_all SET STATUS = '1'
634: WHERE MATCH_IND = '22' AND STATUS = '2'
635: AND INTERFACE_RUN_ID = l_interface_run_id;
636:
637: Igs_Ad_Imp_007.PRC_PE_HLTH_DTLS(

Line 1376: DELETE FROM IGS_AD_HLTH_INS_INT_all WHERE

1372: -- call the procedure to store statistics in igs_ad_imp_stats
1373: pe_cat_stats('PERSON_HEALTH_INSURANCE');
1374:
1375: -- Delete from the table IGS_AD_HLTH_INS_INT
1376: DELETE FROM IGS_AD_HLTH_INS_INT_all WHERE
1377: STATUS = '1' AND interface_run_id = l_interface_run_id;
1378:
1379: -- Delete from the table igs_pe_immu_dtl_int
1380: DELETE FROM igs_pe_immu_dtl_int WHERE

Line 1585: OR EXISTS (SELECT 1 FROM igs_ad_hlth_ins_int_all ai WHERE ad.interface_id = ai.interface_id)

1581: OR EXISTS (SELECT 1 FROM igs_pe_visa_int ai WHERE ad.interface_id = ai.interface_id)
1582: OR EXISTS (SELECT 1 FROM igs_pe_passport_int ai WHERE ad.interface_id = ai.interface_id)
1583: OR EXISTS (SELECT 1 FROM igs_pe_citizen_int ai WHERE ad.interface_id = ai.interface_id)
1584: OR EXISTS (SELECT 1 FROM igs_pe_fund_src_int ai WHERE ad.interface_id = ai.interface_id)
1585: OR EXISTS (SELECT 1 FROM igs_ad_hlth_ins_int_all ai WHERE ad.interface_id = ai.interface_id)
1586: OR EXISTS (SELECT 1 FROM igs_pe_immu_dtl_int ai WHERE ad.interface_id = ai.interface_id)
1587: OR EXISTS (SELECT 1 FROM igs_ad_military_int_all ai WHERE ad.interface_id = ai.interface_id)
1588: OR EXISTS (SELECT 1 FROM igs_ad_excurr_int_all ai WHERE ad.interface_id = ai.interface_id)
1589: OR EXISTS (SELECT 1 FROM igs_pe_res_dtls_int ai WHERE ad.interface_id = ai.interface_id)

Line 1938: SELECT count(*) count1,status FROM IGS_AD_HLTH_INS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;

1934: CURSOR cur_person_immu_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1935: SELECT count(*) count1,status FROM IGS_PE_IMMU_DTL_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1936:
1937: CURSOR cur_person_health_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1938: SELECT count(*) count1,status FROM IGS_AD_HLTH_INS_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1939:
1940: CURSOR cur_person_mil_dtl_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1941: SELECT count(*) count1,status FROM IGS_AD_MILITARY_INT_ALL WHERE interface_run_id = p_interface_run_id GROUP BY status;
1942:

Line 3140: l_tab := 'IGS_AD_HLTH_INS_INT_ALL';

3136: IF l_warning IS NULL THEN
3137: l_warning := 0;
3138: END IF;
3139: l_total_rec := l_success + l_error + l_warning;
3140: l_tab := 'IGS_AD_HLTH_INS_INT_ALL';
3141: INSERT INTO IGS_AD_IMP_STATS
3142: (
3143: INTERFACE_RUN_ID,
3144: SRC_CAT_CODE,