DBA Data[Home] [Help]

APPS.PV_ASSIGNMENT_PUB dependencies on PER_ALL_PEOPLE_F

Line 159: per_all_people_f p

155: cursor lc_get_am_org (pc_user_source_id number) is
156: select otl.name vendor_name
157: from hr_all_organization_units o,
158: hr_all_organization_units_tl otl,
159: per_all_people_f p
160: where o.organization_id = otl.organization_id
161: and otl.language = userenv('lang')
162: and o.organization_id = p.business_group_id
163: and p.person_id = pc_user_source_id;

Line 2878: per_all_people_f p

2874: IS
2875: select otl.name vendor_name
2876: from hr_all_organization_units o,
2877: hr_all_organization_units_tl otl,
2878: per_all_people_f p
2879: where o.organization_id = otl.organization_id
2880: and otl.language = userenv('lang')
2881: and o.organization_id = p.business_group_id
2882: and p.person_id = pc_source_id;

Line 3528: per_all_people_f p

3524: IS
3525: select otl.name vendor_name
3526: from hr_all_organization_units o,
3527: hr_all_organization_units_tl otl,
3528: per_all_people_f p
3529: where o.organization_id = otl.organization_id
3530: and otl.language = userenv('lang')
3531: and o.organization_id = p.business_group_id
3532: and p.person_id = pc_source_id;