APPS.PAY_US_DB_PER_SETUP dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 260: FROM fnd_id_flex_structures_vl

256: --
257: hr_utility.set_location('pay_us_db_per_setup.create_business_group',1);
258: SELECT id_flex_num
259: INTO l_position_num
260: FROM fnd_id_flex_structures_vl
261: WHERE id_flex_code = 'POS'
262: AND id_flex_structure_name = p_position_structure;
263: --
264: hr_utility.set_location('pay_us_db_per_setup.create_business_group',2);

Line 267: FROM fnd_id_flex_structures_vl

263: --
264: hr_utility.set_location('pay_us_db_per_setup.create_business_group',2);
265: SELECT id_flex_num
266: INTO l_grade_num
267: FROM fnd_id_flex_structures_vl
268: WHERE id_flex_code = 'GRD'
269: AND id_flex_structure_name = p_grade_structure;
270: --
271: hr_utility.set_location('pay_us_db_per_setup.create_business_group',3);

Line 274: FROM fnd_id_flex_structures_vl

270: --
271: hr_utility.set_location('pay_us_db_per_setup.create_business_group',3);
272: SELECT id_flex_num
273: INTO l_job_num
274: FROM fnd_id_flex_structures_vl
275: WHERE id_flex_code = 'JOB'
276: AND id_flex_structure_name = p_job_structure;
277: --
278: hr_utility.set_location('pay_us_db_per_setup.create_business_group',4);

Line 281: FROM fnd_id_flex_structures_vl

277: --
278: hr_utility.set_location('pay_us_db_per_setup.create_business_group',4);
279: SELECT id_flex_num
280: INTO l_people_group_num
281: FROM fnd_id_flex_structures_vl
282: WHERE id_flex_code = 'GRP'
283: AND id_flex_structure_name = p_people_group_structure;
284: --
285: hr_utility.set_location('pay_us_db_per_setup.create_business_group',5);

Line 288: FROM fnd_id_flex_structures_vl

284: --
285: hr_utility.set_location('pay_us_db_per_setup.create_business_group',5);
286: SELECT id_flex_num
287: INTO l_cost_allocation_num
288: FROM fnd_id_flex_structures_vl
289: WHERE id_flex_code = 'COST'
290: AND id_flex_structure_name = p_cost_allocation_structure;
291: --
292: hr_utility.set_location('pay_us_db_per_setup.create_business_group',6);