APPS.IGS_PE_PERS_IMP_001 dependencies on IGS_PE_CITIZEN_INT

Line 543: UPDATE igs_pe_citizen_int pci

539: WHERE MATCH_IND = '22' AND STATUS = '2'
540: AND INFORMATION_TYPE = 'PE_INT_PERM_RES'
541: AND INTERFACE_RUN_ID = l_interface_run_id;
542:
543: UPDATE igs_pe_citizen_int pci
544: SET
545: interface_run_id=l_interface_run_id
546: WHERE pci.status='2' AND
547: EXISTS (SELECT 1

Line 556: tabname => 'IGS_PE_CITIZEN_INT',

552: ai.interface_run_id=l_interface_run_id);
553:
554: -- gather statistics for the table after populating it's interface_run_id
555: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
556: tabname => 'IGS_PE_CITIZEN_INT',
557: cascade => TRUE);
558:
559: UPDATE igs_pe_citizen_int SET status = '1'
560: WHERE match_ind = '22' AND status = '2' AND

Line 559: UPDATE igs_pe_citizen_int SET status = '1'

555: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
556: tabname => 'IGS_PE_CITIZEN_INT',
557: cascade => TRUE);
558:
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

Line 1359: DELETE FROM igs_pe_citizen_int WHERE

1355:
1356: DELETE FROM IGS_PE_PASSPORT_INT WHERE
1357: STATUS = '1' AND interface_run_id = l_interface_run_id;
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;

Line 1583: OR EXISTS (SELECT 1 FROM igs_pe_citizen_int ai WHERE ad.interface_id = ai.interface_id)

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

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

1925: SELECT count(*) count1,status FROM IGS_PE_EIT_INT WHERE interface_run_id = p_interface_run_id AND
1926: information_type = p_information_type GROUP BY status;
1927:
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:

Line 2975: l_tab := 'IGS_PE_CITIZEN_INT';

2971: IF l_warning IS NULL THEN
2972: l_warning := 0;
2973: END IF;
2974: l_total_rec := l_success + l_error + l_warning;
2975: l_tab := 'IGS_PE_CITIZEN_INT';
2976: INSERT INTO IGS_AD_IMP_STATS
2977: (
2978: INTERFACE_RUN_ID,
2979: SRC_CAT_CODE,