APPS.PER_DB_PER_SETUP dependencies on HR_ORGANIZATION_INFORMATION

Line 276: FROM hr_organization_information hoi

272: begin
273: hr_utility.set_location('per_db_per_setup.insert_org_information',10);
274: SELECT oit.org_information_type
275: INTO l_org_information_type
276: FROM hr_organization_information hoi
277: , hr_org_info_types_by_class tbc
278: , hr_org_information_types oit
279: WHERE oit.org_information_type = p_org_information_context
280: AND oit.org_information_type = tbc.org_information_type

Line 298: FROM hr_organization_information

294: begin
295: hr_utility.set_location('per_db_per_setup.insert_org_information',15);
296: SELECT 'Y'
297: INTO l_check
298: FROM hr_organization_information
299: WHERE organization_id = l_organization_id
300: AND org_information_context = l_org_information_type
301: AND org_information1 = l_org_information1;
302: --

Line 314: SELECT hr_organization_information_s.nextval

310: exception when NO_DATA_FOUND then null;
311: end;
312: --
313: hr_utility.set_location('per_db_per_setup.insert_org_information',20);
314: SELECT hr_organization_information_s.nextval
315: INTO l_org_information_id
316: FROM sys.dual;
317: --
318: hr_utility.set_location('per_db_per_setup.insert_org_information',25);

Line 319: INSERT INTO HR_ORGANIZATION_INFORMATION

315: INTO l_org_information_id
316: FROM sys.dual;
317: --
318: hr_utility.set_location('per_db_per_setup.insert_org_information',25);
319: INSERT INTO HR_ORGANIZATION_INFORMATION
320: (org_information_id
321: ,organization_id
322: ,attribute_category
323: ,org_information_context