APPS.IGF_SL_CL_ORIG_ACK dependencies on IGS_PE_PERSON_ID_TYP

Line 621: FROM igs_pe_person_id_typ pit_2,

617: igs_ca_inst ci,
618: igf_ap_fa_base_rec facon,
619: (SELECT api_person_id,
620: pe_person_id
621: FROM igs_pe_person_id_typ pit_2,
622: igs_pe_alt_pers_id api_2
623: WHERE api_2.person_id_type = pit_2.person_id_type
624: AND pit_2.s_person_id_type = 'SSN'
625: AND SYSDATE BETWEEN api_2.start_dt AND NVL (api_2.end_dt,SYSDATE)) pit,

Line 4824: ,igs_pe_person_id_typ pit

4820: ,api_person_id_uf prsn_ssn --unformatted ssn value
4821: ,hz.person_first_name firstname
4822: ,hz.person_last_name lastname
4823: FROM igs_pe_alt_pers_id api
4824: ,igs_pe_person_id_typ pit
4825: ,hz_parties hz
4826: WHERE api.person_id_type = pit.person_id_type
4827: AND pit.s_person_id_type = 'SSN'
4828: AND hz.party_id = api.pe_person_id

Line 5002: FROM igs_pe_person_id_typ

4998: --Who When What
4999: ------------------------------------------------------------------
5000: CURSOR c_person_id_type( cp_v_pers_id_type VARCHAR2 ) IS
5001: SELECT person_id_type
5002: FROM igs_pe_person_id_typ
5003: WHERE s_person_id_type = cp_v_pers_id_type ;
5004:
5005:
5006: l_n_msg_count NUMBER ;

Line 5012: l_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;

5008: l_v_return_status VARCHAR2(10);
5009: l_v_rowid ROWID;
5010: l_n_person_id hz_parties.party_id%TYPE;
5011: l_v_person_number hz_parties.party_number%TYPE;
5012: l_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
5013: l_n_location_ovn hz_locations.object_version_number%TYPE;
5014: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5015: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;
5016: l_v_person_first_name hz_parties.person_first_name%TYPE;