APPS.PER_HIERARCHY_VERSIONS_API dependencies on PER_GEN_HIERARCHY

Line 96: From per_gen_hierarchy pgh

92: -- Cursor added for HR Calendar 2912002
93: --
94: CURSOR csr_cal_vers_exists IS
95: Select 'x'
96: From per_gen_hierarchy pgh
97: Where pgh.hierarchy_id = p_hierarchy_id
98: And pgh.type like 'PER_CAL%'
99: And exists (Select 'X'
100: From per_gen_hierarchy_versions pgv

Line 100: From per_gen_hierarchy_versions pgv

96: From per_gen_hierarchy pgh
97: Where pgh.hierarchy_id = p_hierarchy_id
98: And pgh.type like 'PER_CAL%'
99: And exists (Select 'X'
100: From per_gen_hierarchy_versions pgv
101: where pgv.hierarchy_id = p_hierarchy_id);
102: --
103: -- Declare cursors and local variables
104: --

Line 105: l_hierarchy_version_id per_gen_hierarchy_versions.hierarchy_version_id%TYPE;

101: where pgv.hierarchy_id = p_hierarchy_id);
102: --
103: -- Declare cursors and local variables
104: --
105: l_hierarchy_version_id per_gen_hierarchy_versions.hierarchy_version_id%TYPE;
106: l_proc varchar2(72) := g_package||'create_hierarchy_versions';
107: l_object_version_number per_gen_hierarchy_versions.object_version_number%TYPE;
108: l_dummy number;
109: --

Line 107: l_object_version_number per_gen_hierarchy_versions.object_version_number%TYPE;

103: -- Declare cursors and local variables
104: --
105: l_hierarchy_version_id per_gen_hierarchy_versions.hierarchy_version_id%TYPE;
106: l_proc varchar2(72) := g_package||'create_hierarchy_versions';
107: l_object_version_number per_gen_hierarchy_versions.object_version_number%TYPE;
108: l_dummy number;
109: --
110: begin
111: --

Line 532: l_object_version_number per_gen_hierarchy_versions.object_version_number%TYPE;

528: --
529: -- Declare cursors and local variables
530: --
531: l_proc varchar2(72) := g_package||'update_hierarchy_versions';
532: l_object_version_number per_gen_hierarchy_versions.object_version_number%TYPE;
533: l_temp_ovn number := p_object_version_number;
534: --
535: begin
536: --

Line 863: l_object_version_number per_gen_hierarchy_versions.object_version_number%TYPE;

859: --
860: -- Declare cursors and local variables
861: --
862: l_proc varchar2(72) := g_package||'update_hierarchy_versions';
863: l_object_version_number per_gen_hierarchy_versions.object_version_number%TYPE;
864: l_temp_ovn number := p_object_version_number;
865: --
866: begin
867: --