eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on PQH_TABLE_ROUTE

Line 227: pqh_table_route tr

223: cpe.table_route_id,
224: cpe.dml_operation,
225: cpe.datetrack_mode
226: from ben_copy_entity_results cpe,
227: pqh_table_route tr
228: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
229: and cpe.table_route_id = tr.table_route_id
230: -- and tr.where_clause = l_BEN_PL_REGY_BOD_F
231: and tr.table_alias = l_table_alias

Line 709: pqh_table_route tr

705: cpe.table_route_id,
706: cpe.dml_operation,
707: cpe.datetrack_mode
708: from ben_copy_entity_results cpe,
709: pqh_table_route tr
710: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
711: and cpe.table_route_id = tr.table_route_id
712: -- and tr.where_clause = l_BEN_SVC_AREA_PSTL_ZIP_RNG_F
713: and tr.table_alias = l_table_alias

Line 1170: pqh_table_route tr

1166: cpe.information2,
1167: cpe.information3,
1168: cpe.table_route_id
1169: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
1170: pqh_table_route tr
1171: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1172: and cpe.table_route_id = tr.table_route_id
1173: -- and tr.where_clause = l_BEN_PL_BNF_CTFN_F
1174: and tr.table_alias = l_table_alias

Line 1657: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr

1653: select distinct cpe.information1,
1654: cpe.information2,
1655: cpe.information3,
1656: cpe.table_route_id
1657: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
1658: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1659: and cpe.table_route_id = tr.table_route_id
1660: -- and tr.where_clause = l_BEN_PL_DPNT_CVG_CTFN_F
1661: and tr.table_alias = l_table_alias

Line 2132: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr

2128: select distinct cpe.information1,
2129: cpe.information2,
2130: cpe.information3,
2131: cpe.table_route_id
2132: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
2133: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2134: and cpe.table_route_id = tr.table_route_id
2135: -- and tr.where_clause = l_BEN_LER_CHG_PL_NIP_ENRT_F
2136: and tr.table_alias = l_table_alias

Line 2620: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr

2616: select distinct cpe.information1,
2617: cpe.information2,
2618: cpe.information3,
2619: cpe.table_route_id
2620: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
2621: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2622: and cpe.table_route_id = tr.table_route_id
2623: -- and tr.where_clause = l_BEN_LER_CHG_OIPL_ENRT_F
2624: and tr.table_alias = l_table_alias

Line 3100: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr

3096: select distinct cpe.information1,
3097: cpe.information2,
3098: cpe.information3,
3099: cpe.table_route_id
3100: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
3101: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3102: and cpe.table_route_id = tr.table_route_id
3103: -- and tr.where_clause = l_BEN_LER_ENRT_CTFN_F
3104: and tr.table_alias = l_table_alias

Line 3575: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr

3571: select distinct cpe.information1,
3572: cpe.information2,
3573: cpe.information3,
3574: cpe.table_route_id
3575: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
3576: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3577: and cpe.table_route_id = tr.table_route_id
3578: -- and tr.where_clause = l_BEN_LER_RQRS_ENRT_CTFN_F
3579: and tr.table_alias = l_table_alias

Line 4065: pqh_table_route tr

4061: cpe.information2,
4062: cpe.information3,
4063: cpe.table_route_id
4064: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4065: pqh_table_route tr
4066: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4067: and cpe.table_route_id = tr.table_route_id
4068: -- and tr.where_clause = l_BEN_LER_BNFT_RSTRN_CTFN_F
4069: and tr.table_alias = l_table_alias

Line 4539: pqh_table_route tr

4535: cpe.information2,
4536: cpe.information3,
4537: cpe.table_route_id
4538: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4539: pqh_table_route tr
4540: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4541: and cpe.table_route_id = tr.table_route_id
4542: -- and tr.where_clause = l_BEN_BNFT_RSTRN_CTFN_F
4543: and tr.table_alias = l_table_alias

Line 5006: pqh_table_route tr

5002: cpe.information2,
5003: cpe.information3,
5004: cpe.table_route_id
5005: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5006: pqh_table_route tr
5007: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5008: and cpe.table_route_id = tr.table_route_id
5009: -- and tr.where_clause = l_BEN_WV_PRTN_RSN_CTFN_PL_F
5010: and tr.table_alias = l_table_alias

Line 5484: pqh_table_route tr

5480: cpe.information2,
5481: cpe.information3,
5482: cpe.table_route_id
5483: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5484: pqh_table_route tr
5485: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5486: and cpe.table_route_id = tr.table_route_id
5487: -- and tr.where_clause = l_BEN_WV_PRTN_RSN_PL_F
5488: and tr.table_alias = l_table_alias

Line 5953: pqh_table_route tr

5949: cpe.information2,
5950: cpe.information3,
5951: cpe.table_route_id
5952: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5953: pqh_table_route tr
5954: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5955: and cpe.table_route_id = tr.table_route_id
5956: -- and tr.where_clause = l_BEN_VALD_RLSHP_FOR_REIMB_F
5957: and tr.table_alias = l_table_alias

Line 6422: pqh_table_route tr

6418: cpe.information2,
6419: cpe.information3,
6420: cpe.table_route_id
6421: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6422: pqh_table_route tr
6423: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6424: and cpe.table_route_id = tr.table_route_id
6425: -- and tr.where_clause = l_BEN_PL_GD_R_SVC_CTFN_F
6426: and tr.table_alias = l_table_alias

Line 6900: pqh_table_route tr

6896: cpe.information2,
6897: cpe.information3,
6898: cpe.table_route_id
6899: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6900: pqh_table_route tr
6901: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6902: and cpe.table_route_id = tr.table_route_id
6903: -- and tr.where_clause = l_BEN_PL_GD_OR_SVC_F
6904: and tr.table_alias = l_table_alias

Line 7380: pqh_table_route tr

7376: cpe.information2,
7377: cpe.information3,
7378: cpe.table_route_id
7379: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7380: pqh_table_route tr
7381: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7382: and cpe.table_route_id = tr.table_route_id
7383: -- and tr.where_clause = l_BEN_LER_BNFT_RSTRN_F
7384: and tr.table_alias = l_table_alias

Line 7901: pqh_table_route tr

7897: cpe.information2,
7898: cpe.information3,
7899: cpe.table_route_id
7900: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7901: pqh_table_route tr
7902: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7903: and cpe.table_route_id = tr.table_route_id
7904: -- and tr.where_clause = l_BEN_LER_CHG_PLIP_ENRT_F
7905: and tr.table_alias = l_table_alias

Line 8403: pqh_table_route tr

8399: cpe.information2,
8400: cpe.information3,
8401: cpe.table_route_id
8402: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8403: pqh_table_route tr
8404: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8405: and cpe.table_route_id = tr.table_route_id
8406: -- and tr.where_clause = l_BEN_PLIP_F
8407: and tr.table_alias = l_table_alias

Line 8996: pqh_table_route tr

8992: cpe.information2,
8993: cpe.information3,
8994: cpe.table_route_id
8995: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8996: pqh_table_route tr
8997: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8998: and cpe.table_route_id = tr.table_route_id
8999: -- and tr.where_clause = l_BEN_PTIP_DPNT_CVG_CTFN_F
9000: and tr.table_alias = l_table_alias

Line 9481: pqh_table_route tr

9477: cpe.information2,
9478: cpe.information3,
9479: cpe.table_route_id
9480: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9481: pqh_table_route tr
9482: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9483: and cpe.table_route_id = tr.table_route_id
9484: -- and tr.where_clause = l_BEN_LER_CHG_PTIP_ENRT_F
9485: and tr.table_alias = l_table_alias

Line 9976: pqh_table_route tr

9972: cpe.information2,
9973: cpe.information3,
9974: cpe.table_route_id
9975: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9976: pqh_table_route tr
9977: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9978: and cpe.table_route_id = tr.table_route_id
9979: -- and tr.where_clause = l_BEN_WV_PRTN_RSN_CTFN_PTIP_F
9980: and tr.table_alias = l_table_alias

Line 10454: pqh_table_route tr

10450: cpe.information2,
10451: cpe.information3,
10452: cpe.table_route_id
10453: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10454: pqh_table_route tr
10455: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10456: and cpe.table_route_id = tr.table_route_id
10457: -- and tr.where_clause = l_BEN_WV_PRTN_RSN_PTIP_F
10458: and tr.table_alias = l_table_alias

Line 10938: pqh_table_route tr

10934: cpe.information2,
10935: cpe.information3,
10936: cpe.table_route_id
10937: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10938: pqh_table_route tr
10939: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10940: and cpe.table_route_id = tr.table_route_id
10941: -- and tr.where_clause = l_BEN_PTIP_F
10942: and tr.table_alias = l_table_alias

Line 11583: pqh_table_route tr

11579: cpe.information2,
11580: cpe.information3,
11581: cpe.table_route_id
11582: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
11583: pqh_table_route tr
11584: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11585: and cpe.table_route_id = tr.table_route_id
11586: -- and tr.where_clause = l_BEN_LER_CHG_DPNT_CVG_CTFN_F
11587: and tr.table_alias = l_table_alias

Line 12059: pqh_table_route tr

12055: cpe.information2,
12056: cpe.information3,
12057: cpe.table_route_id
12058: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12059: pqh_table_route tr
12060: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12061: and cpe.table_route_id = tr.table_route_id
12062: -- and tr.where_clause = l_BEN_PRTN_ELIGY_RL_F
12063: and tr.table_alias = l_table_alias

Line 12531: pqh_table_route tr

12527: cpe.information2,
12528: cpe.information3,
12529: cpe.table_route_id
12530: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12531: pqh_table_route tr
12532: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12533: and cpe.table_route_id = tr.table_route_id
12534: -- and tr.where_clause = l_BEN_PRTN_ELIG_PRFL_F
12535: and tr.table_alias = l_table_alias

Line 13003: pqh_table_route tr

12999: cpe.information2,
13000: cpe.information3,
13001: cpe.table_route_id
13002: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13003: pqh_table_route tr
13004: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13005: and cpe.table_route_id = tr.table_route_id
13006: -- and tr.where_clause = l_BEN_POPL_ORG_ROLE_F
13007: and tr.table_alias = l_table_alias

Line 13483: pqh_table_route tr

13479: cpe.information2,
13480: cpe.information3,
13481: cpe.table_route_id
13482: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13483: pqh_table_route tr
13484: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13485: and cpe.table_route_id = tr.table_route_id
13486: -- and tr.where_clause = l_BEN_POPL_ORG_F
13487: and tr.table_alias = l_table_alias

Line 14002: pqh_table_route tr

13998: cpe.information2,
13999: cpe.information3,
14000: cpe.table_route_id
14001: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14002: pqh_table_route tr
14003: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14004: and cpe.table_route_id = tr.table_route_id
14005: -- and tr.where_clause = l_BEN_PL_REGN_F
14006: and tr.table_alias = l_table_alias

Line 14529: pqh_table_route tr

14525: cpe.information2,
14526: cpe.information3,
14527: cpe.table_route_id
14528: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14529: pqh_table_route tr
14530: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14531: and cpe.table_route_id = tr.table_route_id
14532: -- and tr.where_clause = l_BEN_POPL_RPTG_GRP_F
14533: and tr.table_alias = l_table_alias

Line 15011: pqh_table_route tr

15007: cpe.information2,
15008: cpe.information3,
15009: cpe.table_route_id
15010: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15011: pqh_table_route tr
15012: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15013: and cpe.table_route_id = tr.table_route_id
15014: -- and tr.where_clause = l_BEN_ENRT_CTFN_F
15015: and tr.table_alias = l_table_alias

Line 15496: pqh_table_route tr

15492: cpe.information2,
15493: cpe.information3,
15494: cpe.table_route_id
15495: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15496: pqh_table_route tr
15497: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15498: and cpe.table_route_id = tr.table_route_id
15499: -- and tr.where_clause = l_BEN_PRTN_ELIG_F
15500: and tr.table_alias = l_table_alias

Line 16015: pqh_table_route tr

16011: cpe.information2,
16012: cpe.information3,
16013: cpe.table_route_id
16014: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16015: pqh_table_route tr
16016: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16017: and cpe.table_route_id = tr.table_route_id
16018: -- and tr.where_clause = l_BEN_POPL_YR_PERD
16019: and tr.table_alias = l_table_alias

Line 16448: pqh_table_route tr

16444: cpe.information2,
16445: cpe.information3,
16446: cpe.table_route_id
16447: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16448: pqh_table_route tr
16449: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16450: and cpe.table_route_id = tr.table_route_id
16451: -- and tr.where_clause = l_BEN_POPL_ENRT_TYP_CYCL_F
16452: and tr.table_alias = l_table_alias

Line 16924: pqh_table_route tr

16920: cpe.information2,
16921: cpe.information3,
16922: cpe.table_route_id
16923: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16924: pqh_table_route tr
16925: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16926: and cpe.table_route_id = tr.table_route_id
16927: -- and tr.where_clause = l_BEN_ENRT_PERD
16928: and tr.table_alias = l_table_alias

Line 17387: pqh_table_route tr

17383: cpe.information2,
17384: cpe.information3,
17385: cpe.table_route_id
17386: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17387: pqh_table_route tr
17388: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17389: and cpe.table_route_id = tr.table_route_id
17390: -- and tr.where_clause = l_BEN_LEE_RSN_F
17391: and tr.table_alias = l_table_alias

Line 17907: pqh_table_route tr

17903: cpe.information2,
17904: cpe.information3,
17905: cpe.table_route_id
17906: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17907: pqh_table_route tr
17908: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17909: and cpe.table_route_id = tr.table_route_id
17910: -- and tr.where_clause = l_BEN_ENRT_PERD_FOR_PL_F
17911: and tr.table_alias = l_table_alias

Line 18400: pqh_table_route tr

18396: cpe.information2,
18397: cpe.information3,
18398: cpe.table_route_id
18399: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18400: pqh_table_route tr
18401: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18402: and cpe.table_route_id = tr.table_route_id
18403: -- and tr.where_clause = l_BEN_SCHEDD_ENRT_RL_F
18404: and tr.table_alias = l_table_alias

Line 18863: pqh_table_route tr

18859: cpe.information2,
18860: cpe.information3,
18861: cpe.table_route_id
18862: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18863: pqh_table_route tr
18864: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18865: and cpe.table_route_id = tr.table_route_id
18866: -- and tr.where_clause = l_BEN_LEE_RSN_RL_F
18867: and tr.table_alias = l_table_alias

Line 19328: pqh_table_route tr

19324: cpe.information2,
19325: cpe.information3,
19326: cpe.table_route_id
19327: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19328: pqh_table_route tr
19329: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19330: and cpe.table_route_id = tr.table_route_id
19331: -- and tr.where_clause = l_APLD_DPNT_CVG_ELIG_PRFL_F
19332: and tr.table_alias = l_table_alias

Line 19808: pqh_table_route tr

19804: cpe.information2,
19805: cpe.information3,
19806: cpe.table_route_id
19807: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19808: pqh_table_route tr
19809: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19810: and cpe.table_route_id = tr.table_route_id
19811: -- and tr.where_clause = l_BEN_PGM_DPNT_CVG_CTFN_F
19812: and tr.table_alias = l_table_alias

Line 20283: pqh_table_route tr

20279: cpe.information2,
20280: cpe.information3,
20281: cpe.table_route_id
20282: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20283: pqh_table_route tr
20284: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20285: and cpe.table_route_id = tr.table_route_id
20286: -- and tr.where_clause = l_BEN_LER_CHG_PGM_ENRT_F
20287: and tr.table_alias = l_table_alias

Line 20771: pqh_table_route tr

20767: cpe.information2,
20768: cpe.information3,
20769: cpe.table_route_id
20770: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20771: pqh_table_route tr
20772: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20773: and cpe.table_route_id = tr.table_route_id
20774: -- and tr.where_clause = l_BEN_LER_CHG_DPNT_CVG_F
20775: and tr.table_alias = l_table_alias

Line 21270: pqh_table_route tr

21266: cpe.information2,
21267: cpe.information3,
21268: cpe.table_route_id
21269: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21270: pqh_table_route tr
21271: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21272: and cpe.table_route_id = tr.table_route_id
21273: -- and tr.where_clause = l_BEN_POPL_ACTN_TYP_F
21274: and tr.table_alias = l_table_alias

Line 21760: pqh_table_route tr

21756: cpe.information2,
21757: cpe.information3,
21758: cpe.table_route_id
21759: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21760: pqh_table_route tr
21761: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21762: and cpe.table_route_id = tr.table_route_id
21763: -- and tr.where_clause = l_BEN_ELIG_TO_PRTE_RSN_F
21764: and tr.table_alias = l_table_alias

Line 22301: pqh_table_route tr

22297: cpe.information2,
22298: cpe.information3,
22299: cpe.table_route_id
22300: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22301: pqh_table_route tr
22302: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22303: and cpe.table_route_id = tr.table_route_id
22304: -- and tr.where_clause = l_BEN_CWB_WKSHT_GRP
22305: and tr.table_alias = l_table_alias

Line 22644: pqh_table_route tr

22640: cpe.information13,
22641: cpe.INFORMATION14,
22642: cpe.table_route_id,dml_operation,cpe.datetrack_mode
22643: from ben_copy_entity_results cpe,
22644: pqh_table_route tr
22645: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22646: and cpe.table_route_id = tr.table_route_id
22647: -- and tr.where_clause = l_BEN_AGE_FCTR
22648: and tr.table_alias = l_table_alias

Line 22846: pqh_table_route tr

22842: cpe.information2,
22843: cpe.information3,
22844: cpe.table_route_id
22845: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22846: pqh_table_route tr
22847: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22848: and cpe.table_route_id = tr.table_route_id
22849: -- and tr.where_clause = l_BEN_PL_PCP
22850: and tr.table_alias = l_table_alias

Line 23250: pqh_table_route tr

23246: cpe.information2,
23247: cpe.information3,
23248: cpe.table_route_id
23249: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23250: pqh_table_route tr
23251: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23252: and cpe.table_route_id = tr.table_route_id
23253: -- and tr.where_clause = l_BEN_OIPL_F
23254: and tr.table_alias = l_table_alias

Line 23798: pqh_table_route tr

23794: cpe.information2,
23795: cpe.information3,
23796: cpe.table_route_id
23797: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23798: pqh_table_route tr
23799: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23800: and cpe.table_route_id = tr.table_route_id
23801: -- and tr.where_clause = l_BEN_DSGN_RQMT_F
23802: and tr.table_alias = l_table_alias

Line 24290: pqh_table_route tr

24286: cpe.information2,
24287: cpe.information3,
24288: cpe.table_route_id
24289: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24290: pqh_table_route tr
24291: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24292: and cpe.table_route_id = tr.table_route_id
24293: -- and tr.where_clause = l_BEN_DSGN_RQMT_RLSHP_TYP
24294: and tr.table_alias = l_table_alias

Line 24639: pqh_table_route tr

24635: cpe.information2,
24636: cpe.information3,
24637: cpe.table_route_id
24638: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24639: pqh_table_route tr
24640: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24641: and cpe.table_route_id = tr.table_route_id
24642: -- and tr.where_clause = l_BEN_OIPLIP_F
24643: and tr.table_alias = l_table_alias

Line 25031: pqh_table_route tr

25027: cpe.information2,
25028: cpe.information3,
25029: cpe.table_route_id
25030: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25031: pqh_table_route tr
25032: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25033: and cpe.table_route_id = tr.table_route_id
25034: -- and tr.where_clause = l_BEN_OPTIP_F
25035: and tr.table_alias = l_table_alias

Line 25433: pqh_table_route tr

25429: cpe.information2,
25430: cpe.information3,
25431: cpe.table_route_id
25432: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25433: pqh_table_route tr
25434: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25435: and cpe.table_route_id = tr.table_route_id
25436: -- and tr.where_clause = l_BEN_PL_PCP_TYP
25437: and tr.table_alias = l_table_alias

Line 25796: pqh_table_route tr

25792: cpe.information2,
25793: cpe.information3,
25794: cpe.table_route_id
25795: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25796: pqh_table_route tr
25797: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25798: and cpe.table_route_id = tr.table_route_id
25799: -- and tr.where_clause = l_BEN_PL_REGY_PRP_F
25800: and tr.table_alias = l_table_alias

Line 26277: pqh_table_route tr

26273: cpe.information3,
26274: cpe.INFORMATION170 name ,
26275: cpe.table_route_id
26276: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26277: pqh_table_route tr
26278: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26279: and cpe.table_route_id = tr.table_route_id
26280: -- and tr.where_clause = l_BEN_BNFT_PRVDR_POOL_F
26281: and tr.table_alias = l_table_alias

Line 26901: pqh_table_route tr

26897: cpe.information3,
26898: cpe.information170 name,
26899: cpe.table_route_id
26900: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26901: pqh_table_route tr
26902: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26903: and cpe.table_route_id = tr.table_route_id
26904: -- and tr.where_clause = l_BEN_ACRS_PTIP_CVG_F
26905: and tr.table_alias = l_table_alias