APPS.PER_DB_PER_SETUP dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 73: to fnd_id_flex_structures_vl

69: 70.24 02-JUL-96 DKERR Year2000:Made date_from/date_to
70: parameters on insert_organization_unit
71: dates instead of varchar2
72: 110.1 05-AUG-97 ALOGUE Change fnd_id_flex_structures
73: to fnd_id_flex_structures_vl
74: 115.1 19-NOV-98 ALOGUE Change to insert_organization_unit
75: to insert into hr_all_organization_units
76: and hr_all_organization_units_tl.
77: 115.2 30-NOV-98 ALOGUE Amend change to insert_organization_unit

Line 426: FROM fnd_id_flex_structures_vl

422: --
423: hr_utility.set_location('per_db_per_setup.create_business_group',1);
424: SELECT id_flex_num
425: INTO l_position_num
426: FROM fnd_id_flex_structures_vl
427: WHERE id_flex_code = 'POS'
428: AND id_flex_structure_name = p_position_structure;
429: --
430: hr_utility.set_location('per_db_per_setup.create_business_group',2);

Line 433: FROM fnd_id_flex_structures_vl

429: --
430: hr_utility.set_location('per_db_per_setup.create_business_group',2);
431: SELECT id_flex_num
432: INTO l_grade_num
433: FROM fnd_id_flex_structures_vl
434: WHERE id_flex_code = 'GRD'
435: AND id_flex_structure_name = p_grade_structure;
436: --
437: hr_utility.set_location('per_db_per_setup.create_business_group',3);

Line 440: FROM fnd_id_flex_structures_vl

436: --
437: hr_utility.set_location('per_db_per_setup.create_business_group',3);
438: SELECT id_flex_num
439: INTO l_job_num
440: FROM fnd_id_flex_structures_vl
441: WHERE id_flex_code = 'JOB'
442: AND id_flex_structure_name = p_job_structure;
443: --
444: hr_utility.set_location('per_db_per_setup.create_business_group',4);

Line 447: FROM fnd_id_flex_structures_vl

443: --
444: hr_utility.set_location('per_db_per_setup.create_business_group',4);
445: SELECT id_flex_num
446: INTO l_people_group_num
447: FROM fnd_id_flex_structures_vl
448: WHERE id_flex_code = 'GRP'
449: AND id_flex_structure_name = p_people_group_structure;
450: --
451: hr_utility.set_location('per_db_per_setup.create_business_group',5);

Line 454: FROM fnd_id_flex_structures_vl

450: --
451: hr_utility.set_location('per_db_per_setup.create_business_group',5);
452: SELECT id_flex_num
453: INTO l_cost_allocation_num
454: FROM fnd_id_flex_structures_vl
455: WHERE id_flex_code = 'COST'
456: AND id_flex_structure_name = p_cost_allocation_structure;
457: --
458: hr_utility.set_location('per_db_per_setup.create_business_group',6);