APPS.HR_GENERAL2 dependencies on HZ_PERSON_PROFILES

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 352: from hz_person_profiles pro,

348: AND per.effective_end_date
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

Line 424: from hz_person_profiles pro,

420: AND per.effective_end_date
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

Line 575: l_full_name hz_person_profiles.person_name%TYPE;

571: ,p_last_name in VARCHAR2
572: ,p_suffix in VARCHAR2)
573: RETURN VARCHAR2
574: IS
575: l_full_name hz_person_profiles.person_name%TYPE;
576: BEGIN
577: if p_title is not null
578: and p_title<>fnd_api.g_miss_char then
579: l_full_name:=l_full_name||p_title;

Line 616: l_full_name hz_person_profiles.person_name%TYPE;

612: ,p_jp_fname varchar2
613: ,p_jp_lname varchar2)
614: RETURN VARCHAR2
615: IS
616: l_full_name hz_person_profiles.person_name%TYPE;
617: BEGIN
618: IF (p_leg_code = 'JP') THEN
619: IF (p_last_name is not null
620: and p_last_name<>fnd_api.g_miss_char) THEN

Line 1371: FROM hz_person_profiles pty,

1367: ,NULL org_name
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'

Line 1682: from hz_person_profiles pty

1678: ,null "OrgName"
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)

Line 1801: FROM hz_person_profiles pty,

1797: ,NULL "OrgName"
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'