eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on HZ_PERSON_PROFILES

Line 4056: l_oss_gender hz_person_profiles.gender%TYPE;

4052: WHERE lookup_type = cp_lkup_type
4053: AND lookup_code = cp_lkup_cd
4054: AND enabled_flag = 'Y';
4055:
4056: l_oss_gender hz_person_profiles.gender%TYPE;
4057:
4058:
4059: CURSOR chk_match_dtls_exists_cur(cp_apm_id NUMBER, cp_person_id NUMBER) IS
4060: SELECT ad.rowid row_id, ad.*

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

4399: TYPE addresstab IS TABLE OF hz_parties.address1%TYPE;
4400: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
4401: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
4402: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;
4403: TYPE dobtab IS TABLE OF hz_person_profiles.date_of_birth%TYPE;
4404: TYPE gendertab IS TABLE OF hz_person_profiles.gender%TYPE;
4405: TYPE totmatchscoretab IS TABLE OF NUMBER;
4406:
4407: t_rec_tab RecTab;

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

4400: TYPE citytab IS TABLE OF hz_parties.city%TYPE;
4401: TYPE postalcodetab IS TABLE OF hz_parties.postal_code%TYPE;
4402: TYPE emailaddresstab IS TABLE OF hz_parties.email_address%TYPE;
4403: TYPE dobtab IS TABLE OF hz_person_profiles.date_of_birth%TYPE;
4404: TYPE gendertab IS TABLE OF hz_person_profiles.gender%TYPE;
4405: TYPE totmatchscoretab IS TABLE OF NUMBER;
4406:
4407: t_rec_tab RecTab;
4408: t_pid_tab PersonIdTab;

Line 4517: hz_person_profiles hp

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,
4517: hz_person_profiles hp
4518: WHERE hz.party_id = api.pe_person_id(+)
4519: AND hz.party_id = hp.party_id
4520: AND hp.effective_end_date IS NULL
4521: AND (api.api_person_id_uf = lv_ssn

Line 4547: hz_person_profiles hp

4543: FROM per_all_people_f ppf,
4544: per_business_groups_perf pbg,
4545: per_person_types ppt,
4546: hz_parties hz,
4547: hz_person_profiles hp
4548: WHERE IGS_EN_GEN_001.Check_HRMS_Installed = 'Y'
4549: AND pbg.legislation_code = 'US'
4550: AND ppt.system_person_type = 'EMP'
4551: AND ppt.person_type_id = ppf.person_type_id