[Home] [Help]
39: if ( get_company_name <> TRUE ) then
40: raise init_error;
41: end if;
42:
43: select meaning into ndf from pa_lookups where
44: lookup_code = 'NO_DATA_FOUND' and
45: lookup_type = 'MESSAGE';
46: c_no_data_found := ndf;
47: end;
49:
50:
51: if P_hierarchy_type = 'PA_REPORTING_ORG' then
52: select meaning into p_select_column
53: From pa_lookups
54: where lookup_code = 'PA_REPORTING_ORG' and lookup_type='ALL_HIERARCHY_CLASS';
55: P_structure_id := 'and pi.organization_structure_id = pos1.organization_structure_id';
56: P_version_id := 'and pi.org_structure_version_id = posv.org_structure_version_id';
57: P_where_clause := 'and p.org_structure_version_id = pi.org_structure_version_id';
66: end if;
67:
68: elsif P_hierarchy_type = 'PA_EXPENDITURE_ORG' then
69: select meaning into p_select_column
70: From pa_lookups
71: where lookup_code = 'PA_EXPENDITURE_ORG' and lookup_type='ALL_HIERARCHY_CLASS';
72: P_structure_id := 'and pi.exp_org_structure_id = pos1.organization_structure_id';
73: P_version_id := 'and pi.exp_org_structure_version_id = posv.org_structure_version_id';
74: P_where_clause := 'and p.org_structure_version_id = pi.exp_org_structure_version_id';
84:
85:
86: elsif P_hierarchy_type = 'PA_PROJECT_ORG' then
87: select meaning into p_select_column
88: From pa_lookups
89: where lookup_code = 'PA_PROJECT_ORG' and lookup_type='ALL_HIERARCHY_CLASS';
90: P_structure_id := 'and pi.proj_org_structure_id = pos1.organization_structure_id';
91: P_version_id := 'and pi.proj_org_structure_version_id = posv.org_structure_version_id';
92:
112: P_select_column1 := 'p.organization_id_parent';
113: p_parent_org_id :='p.organization_id_parent';
114: p_burden:= 'and hr2.org_information_context ' ||'='||''''||'Project Burdening Hierarchy'||'''';
115: select meaning into p_select_column
116: From pa_lookups
117: where lookup_code = 'PA_BURDENING_ORG' and lookup_type='ALL_HIERARCHY_CLASS';
118:
119:
120: if start_org_id is null then