[Home] [Help]
180: cursor check_start_org_exists is
181: (
182: SELECT 'X'
183: FROM pa_implementations_all pai,
184: per_org_structure_elements ose
185: WHERE p_org_structure_element_id = ose.org_structure_element_id /*Start-Added for bug:8285339*/
186: AND ((pai.org_structure_version_id = ose.org_structure_version_id
187: AND pai.start_organization_id = ose.organization_id_child)
188: OR (pai.proj_org_structure_version_id = ose.org_structure_version_id
191: AND pai.exp_start_org_id = ose.organization_id_child)) /*End-Added for bug:8285339*/
192: UNION /* Added for bug 5405854 - Burdening start org */
193: SELECT 'X'
194: FROM pa_ind_rate_sch_revisions ind,
195: per_org_structure_elements ose
196: WHERE ose.org_structure_element_id = p_org_structure_element_id
197: AND ind.org_structure_version_id = ose.org_structure_version_id
198: AND ind.start_organization_id = ose.organization_id_child
199:
232: FROM sys.dual
233: WHERE p_org_structure_element_id IN (
234: SELECT org_structure_element_id
235: FROM hr_organization_information info,
236: per_org_structure_elements ose
237: WHERE info.organization_id = pa_utils.business_group_id
238: AND ose.business_group_id = pa_utils.business_group_id
239: AND info.org_information_context = 'Project Burdening Hierarchy'
240: AND to_number(info.org_information2) = ose.org_structure_version_id
250: WHERE exists (
251: SELECT ics.organization_id
252: FROM pa_ind_compiled_sets ics,/*10327103 changed the table used from "pa_ind_cost_multipliers" to pa_ind_compiled_sets*/
253: pa_ind_rate_sch_revisions irr, --Bug 6074710
254: per_org_structure_elements ose
255: WHERE ose.org_structure_element_id = p_org_structure_element_id
256: /* Added below 2 conditions for bug 6074710*/
257: AND ose.org_structure_version_id = irr.org_structure_version_id
258: AND ics.ind_rate_sch_revision_id = irr.ind_rate_sch_revision_id