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 309: from hz_parties hzp,hz_person_profiles pro

305: AND per.effective_end_date
306: AND per.national_identifier=p_national_identifier)
307: or EXISTS
308: (SELECT 1
309: from hz_parties hzp,hz_person_profiles pro
310: where UPPER(hzp.person_last_name_phonetic)=UPPER(p_last_name_phonetic)
311: AND hzp.party_id = pro.party_id
312: AND pro.effective_end_date is NULL
313: AND

Line 353: hz_parties pty

349: AND per.national_identifier=p_national_identifier)
350: or EXISTS
351: (SELECT 1
352: from hz_person_profiles pro,
353: hz_parties pty
354: where UPPER(pty.person_last_name)=UPPER(p_last_name)
355: AND pty.party_id = pro.party_id
356: AND pro.effective_end_date is NULL
357: AND

Line 425: hz_parties pty

421: AND per.national_identifier=p_national_identifier)
422: or EXISTS
423: (SELECT 1
424: from hz_person_profiles pro,
425: hz_parties pty
426: where UPPER(pty.person_last_name)=UPPER(p_last_name)
427: AND pty.party_id = pro.party_id
428: AND pro.effective_end_date is NULL
429: AND

Line 1372: hz_parties par

1368: ,NULL postal_code
1369: ,NULL national_identifier
1370: ,NULL bg_id
1371: FROM hz_person_profiles pty,
1372: hz_parties par
1373: WHERE pty.party_id = par.party_id
1374: AND par.orig_system_reference NOT LIKE 'PER%'
1375: AND par.party_type = 'PERSON'
1376: AND pty.effective_end_date is NULL

Line 1683: ,hz_parties p

1679: ,null "PostalCode"
1680: ,null "NationalIdentifier",
1681: to_number(null) "BusinessGroupId"
1682: from hz_person_profiles pty
1683: ,hz_parties p
1684: where p.party_id = pty.party_id
1685: and p.person_last_name=p_last_name
1686: and (p.person_first_name=p_first_name or p.person_first_name is null or p_first_name is null)
1687: and (pty.date_of_birth=p_date_of_birth or pty.date_of_birth is null or p_date_of_birth is null)

Line 1802: hz_parties par

1798: ,NULL "PostalCode"
1799: ,NULL "NationalIdentifier"
1800: ,NULL "BusinessGroupId"
1801: FROM hz_person_profiles pty,
1802: hz_parties par
1803: WHERE pty.party_id = par.party_id
1804: AND par.orig_system_reference NOT LIKE 'PER%'
1805: AND par.party_type = 'PERSON'
1806: AND pty.effective_end_date is NULL