DBA Data[Home] [Help]

APPS.PV_ASSIGNMENT_PUB dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 158: hr_all_organization_units_tl otl,

154:
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

Line 2877: hr_all_organization_units_tl otl,

2873: CURSOR lc_get_ven_emp_name(pc_source_id NUMBER)
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

Line 3527: hr_all_organization_units_tl otl,

3523: CURSOR lc_get_ven_emp_name(pc_source_id NUMBER)
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