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 16361: pqh_table_route tr

16357: cpe.information2,
16358: cpe.information3,
16359: cpe.table_route_id
16360: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16361: pqh_table_route tr
16362: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16363: and cpe.table_route_id = tr.table_route_id
16364: -- and tr.where_clause = l_BEN_POPL_ENRT_TYP_CYCL_F
16365: and tr.table_alias = l_table_alias

Line 16837: pqh_table_route tr

16833: cpe.information2,
16834: cpe.information3,
16835: cpe.table_route_id
16836: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16837: pqh_table_route tr
16838: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16839: and cpe.table_route_id = tr.table_route_id
16840: -- and tr.where_clause = l_BEN_ENRT_PERD
16841: and tr.table_alias = l_table_alias

Line 17300: pqh_table_route tr

17296: cpe.information2,
17297: cpe.information3,
17298: cpe.table_route_id
17299: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17300: pqh_table_route tr
17301: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17302: and cpe.table_route_id = tr.table_route_id
17303: -- and tr.where_clause = l_BEN_LEE_RSN_F
17304: and tr.table_alias = l_table_alias

Line 17820: pqh_table_route tr

17816: cpe.information2,
17817: cpe.information3,
17818: cpe.table_route_id
17819: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17820: pqh_table_route tr
17821: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17822: and cpe.table_route_id = tr.table_route_id
17823: -- and tr.where_clause = l_BEN_ENRT_PERD_FOR_PL_F
17824: and tr.table_alias = l_table_alias

Line 18313: pqh_table_route tr

18309: cpe.information2,
18310: cpe.information3,
18311: cpe.table_route_id
18312: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18313: pqh_table_route tr
18314: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18315: and cpe.table_route_id = tr.table_route_id
18316: -- and tr.where_clause = l_BEN_SCHEDD_ENRT_RL_F
18317: and tr.table_alias = l_table_alias

Line 18776: pqh_table_route tr

18772: cpe.information2,
18773: cpe.information3,
18774: cpe.table_route_id
18775: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18776: pqh_table_route tr
18777: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18778: and cpe.table_route_id = tr.table_route_id
18779: -- and tr.where_clause = l_BEN_LEE_RSN_RL_F
18780: and tr.table_alias = l_table_alias

Line 19241: pqh_table_route tr

19237: cpe.information2,
19238: cpe.information3,
19239: cpe.table_route_id
19240: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19241: pqh_table_route tr
19242: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19243: and cpe.table_route_id = tr.table_route_id
19244: -- and tr.where_clause = l_APLD_DPNT_CVG_ELIG_PRFL_F
19245: and tr.table_alias = l_table_alias

Line 19721: pqh_table_route tr

19717: cpe.information2,
19718: cpe.information3,
19719: cpe.table_route_id
19720: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19721: pqh_table_route tr
19722: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19723: and cpe.table_route_id = tr.table_route_id
19724: -- and tr.where_clause = l_BEN_PGM_DPNT_CVG_CTFN_F
19725: and tr.table_alias = l_table_alias

Line 20196: pqh_table_route tr

20192: cpe.information2,
20193: cpe.information3,
20194: cpe.table_route_id
20195: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20196: pqh_table_route tr
20197: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20198: and cpe.table_route_id = tr.table_route_id
20199: -- and tr.where_clause = l_BEN_LER_CHG_PGM_ENRT_F
20200: and tr.table_alias = l_table_alias

Line 20684: pqh_table_route tr

20680: cpe.information2,
20681: cpe.information3,
20682: cpe.table_route_id
20683: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20684: pqh_table_route tr
20685: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20686: and cpe.table_route_id = tr.table_route_id
20687: -- and tr.where_clause = l_BEN_LER_CHG_DPNT_CVG_F
20688: and tr.table_alias = l_table_alias

Line 21183: pqh_table_route tr

21179: cpe.information2,
21180: cpe.information3,
21181: cpe.table_route_id
21182: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21183: pqh_table_route tr
21184: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21185: and cpe.table_route_id = tr.table_route_id
21186: -- and tr.where_clause = l_BEN_POPL_ACTN_TYP_F
21187: and tr.table_alias = l_table_alias

Line 21673: pqh_table_route tr

21669: cpe.information2,
21670: cpe.information3,
21671: cpe.table_route_id
21672: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21673: pqh_table_route tr
21674: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21675: and cpe.table_route_id = tr.table_route_id
21676: -- and tr.where_clause = l_BEN_ELIG_TO_PRTE_RSN_F
21677: and tr.table_alias = l_table_alias

Line 22214: pqh_table_route tr

22210: cpe.information2,
22211: cpe.information3,
22212: cpe.table_route_id
22213: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22214: pqh_table_route tr
22215: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22216: and cpe.table_route_id = tr.table_route_id
22217: -- and tr.where_clause = l_BEN_CWB_WKSHT_GRP
22218: and tr.table_alias = l_table_alias

Line 22557: pqh_table_route tr

22553: cpe.information13,
22554: cpe.INFORMATION14,
22555: cpe.table_route_id,dml_operation,cpe.datetrack_mode
22556: from ben_copy_entity_results cpe,
22557: pqh_table_route tr
22558: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22559: and cpe.table_route_id = tr.table_route_id
22560: -- and tr.where_clause = l_BEN_AGE_FCTR
22561: and tr.table_alias = l_table_alias

Line 22744: pqh_table_route tr

22740: cpe.information2,
22741: cpe.information3,
22742: cpe.table_route_id
22743: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22744: pqh_table_route tr
22745: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22746: and cpe.table_route_id = tr.table_route_id
22747: -- and tr.where_clause = l_BEN_PL_PCP
22748: and tr.table_alias = l_table_alias

Line 23148: pqh_table_route tr

23144: cpe.information2,
23145: cpe.information3,
23146: cpe.table_route_id
23147: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23148: pqh_table_route tr
23149: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23150: and cpe.table_route_id = tr.table_route_id
23151: -- and tr.where_clause = l_BEN_OIPL_F
23152: and tr.table_alias = l_table_alias

Line 23696: pqh_table_route tr

23692: cpe.information2,
23693: cpe.information3,
23694: cpe.table_route_id
23695: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23696: pqh_table_route tr
23697: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23698: and cpe.table_route_id = tr.table_route_id
23699: -- and tr.where_clause = l_BEN_DSGN_RQMT_F
23700: and tr.table_alias = l_table_alias

Line 24188: pqh_table_route tr

24184: cpe.information2,
24185: cpe.information3,
24186: cpe.table_route_id
24187: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24188: pqh_table_route tr
24189: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24190: and cpe.table_route_id = tr.table_route_id
24191: -- and tr.where_clause = l_BEN_DSGN_RQMT_RLSHP_TYP
24192: and tr.table_alias = l_table_alias

Line 24537: pqh_table_route tr

24533: cpe.information2,
24534: cpe.information3,
24535: cpe.table_route_id
24536: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24537: pqh_table_route tr
24538: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24539: and cpe.table_route_id = tr.table_route_id
24540: -- and tr.where_clause = l_BEN_OIPLIP_F
24541: and tr.table_alias = l_table_alias

Line 24929: pqh_table_route tr

24925: cpe.information2,
24926: cpe.information3,
24927: cpe.table_route_id
24928: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24929: pqh_table_route tr
24930: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24931: and cpe.table_route_id = tr.table_route_id
24932: -- and tr.where_clause = l_BEN_OPTIP_F
24933: and tr.table_alias = l_table_alias

Line 25331: pqh_table_route tr

25327: cpe.information2,
25328: cpe.information3,
25329: cpe.table_route_id
25330: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25331: pqh_table_route tr
25332: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25333: and cpe.table_route_id = tr.table_route_id
25334: -- and tr.where_clause = l_BEN_PL_PCP_TYP
25335: and tr.table_alias = l_table_alias

Line 25694: pqh_table_route tr

25690: cpe.information2,
25691: cpe.information3,
25692: cpe.table_route_id
25693: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25694: pqh_table_route tr
25695: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25696: and cpe.table_route_id = tr.table_route_id
25697: -- and tr.where_clause = l_BEN_PL_REGY_PRP_F
25698: and tr.table_alias = l_table_alias

Line 26175: pqh_table_route tr

26171: cpe.information3,
26172: cpe.INFORMATION170 name ,
26173: cpe.table_route_id
26174: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26175: pqh_table_route tr
26176: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26177: and cpe.table_route_id = tr.table_route_id
26178: -- and tr.where_clause = l_BEN_BNFT_PRVDR_POOL_F
26179: and tr.table_alias = l_table_alias

Line 26799: pqh_table_route tr

26795: cpe.information3,
26796: cpe.information170 name,
26797: cpe.table_route_id
26798: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26799: pqh_table_route tr
26800: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26801: and cpe.table_route_id = tr.table_route_id
26802: -- and tr.where_clause = l_BEN_ACRS_PTIP_CVG_F
26803: and tr.table_alias = l_table_alias