[Home] [Help]
6860: CURSOR cur_pa_obj_rela_1(c_src_fin_version_id NUMBER,
6861: c_dest_project_id NUMBER
6862: ) IS
6863: SELECT
6864: pa_object_relationships_s.nextval,
6865: pobj.object_type_from,
6866: ppev1.element_version_id,
6867: pobj.object_type_to,
6868: ppev2.element_version_id,
7332: ,LAST_UPDATE_LOGIN
7333: ,weighting_percentage
7334: )
7335: SELECT
7336: pa_object_relationships_s.nextval
7337: ,pobj.object_type_from
7338: ,ppev1.element_version_id
7339: ,pobj.object_type_to
7340: ,ppev2.element_version_id
7875: CURSOR cur_pa_obj_rela_2(c_src_str_version_id NUMBER,
7876: c_struc_version_id NUMBER
7877: ) IS
7878: SELECT /*+ USE_HASH(ppev2 ppev1)*/
7879: pa_object_relationships_s.nextval,
7880: pobj.object_type_from,
7881: ppev1.element_version_id,
7882: pobj.object_type_to,
7883: ppev2.element_version_id,
9506: ,weighting_percentage
9507: )
9508: /*Added the hint for the bug 3513853*/
9509: /* SELECT /*+ USE_HASH(ppev2 ppev1)*/
9510: /* pa_object_relationships_s.nextval
9511: ,pobj.object_type_from
9512: ,ppev1.element_version_id
9513: ,pobj.object_type_to
9514: ,ppev2.element_version_id
10705: CURSOR cur_pa_obj_rela_3(c_src_str_version_id NUMBER,
10706: c_struc_version_id NUMBER
10707: ) IS
10708: SELECT /*+ USE_HASH(ppev2 ppev1)*/
10709: pa_object_relationships_s.nextval,
10710: pobj.object_type_from,
10711: ppev1.element_version_id,
10712: pobj.object_type_to,
10713: ppev2.element_version_id,
12464: weighting_percentage
12465: )
12466: /*Added the hint for the bug 3513853*/
12467: /* SELECT /*+ USE_HASH(ppev2 ppev1)*/
12468: /* pa_object_relationships_s.nextval,
12469: pobj.object_type_from,
12470: ppev1.element_version_id,
12471: pobj.object_type_to,
12472: ppev2.element_version_id,