DBA Data[Home] [Help]

APPS.PO_MASS_CLOSE_PO_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 104: FROM hr_all_organization_units hou,

100: FROM po_system_parameters;
101:
102: SELECT hou.name
103: INTO p_org_name
104: FROM hr_all_organization_units hou,
105: hr_all_organization_units_tl hout
106: WHERE hou.organization_id = hout.organization_id
107: AND hout.LANGUAGE = UserEnv('LANG')
108: AND hou.organization_id = l_org_id;

Line 105: hr_all_organization_units_tl hout

101:
102: SELECT hou.name
103: INTO p_org_name
104: FROM hr_all_organization_units hou,
105: hr_all_organization_units_tl hout
106: WHERE hou.organization_id = hout.organization_id
107: AND hout.LANGUAGE = UserEnv('LANG')
108: AND hou.organization_id = l_org_id;
109: