APPS.PA_UTILS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 893: SELECT /*+ index_ffs(se1 PER_ORG_STRUCTURE_ELEMENTS_N50) */

889: BEGIN
890: -- index on org_structure_version_id is turned off assuming there won't be
891: -- that many version of org hierarchy. Hence better performance.
892: -- added the below optimiser hint based on the suggestion of performance team for bug 2474299
893: SELECT /*+ index_ffs(se1 PER_ORG_STRUCTURE_ELEMENTS_N50) */
894: DISTINCT
895: se1.organization_id_parent
896: INTO
897: X_top_org_id

Line 899: per_org_structure_elements se1

895: se1.organization_id_parent
896: INTO
897: X_top_org_id
898: FROM
899: per_org_structure_elements se1
900: WHERE
901: se1.org_structure_version_id||'' = X_org_structure_version_id
902: AND NOT exists
903: ( SELECT null

Line 904: FROM per_org_structure_elements se2

900: WHERE
901: se1.org_structure_version_id||'' = X_org_structure_version_id
902: AND NOT exists
903: ( SELECT null
904: FROM per_org_structure_elements se2
905: WHERE se2.org_structure_version_id = X_org_structure_version_id
906: AND se2.organization_id_child = se1.organization_id_parent );
907:
908: RETURN( X_top_org_id );