[Home] [Help]
7109: CURSOR cur_pa_obj_rela_1(c_src_fin_version_id NUMBER,
7110: c_dest_project_id NUMBER
7111: ) IS
7112: SELECT
7113: pa_object_relationships_s.nextval,
7114: pobj.object_type_from,
7115: ppev1.element_version_id,
7116: pobj.object_type_to,
7117: ppev2.element_version_id,
7581: ,LAST_UPDATE_LOGIN
7582: ,weighting_percentage
7583: )
7584: SELECT
7585: pa_object_relationships_s.nextval
7586: ,pobj.object_type_from
7587: ,ppev1.element_version_id
7588: ,pobj.object_type_to
7589: ,ppev2.element_version_id
8124: CURSOR cur_pa_obj_rela_2(c_src_str_version_id NUMBER,
8125: c_struc_version_id NUMBER
8126: ) IS
8127: SELECT /*+ USE_HASH(ppev2 ppev1)*/
8128: pa_object_relationships_s.nextval,
8129: pobj.object_type_from,
8130: ppev1.element_version_id,
8131: pobj.object_type_to,
8132: ppev2.element_version_id,
9798: ,weighting_percentage
9799: )
9800: /*Added the hint for the bug 3513853*/
9801: /* SELECT /*+ USE_HASH(ppev2 ppev1)*/
9802: /* pa_object_relationships_s.nextval
9803: ,pobj.object_type_from
9804: ,ppev1.element_version_id
9805: ,pobj.object_type_to
9806: ,ppev2.element_version_id
11020: CURSOR cur_pa_obj_rela_3(c_src_str_version_id NUMBER,
11021: c_struc_version_id NUMBER
11022: ) IS
11023: SELECT /*+ USE_HASH(ppev2 ppev1)*/
11024: pa_object_relationships_s.nextval,
11025: pobj.object_type_from,
11026: ppev1.element_version_id,
11027: pobj.object_type_to,
11028: ppev2.element_version_id,
12791: weighting_percentage
12792: )
12793: /*Added the hint for the bug 3513853*/
12794: /* SELECT /*+ USE_HASH(ppev2 ppev1)*/
12795: /* pa_object_relationships_s.nextval,
12796: pobj.object_type_from,
12797: ppev1.element_version_id,
12798: pobj.object_type_to,
12799: ppev2.element_version_id,