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.HR_GENERAL2 dependencies on HZ_PARTIES

Line 66: HZ_PARTIES so the person_last_name

62: prsundar 28-NOV-2002 115.27 Added overloaded procedure for
63: init_fndload
64: gperry 10-DEC-2002 115.28 Fixed WWBUG 2687564.
65: mbocutt 16-Dec-2002 115.29 Fixed bug 2690302. Add join to
66: HZ_PARTIES so the person_last_name
67: index can be used when duplicate
68: checking.
69: dharris 06-Jan-2003 115.30 Added the PRIVATE global var
70: g_oracle_version and PUBLIC

Line 112: SQL to join HZ_PARTIES so that index on last_name

108: for performance in JP Legislation.
109: sgelvi 31-May-2006 115.46 Added hrms_efc_column function
110: risgupta 13-OCT-2006 115.47 5599043 modified is_duplicate_person and removed logic
111: written for JP localization. Modified the other
112: SQL to join HZ_PARTIES so that index on last_name
113: can be used.
114: risgupta 27-NOV-2006 115.51 3988762 Added two overloaded function for is_duplicate_person
115: and also defined a global PL/SQL table to hold
116: duplicate records for the fix of enh duplicate person.

Line 297: from hz_parties hzp,hz_person_profiles pro

293: AND per.effective_end_date
294: AND per.national_identifier=p_national_identifier)
295: or EXISTS
296: (SELECT 1
297: from hz_parties hzp,hz_person_profiles pro
298: where UPPER(hzp.person_last_name_phonetic)=UPPER(p_last_name_phonetic)
299: AND hzp.party_id = pro.party_id
300: AND pro.effective_end_date is NULL
301: AND

Line 341: hz_parties pty

337: AND per.national_identifier=p_national_identifier)
338: or EXISTS
339: (SELECT 1
340: from hz_person_profiles pro,
341: hz_parties pty
342: where UPPER(pty.person_last_name)=UPPER(p_last_name)
343: AND pty.party_id = pro.party_id
344: AND pro.effective_end_date is NULL
345: AND

Line 413: hz_parties pty

409: AND per.national_identifier=p_national_identifier)
410: or EXISTS
411: (SELECT 1
412: from hz_person_profiles pro,
413: hz_parties pty
414: where UPPER(pty.person_last_name)=UPPER(p_last_name)
415: AND pty.party_id = pro.party_id
416: AND pro.effective_end_date is NULL
417: AND

Line 1318: hz_parties par

1314: ,NULL postal_code
1315: ,NULL national_identifier
1316: ,NULL bg_id
1317: FROM hz_person_profiles pty,
1318: hz_parties par
1319: WHERE pty.party_id = par.party_id
1320: AND par.orig_system_reference NOT LIKE 'PER%'
1321: AND par.party_type = 'PERSON'
1322: AND pty.effective_end_date is NULL

Line 1628: ,hz_parties p

1624: ,null "PostalCode"
1625: ,null "NationalIdentifier",
1626: to_number(null) "BusinessGroupId"
1627: from hz_person_profiles pty
1628: ,hz_parties p
1629: where p.party_id = pty.party_id
1630: and p.person_last_name=p_last_name
1631: and (p.person_first_name=p_first_name or p.person_first_name is null or p_first_name is null)
1632: and (pty.date_of_birth=p_date_of_birth or pty.date_of_birth is null or p_date_of_birth is null)

Line 1746: hz_parties par

1742: ,NULL "PostalCode"
1743: ,NULL "NationalIdentifier"
1744: ,NULL "BusinessGroupId"
1745: FROM hz_person_profiles pty,
1746: hz_parties par
1747: WHERE pty.party_id = par.party_id
1748: AND par.orig_system_reference NOT LIKE 'PER%'
1749: AND par.party_type = 'PERSON'
1750: AND pty.effective_end_date is NULL