APPS.HR_GENERAL2 dependencies on PER_ALL_PEOPLE_F

Line 291: FROM per_all_people_f per

287: INTO l_dummy
288: FROM dual
289: WHERE EXISTS
290: (SELECT 1
291: FROM per_all_people_f per
292: WHERE l_session_date BETWEEN per.effective_start_date
293: AND per.effective_end_date
294: AND per.national_identifier=p_national_identifier)
295: or EXISTS

Line 334: FROM per_all_people_f per

330: INTO l_dummy
331: FROM dual
332: WHERE EXISTS
333: (SELECT 1
334: FROM per_all_people_f per
335: WHERE l_session_date BETWEEN per.effective_start_date
336: AND per.effective_end_date
337: AND per.national_identifier=p_national_identifier)
338: or EXISTS

Line 406: FROM per_all_people_f per

402: INTO l_dummy
403: FROM dual
404: WHERE EXISTS
405: (SELECT 1
406: FROM per_all_people_f per
407: WHERE l_session_date BETWEEN per.effective_start_date
408: AND per.effective_end_date
409: AND per.national_identifier=p_national_identifier)
410: or EXISTS

Line 493: FROM PER_ALL_PEOPLE_F per

489: SELECT 1
490: INTO dummy_value
491: FROM dual
492: WHERE EXISTS (SELECT 1
493: FROM PER_ALL_PEOPLE_F per
494: WHERE per.party_id=p_party_id
495: AND per.business_group_id=Hr_General.get_business_Group_id);
496: return_value:=get_dup_no_security_char;
497: EXCEPTION

Line 1263: FROM per_all_people_f per

1259: ,org.NAME org_name
1260: ,adr.postal_code postal_code
1261: ,SUBSTR(per.national_identifier,-4,4) national_identifier
1262: ,per.business_group_id bg_id
1263: FROM per_all_people_f per
1264: ,per_all_assignments_f ass
1265: ,per_business_groups_perf bg
1266: ,hr_locations_all loc
1267: ,hr_all_organization_units org

Line 1396: p_business_group_id in per_all_people_f.business_group_id%TYPE

1392: -- |---------< is_duplicate_person function ( FOR SSHR returns XML CLOB) >--|
1393: -- --------------------------------------------------------------------------
1394:
1395: procedure is_duplicate_person(
1396: p_business_group_id in per_all_people_f.business_group_id%TYPE
1397: ,p_first_name IN VARCHAR2
1398: ,p_last_name IN VARCHAR2
1399: ,p_national_identifier IN VARCHAR2
1400: ,p_date_of_birth IN DATE

Line 1589: from per_all_people_f per

1585: org.name "OrgName",
1586: adr.postal_code "PostalCode",
1587: SUBSTR(per.national_identifier,-4,4) "NationalIdentifier",
1588: per.business_group_id "BusinessGroupId"
1589: from per_all_people_f per
1590: ,per_all_assignments_f ass
1591: ,hr_all_organization_units_tl bg
1592: ,hr_locations_all_tl loc
1593: ,hr_all_organization_units_tl org

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

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)
1633: and l_session_date between nvl(pty.effective_start_date,l_session_date) and nvl(pty.effective_end_date,l_session_date)
1634: and not exists (select 'x' from per_all_people_f per
1635: where per.party_id = p.party_id
1636: and l_session_date between nvl(per.effective_start_date,l_session_date) and nvl(per.effective_end_date,l_session_date) );*/
1637:
1638: qryCtx := dbms_xmlgen.newContext(rc);

Line 1691: FROM per_all_people_f per

1687: ,org.NAME "OrgName"
1688: ,adr.postal_code "PostalCode"
1689: ,SUBSTR(per.national_identifier,-4,4) "NationalIdentifier"
1690: ,per.business_group_id "BusinessGroupId"
1691: FROM per_all_people_f per
1692: ,per_all_assignments_f ass
1693: ,per_business_groups_perf bg
1694: ,hr_locations_all loc
1695: ,hr_all_organization_units org