[Home] [Help]
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;
323:
324: return l_org_count;
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)))
401: CONNECT BY PRIOR e.organization_id_child = e.organization_id_parent
402: AND PRIOR e.org_structure_version_id = v.ORG_STRUCTURE_VERSION_ID
403: START WITH e.organization_id_child = p_org_id
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)))
411: CONNECT BY PRIOR e.organization_id_parent = e.organization_id_child
412: AND PRIOR e.org_structure_version_id = v.ORG_STRUCTURE_VERSION_ID
413: START WITH e.organization_id_child = p_org_id
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)))
421: CONNECT BY PRIOR e.organization_id_parent = e.organization_id_child
422: AND PRIOR e.org_structure_version_id = v.ORG_STRUCTURE_VERSION_ID
423: START WITH e.organization_id_parent = p_org_id