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

Line 134: from pqh_table_route tr

130: procedure init_table_data_in_cer(p_copy_entity_txn_id in number) is
131: --
132: cursor c_table_data_in_cer is
133: select tr.table_alias, tr.table_route_id
134: from pqh_table_route tr
135: where tr.table_route_id in(
136: select table_route_id from ben_copy_entity_results cpe
137: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
138: and cpe.number_of_copies = 1);

Line 267: l_display_name pqh_table_route_tl.display_name%TYPE := null ;

263: --
264: procedure raise_error_message( p_table_alias in varchar2,
265: p_object_name in varchar2 ) is
266: l_message varchar2(2000);
267: l_display_name pqh_table_route_tl.display_name%TYPE := null ;
268: --
269: cursor c_display_name is
270: select display_name
271: from pqh_table_route_vl tr

Line 271: from pqh_table_route_vl tr

267: l_display_name pqh_table_route_tl.display_name%TYPE := null ;
268: --
269: cursor c_display_name is
270: select display_name
271: from pqh_table_route_vl tr
272: where tr.table_alias = p_table_alias
273: and tr.from_clause = 'OAB' ;
274: --
275: begin

Line 1160: FROM ben_copy_entity_results cpe, pqh_table_route tr

1156: cpe.information112 NAME, -- 5250824, 5253679 (FF Case Sensitive)
1157: cpe.table_route_id,
1158: cpe.dml_operation, cpe.datetrack_mode
1159: --RKG Modfied for PDW FF Enhancements
1160: FROM ben_copy_entity_results cpe, pqh_table_route tr
1161: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
1162: AND cpe.table_route_id = tr.table_route_id
1163: AND tr.table_alias = l_table_alias
1164: AND cpe.number_of_copies = 1 --ADDITION

Line 1687: pqh_table_route tr

1683: cpe.information3,
1684: cpe.information170 name,
1685: cpe.table_route_id
1686: from ben_copy_entity_results cpe,
1687: pqh_table_route tr
1688: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1689: and cpe.table_route_id = tr.table_route_id
1690: -- and tr.where_clause = l_BEN_ACTN_TYP
1691: and tr.table_alias = l_table_alias

Line 1942: pqh_table_route tr

1938: cpe.table_route_id,
1939: cpe.dml_operation,
1940: cpe.datetrack_mode
1941: from ben_copy_entity_results cpe,
1942: pqh_table_route tr
1943: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1944: and cpe.table_route_id = tr.table_route_id
1945: -- and tr.where_clause = l_BEN_CMBN_PLIP_F
1946: and tr.table_alias = l_table_alias

Line 2462: pqh_table_route tr

2458: cpe.information3,
2459: cpe.INFORMATION170 name,
2460: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
2461: from ben_copy_entity_results cpe,
2462: pqh_table_route tr
2463: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2464: and cpe.table_route_id = tr.table_route_id
2465: -- and tr.where_clause = l_BEN_CMBN_PTIP_F
2466: and tr.table_alias = l_table_alias

Line 2940: pqh_table_route tr

2936: cpe.INFORMATION170 name,
2937: cpe.table_route_id,
2938: cpe.dml_operation,cpe.datetrack_mode
2939: from ben_copy_entity_results cpe,
2940: pqh_table_route tr
2941: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2942: and cpe.table_route_id = tr.table_route_id
2943: -- and tr.where_clause = l_BEN_CMBN_PTIP_OPT_F
2944: and tr.table_alias = l_table_alias

Line 3449: pqh_table_route tr

3445: cpe.INFORMATION170 name,
3446: cpe.table_route_id,
3447: cpe.dml_operation,cpe.datetrack_mode
3448: from ben_copy_entity_results cpe,
3449: pqh_table_route tr
3450: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3451: and cpe.table_route_id = tr.table_route_id
3452: -- and tr.where_clause = l_BEN_BNFTS_BAL_F
3453: and tr.table_alias = l_table_alias

Line 3941: -- pqh_table_route tr UPD

3937: cpe.INFORMATION170 name,
3938: cpe.table_route_id,
3939: cpe.dml_operation --UPD
3940: from ben_copy_entity_results cpe
3941: -- pqh_table_route tr UPD
3942: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3943: -- and cpe.table_route_id = tr.table_route_id UPD
3944: -- and tr.where_clause = l_BEN_COMP_LVL_FCTR
3945: and cpe.table_alias = l_table_alias --UPD

Line 4377: pqh_table_route tr

4373: cpe.information3,
4374: cpe.INFORMATION170 name,
4375: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
4376: from ben_copy_entity_results cpe,
4377: pqh_table_route tr
4378: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4379: and cpe.table_route_id = tr.table_route_id
4380: -- and tr.where_clause = l_BEN_HRS_WKD_IN_PERD_FCTR
4381: and tr.table_alias = l_table_alias

Line 4794: pqh_table_route tr

4790: cpe.information3,
4791: cpe.INFORMATION170 name,
4792: cpe.table_route_id,dml_operation,cpe.datetrack_mode
4793: from ben_copy_entity_results cpe,
4794: pqh_table_route tr
4795: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4796: and cpe.table_route_id = tr.table_route_id
4797: -- and tr.where_clause = l_BEN_AGE_FCTR
4798: and tr.table_alias = l_table_alias

Line 5160: pqh_table_route tr

5156: cpe.information3,
5157: cpe.INFORMATION170 name,
5158: cpe.table_route_id,dml_operation,cpe.datetrack_mode
5159: from ben_copy_entity_results cpe,
5160: pqh_table_route tr
5161: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5162: and cpe.table_route_id = tr.table_route_id
5163: -- and tr.where_clause = l_BEN_LOS_FCTR
5164: and tr.table_alias = l_table_alias

Line 5524: pqh_table_route tr

5520: cpe.information3,
5521: cpe.INFORMATION218 name,
5522: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
5523: from ben_copy_entity_results cpe,
5524: pqh_table_route tr
5525: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5526: and cpe.table_route_id = tr.table_route_id
5527: -- and tr.where_clause = l_BEN_PCT_FL_TM_FCTR
5528: and tr.table_alias = l_table_alias

Line 5868: pqh_table_route tr

5864: cpe.information3,
5865: cpe.INFORMATION170 name,
5866: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
5867: from ben_copy_entity_results cpe,
5868: pqh_table_route tr
5869: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5870: and cpe.table_route_id = tr.table_route_id
5871: -- and tr.where_clause = l_BEN_CMBN_AGE_LOS_FCTR
5872: and tr.table_alias = l_table_alias

Line 6214: pqh_table_route tr

6210: cpe.information3,
6211: cpe.INFORMATION170 name,
6212: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
6213: from ben_copy_entity_results cpe,
6214: pqh_table_route tr
6215: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6216: and cpe.table_route_id = tr.table_route_id
6217: -- and tr.where_clause = l_BEN_PL_TYP_F
6218: and tr.table_alias = l_table_alias

Line 6690: pqh_table_route tr

6686: cpe.information3,
6687: cpe.INFORMATION170 name,
6688: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
6689: from ben_copy_entity_results cpe,
6690: pqh_table_route tr
6691: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6692: and cpe.table_route_id = tr.table_route_id
6693: -- and tr.where_clause = l_BEN_PGM_F
6694: and tr.table_alias = l_table_alias

Line 7353: pqh_table_route tr

7349: cpe.information3,
7350: cpe.INFORMATION170 name,
7351: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
7352: from ben_copy_entity_results cpe,
7353: pqh_table_route tr
7354: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7355: and cpe.table_route_id = tr.table_route_id
7356: -- and tr.where_clause = l_BEN_REGN_F
7357: and tr.table_alias = l_table_alias

Line 7747: pqh_table_route tr

7743: cpe.information2,
7744: cpe.information3,
7745: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
7746: from ben_copy_entity_results cpe,
7747: pqh_table_route tr
7748: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7749: and cpe.table_route_id = tr.table_route_id
7750: -- and tr.where_clause = l_BEN_PSTL_ZIP_RNG_F
7751: and tr.table_alias = l_table_alias

Line 8205: pqh_table_route tr

8201: cpe.information3,
8202: cpe.INFORMATION170 name,
8203: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
8204: from ben_copy_entity_results cpe,
8205: pqh_table_route tr
8206: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8207: and cpe.table_route_id = tr.table_route_id
8208: -- and tr.where_clause = l_BEN_RPTG_GRP
8209: and tr.table_alias = l_table_alias

Line 8546: pqh_table_route tr

8542: cpe.information3,
8543: cpe.INFORMATION218 name,
8544: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
8545: from ben_copy_entity_results cpe,
8546: pqh_table_route tr
8547: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8548: and cpe.table_route_id = tr.table_route_id
8549: -- and tr.where_clause = l_BEN_RLTD_PER_CHG_CS_LER_F
8550: and tr.table_alias = l_table_alias

Line 9004: pqh_table_route tr

9000: cpe.information3,
9001: cpe.INFORMATION170 name,
9002: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
9003: from ben_copy_entity_results cpe,
9004: pqh_table_route tr
9005: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9006: and cpe.table_route_id = tr.table_route_id
9007: -- and tr.where_clause = l_BEN_OPT_F
9008: and tr.table_alias = l_table_alias

Line 9548: pqh_table_route tr

9544: cpe.information16 typ_cd, -- Required for Absences
9545: cpe.information13 lf_evt_oper_cd, -- Required for Absences
9546: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
9547: from ben_copy_entity_results cpe,
9548: pqh_table_route tr
9549: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9550: and cpe.table_route_id = tr.table_route_id
9551: -- and tr.where_clause = l_BEN_LER_F
9552: and tr.table_alias = l_table_alias

Line 10192: pqh_table_route tr

10188: cer.information2,
10189: cer.information3,
10190: cer.table_route_id,cer.dml_operation,cer.datetrack_mode
10191: from ben_copy_entity_results cer,
10192: pqh_table_route tr
10193: where cer.copy_entity_txn_id = p_copy_entity_txn_id
10194: and cer.table_route_id = tr.table_route_id
10195: and tr.table_alias = l_table_alias
10196: and cer.number_of_copies = 1

Line 10658: pqh_table_route tr

10654: cpe.information3,
10655: cpe.INFORMATION170 name,
10656: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
10657: from ben_copy_entity_results cpe,
10658: pqh_table_route tr
10659: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10660: and cpe.table_route_id = tr.table_route_id
10661: -- and tr.where_clause = l_BEN_ELIGY_PRFL_F
10662: and tr.table_alias = l_table_alias

Line 11245: pqh_table_route tr

11241: cpe.information3,
11242: cpe.INFORMATION170 name,
11243: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
11244: from ben_copy_entity_results cpe,
11245: pqh_table_route tr
11246: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11247: and cpe.table_route_id = tr.table_route_id
11248: -- and tr.where_clause = l_BEN_DPNT_CVG_ELIGY_PRFL_F
11249: and tr.table_alias = l_table_alias

Line 11724: pqh_table_route tr

11720: cpe.information3,
11721: cpe.INFORMATION170 name,
11722: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
11723: from ben_copy_entity_results cpe,
11724: pqh_table_route tr
11725: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11726: and cpe.table_route_id = tr.table_route_id
11727: -- and tr.where_clause = l_BEN_GD_OR_SVC_TYP
11728: and tr.table_alias = l_table_alias

Line 12053: pqh_table_route tr

12049: cpe.information3,
12050: cpe.INFORMATION170 name,
12051: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12052: from ben_copy_entity_results cpe,
12053: pqh_table_route tr
12054: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12055: and cpe.table_route_id = tr.table_route_id
12056: -- and tr.where_clause = l_BEN_BENFTS_GRP
12057: and tr.table_alias = l_table_alias

Line 12383: pqh_table_route tr

12379: cpe.information3,
12380: cpe.INFORMATION218 name,
12381: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12382: from ben_copy_entity_results cpe,
12383: pqh_table_route tr
12384: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12385: and cpe.table_route_id = tr.table_route_id
12386: -- and tr.where_clause = l_BEN_PER_INFO_CHG_CS_LER_F
12387: and tr.table_alias = l_table_alias

Line 12935: pqh_table_route tr

12931: cpe.information3,
12932: cpe.INFORMATION170 name,
12933: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12934: from ben_copy_entity_results cpe,
12935: pqh_table_route tr
12936: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12937: and cpe.table_route_id = tr.table_route_id
12938: -- and tr.where_clause = l_BEN_CM_TYP_F
12939: and tr.table_alias = l_table_alias

Line 13414: pqh_table_route tr

13410: cpe.information3,
13411: cpe.INFORMATION170 name,
13412: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
13413: from ben_copy_entity_results cpe,
13414: pqh_table_route tr
13415: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13416: and cpe.table_route_id = tr.table_route_id
13417: -- and tr.where_clause = l_BEN_PTD_LMT_F
13418: and tr.table_alias = l_table_alias

Line 13882: pqh_table_route tr

13878: cpe.information2,
13879: cpe.information3,
13880: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
13881: from ben_copy_entity_results cpe,
13882: pqh_table_route tr
13883: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13884: and cpe.table_route_id = tr.table_route_id
13885: -- and tr.where_clause = l_BEN_YR_PERD
13886: and tr.table_alias = l_table_alias

Line 14222: pqh_table_route tr

14218: cpe.information2,
14219: cpe.information3,
14220: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
14221: from ben_copy_entity_results cpe,
14222: pqh_table_route tr
14223: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14224: and cpe.table_route_id = tr.table_route_id
14225: -- and tr.where_clause = l_BEN_WTHN_YR_PERD
14226: and tr.table_alias = l_table_alias

Line 14561: pqh_table_route tr

14557: cpe.INFORMATION170 name,
14558: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode,
14559: cpe.information8
14560: from ben_copy_entity_results cpe,
14561: pqh_table_route tr
14562: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14563: and cpe.table_route_id = tr.table_route_id
14564: -- and tr.where_clause = l_BEN_PL_F
14565: and tr.table_alias = l_table_alias

Line 15513: pqh_table_route tr

15509: cpe.information3,
15510: cpe.information170 name,
15511: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
15512: from ben_copy_entity_results cpe,
15513: pqh_table_route tr
15514: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15515: and cpe.table_route_id = tr.table_route_id
15516: -- and tr.where_clause = l_BEN_SVC_AREA_F
15517: and tr.table_alias = l_table_alias

Line 15965: pqh_table_route tr

15961: cpe.information2,
15962: cpe.information3,
15963: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
15964: from ben_copy_entity_results cpe,
15965: pqh_table_route tr
15966: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15967: and cpe.table_route_id = tr.table_route_id
15968: -- and tr.where_clause = l_BEN_PL_TYP_OPT_TYP_F
15969: and tr.table_alias = l_table_alias

Line 16554: FROM ben_copy_entity_results cpe, pqh_table_route tr

16550: IS
16551: SELECT DISTINCT cpe.information1, cpe.information2, cpe.information3,
16552: cpe.information170 NAME, cpe.table_route_id,
16553: cpe.dml_operation, cpe.datetrack_mode
16554: FROM ben_copy_entity_results cpe, pqh_table_route tr
16555: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
16556: AND cpe.table_route_id = tr.table_route_id
16557: AND tr.table_alias = l_table_alias
16558: AND cpe.number_of_copies = 1