APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_FUND_SRC_INT

Line 563: UPDATE igs_pe_fund_src_int pfsi

559: UPDATE igs_pe_citizen_int SET status = '1'
560: WHERE match_ind = '22' AND status = '2' AND
561: INTERFACE_RUN_ID = l_interface_run_id;
562:
563: UPDATE igs_pe_fund_src_int pfsi
564: SET
565: interface_run_id=l_interface_run_id
566: WHERE pfsi.status='2' AND
567: EXISTS (SELECT 1

Line 576: tabname => 'IGS_PE_FUND_SRC_INT',

572: ai.interface_run_id=l_interface_run_id);
573:
574: -- gather statistics for the table after populating it's interface_run_id
575: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
576: tabname => 'IGS_PE_FUND_SRC_INT',
577: cascade => TRUE);
578: UPDATE igs_pe_fund_src_int SET status = '1'
579: WHERE match_ind = '22' AND status = '2'
580: AND INTERFACE_RUN_ID = l_interface_run_id;

Line 578: UPDATE igs_pe_fund_src_int SET status = '1'

574: -- gather statistics for the table after populating it's interface_run_id
575: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
576: tabname => 'IGS_PE_FUND_SRC_INT',
577: cascade => TRUE);
578: UPDATE igs_pe_fund_src_int SET status = '1'
579: WHERE match_ind = '22' AND status = '2'
580: AND INTERFACE_RUN_ID = l_interface_run_id;
581:
582: Igs_Ad_Imp_007.PRC_PE_INTL_DTLS(

Line 1362: DELETE FROM igs_pe_fund_src_int WHERE

1358:
1359: DELETE FROM igs_pe_citizen_int WHERE
1360: STATUS = '1' AND interface_run_id = l_interface_run_id;
1361:
1362: DELETE FROM igs_pe_fund_src_int WHERE
1363: STATUS = '1' AND interface_run_id = l_interface_run_id;
1364:
1365: DELETE FROM igs_pe_eit_int WHERE
1366: STATUS = '1' AND interface_run_id = l_interface_run_id;

Line 1584: OR EXISTS (SELECT 1 FROM igs_pe_fund_src_int ai WHERE ad.interface_id = ai.interface_id)

1580: OR EXISTS (SELECT 1 FROM igs_ad_emp_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)

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

1928: CURSOR cur_person_citizen_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1929: SELECT count(*) count1,status FROM IGS_PE_CITIZEN_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1930:
1931: CURSOR cur_person_fund_int (p_interface_run_id igs_ad_imp_001.g_interface_run_id%TYPE) IS
1932: SELECT count(*) count1,status FROM IGS_PE_FUND_SRC_INT WHERE interface_run_id = p_interface_run_id GROUP BY status;
1933:
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:

Line 3031: l_tab := 'IGS_PE_FUND_SRC_INT';

3027: l_warning := 0;
3028: END IF;
3029:
3030: l_total_rec := l_success + l_error + l_warning;
3031: l_tab := 'IGS_PE_FUND_SRC_INT';
3032: INSERT INTO IGS_AD_IMP_STATS
3033: (
3034: INTERFACE_RUN_ID,
3035: SRC_CAT_CODE,