APPS.EGO_ITEM_LC_IMP_PC_PUB dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 1073: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.NAME%TYPE;

1069: l_status_code_itm mtl_pending_item_status.status_code%TYPE;
1070: l_status_code_def mtl_pending_item_status.status_code%TYPE;
1071: l_pending_rec_count NUMBER;
1072: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1073: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.NAME%TYPE;
1074: l_dummy_char VARCHAR2(32767);
1075: l_approval_status mtl_system_items_b.approval_status%TYPE;
1076: l_priv_name_to_check VARCHAR2(100);
1077:

Line 1209: FROM hr_all_organization_units_vl

1205: AND ORGANIZATION_ID = p_organization_id;
1206: fnd_message.set_token('ITEM_NUMBER', l_dummy_char);
1207: SELECT name
1208: INTO l_dummy_char
1209: FROM hr_all_organization_units_vl
1210: WHERE organization_id = p_organization_id;
1211: fnd_message.set_token('ORGANIZATION', l_dummy_char);
1212: fnd_msg_pub.Add;
1213: RAISE FND_API.G_EXC_ERROR;