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 7006: FROM per_org_structure_elements

7002:
7003: CURSOR org_cursor
7004: IS
7005: SELECT organization_id_child org_id_child
7006: FROM per_org_structure_elements
7007: CONNECT BY PRIOR organization_id_child = organization_id_parent
7008: AND org_structure_version_id = ver_id
7009: START WITH organization_id_parent = org_id
7010: AND org_structure_version_id = ver_id

Line 7470: FROM per_org_structure_elements

7466: is
7467: CURSOR org_cursor
7468: IS
7469: SELECT organization_id_child org_id_child
7470: FROM per_org_structure_elements
7471: CONNECT BY PRIOR organization_id_child = organization_id_parent
7472: AND org_structure_version_id = ver_id
7473: START WITH organization_id_parent = org_id
7474: AND org_structure_version_id = ver_id

Line 7556: FROM per_org_structure_elements

7552:
7553: SELECT count(a.organization_id_parent)
7554: into l_count FROM
7555: ( SELECT organization_id_parent
7556: FROM per_org_structure_elements
7557: CONNECT BY PRIOR organization_id_parent = organization_id_child
7558: AND org_structure_version_id = ver_id
7559: START WITH organization_id_child = org.organization_id
7560: AND org_structure_version_id = ver_id) a

Line 7593: FROM per_org_structure_elements

7589:
7590: SELECT b.organization_id_parent
7591: into l_parent
7592: FROM (SELECT organization_id_parent
7593: FROM per_org_structure_elements
7594: CONNECT BY PRIOR organization_id_parent = organization_id_child
7595: AND org_structure_version_id = ver_id
7596: START WITH organization_id_child = org.organization_id
7597: AND org_structure_version_id = ver_id) b

Line 7754: FROM per_org_structure_elements

7750: EXCEPTION
7751: WHEN NO_DATA_FOUND THEN
7752: BEGIN
7753: SELECT organization_id_parent into l_org_id_parent
7754: FROM per_org_structure_elements
7755: WHERE organization_id_child = org_id
7756: AND org_structure_version_id = G_ORG_STRUC_VER_ID;
7757: org_override := check_for_explicit_multiplier(rate_sch_rev_id, l_org_id_parent);
7758: