APPS.PA_UTILS dependencies on PER_ORG_STRUCTURE_ELEMENTS

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

1133: BEGIN
1134: -- index on org_structure_version_id is turned off assuming there won't be
1135: -- that many version of org hierarchy. Hence better performance.
1136: -- added the below optimiser hint based on the suggestion of performance team for bug 2474299
1137: SELECT /*+ index_ffs(se1 PER_ORG_STRUCTURE_ELEMENTS_N50) */
1138: DISTINCT
1139: se1.organization_id_parent
1140: INTO
1141: X_top_org_id

Line 1143: per_org_structure_elements se1

1139: se1.organization_id_parent
1140: INTO
1141: X_top_org_id
1142: FROM
1143: per_org_structure_elements se1
1144: WHERE
1145: se1.org_structure_version_id||'' = X_org_structure_version_id
1146: AND NOT exists
1147: ( SELECT null

Line 1148: FROM per_org_structure_elements se2

1144: WHERE
1145: se1.org_structure_version_id||'' = X_org_structure_version_id
1146: AND NOT exists
1147: ( SELECT null
1148: FROM per_org_structure_elements se2
1149: WHERE se2.org_structure_version_id = X_org_structure_version_id
1150: AND se2.organization_id_child = se1.organization_id_parent );
1151:
1152: RETURN( X_top_org_id );