57: dummy1 := NULL;
58:
59: BEGIN
60: -- Check if this Org Structure is used for burdening'
61: /* Bug 5405854: The check has to be made from pa_ind_rate_sch_revisions
62: as this has the details about the burden schedule revisions.
63: We should not be looking at the hierarchy attached at the
64: Business group.
65: SELECT 'X'
75: INTO dummy1
76: FROM sys.dual
77: WHERE exists (
78: SELECT 'X'
79: FROM pa_ind_rate_sch_revisions ind
80: WHERE ind.organization_structure_id = p_org_structure_id
81: );
82: EXCEPTION
83: WHEN NO_DATA_FOUND THEN
131: dummy1 := NULL;
132:
133: BEGIN
134: -- Check if this Org Structure is used for burdening
135: /* Bug 5405854: The check has to be made from pa_ind_rate_sch_revisions
136: as this has the details about the burden schedule revisions.
137: We should not be looking at the hierarchy attached at the
138: Business group.
139: SELECT 'X'
149: INTO dummy1
150: FROM sys.dual
151: WHERE exists (
152: SELECT 'X'
153: FROM pa_ind_rate_sch_revisions ind
154: WHERE ind.org_structure_version_id = p_org_structure_version_id
155: );
156:
157: EXCEPTION
200: AND pai.exp_org_structure_version_id = ose.org_structure_version_id
201: AND pai.exp_start_org_id = ose.organization_id_child
202: UNION /* Added for bug 5405854 - Burdening start org */
203: SELECT 'X'
204: FROM pa_ind_rate_sch_revisions ind,
205: per_org_structure_elements ose
206: WHERE ose.org_structure_element_id = p_org_structure_element_id
207: AND ind.org_structure_version_id = ose.org_structure_version_id
208: AND ind.start_organization_id = ose.organization_id_child
231: dummy1 := NULL;
232:
233: BEGIN
234: -- Check if this Element is in the Project Burdening Hierarchy'
235: /* Bug 5405854: The check has to be made from pa_ind_rate_sch_revisions
236: as this has the details about the burden schedule revisions.
237: We should not be looking at the hierarchy attached at the
238: Business group.
239: SELECT 'X'