APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGS_PE_PERSON_ID_TYP

Line 16: gv_format igs_pe_person_id_typ.format_mask%TYPE := NULL;

12: g_bad_rec NUMBER := 0;
13: g_dup_rec NUMBER := 0;
14: g_review_count NUMBER := 0;
15: g_rec_not_ins BOOLEAN := TRUE;
16: gv_format igs_pe_person_id_typ.format_mask%TYPE := NULL;
17: g_setup_score igf_ap_record_match%ROWTYPE;
18: g_isir_intrface_rec igf_ap_isir_ints%ROWTYPE;
19: g_ci_cal_type igf_ap_batch_aw_map.ci_cal_type%TYPE;
20: g_ci_sequence_number igf_ap_batch_aw_map.ci_sequence_number%TYPE;

Line 2517: FROM igs_pe_person_id_typ

2513: AND SYSDATE BETWEEN altp.start_dt and NVL(altp.end_dt, SYSDATE);
2514:
2515: CURSOR person_id_type_cur ( cp_pers_id_type VARCHAR2 ) IS
2516: SELECT person_id_type
2517: FROM igs_pe_person_id_typ
2518: WHERE s_person_id_type = cp_pers_id_type ;
2519:
2520: l_pers_id_type igs_pe_person_id_typ.person_id_type%TYPE;
2521:

Line 2520: l_pers_id_type igs_pe_person_id_typ.person_id_type%TYPE;

2516: SELECT person_id_type
2517: FROM igs_pe_person_id_typ
2518: WHERE s_person_id_type = cp_pers_id_type ;
2519:
2520: l_pers_id_type igs_pe_person_id_typ.person_id_type%TYPE;
2521:
2522:
2523: CURSOR cur_lkups(cp_lkup_type VARCHAR2, cp_lkup_cd VARCHAR2) IS
2524: SELECT tag

Line 2533: lv_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;

2529:
2530:
2531: ln_person_number hz_parties.party_number%TYPE;
2532: ln_person_id igf_ap_fa_base_rec.person_id%TYPE;
2533: lv_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
2534: alt_person_id_rec alt_person_id_cur%ROWTYPE;
2535: ln_msg_count NUMBER;
2536: lv_msg_data VARCHAR2(2000);
2537: lv_return_status VARCHAR2(1);

Line 3325: FROM igs_pe_person_id_typ

3321: */
3322:
3323: CURSOR person_id_type_cur ( cp_pers_id_type VARCHAR2 ) IS
3324: SELECT person_id_type
3325: FROM igs_pe_person_id_typ
3326: WHERE s_person_id_type = cp_pers_id_type ;
3327:
3328: CURSOR cur_lookups (p_lkup_type igf_lookups_view.Lookup_type%TYPE,
3329: p_lkup_code igf_lookups_view.Lookup_code%TYPE) IS

Line 3339: lv_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;

3335:
3336:
3337: l_pers_id_typ VARCHAR2(30) ;
3338: ln_person_number hz_parties.party_number%TYPE;
3339: lv_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
3340: ln_msg_count NUMBER;
3341: lv_msg_data VARCHAR2(2000);
3342: lv_return_status VARCHAR2(1);
3343: lv_row_id VARCHAR2(30);

Line 4512: FROM igs_pe_alt_pers_id apii, igs_pe_person_id_typ pit

4508: hz.email_address email_address,
4509: hp.date_of_birth date_of_birth,
4510: hp.gender gender
4511: FROM ( SELECT apii.pe_person_id, apii.api_person_id_uf
4512: FROM igs_pe_alt_pers_id apii, igs_pe_person_id_typ pit
4513: WHERE apii.person_id_type = pit.person_id_type
4514: AND pit.s_person_id_type = 'SSN'
4515: AND SYSDATE BETWEEN apii.start_dt AND NVL (apii.end_dt, SYSDATE)) api,
4516: hz_parties hz,

Line 7659: FROM igs_pe_person_id_typ

7655:
7656:
7657: CURSOR cur_format IS
7658: SELECT NVL(format_mask,'999999999')
7659: FROM igs_pe_person_id_typ
7660: WHERE s_person_id_type = 'SSN';
7661:
7662: l_formated_ssn VARCHAR2(30);
7663: cur NUMBER(15);