APPS.IGF_SL_CL_ORIG_ACK dependencies on IGS_PE_ALT_PERS_ID

Line 622: igs_pe_alt_pers_id api_2

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,
626: hz_parties pe

Line 4816: CURSOR c_ssn(cp_v_ssn igs_pe_alt_pers_id.api_person_id_uf%TYPE) IS

4812: --
4813: --Change History:
4814: --Who When What
4815: ------------------------------------------------------------------
4816: CURSOR c_ssn(cp_v_ssn igs_pe_alt_pers_id.api_person_id_uf%TYPE) IS
4817: SELECT 'OSS' person_rec_type --source of ssn from OSS
4818: ,hz.party_number person_number
4819: ,hz.party_id person_id
4820: ,api_person_id_uf prsn_ssn --unformatted ssn value

Line 4823: FROM igs_pe_alt_pers_id api

4819: ,hz.party_id person_id
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'

Line 4855: TYPE tab_prsn_ssn_typ IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;

4851: AND igf_ap_matching_process_pkg.remove_spl_chr(ppf.national_identifier) = cp_v_ssn;
4852:
4853: TYPE tab_firstname_typ IS TABLE OF hz_parties.person_first_name%TYPE;
4854: TYPE tab_lastname_typ IS TABLE OF hz_parties.person_last_name%TYPE;
4855: TYPE tab_prsn_ssn_typ IS TABLE OF igs_pe_alt_pers_id.api_person_id_uf%TYPE;
4856: TYPE tab_personid_typ IS TABLE OF hz_parties.party_id%TYPE;
4857: TYPE tab_personnum_typ IS TABLE OF hz_parties.party_number%TYPE;
4858: TYPE tab_rec_typ IS TABLE OF VARCHAR2(30);
4859: