APPS.EGO_ITEM_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 3128: FROM hr_all_organization_units_vl

3124: END IF;
3125: IF p_organization_name IS NULL THEN
3126: SELECT name
3127: INTO l_dummy_char
3128: FROM hr_all_organization_units_vl
3129: WHERE organization_id = p_organization_id;
3130: ELSE
3131: l_dummy_char := p_organization_name;
3132: END IF;

Line 3745: l_org_name hr_all_organization_units_vl.name%TYPE;

3741: l_dummy_number NUMBER;
3742: l_revision_master_controlled VARCHAR2(1);
3743: l_status_master_controlled VARCHAR2(1);
3744: l_is_master_org VARCHAR2(1);
3745: l_org_name hr_all_organization_units_vl.name%TYPE;
3746: l_error_message fnd_new_messages.message_name%TYPE;
3747: l_priv_function_name fnd_form_functions.function_name%TYPE;
3748: l_user_id NUMBER;
3749:

Line 3909: FROM hr_all_organization_units_vl

3905: ELSE
3906: code_debug (l_api_name ||' valid organization ');
3907: SELECT name
3908: INTO l_org_name
3909: FROM hr_all_organization_units_vl
3910: WHERE organization_id = l_organization_id;
3911: --
3912: -- validate item details
3913: --