APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on HZ_PERSON_PROFILES

Line 3939: TYPE dobtab IS TABLE OF hz_person_profiles.date_of_birth%TYPE;

3935: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
3936: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
3937: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
3938: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;
3939: TYPE dobtab IS TABLE OF hz_person_profiles.date_of_birth%TYPE;
3940: TYPE gendertab IS TABLE OF hz_person_profiles.gender%TYPE;
3941: TYPE totmatchscoretab IS TABLE OF NUMBER;
3942:
3943: t_rec_tab RecTab;

Line 3940: TYPE gendertab IS TABLE OF hz_person_profiles.gender%TYPE;

3936: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
3937: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
3938: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;
3939: TYPE dobtab IS TABLE OF hz_person_profiles.date_of_birth%TYPE;
3940: TYPE gendertab IS TABLE OF hz_person_profiles.gender%TYPE;
3941: TYPE totmatchscoretab IS TABLE OF NUMBER;
3942:
3943: t_rec_tab RecTab;
3944: t_pid_tab PersonIdTab;

Line 4063: hz_person_profiles hp

4059: WHERE apii.person_id_type = pit.person_id_type
4060: AND pit.s_person_id_type = 'SSN'
4061: AND SYSDATE BETWEEN apii.start_dt AND NVL (apii.end_dt, SYSDATE)) api,
4062: hz_parties hz,
4063: hz_person_profiles hp
4064: WHERE hz.party_id = api.pe_person_id(+)
4065: AND hz.party_id = hp.party_id
4066: AND hp.effective_end_date IS NULL
4067: AND (api.api_person_id_uf = lv_ssn

Line 4093: hz_person_profiles hp

4089: FROM per_all_people_f ppf,
4090: per_business_groups_perf pbg,
4091: per_person_types ppt,
4092: hz_parties hz,
4093: hz_person_profiles hp
4094: WHERE IGS_EN_GEN_001.Check_HRMS_Installed = 'Y'
4095: AND pbg.legislation_code = 'US'
4096: AND ppt.system_person_type = 'EMP'
4097: AND ppt.person_type_id = ppf.person_type_id