APPS.HR_GENERAL2 dependencies on PER_ALL_PEOPLE_F

Line 303: FROM per_all_people_f per

299: INTO l_dummy
300: FROM dual
301: WHERE EXISTS
302: (SELECT 1
303: FROM per_all_people_f per
304: WHERE l_session_date BETWEEN per.effective_start_date
305: AND per.effective_end_date
306: AND per.national_identifier=p_national_identifier)
307: or EXISTS

Line 346: FROM per_all_people_f per

342: INTO l_dummy
343: FROM dual
344: WHERE EXISTS
345: (SELECT 1
346: FROM per_all_people_f per
347: WHERE l_session_date BETWEEN per.effective_start_date
348: AND per.effective_end_date
349: AND per.national_identifier=p_national_identifier)
350: or EXISTS

Line 418: FROM per_all_people_f per

414: INTO l_dummy
415: FROM dual
416: WHERE EXISTS
417: (SELECT 1
418: FROM per_all_people_f per
419: WHERE l_session_date BETWEEN per.effective_start_date
420: AND per.effective_end_date
421: AND per.national_identifier=p_national_identifier)
422: or EXISTS

Line 532: FROM PER_ALL_PEOPLE_F per

528: SELECT 1
529: INTO dummy_value
530: FROM dual
531: WHERE EXISTS (SELECT 1
532: FROM PER_ALL_PEOPLE_F per
533: WHERE per.party_id=p_party_id
534: AND per.business_group_id=Hr_General.get_business_Group_id);
535:
536: return_value:=get_dup_no_security_char;

Line 1317: FROM per_all_people_f per

1313: ,org.NAME org_name
1314: ,adr.postal_code postal_code
1315: ,SUBSTR(per.national_identifier,-4,4) national_identifier
1316: ,per.business_group_id bg_id
1317: FROM per_all_people_f per
1318: ,per_all_assignments_f ass
1319: ,per_business_groups_perf bg
1320: ,hr_locations_all loc
1321: ,hr_all_organization_units org

Line 1450: p_business_group_id in per_all_people_f.business_group_id%TYPE

1446: -- |---------< is_duplicate_person function ( FOR SSHR returns XML CLOB) >--|
1447: -- --------------------------------------------------------------------------
1448:
1449: procedure is_duplicate_person(
1450: p_business_group_id in per_all_people_f.business_group_id%TYPE
1451: ,p_first_name IN VARCHAR2
1452: ,p_last_name IN VARCHAR2
1453: ,p_national_identifier IN VARCHAR2
1454: ,p_date_of_birth IN DATE

Line 1644: from per_all_people_f per

1640: org.name "OrgName",
1641: adr.postal_code "PostalCode",
1642: SUBSTR(per.national_identifier,-4,4) "NationalIdentifier",
1643: per.business_group_id "BusinessGroupId"
1644: from per_all_people_f per
1645: ,per_all_assignments_f ass
1646: ,hr_all_organization_units_tl bg
1647: ,hr_locations_all_tl loc
1648: ,hr_all_organization_units_tl org

Line 1689: and not exists (select 'x' from per_all_people_f per

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)
1688: and l_session_date between nvl(pty.effective_start_date,l_session_date) and nvl(pty.effective_end_date,l_session_date)
1689: and not exists (select 'x' from per_all_people_f per
1690: where per.party_id = p.party_id
1691: and l_session_date between nvl(per.effective_start_date,l_session_date) and nvl(per.effective_end_date,l_session_date) );*/
1692:
1693: qryCtx := dbms_xmlgen.newContext(rc);

Line 1746: FROM per_all_people_f per

1742: ,org.NAME "OrgName"
1743: ,adr.postal_code "PostalCode"
1744: ,SUBSTR(per.national_identifier,-4,4) "NationalIdentifier"
1745: ,per.business_group_id "BusinessGroupId"
1746: FROM per_all_people_f per
1747: ,per_all_assignments_f ass
1748: ,per_business_groups_perf bg
1749: ,hr_locations_all loc
1750: ,hr_all_organization_units org