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_FOUR dependencies on PQH_TABLE_ROUTE

Line 231: pqh_table_route tr

227: cpe.information2,
228: cpe.information3,
229: cpe.table_route_id
230: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
231: pqh_table_route tr
232: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
233: and cpe.table_route_id = tr.table_route_id
234: -- and tr.where_clause = l_BEN_ELIG_ASNT_SET_PRTE_F
235: and tr.table_alias = l_table_alias

Line 758: pqh_table_route tr

754: cpe.information3,
755: cpe.information170 name,
756: cpe.table_route_id
757: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
758: pqh_table_route tr
759: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
760: and cpe.table_route_id = tr.table_route_id
761: -- and tr.where_clause = l_BEN_CNTNG_PRTN_ELIG_PRFL_F
762: and tr.table_alias = l_table_alias

Line 1265: pqh_table_route tr

1261: cpe.information2,
1262: cpe.information3,
1263: cpe.table_route_id
1264: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
1265: pqh_table_route tr
1266: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1267: and cpe.table_route_id = tr.table_route_id
1268: -- and tr.where_clause = l_BEN_ELIG_AGE_PRTE_F
1269: and tr.table_alias = l_table_alias

Line 1757: pqh_table_route tr

1753: cpe.information2,
1754: cpe.information3,
1755: cpe.table_route_id
1756: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
1757: pqh_table_route tr
1758: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1759: and cpe.table_route_id = tr.table_route_id
1760: -- and tr.where_clause = l_BEN_ELIG_BENFTS_GRP_PRTE_F
1761: and tr.table_alias = l_table_alias

Line 2248: pqh_table_route tr

2244: cpe.information2,
2245: cpe.information3,
2246: cpe.table_route_id
2247: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
2248: pqh_table_route tr
2249: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2250: and cpe.table_route_id = tr.table_route_id
2251: -- and tr.where_clause = l_BEN_ELIG_BRGNG_UNIT_PRTE_F
2252: and tr.table_alias = l_table_alias

Line 2740: pqh_table_route tr

2736: cpe.information2,
2737: cpe.information3,
2738: cpe.table_route_id
2739: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
2740: pqh_table_route tr
2741: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2742: and cpe.table_route_id = tr.table_route_id
2743: -- and tr.where_clause = l_BEN_ELIG_COMP_LVL_PRTE_F
2744: and tr.table_alias = l_table_alias

Line 3230: pqh_table_route tr

3226: cpe.information2,
3227: cpe.information3,
3228: cpe.table_route_id
3229: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
3230: pqh_table_route tr
3231: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3232: and cpe.table_route_id = tr.table_route_id
3233: -- and tr.where_clause = l_BEN_ELIG_CMBN_AGE_LOS_PRTE_F
3234: and tr.table_alias = l_table_alias

Line 3726: pqh_table_route tr

3722: cpe.information2,
3723: cpe.information3,
3724: cpe.table_route_id
3725: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
3726: pqh_table_route tr
3727: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3728: and cpe.table_route_id = tr.table_route_id
3729: -- and tr.where_clause = l_BEN_ELIG_CBR_QUALD_BNF_F
3730: and tr.table_alias = l_table_alias

Line 4237: pqh_table_route tr

4233: cpe.information2,
4234: cpe.information3,
4235: cpe.table_route_id
4236: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4237: pqh_table_route tr
4238: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4239: and cpe.table_route_id = tr.table_route_id
4240: -- and tr.where_clause = l_BEN_ELIG_COMPTNCY_PRTE_F
4241: and tr.table_alias = l_table_alias

Line 4859: pqh_table_route tr

4855: cpe.information2,
4856: cpe.information3,
4857: cpe.table_route_id
4858: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4859: pqh_table_route tr
4860: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4861: and cpe.table_route_id = tr.table_route_id
4862: -- and tr.where_clause = l_BEN_ELG_DPNT_CVR_OTHR_PGM_F
4863: and tr.table_alias = l_table_alias

Line 5362: pqh_table_route tr

5358: cpe.information2,
5359: cpe.information3,
5360: cpe.table_route_id
5361: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5362: pqh_table_route tr
5363: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5364: and cpe.table_route_id = tr.table_route_id
5365: -- and tr.where_clause = l_BEN_ELIG_DPNT_CVRD_PLIP_F
5366: and tr.table_alias = l_table_alias

Line 5865: pqh_table_route tr

5861: cpe.information2,
5862: cpe.information3,
5863: cpe.table_route_id
5864: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5865: pqh_table_route tr
5866: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5867: and cpe.table_route_id = tr.table_route_id
5868: -- and tr.where_clause = l_BEN_ELIG_DPNT_CVRD_OTHR_PL_F
5869: and tr.table_alias = l_table_alias

Line 6364: pqh_table_route tr

6360: cpe.information2,
6361: cpe.information3,
6362: cpe.table_route_id
6363: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6364: pqh_table_route tr
6365: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6366: and cpe.table_route_id = tr.table_route_id
6367: -- and tr.where_clause = l_BEN_ELG_DPNT_CVR_OTR_PTIP_F
6368: and tr.table_alias = l_table_alias

Line 6864: pqh_table_route tr

6860: cpe.information2,
6861: cpe.information3,
6862: cpe.table_route_id
6863: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6864: pqh_table_route tr
6865: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6866: and cpe.table_route_id = tr.table_route_id
6867: -- and tr.where_clause = l_BEN_ELIGY_PRFL_RL_F
6868: and tr.table_alias = l_table_alias

Line 7364: pqh_table_route tr

7360: cpe.information2,
7361: cpe.information3,
7362: cpe.table_route_id
7363: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7364: pqh_table_route tr
7365: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7366: and cpe.table_route_id = tr.table_route_id
7367: -- and tr.where_clause = l_BEN_ELIG_HRS_WKD_PRTE_F
7368: and tr.table_alias = l_table_alias

Line 7858: pqh_table_route tr

7854: cpe.information2,
7855: cpe.information3,
7856: cpe.table_route_id
7857: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7858: pqh_table_route tr
7859: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7860: and cpe.table_route_id = tr.table_route_id
7861: -- and tr.where_clause = l_BEN_ELIG_JOB_PRTE_F
7862: and tr.table_alias = l_table_alias

Line 8375: pqh_table_route tr

8371: cpe.information2,
8372: cpe.information3,
8373: cpe.table_route_id
8374: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8375: pqh_table_route tr
8376: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8377: and cpe.table_route_id = tr.table_route_id
8378: -- and tr.where_clause = l_BEN_ELIG_LBR_MMBR_PRTE_F
8379: and tr.table_alias = l_table_alias

Line 8864: pqh_table_route tr

8860: cpe.information2,
8861: cpe.information3,
8862: cpe.table_route_id
8863: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8864: pqh_table_route tr
8865: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8866: and cpe.table_route_id = tr.table_route_id
8867: -- and tr.where_clause = l_BEN_ELIG_LGL_ENTY_PRTE_F
8868: and tr.table_alias = l_table_alias

Line 9381: pqh_table_route tr

9377: cpe.information2,
9378: cpe.information3,
9379: cpe.table_route_id
9380: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9381: pqh_table_route tr
9382: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9383: and cpe.table_route_id = tr.table_route_id
9384: -- and tr.where_clause = l_BEN_ELIG_LOA_RSN_PRTE_F
9385: and tr.table_alias = l_table_alias

Line 9935: pqh_table_route tr

9931: cpe.information2,
9932: cpe.information3,
9933: cpe.table_route_id
9934: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9935: pqh_table_route tr
9936: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9937: and cpe.table_route_id = tr.table_route_id
9938: -- and tr.where_clause = l_BEN_ELIG_LOS_PRTE_F
9939: and tr.table_alias = l_table_alias

Line 10429: pqh_table_route tr

10425: cpe.information2,
10426: cpe.information3,
10427: cpe.table_route_id
10428: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10429: pqh_table_route tr
10430: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10431: and cpe.table_route_id = tr.table_route_id
10432: -- and tr.where_clause = l_BEN_ELIG_LVG_RSN_PRTE_F
10433: and tr.table_alias = l_table_alias

Line 10925: pqh_table_route tr

10921: cpe.information2,
10922: cpe.information3,
10923: cpe.table_route_id
10924: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10925: pqh_table_route tr
10926: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10927: and cpe.table_route_id = tr.table_route_id
10928: -- and tr.where_clause = l_BEN_ELIG_MRTL_STS_PRTE_F
10929: and tr.table_alias = l_table_alias

Line 11419: pqh_table_route tr

11415: cpe.information2,
11416: cpe.information3,
11417: cpe.table_route_id
11418: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
11419: pqh_table_route tr
11420: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11421: and cpe.table_route_id = tr.table_route_id
11422: -- and tr.where_clause = l_BEN_ELIG_NO_OTHR_CVG_PRTE_F
11423: and tr.table_alias = l_table_alias

Line 11904: pqh_table_route tr

11900: cpe.information2,
11901: cpe.information3,
11902: cpe.table_route_id
11903: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
11904: pqh_table_route tr
11905: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11906: and cpe.table_route_id = tr.table_route_id
11907: -- and tr.where_clause = l_BEN_ELIG_OPTD_MDCR_PRTE_F
11908: and tr.table_alias = l_table_alias

Line 12389: pqh_table_route tr

12385: cpe.information2,
12386: cpe.information3,
12387: cpe.table_route_id
12388: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12389: pqh_table_route tr
12390: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12391: and cpe.table_route_id = tr.table_route_id
12392: -- and tr.where_clause = l_BEN_ELIG_ORG_UNIT_PRTE_F
12393: and tr.table_alias = l_table_alias

Line 12909: pqh_table_route tr

12905: cpe.information2,
12906: cpe.information3,
12907: cpe.table_route_id
12908: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12909: pqh_table_route tr
12910: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12911: and cpe.table_route_id = tr.table_route_id
12912: -- and tr.where_clause = l_BEN_ELIG_OTHR_PTIP_PRTE_F
12913: and tr.table_alias = l_table_alias

Line 13405: pqh_table_route tr

13401: cpe.information2,
13402: cpe.information3,
13403: cpe.table_route_id
13404: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13405: pqh_table_route tr
13406: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13407: and cpe.table_route_id = tr.table_route_id
13408: -- and tr.where_clause = l_BEN_ELIG_PCT_FL_TM_PRTE_F
13409: and tr.table_alias = l_table_alias

Line 13902: pqh_table_route tr

13898: cpe.information2,
13899: cpe.information3,
13900: cpe.table_route_id
13901: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13902: pqh_table_route tr
13903: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13904: and cpe.table_route_id = tr.table_route_id
13905: -- and tr.where_clause = l_BEN_ELIG_PER_TYP_PRTE_F
13906: and tr.table_alias = l_table_alias

Line 14429: pqh_table_route tr

14425: cpe.information2,
14426: cpe.information3,
14427: cpe.table_route_id
14428: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14429: pqh_table_route tr
14430: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14431: and cpe.table_route_id = tr.table_route_id
14432: -- and tr.where_clause = l_BEN_ELIG_PPL_GRP_PRTE_F
14433: and tr.table_alias = l_table_alias

Line 14934: pqh_table_route tr

14930: cpe.information2,
14931: cpe.information3,
14932: cpe.table_route_id
14933: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14934: pqh_table_route tr
14935: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14936: and cpe.table_route_id = tr.table_route_id
14937: -- and tr.where_clause = l_BEN_ELIG_PY_BSS_PRTE_F
14938: and tr.table_alias = l_table_alias

Line 15449: pqh_table_route tr

15445: cpe.information2,
15446: cpe.information3,
15447: cpe.table_route_id
15448: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15449: pqh_table_route tr
15450: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15451: and cpe.table_route_id = tr.table_route_id
15452: -- and tr.where_clause = l_BEN_ELIG_PRBTN_PERD_PRTE_F
15453: and tr.table_alias = l_table_alias

Line 15954: pqh_table_route tr

15950: cpe.information2,
15951: cpe.information3,
15952: cpe.table_route_id
15953: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15954: pqh_table_route tr
15955: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15956: and cpe.table_route_id = tr.table_route_id
15957: -- and tr.where_clause = l_BEN_ELG_PRTT_ANTR_PL_PRTE_F
15958: and tr.table_alias = l_table_alias

Line 16446: pqh_table_route tr

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

Line 16962: pqh_table_route tr

16958: cpe.information2,
16959: cpe.information3,
16960: cpe.table_route_id
16961: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16962: pqh_table_route tr
16963: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16964: and cpe.table_route_id = tr.table_route_id
16965: -- and tr.where_clause = l_BEN_ELIG_PYRL_PRTE_F
16966: and tr.table_alias = l_table_alias

Line 17475: pqh_table_route tr

17471: cpe.information2,
17472: cpe.information3,
17473: cpe.table_route_id
17474: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17475: pqh_table_route tr
17476: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17477: and cpe.table_route_id = tr.table_route_id
17478: -- and tr.where_clause = l_BEN_ELG_PSL_CD_R_RNG_PRTE_F
17479: and tr.table_alias = l_table_alias

Line 17959: pqh_table_route tr

17955: cpe.information2,
17956: cpe.information3,
17957: cpe.table_route_id
17958: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17959: pqh_table_route tr
17960: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17961: and cpe.table_route_id = tr.table_route_id
17962: -- and tr.where_clause = l_BEN_ELIG_QUAL_TITL_PRTE_F
17963: and tr.table_alias = l_table_alias

Line 18476: pqh_table_route tr

18472: cpe.information2,
18473: cpe.information3,
18474: cpe.table_route_id
18475: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18476: pqh_table_route tr
18477: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18478: and cpe.table_route_id = tr.table_route_id
18479: -- and tr.where_clause = l_BEN_ELIG_SVC_AREA_PRTE_F
18480: and tr.table_alias = l_table_alias

Line 18989: pqh_table_route tr

18985: cpe.information2,
18986: cpe.information3,
18987: cpe.table_route_id
18988: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18989: pqh_table_route tr
18990: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18991: and cpe.table_route_id = tr.table_route_id
18992: -- and tr.where_clause = l_BEN_ELIG_SCHEDD_HRS_PRTE_F
18993: and tr.table_alias = l_table_alias

Line 19536: pqh_table_route tr

19532: cpe.information2,
19533: cpe.information3,
19534: cpe.table_route_id
19535: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19536: pqh_table_route tr
19537: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19538: and cpe.table_route_id = tr.table_route_id
19539: -- and tr.where_clause = l_BEN_ELIG_SP_CLNG_PRG_PRTE_F
19540: and tr.table_alias = l_table_alias

Line 20057: pqh_table_route tr

20053: cpe.information2,
20054: cpe.information3,
20055: cpe.table_route_id
20056: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20057: pqh_table_route tr
20058: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20059: and cpe.table_route_id = tr.table_route_id
20060: -- and tr.where_clause = l_BEN_ELIG_SUPPL_ROLE_PRTE_F
20061: and tr.table_alias = l_table_alias

Line 20581: pqh_table_route tr

20577: cpe.information2,
20578: cpe.information3,
20579: cpe.table_route_id
20580: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20581: pqh_table_route tr
20582: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20583: and cpe.table_route_id = tr.table_route_id
20584: -- and tr.where_clause = l_BEN_ELIG_WK_LOC_PRTE_F
20585: and tr.table_alias = l_table_alias

Line 21098: pqh_table_route tr

21094: cpe.information2,
21095: cpe.information3,
21096: cpe.table_route_id
21097: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21098: pqh_table_route tr
21099: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21100: and cpe.table_route_id = tr.table_route_id
21101: -- and tr.where_clause = l_BEN_ELIG_DPNT_OTHR_PTIP_F
21102: and tr.table_alias = l_table_alias

Line 21603: pqh_table_route tr

21599: cpe.information2,
21600: cpe.information3,
21601: cpe.table_route_id
21602: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21603: pqh_table_route tr
21604: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21605: and cpe.table_route_id = tr.table_route_id
21606: -- and tr.where_clause = l_BEN_ELIG_DSBLTY_CTG_PRTE_F
21607: and tr.table_alias = l_table_alias

Line 22107: pqh_table_route tr

22103: cpe.information2,
22104: cpe.information3,
22105: cpe.table_route_id
22106: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22107: pqh_table_route tr
22108: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22109: and cpe.table_route_id = tr.table_route_id
22110: -- and tr.where_clause = l_BEN_ELIG_DSBLTY_DGR_PRTE_F
22111: and tr.table_alias = l_table_alias

Line 22616: pqh_table_route tr

22612: cpe.information2,
22613: cpe.information3,
22614: cpe.table_route_id
22615: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22616: pqh_table_route tr
22617: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22618: and cpe.table_route_id = tr.table_route_id
22619: -- and tr.where_clause = l_BEN_ELIG_DSBLTY_RSN_PRTE_F
22620: and tr.table_alias = l_table_alias

Line 23144: pqh_table_route tr

23140: cpe.information2,
23141: cpe.information3,
23142: cpe.table_route_id
23143: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23144: pqh_table_route tr
23145: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23146: and cpe.table_route_id = tr.table_route_id
23147: -- and tr.where_clause = l_BEN_ELIG_EE_STAT_PRTE_F
23148: and tr.table_alias = l_table_alias

Line 23658: pqh_table_route tr

23654: cpe.information2,
23655: cpe.information3,
23656: cpe.table_route_id
23657: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23658: pqh_table_route tr
23659: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23660: and cpe.table_route_id = tr.table_route_id
23661: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_OIPL_F
23662: and tr.table_alias = l_table_alias

Line 24152: pqh_table_route tr

24148: cpe.information2,
24149: cpe.information3,
24150: cpe.table_route_id
24151: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24152: pqh_table_route tr
24153: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24154: and cpe.table_route_id = tr.table_route_id
24155: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PGM_F
24156: and tr.table_alias = l_table_alias

Line 24646: pqh_table_route tr

24642: cpe.information2,
24643: cpe.information3,
24644: cpe.table_route_id
24645: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24646: pqh_table_route tr
24647: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24648: and cpe.table_route_id = tr.table_route_id
24649: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PLIP_F
24650: and tr.table_alias = l_table_alias

Line 25139: pqh_table_route tr

25135: cpe.information2,
25136: cpe.information3,
25137: cpe.table_route_id
25138: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25139: pqh_table_route tr
25140: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25141: and cpe.table_route_id = tr.table_route_id
25142: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PL_F
25143: and tr.table_alias = l_table_alias

Line 25630: pqh_table_route tr

25626: cpe.information2,
25627: cpe.information3,
25628: cpe.table_route_id
25629: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25630: pqh_table_route tr
25631: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25632: and cpe.table_route_id = tr.table_route_id
25633: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PTIP_F
25634: and tr.table_alias = l_table_alias

Line 26130: pqh_table_route tr

26126: cpe.information2,
26127: cpe.information3,
26128: cpe.table_route_id
26129: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26130: pqh_table_route tr
26131: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26132: and cpe.table_route_id = tr.table_route_id
26133: -- and tr.where_clause = l_BEN_ELIG_FL_TM_PT_TM_PRTE_F
26134: and tr.table_alias = l_table_alias

Line 26632: pqh_table_route tr

26628: cpe.information2,
26629: cpe.information3,
26630: cpe.table_route_id
26631: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26632: pqh_table_route tr
26633: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26634: and cpe.table_route_id = tr.table_route_id
26635: -- and tr.where_clause = l_BEN_ELIG_GRD_PRTE_F
26636: and tr.table_alias = l_table_alias

Line 27162: pqh_table_route tr

27158: cpe.information2,
27159: cpe.information3,
27160: cpe.table_route_id
27161: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
27162: pqh_table_route tr
27163: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
27164: and cpe.table_route_id = tr.table_route_id
27165: -- and tr.where_clause = l_BEN_ELIG_HRLY_SLRD_PRTE_F
27166: and tr.table_alias = l_table_alias

Line 27664: pqh_table_route tr

27660: cpe.information2,
27661: cpe.information3,
27662: cpe.table_route_id
27663: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
27664: pqh_table_route tr
27665: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
27666: and cpe.table_route_id = tr.table_route_id
27667: -- and tr.where_clause = l_BEN_ELIG_PERF_RTNG_PRTE_F
27668: and tr.table_alias = l_table_alias

Line 28168: pqh_table_route tr

28164: cpe.information2,
28165: cpe.information3,
28166: cpe.table_route_id
28167: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
28168: pqh_table_route tr
28169: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
28170: and cpe.table_route_id = tr.table_route_id
28171: -- and tr.where_clause = l_BEN_ELIG_QUA_IN_GR_PRTE_F
28172: and tr.table_alias = l_table_alias

Line 28664: pqh_table_route tr

28660: cpe.information2,
28661: cpe.information3,
28662: cpe.table_route_id
28663: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
28664: pqh_table_route tr
28665: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
28666: and cpe.table_route_id = tr.table_route_id
28667: -- and tr.where_clause = l_BEN_ELIG_GNDR_PRTE_F
28668: and tr.table_alias = l_table_alias

Line 29162: pqh_table_route tr

29158: cpe.information2,
29159: cpe.information3,
29160: cpe.table_route_id
29161: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
29162: pqh_table_route tr
29163: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
29164: and cpe.table_route_id = tr.table_route_id
29165: -- and tr.where_clause = l_BEN_ELIG_TBCO_USE_PRTE_F
29166: and tr.table_alias = l_table_alias

Line 29653: pqh_table_route tr

29649: cpe.information2,
29650: cpe.information3,
29651: cpe.table_route_id
29652: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
29653: pqh_table_route tr
29654: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
29655: and cpe.table_route_id = tr.table_route_id
29656: -- and tr.where_clause = l_BEN_ELIG_DSBLD_PRTE_F
29657: and tr.table_alias = l_table_alias

Line 30151: pqh_table_route tr

30147: cpe.information2,
30148: cpe.information3,
30149: cpe.table_route_id
30150: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
30151: pqh_table_route tr
30152: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
30153: and cpe.table_route_id = tr.table_route_id
30154: -- and tr.where_clause = l_BEN_ELIG_TTL_PRTT_PRTE_F
30155: and tr.table_alias = l_table_alias

Line 30681: pqh_table_route tr

30677: cpe.information2,
30678: cpe.information3,
30679: cpe.table_route_id
30680: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
30681: pqh_table_route tr
30682: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
30683: and cpe.table_route_id = tr.table_route_id
30684: -- and tr.where_clause = l_BEN_ELIG_TTL_CVG_VOL_PRTE_F
30685: and tr.table_alias = l_table_alias

Line 31205: pqh_table_route tr

31201: cpe.information2,
31202: cpe.information3,
31203: cpe.table_route_id
31204: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
31205: pqh_table_route tr
31206: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
31207: and cpe.table_route_id = tr.table_route_id
31208: -- and tr.where_clause = l_BEN_ELIG_HLTH_CVG_PRTE_F
31209: and tr.table_alias = l_table_alias

Line 31702: pqh_table_route tr

31698: cpe.information2,
31699: cpe.information3,
31700: cpe.table_route_id
31701: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
31702: pqh_table_route tr
31703: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
31704: and cpe.table_route_id = tr.table_route_id
31705: -- and tr.where_clause = l_BEN_ELIG_ANTHR_PL_PRTE_F
31706: and tr.table_alias = l_table_alias

Line 32404: FROM ben_copy_entity_results cpe, pqh_table_route tr

32400: IS
32401: SELECT DISTINCT cpe.information1, cpe.information2, cpe.information3,
32402: cpe.table_route_id, cpe.dml_operation,
32403: cpe.datetrack_mode, cpe.information263
32404: FROM ben_copy_entity_results cpe, pqh_table_route tr
32405: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
32406: AND cpe.table_route_id = tr.table_route_id
32407: AND tr.table_alias = cv_table_alias
32408: AND cpe.number_of_copies = 1

Line 32461: FROM ben_copy_entity_results cpe, pqh_table_route tr

32457: --
32458: CURSOR c_unique_ecv_id (cv_table_alias VARCHAR2)
32459: IS
32460: SELECT DISTINCT cpe.information1, cpe.information5, cpe.information263
32461: FROM ben_copy_entity_results cpe, pqh_table_route tr
32462: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
32463: AND cpe.table_route_id = tr.table_route_id
32464: AND tr.table_alias = cv_table_alias
32465: AND cpe.number_of_copies = 1

Line 32480: FROM pqh_table_route

32476: --
32477: CURSOR c_display_name (p_table_alias VARCHAR2)
32478: IS
32479: SELECT display_name, table_route_id
32480: FROM pqh_table_route
32481: WHERE table_alias = p_table_alias;
32482: --
32483: CURSOR c_parent_data (
32484: p_parent_pk_id NUMBER,