[Home] [Help]
160: ,p_child_data in varchar2) is
161: --
162: cursor c_display_name(p_table_alias varchar2) is
163: select display_name,table_route_id
164: from pqh_table_route
165: where table_alias= p_table_alias;
166: --
167: cursor c_parent_data(p_parent_pk_id number,
168: p_copy_entity_txn_id number,
248: cpe.information2,
249: cpe.information3,
250: cpe.table_route_id
251: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
252: pqh_table_route tr
253: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
254: and cpe.table_route_id = tr.table_route_id
255: -- and tr.where_clause = l_BEN_JOB_RT_F
256: and tr.table_alias = l_table_alias
737: cpe.information2,
738: cpe.information3,
739: cpe.table_route_id
740: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
741: pqh_table_route tr
742: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
743: and cpe.table_route_id = tr.table_route_id
744: -- and tr.where_clause = l_BEN_HRLY_SLRD_RT_F
745: and tr.table_alias = l_table_alias
1202: cpe.information2,
1203: cpe.information3,
1204: cpe.table_route_id
1205: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
1206: pqh_table_route tr
1207: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1208: and cpe.table_route_id = tr.table_route_id
1209: -- and tr.where_clause = l_BEN_GRADE_RT_F
1210: and tr.table_alias = l_table_alias
1687: cpe.information2,
1688: cpe.information3,
1689: cpe.table_route_id
1690: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
1691: pqh_table_route tr
1692: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1693: and cpe.table_route_id = tr.table_route_id
1694: -- and tr.where_clause = l_BEN_FL_TM_PT_TM_RT_F
1695: and tr.table_alias = l_table_alias
2152: cpe.information2,
2153: cpe.information3,
2154: cpe.table_route_id
2155: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
2156: pqh_table_route tr
2157: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2158: and cpe.table_route_id = tr.table_route_id
2159: -- and tr.where_clause = l_BEN_BRGNG_UNIT_RT_F
2160: and tr.table_alias = l_table_alias
2617: cpe.information2,
2618: cpe.information3,
2619: cpe.table_route_id
2620: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
2621: pqh_table_route tr
2622: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2623: and cpe.table_route_id = tr.table_route_id
2624: -- and tr.where_clause = l_BEN_EE_STAT_RT_F
2625: and tr.table_alias = l_table_alias
3099: cpe.information2,
3100: cpe.information3,
3101: cpe.table_route_id
3102: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
3103: pqh_table_route tr
3104: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3105: and cpe.table_route_id = tr.table_route_id
3106: -- and tr.where_clause = l_BEN_ASNT_SET_RT_F
3107: and tr.table_alias = l_table_alias
3580: cpe.information2,
3581: cpe.information3,
3582: cpe.table_route_id
3583: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
3584: pqh_table_route tr
3585: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3586: and cpe.table_route_id = tr.table_route_id
3587: -- and tr.where_clause = l_BEN_TBCO_USE_RT_F
3588: and tr.table_alias = l_table_alias
4047: cpe.information2,
4048: cpe.information3,
4049: cpe.table_route_id
4050: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4051: pqh_table_route tr
4052: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4053: and cpe.table_route_id = tr.table_route_id
4054: -- and tr.where_clause = l_BEN_SVC_AREA_RT_F
4055: and tr.table_alias = l_table_alias
4512: cpe.information2,
4513: cpe.information3,
4514: cpe.table_route_id
4515: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4516: pqh_table_route tr
4517: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4518: and cpe.table_route_id = tr.table_route_id
4519: -- and tr.where_clause = l_BEN_QUAL_TITL_RT_F
4520: and tr.table_alias = l_table_alias
4994: cpe.information2,
4995: cpe.information3,
4996: cpe.table_route_id
4997: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4998: pqh_table_route tr
4999: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5000: and cpe.table_route_id = tr.table_route_id
5001: -- and tr.where_clause = l_BEN_PSTL_ZIP_RT_F
5002: and tr.table_alias = l_table_alias
5459: cpe.information2,
5460: cpe.information3,
5461: cpe.table_route_id
5462: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5463: pqh_table_route tr
5464: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5465: and cpe.table_route_id = tr.table_route_id
5466: -- and tr.where_clause = l_BEN_PER_TYP_RT_F
5467: and tr.table_alias = l_table_alias
5942: cpe.information2,
5943: cpe.information3,
5944: cpe.table_route_id
5945: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5946: pqh_table_route tr
5947: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5948: and cpe.table_route_id = tr.table_route_id
5949: -- and tr.where_clause = l_BEN_GNDR_RT_F
5950: and tr.table_alias = l_table_alias
6404: cpe.information2,
6405: cpe.information3,
6406: cpe.table_route_id
6407: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6408: pqh_table_route tr
6409: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6410: and cpe.table_route_id = tr.table_route_id
6411: -- and tr.where_clause = l_BEN_DSBLD_RT_F
6412: and tr.table_alias = l_table_alias
6870: cpe.information2,
6871: cpe.information3,
6872: cpe.table_route_id
6873: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6874: pqh_table_route tr
6875: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6876: and cpe.table_route_id = tr.table_route_id
6877: -- and tr.where_clause = l_BEN_COMPTNCY_RT_F
6878: and tr.table_alias = l_table_alias
7366: cpe.information2,
7367: cpe.information3,
7368: cpe.table_route_id
7369: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7370: pqh_table_route tr
7371: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7372: and cpe.table_route_id = tr.table_route_id
7373: -- and tr.where_clause = l_BEN_LBR_MMBR_RT_F
7374: and tr.table_alias = l_table_alias
7825: cpe.information2,
7826: cpe.information3,
7827: cpe.table_route_id
7828: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7829: pqh_table_route tr
7830: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7831: and cpe.table_route_id = tr.table_route_id
7832: -- and tr.where_clause = l_BEN_LOA_RSN_RT_F
7833: and tr.table_alias = l_table_alias
8316: cpe.information2,
8317: cpe.information3,
8318: cpe.table_route_id
8319: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8320: pqh_table_route tr
8321: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8322: and cpe.table_route_id = tr.table_route_id
8323: -- and tr.where_clause = l_BEN_ORG_UNIT_RT_F
8324: and tr.table_alias = l_table_alias
8791: cpe.information2,
8792: cpe.information3,
8793: cpe.table_route_id
8794: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8795: pqh_table_route tr
8796: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8797: and cpe.table_route_id = tr.table_route_id
8798: -- and tr.where_clause = l_BEN_LGL_ENTY_RT_F
8799: and tr.table_alias = l_table_alias
9267: cpe.information2,
9268: cpe.information3,
9269: cpe.table_route_id
9270: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9271: pqh_table_route tr
9272: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9273: and cpe.table_route_id = tr.table_route_id
9274: -- and tr.where_clause = l_BEN_PYRL_RT_F
9275: and tr.table_alias = l_table_alias
9741: cpe.information2,
9742: cpe.information3,
9743: cpe.table_route_id
9744: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9745: pqh_table_route tr
9746: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9747: and cpe.table_route_id = tr.table_route_id
9748: -- and tr.where_clause = l_BEN_PY_BSS_RT_F
9749: and tr.table_alias = l_table_alias
10219: cpe.information2,
10220: cpe.information3,
10221: cpe.table_route_id
10222: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10223: pqh_table_route tr
10224: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10225: and cpe.table_route_id = tr.table_route_id
10226: -- and tr.where_clause = l_BEN_CBR_QUALD_BNF_RT_F
10227: and tr.table_alias = l_table_alias
10687: cpe.information2,
10688: cpe.information3,
10689: cpe.table_route_id
10690: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10691: pqh_table_route tr
10692: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10693: and cpe.table_route_id = tr.table_route_id
10694: -- and tr.where_clause = l_BEN_BENFTS_GRP_RT_F
10695: and tr.table_alias = l_table_alias
11144: cpe.information2,
11145: cpe.information3,
11146: cpe.table_route_id
11147: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
11148: pqh_table_route tr
11149: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11150: and cpe.table_route_id = tr.table_route_id
11151: -- and tr.where_clause = l_BEN_CMBN_AGE_LOS_RT_F
11152: and tr.table_alias = l_table_alias
11601: cpe.information2,
11602: cpe.information3,
11603: cpe.table_route_id
11604: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
11605: pqh_table_route tr
11606: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11607: and cpe.table_route_id = tr.table_route_id
11608: -- and tr.where_clause = l_BEN_VRBL_MTCHG_RT_F
11609: and tr.table_alias = l_table_alias
12077: cpe.information2,
12078: cpe.information3,
12079: cpe.table_route_id
12080: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12081: pqh_table_route tr
12082: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12083: and cpe.table_route_id = tr.table_route_id
12084: -- and tr.where_clause = l_BEN_PRTT_ANTHR_PL_RT_F
12085: and tr.table_alias = l_table_alias
12537: cpe.information2,
12538: cpe.information3,
12539: cpe.table_route_id
12540: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12541: pqh_table_route tr
12542: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12543: and cpe.table_route_id = tr.table_route_id
12544: -- and tr.where_clause = l_BEN_OTHR_PTIP_RT_F
12545: and tr.table_alias = l_table_alias
12998: cpe.information2,
12999: cpe.information3,
13000: cpe.table_route_id
13001: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13002: pqh_table_route tr
13003: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13004: and cpe.table_route_id = tr.table_route_id
13005: -- and tr.where_clause = l_BEN_NO_OTHR_CVG_RT_F
13006: and tr.table_alias = l_table_alias
13452: cpe.information2,
13453: cpe.information3,
13454: cpe.table_route_id
13455: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13456: pqh_table_route tr
13457: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13458: and cpe.table_route_id = tr.table_route_id
13459: -- and tr.where_clause = l_BEN_OPTD_MDCR_RT_F
13460: and tr.table_alias = l_table_alias
13905: cpe.information2,
13906: cpe.information3,
13907: cpe.table_route_id
13908: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13909: pqh_table_route tr
13910: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13911: and cpe.table_route_id = tr.table_route_id
13912: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PGM_RT_F
13913: and tr.table_alias = l_table_alias
14366: cpe.information2,
14367: cpe.information3,
14368: cpe.table_route_id
14369: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14370: pqh_table_route tr
14371: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14372: and cpe.table_route_id = tr.table_route_id
14373: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PTIP_RT_F
14374: and tr.table_alias = l_table_alias
14829: cpe.information2,
14830: cpe.information3,
14831: cpe.table_route_id
14832: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14833: pqh_table_route tr
14834: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14835: and cpe.table_route_id = tr.table_route_id
14836: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PL_RT_F
14837: and tr.table_alias = l_table_alias
15290: cpe.information2,
15291: cpe.information3,
15292: cpe.table_route_id
15293: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15294: pqh_table_route tr
15295: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15296: and cpe.table_route_id = tr.table_route_id
15297: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PLIP_RT_F
15298: and tr.table_alias = l_table_alias
15751: cpe.information2,
15752: cpe.information3,
15753: cpe.table_route_id
15754: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15755: pqh_table_route tr
15756: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15757: and cpe.table_route_id = tr.table_route_id
15758: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_OIPL_RT_F
15759: and tr.table_alias = l_table_alias
16212: cpe.information2,
16213: cpe.information3,
16214: cpe.table_route_id
16215: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16216: pqh_table_route tr
16217: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16218: and cpe.table_route_id = tr.table_route_id
16219: -- and tr.where_clause = l_BEN_DPNT_OTHR_PTIP_RT_F
16220: and tr.table_alias = l_table_alias
16671: cpe.information2,
16672: cpe.information3,
16673: cpe.table_route_id
16674: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16675: pqh_table_route tr
16676: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16677: and cpe.table_route_id = tr.table_route_id
16678: -- and tr.where_clause = l_BEN_DPNT_CVRD_OTHR_PGM_RT_F
16679: and tr.table_alias = l_table_alias
17134: cpe.information2,
17135: cpe.information3,
17136: cpe.table_route_id
17137: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17138: pqh_table_route tr
17139: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17140: and cpe.table_route_id = tr.table_route_id
17141: -- and tr.where_clause = l_BEN_DPNT_CVRD_PLIP_RT_F
17142: and tr.table_alias = l_table_alias
17595: cpe.information2,
17596: cpe.information3,
17597: cpe.table_route_id
17598: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17599: pqh_table_route tr
17600: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17601: and cpe.table_route_id = tr.table_route_id
17602: -- and tr.where_clause = l_BEN_DPNT_CVRD_OTHR_PTIP_RT_F
17603: and tr.table_alias = l_table_alias
18058: cpe.information2,
18059: cpe.information3,
18060: cpe.table_route_id
18061: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18062: pqh_table_route tr
18063: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18064: and cpe.table_route_id = tr.table_route_id
18065: -- and tr.where_clause = l_BEN_DPNT_CVRD_OTHR_PL_RT_F
18066: and tr.table_alias = l_table_alias
18526: cpe.information2,
18527: cpe.information3,
18528: cpe.table_route_id
18529: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18530: pqh_table_route tr
18531: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18532: and cpe.table_route_id = tr.table_route_id
18533: -- and tr.where_clause = l_BEN_TTL_PRTT_RT_F
18534: and tr.table_alias = l_table_alias
19026: cpe.information2,
19027: cpe.information3,
19028: cpe.table_route_id
19029: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19030: pqh_table_route tr
19031: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19032: and cpe.table_route_id = tr.table_route_id
19033: -- and tr.where_clause = l_BEN_TTL_CVG_VOL_RT_F
19034: and tr.table_alias = l_table_alias
19516: cpe.information2,
19517: cpe.information3,
19518: cpe.table_route_id
19519: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19520: pqh_table_route tr
19521: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19522: and cpe.table_route_id = tr.table_route_id
19523: -- and tr.where_clause = l_BEN_VRBL_RT_PRFL_RL_F
19524: and tr.table_alias = l_table_alias
19979: cpe.information2,
19980: cpe.information3,
19981: cpe.table_route_id
19982: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19983: pqh_table_route tr
19984: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19985: and cpe.table_route_id = tr.table_route_id
19986: -- and tr.where_clause = l_BEN_POE_RT_F
19987: and tr.table_alias = l_table_alias
20473: cpe.information3,
20474: cpe.information170 name,
20475: cpe.table_route_id
20476: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20477: pqh_table_route tr
20478: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20479: and cpe.table_route_id = tr.table_route_id
20480: -- and tr.where_clause = l_BEN_CNTNG_PRTN_PRFL_RT_F
20481: and tr.table_alias = l_table_alias
20939: cpe.information2,
20940: cpe.information3,
20941: cpe.table_route_id
20942: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20943: pqh_table_route tr
20944: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20945: and cpe.table_route_id = tr.table_route_id
20946: -- and tr.where_clause = l_BEN_PSTN_RT_F
20947: and tr.table_alias = l_table_alias
21422: cpe.information2,
21423: cpe.information3,
21424: cpe.table_route_id
21425: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21426: pqh_table_route tr
21427: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21428: and cpe.table_route_id = tr.table_route_id
21429: -- and tr.where_clause = l_BEN_WK_LOC_RT_F
21430: and tr.table_alias = l_table_alias
21901: cpe.information2,
21902: cpe.information3,
21903: cpe.table_route_id
21904: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21905: pqh_table_route tr
21906: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21907: and cpe.table_route_id = tr.table_route_id
21908: -- and tr.where_clause = l_BEN_PCT_FL_TM_RT_F
21909: and tr.table_alias = l_table_alias
22364: cpe.information2,
22365: cpe.information3,
22366: cpe.table_route_id
22367: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22368: pqh_table_route tr
22369: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22370: and cpe.table_route_id = tr.table_route_id
22371: -- and tr.where_clause = l_BEN_HRS_WKD_IN_PERD_RT_F
22372: and tr.table_alias = l_table_alias
22828: cpe.information2,
22829: cpe.information3,
22830: cpe.table_route_id
22831: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22832: pqh_table_route tr
22833: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22834: and cpe.table_route_id = tr.table_route_id
22835: -- and tr.where_clause = l_BEN_COMP_LVL_RT_F
22836: and tr.table_alias = l_table_alias
23290: cpe.information2,
23291: cpe.information3,
23292: cpe.table_route_id
23293: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23294: pqh_table_route tr
23295: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23296: and cpe.table_route_id = tr.table_route_id
23297: -- and tr.where_clause = l_BEN_LOS_RT_F
23298: and tr.table_alias = l_table_alias
23747: cpe.information2,
23748: cpe.information3,
23749: cpe.table_route_id
23750: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23751: pqh_table_route tr
23752: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23753: and cpe.table_route_id = tr.table_route_id
23754: -- and tr.where_clause = l_BEN_LVG_RSN_RT_F
23755: and tr.table_alias = l_table_alias
24205: cpe.information2,
24206: cpe.information3,
24207: cpe.table_route_id
24208: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24209: pqh_table_route tr
24210: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24211: and cpe.table_route_id = tr.table_route_id
24212: -- and tr.where_clause = l_BEN_AGE_RT_F
24213: and tr.table_alias = l_table_alias
24677: cpe.information2,
24678: cpe.information3,
24679: cpe.table_route_id
24680: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24681: pqh_table_route tr
24682: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24683: and cpe.table_route_id = tr.table_route_id
24684: -- and tr.where_clause = l_BEN_SCHEDD_HRS_RT_F
24685: and tr.table_alias = l_table_alias
25184: cpe.information2,
25185: cpe.information3,
25186: cpe.table_route_id
25187: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25188: pqh_table_route tr
25189: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25190: and cpe.table_route_id = tr.table_route_id
25191: -- and tr.where_clause = l_BEN_QUA_IN_GR_RT_F
25192: and tr.table_alias = l_table_alias
25649: cpe.information2,
25650: cpe.information3,
25651: cpe.table_route_id
25652: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25653: pqh_table_route tr
25654: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25655: and cpe.table_route_id = tr.table_route_id
25656: -- and tr.where_clause = l_BEN_PERF_RTNG_RT_F
25657: and tr.table_alias = l_table_alias
26117: cpe.information2,
26118: cpe.information3,
26119: cpe.table_route_id
26120: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26121: pqh_table_route tr
26122: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26123: and cpe.table_route_id = tr.table_route_id
26124: -- and tr.where_clause = l_BEN_PPL_GRP_RT_F
26125: and tr.table_alias = l_table_alias