[Home] [Help]
5: l_name gl_sets_of_books.name%TYPE;
6: BEGIN
7: SELECT gl.name
8: INTO l_name
9: FROM gl_sets_of_books gl,pa_implementations pi
10: WHERE gl.set_of_books_id = pi.set_of_books_id;
11:
12: c_company_name_header := l_name;
13:
61: P_select_column1 := 'pi.org_structure_version_id';
62: P_parent_org_id := 'pi.start_organization_id';
63: p_burden := 'and 1=1';
64: if start_org_id is null then
65: select start_organization_id into start_org_id from pa_implementations;
66: end if;
67:
68: elsif P_hierarchy_type = 'PA_EXPENDITURE_ORG' then
69: select meaning into p_select_column
78: P_select_column1 := 'pi.exp_org_structure_version_id';
79: P_parent_org_id := 'pi.exp_start_org_id';
80: p_burden := 'and 1=1';
81: if start_org_id is null then
82: select exp_start_org_id into start_org_id from pa_implementations;
83: end if;
84:
85:
86: elsif P_hierarchy_type = 'PA_PROJECT_ORG' then
97: P_select_column1 := 'pi.proj_org_structure_version_id';
98: P_parent_org_id := 'pi.proj_start_org_id';
99: p_burden := 'and 1=1';
100: if start_org_id is null then
101: select proj_start_org_id into start_org_id from pa_implementations;
102: end if;
103:
104: elsif p_Hierarchy_Type = 'PA_BURDENING_ORG' then
105: P_where_clause := 'and p.org_structure_version_id =to_number(hr2.org_information2)';
120: if start_org_id is null then
121:
122: select distinct organization_id_parent into start_org_id
123: from per_org_structure_elements a
124: ,pa_implementations b
125: ,hr_organization_information c
126: where organization_id_parent not in
127: ( select d.ORGANIZATION_ID_CHILD from per_org_structure_elements d
128: where d.org_structure_version_id = to_number(c.org_information2)