APPS.PA_ORG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 184: per_org_structure_elements ose

180: cursor check_start_org_exists is
181: (
182: SELECT 'X' /* Reporting Start Org */
183: FROM pa_implementations_all pai,
184: per_org_structure_elements ose
185: WHERE p_org_structure_element_id = ose.org_structure_element_id
186: AND pai.org_structure_version_id = ose.org_structure_version_id
187: AND pai.start_organization_id = ose.organization_id_child
188: union

Line 191: per_org_structure_elements ose

187: AND pai.start_organization_id = ose.organization_id_child
188: union
189: SELECT 'X' /* Project Start Org */
190: FROM pa_implementations_all pai,
191: per_org_structure_elements ose
192: WHERE p_org_structure_element_id = ose.org_structure_element_id
193: AND pai.proj_org_structure_version_id = ose.org_structure_version_id
194: AND pai.proj_start_org_id = ose.organization_id_child
195: union

Line 198: per_org_structure_elements ose

194: AND pai.proj_start_org_id = ose.organization_id_child
195: union
196: SELECT 'X' /* Exp Start Org */
197: FROM pa_implementations_all pai,
198: per_org_structure_elements ose
199: WHERE p_org_structure_element_id = ose.org_structure_element_id
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 */

Line 205: per_org_structure_elements ose

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
209: ) ;

Line 245: per_org_structure_elements ose

241: FROM sys.dual
242: WHERE p_org_structure_element_id IN (
243: SELECT org_structure_element_id
244: FROM hr_organization_information info,
245: per_org_structure_elements ose
246: WHERE info.organization_id = pa_utils.business_group_id
247: AND ose.business_group_id = pa_utils.business_group_id
248: AND info.org_information_context = 'Project Burdening Hierarchy'
249: AND to_number(info.org_information2) = ose.org_structure_version_id

Line 262: per_org_structure_elements ose

258: FROM sys.dual
259: WHERE exists (
260: SELECT icm.organization_id
261: FROM pa_ind_cost_multipliers icm,
262: per_org_structure_elements ose
263: WHERE ose.org_structure_element_id = p_org_structure_element_id
264: AND ose.organization_id_child = icm.organization_id);
265:
266: EXCEPTION