APPS.PER_PGH_BUS dependencies on PER_GEN_HIERARCHY

Line 29: , per_gen_hierarchy pgh

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups_perf pbg
29: , per_gen_hierarchy pgh
30: where pgh.hierarchy_id = p_hierarchy_id
31: and pbg.business_group_id (+) = pgh.business_group_id;
32: --
33: -- Declare local variables

Line 89: , per_gen_hierarchy pgh

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups_perf pbg
89: , per_gen_hierarchy pgh
90: where pgh.hierarchy_id = p_hierarchy_id
91: and pbg.business_group_id (+) = pgh.business_group_id;
92: --
93: -- Declare local variables

Line 440: ,p_descflex_name => 'PER_GEN_HIERARCHY'

436: --
437: null;
438: hr_dflex_utility.ins_or_upd_descflex_attribs
439: (p_appl_short_name => 'PER'
440: ,p_descflex_name => 'PER_GEN_HIERARCHY'
441: ,p_attribute_category => p_rec.ATTRIBUTE_CATEGORY
442: ,p_attribute1_name => 'ATTRIBUTE1'
443: ,p_attribute1_value => p_rec.attribute1
444: ,p_attribute2_name => 'ATTRIBUTE2'

Line 683: FROM per_gen_hierarchy

679: -- Cursor to check uniqueness.
680: --
681: cursor csr_unique_name IS
682: SELECT 'Y'
683: FROM per_gen_hierarchy
684: WHERE (business_group_id = p_business_group_id or p_business_group_id is null)
685: AND hierarchy_id <> nvl(p_hierarchy_id,-1)
686: AND name = p_name;
687: --

Line 862: FROM Per_Gen_Hierarchy

858: AND system_type_cd = shared_type_code;
859: --
860: CURSOR csr_hierarchy_exists IS
861: SELECT 'Y'
862: FROM Per_Gen_Hierarchy
863: WHERE type = p_type;
864: --
865: --
866: l_duplicate_name Varchar2(1) := 'Y';

Line 909: from per_gen_hierarchy_versions

905: l_proc varchar2(72) := g_package||'chk_delete';
906: --
907: cursor csr_vers_exists is
908: select 'Y'
909: from per_gen_hierarchy_versions
910: where hierarchy_id = p_hierarchy_id;
911: --
912: cursor csr_ev is
913: select 'X'