APPS.EGO_ITEM_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 3388: FROM hr_all_organization_units_vl

3384: END IF;
3385: IF p_organization_name IS NULL THEN
3386: SELECT name
3387: INTO l_dummy_char
3388: FROM hr_all_organization_units_vl
3389: WHERE organization_id = p_organization_id;
3390: ELSE
3391: l_dummy_char := p_organization_name;
3392: END IF;

Line 4005: l_org_name hr_all_organization_units_vl.name%TYPE;

4001: l_dummy_number NUMBER;
4002: l_revision_master_controlled VARCHAR2(1);
4003: l_status_master_controlled VARCHAR2(1);
4004: l_is_master_org VARCHAR2(1);
4005: l_org_name hr_all_organization_units_vl.name%TYPE;
4006: l_error_message fnd_new_messages.message_name%TYPE;
4007: l_priv_function_name fnd_form_functions.function_name%TYPE;
4008: l_user_id NUMBER;
4009: l_temp NUMBER;

Line 4200: FROM hr_all_organization_units_vl

4196: ELSE
4197: code_debug (l_api_name ||' valid organization ');
4198: SELECT name
4199: INTO l_org_name
4200: FROM hr_all_organization_units_vl
4201: WHERE organization_id = l_organization_id;
4202: --
4203: -- validate item details
4204: --