eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ASSIGNMENT_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 157: from hr_all_organization_units o,

153: and fuser.user_id = extn.user_id;
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')

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 2876: from hr_all_organization_units o,

2872:
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')

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 3526: from hr_all_organization_units o,

3522:
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')

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