APPS.EGO_ITEM_LC_IMP_PC_PUB dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 1070: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.NAME%TYPE;

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

Line 1200: FROM hr_all_organization_units_vl

1196: AND ORGANIZATION_ID = p_organization_id;
1197: fnd_message.set_token('ITEM_NUMBER', l_dummy_char);
1198: SELECT name
1199: INTO l_dummy_char
1200: FROM hr_all_organization_units_vl
1201: WHERE organization_id = p_organization_id;
1202: fnd_message.set_token('ORGANIZATION', l_dummy_char);
1203: fnd_msg_pub.Add;
1204: RAISE FND_API.G_EXC_ERROR;