DBA Data[Home] [Help]

APPS.HR_SECURITY dependencies on PER_ALL_PEOPLE_F

Line 1620: ,per_all_people_f per

1616: IS
1617: CURSOR CSR_TEAM is
1618: Select 1
1619: from irc_rec_team_members team
1620: ,per_all_people_f per
1621: ,fnd_user usr
1622: where team.vacancy_id = p_vacancy_id
1623: and team.party_id = nvl(per.party_id, usr.customer_id)
1624: and per.person_id(+) = usr.employee_id

Line 1757: IF (p_table_name = 'PER_ALL_PEOPLE_F') THEN

1753: IF (g_view_no_rows) THEN
1754: RETURN 'FALSE';
1755: END IF;
1756: --
1757: IF (p_table_name = 'PER_ALL_PEOPLE_F') THEN
1758: RETURN (show_person(p_person_id => p_unique_id,
1759: p_person_type_id => p_val1,
1760: p_employee_number => p_val2,
1761: p_applicant_number => p_val3));