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.PA_COST_PLUS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 257: INDEX(ose PER_ORG_STRUCTURE_ELEMENTS_FK4)

253: -- Get the set id information from its parent organization
254: --
255:
256: SELECT /*+ ORDERED
257: INDEX(ose PER_ORG_STRUCTURE_ELEMENTS_FK4)
258: INDEX(ics PA_IND_COMPILED_SETS_N1) */
259: ics.ind_compiled_set_id
260: INTO compiled_set_id
261: FROM per_org_structure_elements ose,

Line 261: FROM per_org_structure_elements ose,

257: INDEX(ose PER_ORG_STRUCTURE_ELEMENTS_FK4)
258: INDEX(ics PA_IND_COMPILED_SETS_N1) */
259: ics.ind_compiled_set_id
260: INTO compiled_set_id
261: FROM per_org_structure_elements ose,
262: pa_ind_compiled_sets ics
263: WHERE ose.organization_id_child = org_id
264: AND ose.org_structure_version_id = org_struc_ver_id
265: AND ose.organization_id_parent = ics.organization_id

Line 524: FROM per_org_structure_elements

520: --
521:
522: SELECT organization_id_parent
523: INTO defined_org_id
524: FROM per_org_structure_elements
525: WHERE
526: organization_id_child = defined_org_id
527: AND org_structure_version_id = org_struc_ver_id;
528:

Line 772: FROM per_org_structure_elements

768: IS
769: CURSOR org_cursor(ver_id NUMBER) /*Bug# 2933915 :removed bg_id for business_group_id from cursor as it is not reqd*/
770: IS
771: SELECT organization_id_child
772: FROM per_org_structure_elements
773: CONNECT BY PRIOR organization_id_child = organization_id_parent
774: AND org_structure_version_id = ver_id
775: START WITH organization_id_parent = org_id
776: AND org_structure_version_id = ver_id;

Line 946: from per_org_structure_elements

942: WHERE compiled_flag = 'Y'
943: AND ready_to_compile_flag = 'Y'
944: AND org_structure_version_id in
945: (select org_structure_version_id
946: from per_org_structure_elements
947: where organization_id_child = l_org_id
948: or organization_id_parent = l_org_id);
949:
950: Cursor orgn_cursor(ver_id in NUMBER) is

Line 952: FROM per_org_structure_elements

948: or organization_id_parent = l_org_id);
949:
950: Cursor orgn_cursor(ver_id in NUMBER) is
951: SELECT level, organization_id_child organization_id
952: FROM per_org_structure_elements
953: CONNECT BY PRIOR organization_id_child = organization_id_parent
954: AND org_structure_version_id = ver_id
955: START WITH organization_id_parent = l_org_id
956: AND org_structure_version_id = ver_id

Line 1135: INDEX(ose PER_ORG_STRUCTURE_ELEMENTS_FK4)

1131: * Get compiled set id of the parent.
1132: */
1133: /*Bug# 1851731:
1134: SELECT + ORDERED
1135: INDEX(ose PER_ORG_STRUCTURE_ELEMENTS_FK4)
1136: INDEX(ics PA_IND_COMPILED_SETS_N1)
1137: ics.ind_compiled_set_id
1138: INTO l_compiled_set_id
1139: FROM per_org_structure_elements ose,

Line 1139: FROM per_org_structure_elements ose,

1135: INDEX(ose PER_ORG_STRUCTURE_ELEMENTS_FK4)
1136: INDEX(ics PA_IND_COMPILED_SETS_N1)
1137: ics.ind_compiled_set_id
1138: INTO l_compiled_set_id
1139: FROM per_org_structure_elements ose,
1140: pa_ind_compiled_sets ics
1141: WHERE ose.organization_id_child = l_org_id
1142: AND ose.org_structure_version_id = l_org_struc_ver_id
1143: AND ose.organization_id_parent = ics.organization_id

Line 6779: FROM per_org_structure_elements

6775:
6776: CURSOR org_cursor
6777: IS
6778: SELECT organization_id_child org_id_child
6779: FROM per_org_structure_elements
6780: CONNECT BY PRIOR organization_id_child = organization_id_parent
6781: AND org_structure_version_id = ver_id
6782: START WITH organization_id_parent = org_id
6783: AND org_structure_version_id = ver_id

Line 7243: FROM per_org_structure_elements

7239: is
7240: CURSOR org_cursor
7241: IS
7242: SELECT organization_id_child org_id_child
7243: FROM per_org_structure_elements
7244: CONNECT BY PRIOR organization_id_child = organization_id_parent
7245: AND org_structure_version_id = ver_id
7246: START WITH organization_id_parent = org_id
7247: AND org_structure_version_id = ver_id

Line 7329: FROM per_org_structure_elements

7325:
7326: SELECT count(a.organization_id_parent)
7327: into l_count FROM
7328: ( SELECT organization_id_parent
7329: FROM per_org_structure_elements
7330: CONNECT BY PRIOR organization_id_parent = organization_id_child
7331: AND org_structure_version_id = ver_id
7332: START WITH organization_id_child = org.organization_id
7333: AND org_structure_version_id = ver_id) a

Line 7366: FROM per_org_structure_elements

7362:
7363: SELECT b.organization_id_parent
7364: into l_parent
7365: FROM (SELECT organization_id_parent
7366: FROM per_org_structure_elements
7367: CONNECT BY PRIOR organization_id_parent = organization_id_child
7368: AND org_structure_version_id = ver_id
7369: START WITH organization_id_child = org.organization_id
7370: AND org_structure_version_id = ver_id) b

Line 7496: FROM per_org_structure_elements

7492: EXCEPTION
7493: WHEN NO_DATA_FOUND THEN
7494: BEGIN
7495: SELECT organization_id_parent into l_org_id_parent
7496: FROM per_org_structure_elements
7497: WHERE organization_id_child = org_id
7498: AND org_structure_version_id = G_ORG_STRUC_VER_ID;
7499: org_override := check_for_explicit_multiplier(rate_sch_rev_id, l_org_id_parent);
7500: return org_override;