eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FPA_UTILS_PVT dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 397: ,PER_ORG_STRUCTURE_VERSIONS 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)))
401: CONNECT BY PRIOR e.organization_id_child = e.organization_id_parent

Line 407: ,PER_ORG_STRUCTURE_VERSIONS v

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)))
411: CONNECT BY PRIOR e.organization_id_parent = e.organization_id_child

Line 417: ,PER_ORG_STRUCTURE_VERSIONS v

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)))
421: CONNECT BY PRIOR e.organization_id_parent = e.organization_id_child