DBA Data[Home] [Help]

APPS.PER_ENT_BUS dependencies on PER_GEN_HIERARCHY

Line 378: from PER_GEN_HIERARCHY_VERSIONS

374: where org_structure_version_id = p_org_structure_version_id;
375:
376: cursor csr_geo_hier(p_hierarchy_id NUMBER) is
377: select date_from, date_to
378: from PER_GEN_HIERARCHY_VERSIONS
379: where hierarchy_id = p_hierarchy_id;
380: --
381: begin
382: hr_utility.set_location('Entering:'||l_proc, 1);

Line 558: FROM per_gen_hierarchy gen

554: -- if entry is global then hierarchy must also be global
555: -- if entry not global then hierarchy must be global or in the current business group
556: CURSOR CSR_HIER IS
557: SELECT 'Y'
558: FROM per_gen_hierarchy gen
559: WHERE gen.hierarchy_id = p_hierarchy_id
560: AND gen.TYPE like 'PER_CAL%'
561: AND ( (p_business_group_id is not null and
562: (gen.business_group_id = p_business_group_id or gen.business_group_id is null))