DBA Data[Home] [Help]

APPS.HXC_SUPERVISOR_DASHBOARD dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1028: hr_all_organization_units_tl hxo, hxc_temp_tcd htt

1024: DISTINCT
1025: hxo.name,
1026: htt.organization_name
1027: FROM
1028: hr_all_organization_units_tl hxo, hxc_temp_tcd htt
1029: WHERE hxo.organization_id = htt.organization_name
1030: AND htt.user_id = p_user_id
1031: AND hxo.language = userenv('LANG');
1032:

Line 3162: FROM hr_all_organization_units_tl

3158: IF p_organization IS NOT NULL
3159: THEN
3160: SELECT DISTINCT
3161: name INTO l_organization_name
3162: FROM hr_all_organization_units_tl
3163: WHERE organization_id = p_organization
3164: AND language = userenv('LANG');
3165: END IF;
3166: