APPS.HR_GENERAL2 dependencies on HZ_PERSON_PROFILES

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

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

Line 412: from hz_person_profiles pro,

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

Line 528: l_full_name hz_person_profiles.person_name%TYPE;

524: ,p_last_name in VARCHAR2
525: ,p_suffix in VARCHAR2)
526: RETURN VARCHAR2
527: IS
528: l_full_name hz_person_profiles.person_name%TYPE;
529: BEGIN
530: if p_title is not null
531: and p_title<>fnd_api.g_miss_char then
532: l_full_name:=l_full_name||p_title;

Line 569: l_full_name hz_person_profiles.person_name%TYPE;

565: ,p_jp_fname varchar2
566: ,p_jp_lname varchar2)
567: RETURN VARCHAR2
568: IS
569: l_full_name hz_person_profiles.person_name%TYPE;
570: BEGIN
571: IF (p_leg_code = 'JP') THEN
572: IF (p_last_name is not null
573: and p_last_name<>fnd_api.g_miss_char) THEN

Line 1317: FROM hz_person_profiles pty,

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

Line 1627: from hz_person_profiles pty

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

Line 1745: FROM hz_person_profiles pty,

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