[Home] [Help]
12: procedure init_table_data_in_cer(p_copy_entity_txn_id in number) is
13: --
14: cursor c_table_data_in_cer is
15: select tr.table_alias, tr.table_route_id
16: from pqh_table_route tr
17: where tr.table_route_id in(
18: select table_route_id from pqh_copy_entity_results cer
19: where cer.copy_entity_txn_id = p_copy_entity_txn_id);
20: --
100: information182,
101: information19,
102: cer.object_version_number
103: from pqh_copy_entity_results cer,
104: pqh_table_route trt
105: where cer.table_route_id = trt.table_route_id
106: and trt.table_alias = 'FFF'
107: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
108:
390: information181,
391: information182,
392: cer.object_version_number
393: from pqh_copy_entity_results cer,
394: pqh_table_route trt
395: where cer.table_route_id = trt.table_route_id
396: and trt.table_alias = 'PGM'
397: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
398: end if;
539: information181,
540: information182,
541: cer.object_version_number
542: from pqh_copy_entity_results cer,
543: pqh_table_route trt
544: where cer.table_route_id = trt.table_route_id
545: and trt.table_alias = 'ACP'
546: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
547: end if;
744: information181,
745: information182,
746: cer.object_version_number
747: from pqh_copy_entity_results cer,
748: pqh_table_route trt
749: where cer.table_route_id = trt.table_route_id
750: and trt.table_alias = 'APR'
751: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
752: end if;
891: information181,
892: information182,
893: cer.object_version_number
894: from pqh_copy_entity_results cer,
895: pqh_table_route trt
896: where cer.table_route_id = trt.table_route_id
897: and trt.table_alias = 'APV'
898: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
899: end if;
1040: information181,
1041: information182,
1042: cer.object_version_number
1043: from pqh_copy_entity_results cer,
1044: pqh_table_route trt
1045: where cer.table_route_id = trt.table_route_id
1046: and trt.table_alias = 'AVA'
1047: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
1048: end if;
1187: information181,
1188: information182,
1189: cer.object_version_number
1190: from pqh_copy_entity_results cer,
1191: pqh_table_route trt
1192: where cer.table_route_id = trt.table_route_id
1193: and trt.table_alias = 'EAT'
1194: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
1195: end if;
1336: information181,
1337: information182,
1338: cer.object_version_number
1339: from pqh_copy_entity_results cer,
1340: pqh_table_route trt
1341: where cer.table_route_id = trt.table_route_id
1342: and trt.table_alias = 'ABC'
1343: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
1344: end if;
1649: information181,
1650: information182,
1651: cer.object_version_number
1652: from pqh_copy_entity_results cer,
1653: pqh_table_route trt
1654: where cer.table_route_id = trt.table_route_id
1655: and trt.table_alias = 'ABR'
1656: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
1657: end if;
1794: information181,
1795: information182,
1796: cer.object_version_number
1797: from pqh_copy_entity_results cer,
1798: pqh_table_route trt
1799: where cer.table_route_id = trt.table_route_id
1800: and trt.table_alias = 'APL1'
1801: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
1802: end if;
1941: information181,
1942: information182,
1943: cer.object_version_number
1944: from pqh_copy_entity_results cer,
1945: pqh_table_route trt
1946: where cer.table_route_id = trt.table_route_id
1947: and trt.table_alias = 'APF'
1948: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
1949: end if;
2088: information181,
2089: information182,
2090: cer.object_version_number
2091: from pqh_copy_entity_results cer,
2092: pqh_table_route trt
2093: where cer.table_route_id = trt.table_route_id
2094: and trt.table_alias = 'AVR'
2095: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
2096: end if;
2253: information181,
2254: information182,
2255: cer.object_version_number
2256: from pqh_copy_entity_results cer,
2257: pqh_table_route trt
2258: where cer.table_route_id = trt.table_route_id
2259: and trt.table_alias = 'AGF'
2260: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
2261: end if;
2402: information181,
2403: information182,
2404: cer.object_version_number
2405: from pqh_copy_entity_results cer,
2406: pqh_table_route trt
2407: where cer.table_route_id = trt.table_route_id
2408: and trt.table_alias = 'ART'
2409: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
2410: end if;
2547: information181,
2548: information182,
2549: cer.object_version_number
2550: from pqh_copy_entity_results cer,
2551: pqh_table_route trt
2552: where cer.table_route_id = trt.table_route_id
2553: and trt.table_alias = 'ABP'
2554: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
2555: end if;
2700: information181,
2701: information182,
2702: cer.object_version_number
2703: from pqh_copy_entity_results cer,
2704: pqh_table_route trt
2705: where cer.table_route_id = trt.table_route_id
2706: and trt.table_alias = 'ADE'
2707: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
2708: end if;
2847: information181,
2848: information182,
2849: cer.object_version_number
2850: from pqh_copy_entity_results cer,
2851: pqh_table_route trt
2852: where cer.table_route_id = trt.table_route_id
2853: and trt.table_alias = 'ASR'
2854: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
2855: end if;
2992: information181,
2993: information182,
2994: cer.object_version_number
2995: from pqh_copy_entity_results cer,
2996: pqh_table_route trt
2997: where cer.table_route_id = trt.table_route_id
2998: and trt.table_alias = 'BNG'
2999: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
3000: end if;
3141: information181,
3142: information182,
3143: cer.object_version_number
3144: from pqh_copy_entity_results cer,
3145: pqh_table_route trt
3146: where cer.table_route_id = trt.table_route_id
3147: and trt.table_alias = 'BRG'
3148: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
3149: end if;
3292: information181,
3293: information182,
3294: cer.object_version_number
3295: from pqh_copy_entity_results cer,
3296: pqh_table_route trt
3297: where cer.table_route_id = trt.table_route_id
3298: and trt.table_alias = 'BNB'
3299: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
3300: end if;
3475: information181,
3476: information182,
3477: cer.object_version_number
3478: from pqh_copy_entity_results cer,
3479: pqh_table_route trt
3480: where cer.table_route_id = trt.table_route_id
3481: and trt.table_alias = 'BPR1'
3482: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
3483: end if;
3682: information181,
3683: information182,
3684: cer.object_version_number
3685: from pqh_copy_entity_results cer,
3686: pqh_table_route trt
3687: where cer.table_route_id = trt.table_route_id
3688: and trt.table_alias = 'BPP'
3689: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
3690: end if;
3831: information181,
3832: information182,
3833: cer.object_version_number
3834: from pqh_copy_entity_results cer,
3835: pqh_table_route trt
3836: where cer.table_route_id = trt.table_route_id
3837: and trt.table_alias = 'BRC'
3838: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
3839: end if;
3978: information181,
3979: information182,
3980: cer.object_version_number
3981: from pqh_copy_entity_results cer,
3982: pqh_table_route trt
3983: where cer.table_route_id = trt.table_route_id
3984: and trt.table_alias = 'BVR1'
3985: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
3986: end if;
4125: information181,
4126: information182,
4127: cer.object_version_number
4128: from pqh_copy_entity_results cer,
4129: pqh_table_route trt
4130: where cer.table_route_id = trt.table_route_id
4131: and trt.table_alias = 'BRR'
4132: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
4133: end if;
4274: information181,
4275: information182,
4276: cer.object_version_number
4277: from pqh_copy_entity_results cer,
4278: pqh_table_route trt
4279: where cer.table_route_id = trt.table_route_id
4280: and trt.table_alias = 'BUR'
4281: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
4282: end if;
4425: information181,
4426: information182,
4427: cer.object_version_number
4428: from pqh_copy_entity_results cer,
4429: pqh_table_route trt
4430: where cer.table_route_id = trt.table_route_id
4431: and trt.table_alias = 'CQR'
4432: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
4433: end if;
4578: information181,
4579: information182,
4580: cer.object_version_number
4581: from pqh_copy_entity_results cer,
4582: pqh_table_route trt
4583: where cer.table_route_id = trt.table_route_id
4584: and trt.table_alias = 'CLA'
4585: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
4586: end if;
4727: information181,
4728: information182,
4729: cer.object_version_number
4730: from pqh_copy_entity_results cer,
4731: pqh_table_route trt
4732: where cer.table_route_id = trt.table_route_id
4733: and trt.table_alias = 'CMR'
4734: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
4735: end if;
4872: information181,
4873: information182,
4874: cer.object_version_number
4875: from pqh_copy_entity_results cer,
4876: pqh_table_route trt
4877: where cer.table_route_id = trt.table_route_id
4878: and trt.table_alias = 'CPL'
4879: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
4880: end if;
5017: information181,
5018: information182,
5019: cer.object_version_number
5020: from pqh_copy_entity_results cer,
5021: pqh_table_route trt
5022: where cer.table_route_id = trt.table_route_id
5023: and trt.table_alias = 'CBP'
5024: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
5025: end if;
5166: information181,
5167: information182,
5168: cer.object_version_number
5169: from pqh_copy_entity_results cer,
5170: pqh_table_route trt
5171: where cer.table_route_id = trt.table_route_id
5172: and trt.table_alias = 'CPT'
5173: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
5174: end if;
5317: information181,
5318: information182,
5319: cer.object_version_number
5320: from pqh_copy_entity_results cer,
5321: pqh_table_route trt
5322: where cer.table_route_id = trt.table_route_id
5323: and trt.table_alias = 'CGP'
5324: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
5325: end if;
5468: information181,
5469: information182,
5470: cer.object_version_number
5471: from pqh_copy_entity_results cer,
5472: pqh_table_route trt
5473: where cer.table_route_id = trt.table_route_id
5474: and trt.table_alias = 'CPN'
5475: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
5476: end if;
5615: information181,
5616: information182,
5617: cer.object_version_number
5618: from pqh_copy_entity_results cer,
5619: pqh_table_route trt
5620: where cer.table_route_id = trt.table_route_id
5621: and trt.table_alias = 'CTY'
5622: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
5623: end if;
5786: information181,
5787: information182,
5788: cer.object_version_number
5789: from pqh_copy_entity_results cer,
5790: pqh_table_route trt
5791: where cer.table_route_id = trt.table_route_id
5792: and trt.table_alias = 'CLF'
5793: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
5794: end if;
5935: information181,
5936: information182,
5937: cer.object_version_number
5938: from pqh_copy_entity_results cer,
5939: pqh_table_route trt
5940: where cer.table_route_id = trt.table_route_id
5941: and trt.table_alias = 'CLR'
5942: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
5943: end if;
6082: information181,
6083: information182,
6084: cer.object_version_number
6085: from pqh_copy_entity_results cer,
6086: pqh_table_route trt
6087: where cer.table_route_id = trt.table_route_id
6088: and trt.table_alias = 'CSR'
6089: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
6090: end if;
6279: information181,
6280: information182,
6281: cer.object_version_number
6282: from pqh_copy_entity_results cer,
6283: pqh_table_route trt
6284: where cer.table_route_id = trt.table_route_id
6285: and trt.table_alias = 'CCM'
6286: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
6287: end if;
6428: information181,
6429: information182,
6430: cer.object_version_number
6431: from pqh_copy_entity_results cer,
6432: pqh_table_route trt
6433: where cer.table_route_id = trt.table_route_id
6434: and trt.table_alias = 'CWG'
6435: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
6436: end if;
6597: information181,
6598: information182,
6599: cer.object_version_number
6600: from pqh_copy_entity_results cer,
6601: pqh_table_route trt
6602: where cer.table_route_id = trt.table_route_id
6603: and trt.table_alias = 'DCE'
6604: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
6605: end if;
6750: information181,
6751: information182,
6752: cer.object_version_number
6753: from pqh_copy_entity_results cer,
6754: pqh_table_route trt
6755: where cer.table_route_id = trt.table_route_id
6756: and trt.table_alias = 'DCR'
6757: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
6758: end if;
6901: information181,
6902: information182,
6903: cer.object_version_number
6904: from pqh_copy_entity_results cer,
6905: pqh_table_route trt
6906: where cer.table_route_id = trt.table_route_id
6907: and trt.table_alias = 'DPC'
6908: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
6909: end if;
7054: information181,
7055: information182,
7056: cer.object_version_number
7057: from pqh_copy_entity_results cer,
7058: pqh_table_route trt
7059: where cer.table_route_id = trt.table_route_id
7060: and trt.table_alias = 'DOP'
7061: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
7062: end if;
7205: information181,
7206: information182,
7207: cer.object_version_number
7208: from pqh_copy_entity_results cer,
7209: pqh_table_route trt
7210: where cer.table_route_id = trt.table_route_id
7211: and trt.table_alias = 'DCL'
7212: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
7213: end if;
7358: information181,
7359: information182,
7360: cer.object_version_number
7361: from pqh_copy_entity_results cer,
7362: pqh_table_route trt
7363: where cer.table_route_id = trt.table_route_id
7364: and trt.table_alias = 'DCO'
7365: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
7366: end if;
7509: information181,
7510: information182,
7511: cer.object_version_number
7512: from pqh_copy_entity_results cer,
7513: pqh_table_route trt
7514: where cer.table_route_id = trt.table_route_id
7515: and trt.table_alias = 'DCP'
7516: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
7517: end if;
7658: information181,
7659: information182,
7660: cer.object_version_number
7661: from pqh_copy_entity_results cer,
7662: pqh_table_route trt
7663: where cer.table_route_id = trt.table_route_id
7664: and trt.table_alias = 'DOT'
7665: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
7666: end if;
7807: information181,
7808: information182,
7809: cer.object_version_number
7810: from pqh_copy_entity_results cer,
7811: pqh_table_route trt
7812: where cer.table_route_id = trt.table_route_id
7813: and trt.table_alias = 'DBR'
7814: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
7815: end if;
7952: information181,
7953: information182,
7954: cer.object_version_number
7955: from pqh_copy_entity_results cer,
7956: pqh_table_route trt
7957: where cer.table_route_id = trt.table_route_id
7958: and trt.table_alias = 'DEC'
7959: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
7960: end if;
8113: information181,
8114: information182,
8115: cer.object_version_number
8116: from pqh_copy_entity_results cer,
8117: pqh_table_route trt
8118: where cer.table_route_id = trt.table_route_id
8119: and trt.table_alias = 'DDR'
8120: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
8121: end if;
8258: information181,
8259: information182,
8260: cer.object_version_number
8261: from pqh_copy_entity_results cer,
8262: pqh_table_route trt
8263: where cer.table_route_id = trt.table_route_id
8264: and trt.table_alias = 'DRR'
8265: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
8266: end if;
8405: information181,
8406: information182,
8407: cer.object_version_number
8408: from pqh_copy_entity_results cer,
8409: pqh_table_route trt
8410: where cer.table_route_id = trt.table_route_id
8411: and trt.table_alias = 'ESR'
8412: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
8413: end if;
8684: information181,
8685: information182,
8686: cer.object_version_number
8687: from pqh_copy_entity_results cer,
8688: pqh_table_route trt
8689: where cer.table_route_id = trt.table_route_id
8690: and trt.table_alias = 'ELP'
8691: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
8692: end if;
8833: information181,
8834: information182,
8835: cer.object_version_number
8836: from pqh_copy_entity_results cer,
8837: pqh_table_route trt
8838: where cer.table_route_id = trt.table_route_id
8839: and trt.table_alias = 'ERL'
8840: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
8841: end if;
8988: information181,
8989: information182,
8990: cer.object_version_number
8991: from pqh_copy_entity_results cer,
8992: pqh_table_route trt
8993: where cer.table_route_id = trt.table_route_id
8994: and trt.table_alias = 'EAC'
8995: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
8996: end if;
9137: information181,
9138: information182,
9139: cer.object_version_number
9140: from pqh_copy_entity_results cer,
9141: pqh_table_route trt
9142: where cer.table_route_id = trt.table_route_id
9143: and trt.table_alias = 'EAP'
9144: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
9145: end if;
9284: information181,
9285: information182,
9286: cer.object_version_number
9287: from pqh_copy_entity_results cer,
9288: pqh_table_route trt
9289: where cer.table_route_id = trt.table_route_id
9290: and trt.table_alias = 'EAN'
9291: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
9292: end if;
9433: information181,
9434: information182,
9435: cer.object_version_number
9436: from pqh_copy_entity_results cer,
9437: pqh_table_route trt
9438: where cer.table_route_id = trt.table_route_id
9439: and trt.table_alias = 'EBN'
9440: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
9441: end if;
9582: information181,
9583: information182,
9584: cer.object_version_number
9585: from pqh_copy_entity_results cer,
9586: pqh_table_route trt
9587: where cer.table_route_id = trt.table_route_id
9588: and trt.table_alias = 'EBU'
9589: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
9590: end if;
9733: information181,
9734: information182,
9735: cer.object_version_number
9736: from pqh_copy_entity_results cer,
9737: pqh_table_route trt
9738: where cer.table_route_id = trt.table_route_id
9739: and trt.table_alias = 'ECQ'
9740: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
9741: end if;
9884: information181,
9885: information182,
9886: cer.object_version_number
9887: from pqh_copy_entity_results cer,
9888: pqh_table_route trt
9889: where cer.table_route_id = trt.table_route_id
9890: and trt.table_alias = 'ECP'
9891: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
9892: end if;
10031: information181,
10032: information182,
10033: cer.object_version_number
10034: from pqh_copy_entity_results cer,
10035: pqh_table_route trt
10036: where cer.table_route_id = trt.table_route_id
10037: and trt.table_alias = 'ECY'
10038: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
10039: end if;
10180: information181,
10181: information182,
10182: cer.object_version_number
10183: from pqh_copy_entity_results cer,
10184: pqh_table_route trt
10185: where cer.table_route_id = trt.table_route_id
10186: and trt.table_alias = 'ECL'
10187: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
10188: end if;
10329: information181,
10330: information182,
10331: cer.object_version_number
10332: from pqh_copy_entity_results cer,
10333: pqh_table_route trt
10334: where cer.table_route_id = trt.table_route_id
10335: and trt.table_alias = 'EDO'
10336: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
10337: end if;
10482: information181,
10483: information182,
10484: cer.object_version_number
10485: from pqh_copy_entity_results cer,
10486: pqh_table_route trt
10487: where cer.table_route_id = trt.table_route_id
10488: and trt.table_alias = 'EDG'
10489: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
10490: end if;
10633: information181,
10634: information182,
10635: cer.object_version_number
10636: from pqh_copy_entity_results cer,
10637: pqh_table_route trt
10638: where cer.table_route_id = trt.table_route_id
10639: and trt.table_alias = 'EDP'
10640: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
10641: end if;
10786: information181,
10787: information182,
10788: cer.object_version_number
10789: from pqh_copy_entity_results cer,
10790: pqh_table_route trt
10791: where cer.table_route_id = trt.table_route_id
10792: and trt.table_alias = 'EDT'
10793: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
10794: end if;
10937: information181,
10938: information182,
10939: cer.object_version_number
10940: from pqh_copy_entity_results cer,
10941: pqh_table_route trt
10942: where cer.table_route_id = trt.table_route_id
10943: and trt.table_alias = 'EDI'
10944: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
10945: end if;
11086: information181,
11087: information182,
11088: cer.object_version_number
11089: from pqh_copy_entity_results cer,
11090: pqh_table_route trt
11091: where cer.table_route_id = trt.table_route_id
11092: and trt.table_alias = 'ETD'
11093: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
11094: end if;
11235: information181,
11236: information182,
11237: cer.object_version_number
11238: from pqh_copy_entity_results cer,
11239: pqh_table_route trt
11240: where cer.table_route_id = trt.table_route_id
11241: and trt.table_alias = 'EDB'
11242: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
11243: end if;
11388: information181,
11389: information182,
11390: cer.object_version_number
11391: from pqh_copy_entity_results cer,
11392: pqh_table_route trt
11393: where cer.table_route_id = trt.table_route_id
11394: and trt.table_alias = 'EDC'
11395: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
11396: end if;
11537: information181,
11538: information182,
11539: cer.object_version_number
11540: from pqh_copy_entity_results cer,
11541: pqh_table_route trt
11542: where cer.table_route_id = trt.table_route_id
11543: and trt.table_alias = 'EDS'
11544: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
11545: end if;
11686: information181,
11687: information182,
11688: cer.object_version_number
11689: from pqh_copy_entity_results cer,
11690: pqh_table_route trt
11691: where cer.table_route_id = trt.table_route_id
11692: and trt.table_alias = 'ECT'
11693: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
11694: end if;
11837: information181,
11838: information182,
11839: cer.object_version_number
11840: from pqh_copy_entity_results cer,
11841: pqh_table_route trt
11842: where cer.table_route_id = trt.table_route_id
11843: and trt.table_alias = 'EDD'
11844: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
11845: end if;
11988: information181,
11989: information182,
11990: cer.object_version_number
11991: from pqh_copy_entity_results cer,
11992: pqh_table_route trt
11993: where cer.table_route_id = trt.table_route_id
11994: and trt.table_alias = 'EDR'
11995: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
11996: end if;
12135: information181,
12136: information182,
12137: cer.object_version_number
12138: from pqh_copy_entity_results cer,
12139: pqh_table_route trt
12140: where cer.table_route_id = trt.table_route_id
12141: and trt.table_alias = 'EES'
12142: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
12143: end if;
12286: information181,
12287: information182,
12288: cer.object_version_number
12289: from pqh_copy_entity_results cer,
12290: pqh_table_route trt
12291: where cer.table_route_id = trt.table_route_id
12292: and trt.table_alias = 'EEI'
12293: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
12294: end if;
12437: information181,
12438: information182,
12439: cer.object_version_number
12440: from pqh_copy_entity_results cer,
12441: pqh_table_route trt
12442: where cer.table_route_id = trt.table_route_id
12443: and trt.table_alias = 'EEG'
12444: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
12445: end if;
12588: information181,
12589: information182,
12590: cer.object_version_number
12591: from pqh_copy_entity_results cer,
12592: pqh_table_route trt
12593: where cer.table_route_id = trt.table_route_id
12594: and trt.table_alias = 'EAI'
12595: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
12596: end if;
12739: information181,
12740: information182,
12741: cer.object_version_number
12742: from pqh_copy_entity_results cer,
12743: pqh_table_route trt
12744: where cer.table_route_id = trt.table_route_id
12745: and trt.table_alias = 'EEP'
12746: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
12747: end if;
12892: information181,
12893: information182,
12894: cer.object_version_number
12895: from pqh_copy_entity_results cer,
12896: pqh_table_route trt
12897: where cer.table_route_id = trt.table_route_id
12898: and trt.table_alias = 'EET'
12899: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
12900: end if;
13041: information181,
13042: information182,
13043: cer.object_version_number
13044: from pqh_copy_entity_results cer,
13045: pqh_table_route trt
13046: where cer.table_route_id = trt.table_route_id
13047: and trt.table_alias = 'EFP'
13048: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
13049: end if;
13190: information181,
13191: information182,
13192: cer.object_version_number
13193: from pqh_copy_entity_results cer,
13194: pqh_table_route trt
13195: where cer.table_route_id = trt.table_route_id
13196: and trt.table_alias = 'EGN'
13197: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
13198: end if;
13337: information181,
13338: information182,
13339: cer.object_version_number
13340: from pqh_copy_entity_results cer,
13341: pqh_table_route trt
13342: where cer.table_route_id = trt.table_route_id
13343: and trt.table_alias = 'EGR'
13344: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
13345: end if;
13486: information181,
13487: information182,
13488: cer.object_version_number
13489: from pqh_copy_entity_results cer,
13490: pqh_table_route trt
13491: where cer.table_route_id = trt.table_route_id
13492: and trt.table_alias = 'EHS'
13493: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
13494: end if;
13635: information181,
13636: information182,
13637: cer.object_version_number
13638: from pqh_copy_entity_results cer,
13639: pqh_table_route trt
13640: where cer.table_route_id = trt.table_route_id
13641: and trt.table_alias = 'EHW'
13642: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
13643: end if;
13782: information181,
13783: information182,
13784: cer.object_version_number
13785: from pqh_copy_entity_results cer,
13786: pqh_table_route trt
13787: where cer.table_route_id = trt.table_route_id
13788: and trt.table_alias = 'EJP'
13789: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
13790: end if;
13931: information181,
13932: information182,
13933: cer.object_version_number
13934: from pqh_copy_entity_results cer,
13935: pqh_table_route trt
13936: where cer.table_route_id = trt.table_route_id
13937: and trt.table_alias = 'ELU'
13938: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
13939: end if;
14078: information181,
14079: information182,
14080: cer.object_version_number
14081: from pqh_copy_entity_results cer,
14082: pqh_table_route trt
14083: where cer.table_route_id = trt.table_route_id
14084: and trt.table_alias = 'ELN'
14085: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
14086: end if;
14225: information181,
14226: information182,
14227: cer.object_version_number
14228: from pqh_copy_entity_results cer,
14229: pqh_table_route trt
14230: where cer.table_route_id = trt.table_route_id
14231: and trt.table_alias = 'ELR'
14232: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
14233: end if;
14374: information181,
14375: information182,
14376: cer.object_version_number
14377: from pqh_copy_entity_results cer,
14378: pqh_table_route trt
14379: where cer.table_route_id = trt.table_route_id
14380: and trt.table_alias = 'ELS'
14381: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
14382: end if;
14523: information181,
14524: information182,
14525: cer.object_version_number
14526: from pqh_copy_entity_results cer,
14527: pqh_table_route trt
14528: where cer.table_route_id = trt.table_route_id
14529: and trt.table_alias = 'ELV'
14530: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
14531: end if;
14676: information181,
14677: information182,
14678: cer.object_version_number
14679: from pqh_copy_entity_results cer,
14680: pqh_table_route trt
14681: where cer.table_route_id = trt.table_route_id
14682: and trt.table_alias = 'EMC'
14683: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
14684: end if;
14829: information181,
14830: information182,
14831: cer.object_version_number
14832: from pqh_copy_entity_results cer,
14833: pqh_table_route trt
14834: where cer.table_route_id = trt.table_route_id
14835: and trt.table_alias = 'EMS'
14836: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
14837: end if;
14976: information181,
14977: information182,
14978: cer.object_version_number
14979: from pqh_copy_entity_results cer,
14980: pqh_table_route trt
14981: where cer.table_route_id = trt.table_route_id
14982: and trt.table_alias = 'EMP'
14983: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
14984: end if;
15121: information181,
15122: information182,
15123: cer.object_version_number
15124: from pqh_copy_entity_results cer,
15125: pqh_table_route trt
15126: where cer.table_route_id = trt.table_route_id
15127: and trt.table_alias = 'ENO'
15128: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
15129: end if;
15268: information181,
15269: information182,
15270: cer.object_version_number
15271: from pqh_copy_entity_results cer,
15272: pqh_table_route trt
15273: where cer.table_route_id = trt.table_route_id
15274: and trt.table_alias = 'EOM'
15275: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
15276: end if;
15415: information181,
15416: information182,
15417: cer.object_version_number
15418: from pqh_copy_entity_results cer,
15419: pqh_table_route trt
15420: where cer.table_route_id = trt.table_route_id
15421: and trt.table_alias = 'EOU'
15422: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
15423: end if;
15566: information181,
15567: information182,
15568: cer.object_version_number
15569: from pqh_copy_entity_results cer,
15570: pqh_table_route trt
15571: where cer.table_route_id = trt.table_route_id
15572: and trt.table_alias = 'EOY'
15573: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
15574: end if;
15715: information181,
15716: information182,
15717: cer.object_version_number
15718: from pqh_copy_entity_results cer,
15719: pqh_table_route trt
15720: where cer.table_route_id = trt.table_route_id
15721: and trt.table_alias = 'EPF'
15722: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
15723: end if;
15866: information181,
15867: information182,
15868: cer.object_version_number
15869: from pqh_copy_entity_results cer,
15870: pqh_table_route trt
15871: where cer.table_route_id = trt.table_route_id
15872: and trt.table_alias = 'ERG'
15873: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
15874: end if;
16015: information181,
16016: information182,
16017: cer.object_version_number
16018: from pqh_copy_entity_results cer,
16019: pqh_table_route trt
16020: where cer.table_route_id = trt.table_route_id
16021: and trt.table_alias = 'EPT'
16022: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
16023: end if;
16164: information181,
16165: information182,
16166: cer.object_version_number
16167: from pqh_copy_entity_results cer,
16168: pqh_table_route trt
16169: where cer.table_route_id = trt.table_route_id
16170: and trt.table_alias = 'EPG'
16171: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
16172: end if;
16315: information181,
16316: information182,
16317: cer.object_version_number
16318: from pqh_copy_entity_results cer,
16319: pqh_table_route trt
16320: where cer.table_route_id = trt.table_route_id
16321: and trt.table_alias = 'EPN'
16322: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
16323: end if;
16464: information181,
16465: information182,
16466: cer.object_version_number
16467: from pqh_copy_entity_results cer,
16468: pqh_table_route trt
16469: where cer.table_route_id = trt.table_route_id
16470: and trt.table_alias = 'EAG'
16471: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
16472: end if;
16613: information181,
16614: information182,
16615: cer.object_version_number
16616: from pqh_copy_entity_results cer,
16617: pqh_table_route trt
16618: where cer.table_route_id = trt.table_route_id
16619: and trt.table_alias = 'EPP'
16620: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
16621: end if;
16762: information181,
16763: information182,
16764: cer.object_version_number
16765: from pqh_copy_entity_results cer,
16766: pqh_table_route trt
16767: where cer.table_route_id = trt.table_route_id
16768: and trt.table_alias = 'EPL'
16769: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
16770: end if;
16911: information181,
16912: information182,
16913: cer.object_version_number
16914: from pqh_copy_entity_results cer,
16915: pqh_table_route trt
16916: where cer.table_route_id = trt.table_route_id
16917: and trt.table_alias = 'EPZ'
16918: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
16919: end if;
17058: information181,
17059: information182,
17060: cer.object_version_number
17061: from pqh_copy_entity_results cer,
17062: pqh_table_route trt
17063: where cer.table_route_id = trt.table_route_id
17064: and trt.table_alias = 'EPS'
17065: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
17066: end if;
17205: information181,
17206: information182,
17207: cer.object_version_number
17208: from pqh_copy_entity_results cer,
17209: pqh_table_route trt
17210: where cer.table_route_id = trt.table_route_id
17211: and trt.table_alias = 'EPY'
17212: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
17213: end if;
17352: information181,
17353: information182,
17354: cer.object_version_number
17355: from pqh_copy_entity_results cer,
17356: pqh_table_route trt
17357: where cer.table_route_id = trt.table_route_id
17358: and trt.table_alias = 'EPB'
17359: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
17360: end if;
17501: information181,
17502: information182,
17503: cer.object_version_number
17504: from pqh_copy_entity_results cer,
17505: pqh_table_route trt
17506: where cer.table_route_id = trt.table_route_id
17507: and trt.table_alias = 'EQT'
17508: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
17509: end if;
17650: information181,
17651: information182,
17652: cer.object_version_number
17653: from pqh_copy_entity_results cer,
17654: pqh_table_route trt
17655: where cer.table_route_id = trt.table_route_id
17656: and trt.table_alias = 'EQG'
17657: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
17658: end if;
17813: information181,
17814: information182,
17815: cer.object_version_number
17816: from pqh_copy_entity_results cer,
17817: pqh_table_route trt
17818: where cer.table_route_id = trt.table_route_id
17819: and trt.table_alias = 'ESH'
17820: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
17821: end if;
17960: information181,
17961: information182,
17962: cer.object_version_number
17963: from pqh_copy_entity_results cer,
17964: pqh_table_route trt
17965: where cer.table_route_id = trt.table_route_id
17966: and trt.table_alias = 'ESP'
17967: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
17968: end if;
18113: information181,
18114: information182,
18115: cer.object_version_number
18116: from pqh_copy_entity_results cer,
18117: pqh_table_route trt
18118: where cer.table_route_id = trt.table_route_id
18119: and trt.table_alias = 'ESC'
18120: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
18121: end if;
18260: information181,
18261: information182,
18262: cer.object_version_number
18263: from pqh_copy_entity_results cer,
18264: pqh_table_route trt
18265: where cer.table_route_id = trt.table_route_id
18266: and trt.table_alias = 'EST'
18267: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
18268: end if;
18409: information181,
18410: information182,
18411: cer.object_version_number
18412: from pqh_copy_entity_results cer,
18413: pqh_table_route trt
18414: where cer.table_route_id = trt.table_route_id
18415: and trt.table_alias = 'ESA'
18416: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
18417: end if;
18558: information181,
18559: information182,
18560: cer.object_version_number
18561: from pqh_copy_entity_results cer,
18562: pqh_table_route trt
18563: where cer.table_route_id = trt.table_route_id
18564: and trt.table_alias = 'ETU'
18565: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
18566: end if;
18751: information181,
18752: information182,
18753: cer.object_version_number
18754: from pqh_copy_entity_results cer,
18755: pqh_table_route trt
18756: where cer.table_route_id = trt.table_route_id
18757: and trt.table_alias = 'PEO'
18758: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
18759: end if;
18910: information181,
18911: information182,
18912: cer.object_version_number
18913: from pqh_copy_entity_results cer,
18914: pqh_table_route trt
18915: where cer.table_route_id = trt.table_route_id
18916: and trt.table_alias = 'ETC'
18917: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
18918: end if;
19069: information181,
19070: information182,
19071: cer.object_version_number
19072: from pqh_copy_entity_results cer,
19073: pqh_table_route trt
19074: where cer.table_route_id = trt.table_route_id
19075: and trt.table_alias = 'ETP'
19076: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
19077: end if;
19216: information181,
19217: information182,
19218: cer.object_version_number
19219: from pqh_copy_entity_results cer,
19220: pqh_table_route trt
19221: where cer.table_route_id = trt.table_route_id
19222: and trt.table_alias = 'EWL'
19223: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
19224: end if;
19367: information181,
19368: information182,
19369: cer.object_version_number
19370: from pqh_copy_entity_results cer,
19371: pqh_table_route trt
19372: where cer.table_route_id = trt.table_route_id
19373: and trt.table_alias = 'EAO'
19374: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
19375: end if;
19518: information181,
19519: information182,
19520: cer.object_version_number
19521: from pqh_copy_entity_results cer,
19522: pqh_table_route trt
19523: where cer.table_route_id = trt.table_route_id
19524: and trt.table_alias = 'EPM'
19525: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
19526: end if;
19669: information181,
19670: information182,
19671: cer.object_version_number
19672: from pqh_copy_entity_results cer,
19673: pqh_table_route trt
19674: where cer.table_route_id = trt.table_route_id
19675: and trt.table_alias = 'EAR'
19676: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
19677: end if;
19820: information181,
19821: information182,
19822: cer.object_version_number
19823: from pqh_copy_entity_results cer,
19824: pqh_table_route trt
19825: where cer.table_route_id = trt.table_route_id
19826: and trt.table_alias = 'ENL'
19827: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
19828: end if;
19973: information181,
19974: information182,
19975: cer.object_version_number
19976: from pqh_copy_entity_results cer,
19977: pqh_table_route trt
19978: where cer.table_route_id = trt.table_route_id
19979: and trt.table_alias = 'ENT'
19980: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
19981: end if;
20126: information181,
20127: information182,
20128: cer.object_version_number
20129: from pqh_copy_entity_results cer,
20130: pqh_table_route trt
20131: where cer.table_route_id = trt.table_route_id
20132: and trt.table_alias = 'ECF'
20133: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
20134: end if;
20333: information181,
20334: information182,
20335: cer.object_version_number
20336: from pqh_copy_entity_results cer,
20337: pqh_table_route trt
20338: where cer.table_route_id = trt.table_route_id
20339: and trt.table_alias = 'ENP'
20340: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
20341: end if;
20496: information181,
20497: information182,
20498: cer.object_version_number
20499: from pqh_copy_entity_results cer,
20500: pqh_table_route trt
20501: where cer.table_route_id = trt.table_route_id
20502: and trt.table_alias = 'ERP'
20503: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
20504: end if;
20647: information181,
20648: information182,
20649: cer.object_version_number
20650: from pqh_copy_entity_results cer,
20651: pqh_table_route trt
20652: where cer.table_route_id = trt.table_route_id
20653: and trt.table_alias = 'EIV'
20654: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
20655: end if;
20796: information181,
20797: information182,
20798: cer.object_version_number
20799: from pqh_copy_entity_results cer,
20800: pqh_table_route trt
20801: where cer.table_route_id = trt.table_route_id
20802: and trt.table_alias = 'FTR'
20803: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
20804: end if;
20943: information181,
20944: information182,
20945: cer.object_version_number
20946: from pqh_copy_entity_results cer,
20947: pqh_table_route trt
20948: where cer.table_route_id = trt.table_route_id
20949: and trt.table_alias = 'GOS'
20950: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
20951: end if;
21092: information181,
21093: information182,
21094: cer.object_version_number
21095: from pqh_copy_entity_results cer,
21096: pqh_table_route trt
21097: where cer.table_route_id = trt.table_route_id
21098: and trt.table_alias = 'GNR'
21099: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
21100: end if;
21239: information181,
21240: information182,
21241: cer.object_version_number
21242: from pqh_copy_entity_results cer,
21243: pqh_table_route trt
21244: where cer.table_route_id = trt.table_route_id
21245: and trt.table_alias = 'GRR'
21246: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
21247: end if;
21388: information181,
21389: information182,
21390: cer.object_version_number
21391: from pqh_copy_entity_results cer,
21392: pqh_table_route trt
21393: where cer.table_route_id = trt.table_route_id
21394: and trt.table_alias = 'HSR'
21395: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
21396: end if;
21561: information181,
21562: information182,
21563: cer.object_version_number
21564: from pqh_copy_entity_results cer,
21565: pqh_table_route trt
21566: where cer.table_route_id = trt.table_route_id
21567: and trt.table_alias = 'HWF'
21568: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
21569: end if;
21710: information181,
21711: information182,
21712: cer.object_version_number
21713: from pqh_copy_entity_results cer,
21714: pqh_table_route trt
21715: where cer.table_route_id = trt.table_route_id
21716: and trt.table_alias = 'HWR'
21717: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
21718: end if;
21857: information181,
21858: information182,
21859: cer.object_version_number
21860: from pqh_copy_entity_results cer,
21861: pqh_table_route trt
21862: where cer.table_route_id = trt.table_route_id
21863: and trt.table_alias = 'JRT'
21864: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
21865: end if;
22006: information181,
22007: information182,
22008: cer.object_version_number
22009: from pqh_copy_entity_results cer,
22010: pqh_table_route trt
22011: where cer.table_route_id = trt.table_route_id
22012: and trt.table_alias = 'LMM'
22013: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
22014: end if;
22187: information181,
22188: information182,
22189: cer.object_version_number
22190: from pqh_copy_entity_results cer,
22191: pqh_table_route trt
22192: where cer.table_route_id = trt.table_route_id
22193: and trt.table_alias = 'LEN'
22194: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
22195: end if;
22334: information181,
22335: information182,
22336: cer.object_version_number
22337: from pqh_copy_entity_results cer,
22338: pqh_table_route trt
22339: where cer.table_route_id = trt.table_route_id
22340: and trt.table_alias = 'LRR'
22341: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
22342: end if;
22483: information181,
22484: information182,
22485: cer.object_version_number
22486: from pqh_copy_entity_results cer,
22487: pqh_table_route trt
22488: where cer.table_route_id = trt.table_route_id
22489: and trt.table_alias = 'LBC'
22490: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
22491: end if;
22664: information181,
22665: information182,
22666: cer.object_version_number
22667: from pqh_copy_entity_results cer,
22668: pqh_table_route trt
22669: where cer.table_route_id = trt.table_route_id
22670: and trt.table_alias = 'LBR'
22671: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
22672: end if;
22817: information181,
22818: information182,
22819: cer.object_version_number
22820: from pqh_copy_entity_results cer,
22821: pqh_table_route trt
22822: where cer.table_route_id = trt.table_route_id
22823: and trt.table_alias = 'LCC'
22824: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
22825: end if;
22980: information181,
22981: information182,
22982: cer.object_version_number
22983: from pqh_copy_entity_results cer,
22984: pqh_table_route trt
22985: where cer.table_route_id = trt.table_route_id
22986: and trt.table_alias = 'LDC'
22987: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
22988: end if;
23143: information181,
23144: information182,
23145: cer.object_version_number
23146: from pqh_copy_entity_results cer,
23147: pqh_table_route trt
23148: where cer.table_route_id = trt.table_route_id
23149: and trt.table_alias = 'LOP'
23150: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
23151: end if;
23304: information181,
23305: information182,
23306: cer.object_version_number
23307: from pqh_copy_entity_results cer,
23308: pqh_table_route trt
23309: where cer.table_route_id = trt.table_route_id
23310: and trt.table_alias = 'LGE'
23311: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
23312: end if;
23469: information181,
23470: information182,
23471: cer.object_version_number
23472: from pqh_copy_entity_results cer,
23473: pqh_table_route trt
23474: where cer.table_route_id = trt.table_route_id
23475: and trt.table_alias = 'LPR1'
23476: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
23477: end if;
23634: information181,
23635: information182,
23636: cer.object_version_number
23637: from pqh_copy_entity_results cer,
23638: pqh_table_route trt
23639: where cer.table_route_id = trt.table_route_id
23640: and trt.table_alias = 'LPE'
23641: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
23642: end if;
23797: information181,
23798: information182,
23799: cer.object_version_number
23800: from pqh_copy_entity_results cer,
23801: pqh_table_route trt
23802: where cer.table_route_id = trt.table_route_id
23803: and trt.table_alias = 'LCT'
23804: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
23805: end if;
23946: information181,
23947: information182,
23948: cer.object_version_number
23949: from pqh_copy_entity_results cer,
23950: pqh_table_route trt
23951: where cer.table_route_id = trt.table_route_id
23952: and trt.table_alias = 'LNC'
23953: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
23954: end if;
24127: information181,
24128: information182,
24129: cer.object_version_number
24130: from pqh_copy_entity_results cer,
24131: pqh_table_route trt
24132: where cer.table_route_id = trt.table_route_id
24133: and trt.table_alias = 'LER'
24134: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
24135: end if;
24274: information181,
24275: information182,
24276: cer.object_version_number
24277: from pqh_copy_entity_results cer,
24278: pqh_table_route trt
24279: where cer.table_route_id = trt.table_route_id
24280: and trt.table_alias = 'LPL'
24281: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
24282: end if;
24421: information181,
24422: information182,
24423: cer.object_version_number
24424: from pqh_copy_entity_results cer,
24425: pqh_table_route trt
24426: where cer.table_route_id = trt.table_route_id
24427: and trt.table_alias = 'LRC'
24428: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
24429: end if;
24574: information181,
24575: information182,
24576: cer.object_version_number
24577: from pqh_copy_entity_results cer,
24578: pqh_table_route trt
24579: where cer.table_route_id = trt.table_route_id
24580: and trt.table_alias = 'LRE'
24581: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
24582: end if;
24721: information181,
24722: information182,
24723: cer.object_version_number
24724: from pqh_copy_entity_results cer,
24725: pqh_table_route trt
24726: where cer.table_route_id = trt.table_route_id
24727: and trt.table_alias = 'LER1'
24728: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
24729: end if;
24870: information181,
24871: information182,
24872: cer.object_version_number
24873: from pqh_copy_entity_results cer,
24874: pqh_table_route trt
24875: where cer.table_route_id = trt.table_route_id
24876: and trt.table_alias = 'LAR'
24877: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
24878: end if;
25043: information181,
25044: information182,
25045: cer.object_version_number
25046: from pqh_copy_entity_results cer,
25047: pqh_table_route trt
25048: where cer.table_route_id = trt.table_route_id
25049: and trt.table_alias = 'LSF'
25050: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
25051: end if;
25192: information181,
25193: information182,
25194: cer.object_version_number
25195: from pqh_copy_entity_results cer,
25196: pqh_table_route trt
25197: where cer.table_route_id = trt.table_route_id
25198: and trt.table_alias = 'LSR'
25199: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
25200: end if;
25341: information181,
25342: information182,
25343: cer.object_version_number
25344: from pqh_copy_entity_results cer,
25345: pqh_table_route trt
25346: where cer.table_route_id = trt.table_route_id
25347: and trt.table_alias = 'LRN'
25348: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
25349: end if;
25512: information181,
25513: information182,
25514: cer.object_version_number
25515: from pqh_copy_entity_results cer,
25516: pqh_table_route trt
25517: where cer.table_route_id = trt.table_route_id
25518: and trt.table_alias = 'MTR'
25519: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
25520: end if;
25657: information181,
25658: information182,
25659: cer.object_version_number
25660: from pqh_copy_entity_results cer,
25661: pqh_table_route trt
25662: where cer.table_route_id = trt.table_route_id
25663: and trt.table_alias = 'NOC'
25664: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
25665: end if;
25802: information181,
25803: information182,
25804: cer.object_version_number
25805: from pqh_copy_entity_results cer,
25806: pqh_table_route trt
25807: where cer.table_route_id = trt.table_route_id
25808: and trt.table_alias = 'OPP'
25809: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
25810: end if;
26009: information181,
26010: information182,
26011: cer.object_version_number
26012: from pqh_copy_entity_results cer,
26013: pqh_table_route trt
26014: where cer.table_route_id = trt.table_route_id
26015: and trt.table_alias = 'COP'
26016: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
26017: end if;
26156: information181,
26157: information182,
26158: cer.object_version_number
26159: from pqh_copy_entity_results cer,
26160: pqh_table_route trt
26161: where cer.table_route_id = trt.table_route_id
26162: and trt.table_alias = 'OMR'
26163: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
26164: end if;
26307: information181,
26308: information182,
26309: cer.object_version_number
26310: from pqh_copy_entity_results cer,
26311: pqh_table_route trt
26312: where cer.table_route_id = trt.table_route_id
26313: and trt.table_alias = 'OTP'
26314: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
26315: end if;
26470: information181,
26471: information182,
26472: cer.object_version_number
26473: from pqh_copy_entity_results cer,
26474: pqh_table_route trt
26475: where cer.table_route_id = trt.table_route_id
26476: and trt.table_alias = 'OPT'
26477: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
26478: end if;
26617: information181,
26618: information182,
26619: cer.object_version_number
26620: from pqh_copy_entity_results cer,
26621: pqh_table_route trt
26622: where cer.table_route_id = trt.table_route_id
26623: and trt.table_alias = 'OUR'
26624: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
26625: end if;
26768: information181,
26769: information182,
26770: cer.object_version_number
26771: from pqh_copy_entity_results cer,
26772: pqh_table_route trt
26773: where cer.table_route_id = trt.table_route_id
26774: and trt.table_alias = 'OPR'
26775: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
26776: end if;
26927: information181,
26928: information182,
26929: cer.object_version_number
26930: from pqh_copy_entity_results cer,
26931: pqh_table_route trt
26932: where cer.table_route_id = trt.table_route_id
26933: and trt.table_alias = 'PFF'
26934: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
26935: end if;
27076: information181,
27077: information182,
27078: cer.object_version_number
27079: from pqh_copy_entity_results cer,
27080: pqh_table_route trt
27081: where cer.table_route_id = trt.table_route_id
27082: and trt.table_alias = 'PFR'
27083: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
27084: end if;
27227: information181,
27228: information182,
27229: cer.object_version_number
27230: from pqh_copy_entity_results cer,
27231: pqh_table_route trt
27232: where cer.table_route_id = trt.table_route_id
27233: and trt.table_alias = 'PRR'
27234: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
27235: end if;
27386: information181,
27387: information182,
27388: cer.object_version_number
27389: from pqh_copy_entity_results cer,
27390: pqh_table_route trt
27391: where cer.table_route_id = trt.table_route_id
27392: and trt.table_alias = 'PSL'
27393: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
27394: end if;
27535: information181,
27536: information182,
27537: cer.object_version_number
27538: from pqh_copy_entity_results cer,
27539: pqh_table_route trt
27540: where cer.table_route_id = trt.table_route_id
27541: and trt.table_alias = 'PTR'
27542: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
27543: end if;
27690: information181,
27691: information182,
27692: cer.object_version_number
27693: from pqh_copy_entity_results cer,
27694: pqh_table_route trt
27695: where cer.table_route_id = trt.table_route_id
27696: and trt.table_alias = 'PGC'
27697: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
27698: end if;
27941: information181,
27942: information182,
27943: cer.object_version_number
27944: from pqh_copy_entity_results cer,
27945: pqh_table_route trt
27946: where cer.table_route_id = trt.table_route_id
27947: and trt.table_alias = 'CPP'
27948: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
27949: end if;
28098: information181,
28099: information182,
28100: cer.object_version_number
28101: from pqh_copy_entity_results cer,
28102: pqh_table_route trt
28103: where cer.table_route_id = trt.table_route_id
28104: and trt.table_alias = 'PCX'
28105: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
28106: end if;
28253: information181,
28254: information182,
28255: cer.object_version_number
28256: from pqh_copy_entity_results cer,
28257: pqh_table_route trt
28258: where cer.table_route_id = trt.table_route_id
28259: and trt.table_alias = 'PND'
28260: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
28261: end if;
28658: information177,
28659: information178,
28660: cer.object_version_number
28661: from pqh_copy_entity_results cer,
28662: pqh_table_route trt
28663: where cer.table_route_id = trt.table_route_id
28664: and trt.table_alias = 'PLN'
28665: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
28666: end if;
28813: information181,
28814: information182,
28815: cer.object_version_number
28816: from pqh_copy_entity_results cer,
28817: pqh_table_route trt
28818: where cer.table_route_id = trt.table_route_id
28819: and trt.table_alias = 'VGS'
28820: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
28821: end if;
28968: information181,
28969: information182,
28970: cer.object_version_number
28971: from pqh_copy_entity_results cer,
28972: pqh_table_route trt
28973: where cer.table_route_id = trt.table_route_id
28974: and trt.table_alias = 'PCT'
28975: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
28976: end if;
29131: information181,
29132: information182,
29133: cer.object_version_number
29134: from pqh_copy_entity_results cer,
29135: pqh_table_route trt
29136: where cer.table_route_id = trt.table_route_id
29137: and trt.table_alias = 'PCP'
29138: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
29139: end if;
29282: information181,
29283: information182,
29284: cer.object_version_number
29285: from pqh_copy_entity_results cer,
29286: pqh_table_route trt
29287: where cer.table_route_id = trt.table_route_id
29288: and trt.table_alias = 'PTY'
29289: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
29290: end if;
29441: information181,
29442: information182,
29443: cer.object_version_number
29444: from pqh_copy_entity_results cer,
29445: pqh_table_route trt
29446: where cer.table_route_id = trt.table_route_id
29447: and trt.table_alias = 'PRG'
29448: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
29449: end if;
29596: information181,
29597: information182,
29598: cer.object_version_number
29599: from pqh_copy_entity_results cer,
29600: pqh_table_route trt
29601: where cer.table_route_id = trt.table_route_id
29602: and trt.table_alias = 'PRB'
29603: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
29604: end if;
29743: information181,
29744: information182,
29745: cer.object_version_number
29746: from pqh_copy_entity_results cer,
29747: pqh_table_route trt
29748: where cer.table_route_id = trt.table_route_id
29749: and trt.table_alias = 'PRP'
29750: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
29751: end if;
29908: information181,
29909: information182,
29910: cer.object_version_number
29911: from pqh_copy_entity_results cer,
29912: pqh_table_route trt
29913: where cer.table_route_id = trt.table_route_id
29914: and trt.table_alias = 'PTP'
29915: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
29916: end if;
30055: information181,
30056: information182,
30057: cer.object_version_number
30058: from pqh_copy_entity_results cer,
30059: pqh_table_route trt
30060: where cer.table_route_id = trt.table_route_id
30061: and trt.table_alias = 'PON'
30062: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
30063: end if;
30214: information181,
30215: information182,
30216: cer.object_version_number
30217: from pqh_copy_entity_results cer,
30218: pqh_table_route trt
30219: where cer.table_route_id = trt.table_route_id
30220: and trt.table_alias = 'PRT'
30221: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
30222: end if;
30365: information181,
30366: information182,
30367: cer.object_version_number
30368: from pqh_copy_entity_results cer,
30369: pqh_table_route trt
30370: where cer.table_route_id = trt.table_route_id
30371: and trt.table_alias = 'PAT'
30372: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
30373: end if;
30512: information181,
30513: information182,
30514: cer.object_version_number
30515: from pqh_copy_entity_results cer,
30516: pqh_table_route trt
30517: where cer.table_route_id = trt.table_route_id
30518: and trt.table_alias = 'PET'
30519: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
30520: end if;
30663: information181,
30664: information182,
30665: cer.object_version_number
30666: from pqh_copy_entity_results cer,
30667: pqh_table_route trt
30668: where cer.table_route_id = trt.table_route_id
30669: and trt.table_alias = 'CPO'
30670: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
30671: end if;
30810: information181,
30811: information182,
30812: cer.object_version_number
30813: from pqh_copy_entity_results cer,
30814: pqh_table_route trt
30815: where cer.table_route_id = trt.table_route_id
30816: and trt.table_alias = 'CPR'
30817: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
30818: end if;
30957: information181,
30958: information182,
30959: cer.object_version_number
30960: from pqh_copy_entity_results cer,
30961: pqh_table_route trt
30962: where cer.table_route_id = trt.table_route_id
30963: and trt.table_alias = 'RGR'
30964: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
30965: end if;
31110: information181,
31111: information182,
31112: cer.object_version_number
31113: from pqh_copy_entity_results cer,
31114: pqh_table_route trt
31115: where cer.table_route_id = trt.table_route_id
31116: and trt.table_alias = 'CPY'
31117: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
31118: end if;
31259: information181,
31260: information182,
31261: cer.object_version_number
31262: from pqh_copy_entity_results cer,
31263: pqh_table_route trt
31264: where cer.table_route_id = trt.table_route_id
31265: and trt.table_alias = 'PGR'
31266: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
31267: end if;
31420: information181,
31421: information182,
31422: cer.object_version_number
31423: from pqh_copy_entity_results cer,
31424: pqh_table_route trt
31425: where cer.table_route_id = trt.table_route_id
31426: and trt.table_alias = 'PMRPV'
31427: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
31428: end if;
31571: information181,
31572: information182,
31573: cer.object_version_number
31574: from pqh_copy_entity_results cer,
31575: pqh_table_route trt
31576: where cer.table_route_id = trt.table_route_id
31577: and trt.table_alias = 'CER'
31578: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
31579: end if;
31752: information181,
31753: information182,
31754: cer.object_version_number
31755: from pqh_copy_entity_results cer,
31756: pqh_table_route trt
31757: where cer.table_route_id = trt.table_route_id
31758: and trt.table_alias = 'EPA'
31759: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
31760: end if;
31901: information181,
31902: information182,
31903: cer.object_version_number
31904: from pqh_copy_entity_results cer,
31905: pqh_table_route trt
31906: where cer.table_route_id = trt.table_route_id
31907: and trt.table_alias = 'CEP'
31908: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
31909: end if;
32050: information181,
32051: information182,
32052: cer.object_version_number
32053: from pqh_copy_entity_results cer,
32054: pqh_table_route trt
32055: where cer.table_route_id = trt.table_route_id
32056: and trt.table_alias = 'PAP'
32057: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
32058: end if;
32195: information181,
32196: information182,
32197: cer.object_version_number
32198: from pqh_copy_entity_results cer,
32199: pqh_table_route trt
32200: where cer.table_route_id = trt.table_route_id
32201: and trt.table_alias = 'RZR'
32202: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
32203: end if;
32344: information181,
32345: information182,
32346: cer.object_version_number
32347: from pqh_copy_entity_results cer,
32348: pqh_table_route trt
32349: where cer.table_route_id = trt.table_route_id
32350: and trt.table_alias = 'PZR'
32351: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
32352: end if;
32491: information181,
32492: information182,
32493: cer.object_version_number
32494: from pqh_copy_entity_results cer,
32495: pqh_table_route trt
32496: where cer.table_route_id = trt.table_route_id
32497: and trt.table_alias = 'PST'
32498: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
32499: end if;
32648: information181,
32649: information182,
32650: cer.object_version_number
32651: from pqh_copy_entity_results cer,
32652: pqh_table_route trt
32653: where cer.table_route_id = trt.table_route_id
32654: and trt.table_alias = 'PDL'
32655: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
32656: end if;
32803: information181,
32804: information182,
32805: cer.object_version_number
32806: from pqh_copy_entity_results cer,
32807: pqh_table_route trt
32808: where cer.table_route_id = trt.table_route_id
32809: and trt.table_alias = 'PYD'
32810: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
32811: end if;
33064: information181,
33065: information182,
33066: cer.object_version_number
33067: from pqh_copy_entity_results cer,
33068: pqh_table_route trt
33069: where cer.table_route_id = trt.table_route_id
33070: and trt.table_alias = 'CTP'
33071: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
33072: end if;
33211: information181,
33212: information182,
33213: cer.object_version_number
33214: from pqh_copy_entity_results cer,
33215: pqh_table_route trt
33216: where cer.table_route_id = trt.table_route_id
33217: and trt.table_alias = 'PSQ'
33218: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
33219: end if;
33358: information181,
33359: information182,
33360: cer.object_version_number
33361: from pqh_copy_entity_results cer,
33362: pqh_table_route trt
33363: where cer.table_route_id = trt.table_route_id
33364: and trt.table_alias = 'PR_'
33365: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
33366: end if;
33505: information181,
33506: information182,
33507: cer.object_version_number
33508: from pqh_copy_entity_results cer,
33509: pqh_table_route trt
33510: where cer.table_route_id = trt.table_route_id
33511: and trt.table_alias = 'PBR'
33512: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
33513: end if;
33654: information181,
33655: information182,
33656: cer.object_version_number
33657: from pqh_copy_entity_results cer,
33658: pqh_table_route trt
33659: where cer.table_route_id = trt.table_route_id
33660: and trt.table_alias = 'QTR'
33661: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
33662: end if;
33803: information181,
33804: information182,
33805: cer.object_version_number
33806: from pqh_copy_entity_results cer,
33807: pqh_table_route trt
33808: where cer.table_route_id = trt.table_route_id
33809: and trt.table_alias = 'QIG'
33810: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
33811: end if;
33950: information181,
33951: information182,
33952: cer.object_version_number
33953: from pqh_copy_entity_results cer,
33954: pqh_table_route trt
33955: where cer.table_route_id = trt.table_route_id
33956: and trt.table_alias = 'REG'
33957: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
33958: end if;
34105: information181,
34106: information182,
34107: cer.object_version_number
34108: from pqh_copy_entity_results cer,
34109: pqh_table_route trt
34110: where cer.table_route_id = trt.table_route_id
34111: and trt.table_alias = 'RCL'
34112: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
34113: end if;
34252: information181,
34253: information182,
34254: cer.object_version_number
34255: from pqh_copy_entity_results cer,
34256: pqh_table_route trt
34257: where cer.table_route_id = trt.table_route_id
34258: and trt.table_alias = 'BNR'
34259: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
34260: end if;
34399: information181,
34400: information182,
34401: cer.object_version_number
34402: from pqh_copy_entity_results cer,
34403: pqh_table_route trt
34404: where cer.table_route_id = trt.table_route_id
34405: and trt.table_alias = 'SER'
34406: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
34407: end if;
34562: information181,
34563: information182,
34564: cer.object_version_number
34565: from pqh_copy_entity_results cer,
34566: pqh_table_route trt
34567: where cer.table_route_id = trt.table_route_id
34568: and trt.table_alias = 'SHR'
34569: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
34570: end if;
34707: information181,
34708: information182,
34709: cer.object_version_number
34710: from pqh_copy_entity_results cer,
34711: pqh_table_route trt
34712: where cer.table_route_id = trt.table_route_id
34713: and trt.table_alias = 'SVA'
34714: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
34715: end if;
34852: information181,
34853: information182,
34854: cer.object_version_number
34855: from pqh_copy_entity_results cer,
34856: pqh_table_route trt
34857: where cer.table_route_id = trt.table_route_id
34858: and trt.table_alias = 'SAZ'
34859: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
34860: end if;
35001: information181,
35002: information182,
35003: cer.object_version_number
35004: from pqh_copy_entity_results cer,
35005: pqh_table_route trt
35006: where cer.table_route_id = trt.table_route_id
35007: and trt.table_alias = 'SAR'
35008: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
35009: end if;
35150: information181,
35151: information182,
35152: cer.object_version_number
35153: from pqh_copy_entity_results cer,
35154: pqh_table_route trt
35155: where cer.table_route_id = trt.table_route_id
35156: and trt.table_alias = 'TUR'
35157: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
35158: end if;
35309: information181,
35310: information182,
35311: cer.object_version_number
35312: from pqh_copy_entity_results cer,
35313: pqh_table_route trt
35314: where cer.table_route_id = trt.table_route_id
35315: and trt.table_alias = 'TCV'
35316: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
35317: end if;
35468: information181,
35469: information182,
35470: cer.object_version_number
35471: from pqh_copy_entity_results cer,
35472: pqh_table_route trt
35473: where cer.table_route_id = trt.table_route_id
35474: and trt.table_alias = 'TTP'
35475: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
35476: end if;
35613: information181,
35614: information182,
35615: cer.object_version_number
35616: from pqh_copy_entity_results cer,
35617: pqh_table_route trt
35618: where cer.table_route_id = trt.table_route_id
35619: and trt.table_alias = 'VRP'
35620: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
35621: end if;
35782: information181,
35783: information182,
35784: cer.object_version_number
35785: from pqh_copy_entity_results cer,
35786: pqh_table_route trt
35787: where cer.table_route_id = trt.table_route_id
35788: and trt.table_alias = 'VMR'
35789: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
35790: end if;
36111: information181,
36112: information182,
36113: cer.object_version_number
36114: from pqh_copy_entity_results cer,
36115: pqh_table_route trt
36116: where cer.table_route_id = trt.table_route_id
36117: and trt.table_alias = 'VPF'
36118: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
36119: end if;
36260: information181,
36261: information182,
36262: cer.object_version_number
36263: from pqh_copy_entity_results cer,
36264: pqh_table_route trt
36265: where cer.table_route_id = trt.table_route_id
36266: and trt.table_alias = 'VPR'
36267: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
36268: end if;
36407: information181,
36408: information182,
36409: cer.object_version_number
36410: from pqh_copy_entity_results cer,
36411: pqh_table_route trt
36412: where cer.table_route_id = trt.table_route_id
36413: and trt.table_alias = 'WLR'
36414: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
36415: end if;
36560: information181,
36561: information182,
36562: cer.object_version_number
36563: from pqh_copy_entity_results cer,
36564: pqh_table_route trt
36565: where cer.table_route_id = trt.table_route_id
36566: and trt.table_alias = 'WYP'
36567: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
36568: end if;
36713: information181,
36714: information182,
36715: cer.object_version_number
36716: from pqh_copy_entity_results cer,
36717: pqh_table_route trt
36718: where cer.table_route_id = trt.table_route_id
36719: and trt.table_alias = 'WCN'
36720: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
36721: end if;
36868: information181,
36869: information182,
36870: cer.object_version_number
36871: from pqh_copy_entity_results cer,
36872: pqh_table_route trt
36873: where cer.table_route_id = trt.table_route_id
36874: and trt.table_alias = 'WCT'
36875: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
36876: end if;
37015: information181,
37016: information182,
37017: cer.object_version_number
37018: from pqh_copy_entity_results cer,
37019: pqh_table_route trt
37020: where cer.table_route_id = trt.table_route_id
37021: and trt.table_alias = 'WPN'
37022: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
37023: end if;
37162: information181,
37163: information182,
37164: cer.object_version_number
37165: from pqh_copy_entity_results cer,
37166: pqh_table_route trt
37167: where cer.table_route_id = trt.table_route_id
37168: and trt.table_alias = 'WPT'
37169: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
37170: end if;
37317: information181,
37318: information182,
37319: cer.object_version_number
37320: from pqh_copy_entity_results cer,
37321: pqh_table_route trt
37322: where cer.table_route_id = trt.table_route_id
37323: and trt.table_alias = 'YRP'
37324: and cer.copy_entity_txn_id = p_copy_entity_txn_id;
37325: end if;