DBA Data[Home] [Help]

APPS.HR_SECURITY dependencies on PER_ALL_PEOPLE_F

Line 2077: ,per_all_people_f per

2073: IS
2074: CURSOR CSR_TEAM is
2075: Select 1
2076: from irc_rec_team_members team
2077: ,per_all_people_f per
2078: ,fnd_user usr
2079: where team.vacancy_id = p_vacancy_id
2080: and team.party_id = nvl(per.party_id, usr.customer_id)
2081: and per.person_id(+) = usr.employee_id

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

2225: THEN
2226: g_IS_SSHR := 1;
2227: END IF;
2228:
2229: IF (p_table_name = 'PER_ALL_PEOPLE_F') THEN
2230: IF (g_IS_SSHR = 1) THEN
2231: RETURN (show_person(p_person_id => p_unique_id,
2232: p_person_type_id => p_val1,
2233: p_employee_number => p_val2,