APPS.FPA_UTILS_PVT dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 318: from per_org_structure_elements c,

314: begin
315:
316: select count(c.org_structure_element_id)
317: into l_org_count
318: from per_org_structure_elements c,
319: per_organization_structures d
320: where d.organization_structure_id = fnd_profile.VALUE('PJP_ORGANIZATION_HIERARCHY')
321: and c.business_group_id = d.business_group_id
322: and c.org_structure_element_id = p_org_id;

Line 396: FROM per_org_structure_elements e

392: from fpa_aw_portf_headers_v
393: where portfolio_class_code = p_class_code
394: and portfolio_organization in (
395: SELECT e.organization_id_child
396: FROM per_org_structure_elements e
397: ,PER_ORG_STRUCTURE_VERSIONS v
398: WHERE e.org_structure_version_id = v.ORG_STRUCTURE_VERSION_ID
399: and v.ORGANIZATION_STRUCTURE_ID = FND_PROFILE.VALUE('PJP_ORGANIZATION_HIERARCHY')
400: AND (TRUNC(SYSDATE) BETWEEN TRUNC(v.DATE_FROM) AND TRUNC(nvl(v.DATE_TO, sysdate)))

Line 406: FROM per_org_structure_elements e

402: AND PRIOR e.org_structure_version_id = v.ORG_STRUCTURE_VERSION_ID
403: START WITH e.organization_id_child = p_org_id
404: UNION
405: SELECT e.organization_id_parent
406: FROM per_org_structure_elements e
407: ,PER_ORG_STRUCTURE_VERSIONS v
408: WHERE e.org_structure_version_id = v.ORG_STRUCTURE_VERSION_ID
409: and v.ORGANIZATION_STRUCTURE_ID = FND_PROFILE.VALUE('PJP_ORGANIZATION_HIERARCHY')
410: AND (TRUNC(SYSDATE) BETWEEN TRUNC(v.DATE_FROM) AND TRUNC(nvl(v.DATE_TO, sysdate)))

Line 416: FROM per_org_structure_elements e

412: AND PRIOR e.org_structure_version_id = v.ORG_STRUCTURE_VERSION_ID
413: START WITH e.organization_id_child = p_org_id
414: UNION
415: SELECT e.organization_id_parent
416: FROM per_org_structure_elements e
417: ,PER_ORG_STRUCTURE_VERSIONS v
418: WHERE e.org_structure_version_id = v.ORG_STRUCTURE_VERSION_ID
419: and v.ORGANIZATION_STRUCTURE_ID = FND_PROFILE.VALUE('PJP_ORGANIZATION_HIERARCHY')
420: AND (TRUNC(SYSDATE) BETWEEN TRUNC(v.DATE_FROM) AND TRUNC(nvl(v.DATE_TO, sysdate)))