[Home] [Help]
263: cpe.dml_operation,
264: cpe.datetrack_mode
265: -- UPD END
266: from ben_copy_entity_results cpe,
267: pqh_table_route tr
268: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
269: and cpe.table_route_id = tr.table_route_id
270: -- and tr.where_clause = l_BEN_CM_TYP_USG_F
271: and tr.table_alias = l_table_alias
793: cpe.dml_operation,
794: cpe.datetrack_mode
795: -- UPD END
796: from ben_copy_entity_results cpe,
797: pqh_table_route tr
798: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
799: and cpe.table_route_id = tr.table_route_id
800: -- and tr.where_clause = l_BEN_CM_TYP_TRGR_F
801: and tr.table_alias = l_table_alias
1282: cpe.dml_operation,
1283: cpe.datetrack_mode
1284: -- UPD END
1285: from ben_copy_entity_results cpe,
1286: pqh_table_route tr
1287: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1288: and cpe.table_route_id = tr.table_route_id
1289: -- and tr.where_clause = l_BEN_CM_DLVRY_MTHD_TYP
1290: and tr.table_alias = l_table_alias
1652: cpe.dml_operation,
1653: cpe.datetrack_mode
1654: -- UPD END
1655: from ben_copy_entity_results cpe,
1656: pqh_table_route tr
1657: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1658: and cpe.table_route_id = tr.table_route_id
1659: -- and tr.where_clause = l_BEN_CM_DLVRY_MED_TYP
1660: and tr.table_alias = l_table_alias
1998: -- Bug : 3752407 : Global cursor ben_plan_design_program_module.g_table_route will now be used
1999: --
2000: -- cursor c_table_route is
2001: -- select table_route_id
2002: -- from pqh_table_route
2003: -- where from_clause = 'OAB' and
2004: -- table_alias = 'ABR' ;
2005: --
2006: --
2110: cpe.information169,
2111: cpe.dml_operation,
2112: cpe.datetrack_mode
2113: from ben_copy_entity_results cpe,
2114: pqh_table_route tr
2115: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2116: and cpe.table_route_id = tr.table_route_id
2117: -- and tr.where_clause = l_BEN_ACTY_BASE_RT_F
2118: and tr.table_alias = l_table_alias
3044: cpe.table_route_id,
3045: cpe.dml_operation,
3046: cpe.datetrack_mode
3047: from ben_copy_entity_results cpe,
3048: pqh_table_route tr
3049: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3050: and cpe.table_route_id = tr.table_route_id
3051: -- and tr.where_clause = l_BEN_MTCHG_RT_F
3052: and tr.table_alias = l_table_alias
3557: cpe.table_route_id,
3558: cpe.dml_operation,
3559: cpe.datetrack_mode
3560: from ben_copy_entity_results cpe,
3561: pqh_table_route tr
3562: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3563: and cpe.table_route_id = tr.table_route_id
3564: -- and tr.where_clause = l_BEN_ACTY_RT_PTD_LMT_F
3565: and tr.table_alias = l_table_alias
4051: cpe.table_route_id,
4052: cpe.dml_operation,
4053: cpe.datetrack_mode
4054: from ben_copy_entity_results cpe,
4055: pqh_table_route tr
4056: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4057: and cpe.table_route_id = tr.table_route_id
4058: -- and tr.where_clause = l_BEN_ACTL_PREM_F
4059: and tr.table_alias = l_table_alias
4676: cpe.table_route_id,
4677: cpe.dml_operation,
4678: cpe.datetrack_mode
4679: from ben_copy_entity_results cpe,
4680: pqh_table_route tr
4681: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4682: and cpe.table_route_id = tr.table_route_id
4683: -- and tr.where_clause = l_BEN_ACTY_VRBL_RT_F
4684: and tr.table_alias = l_table_alias
5175: cpe.table_route_id,
5176: cpe.dml_operation,
5177: cpe.datetrack_mode
5178: from ben_copy_entity_results cpe,
5179: pqh_table_route tr
5180: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5181: and cpe.table_route_id = tr.table_route_id
5182: -- and tr.where_clause = l_BEN_VRBL_RT_PRFL_F
5183: and tr.table_alias = l_table_alias
5868: cpe.table_route_id,
5869: cpe.dml_operation,
5870: cpe.datetrack_mode
5871: from ben_copy_entity_results cpe,
5872: pqh_table_route tr
5873: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5874: and cpe.table_route_id = tr.table_route_id
5875: -- and tr.where_clause = l_BEN_CVG_AMT_CALC_MTHD_F
5876: and tr.table_alias = l_table_alias
6469: cpe.table_route_id,
6470: cpe.dml_operation,
6471: cpe.datetrack_mode
6472: from ben_copy_entity_results cpe,
6473: pqh_table_route tr
6474: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6475: and cpe.table_route_id = tr.table_route_id
6476: -- and tr.where_clause = l_BEN_BNFT_VRBL_RT_F
6477: and tr.table_alias = l_table_alias
6946: cpe.table_route_id,
6947: cpe.dml_operation,
6948: cpe.datetrack_mode
6949: from ben_copy_entity_results cpe,
6950: pqh_table_route tr
6951: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6952: and cpe.table_route_id = tr.table_route_id
6953: -- and tr.where_clause = l_BEN_BNFT_VRBL_RT_RL_F
6954: and tr.table_alias = l_table_alias
7416: cpe.table_route_id,
7417: cpe.dml_operation,
7418: cpe.datetrack_mode
7419: from ben_copy_entity_results cpe,
7420: pqh_table_route tr
7421: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7422: and cpe.table_route_id = tr.table_route_id
7423: -- and tr.where_clause = l_BEN_ACTL_PREM_VRBL_RT_F
7424: and tr.table_alias = l_table_alias
7885: cpe.table_route_id,
7886: cpe.dml_operation,
7887: cpe.datetrack_mode
7888: from ben_copy_entity_results cpe,
7889: pqh_table_route tr
7890: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7891: and cpe.table_route_id = tr.table_route_id
7892: -- and tr.where_clause = l_BEN_ACTL_PREM_VRBL_RT_RL_F
7893: and tr.table_alias = l_table_alias
8368: cpe.table_route_id,
8369: cpe.dml_operation,
8370: cpe.datetrack_mode
8371: from ben_copy_entity_results cpe,
8372: pqh_table_route tr
8373: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8374: and cpe.table_route_id = tr.table_route_id
8375: -- and tr.where_clause = l_BEN_APLCN_TO_BNFT_POOL_F
8376: and tr.table_alias = l_table_alias
8853: cpe.table_route_id,
8854: cpe.dml_operation,
8855: cpe.datetrack_mode
8856: from ben_copy_entity_results cpe,
8857: pqh_table_route tr
8858: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8859: and cpe.table_route_id = tr.table_route_id
8860: -- and tr.where_clause = l_BEN_BNFT_POOL_RLOVR_RQMT_F
8861: and tr.table_alias = l_table_alias
9377: cpe.table_route_id,
9378: cpe.dml_operation,
9379: cpe.datetrack_mode
9380: 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_DPNT_CVG_RQD_RLSHP_F
9385: and tr.table_alias = l_table_alias
9863: cpe.table_route_id,
9864: cpe.dml_operation,
9865: cpe.datetrack_mode
9866: from ben_copy_entity_results cpe,
9867: pqh_table_route tr
9868: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9869: and cpe.table_route_id = tr.table_route_id
9870: -- and tr.where_clause = l_BEN_DSGNTR_ENRLD_CVG_F
9871: and tr.table_alias = l_table_alias
10336: cpe.table_route_id,
10337: cpe.dml_operation,
10338: cpe.datetrack_mode
10339: from ben_copy_entity_results cpe,
10340: pqh_table_route tr
10341: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10342: and cpe.table_route_id = tr.table_route_id
10343: -- and tr.where_clause = l_BEN_DPNT_CVRD_ANTHR_PL_CVG_F
10344: and tr.table_alias = l_table_alias
10824: cpe.table_route_id,
10825: cpe.dml_operation,
10826: cpe.datetrack_mode
10827: from ben_copy_entity_results cpe,
10828: pqh_table_route tr
10829: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10830: and cpe.table_route_id = tr.table_route_id
10831: -- and tr.where_clause = l_BEN_ELIG_AGE_CVG_F
10832: and tr.table_alias = l_table_alias
11313: cpe.table_route_id,
11314: cpe.dml_operation,
11315: cpe.datetrack_mode
11316: from ben_copy_entity_results cpe,
11317: pqh_table_route tr
11318: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11319: and cpe.table_route_id = tr.table_route_id
11320: -- and tr.where_clause = l_BEN_ELIG_DSBLD_STAT_CVG_F
11321: and tr.table_alias = l_table_alias
11789: cpe.information3,
11790: cpe.table_route_id,
11791: cpe.dml_operation,cpe.datetrack_mode
11792: from ben_copy_entity_results cpe,
11793: pqh_table_route tr
11794: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11795: and cpe.table_route_id = tr.table_route_id
11796: -- and tr.where_clause = l_BEN_ELIG_MLTRY_STAT_CVG_F
11797: and tr.table_alias = l_table_alias
12273: cpe.table_route_id,
12274: cpe.dml_operation,
12275: cpe.datetrack_mode
12276: from ben_copy_entity_results cpe,
12277: pqh_table_route tr
12278: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12279: and cpe.table_route_id = tr.table_route_id
12280: -- and tr.where_clause = l_BEN_ELIG_MRTL_STAT_CVG_F
12281: and tr.table_alias = l_table_alias
12758: cpe.table_route_id,
12759: cpe.dml_operation,
12760: cpe.datetrack_mode
12761: from ben_copy_entity_results cpe,
12762: pqh_table_route tr
12763: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12764: and cpe.table_route_id = tr.table_route_id
12765: -- and tr.where_clause = l_BEN_ELIG_PSTL_CD_R_RNG_CVG_F
12766: and tr.table_alias = l_table_alias
13226: cpe.information3,
13227: cpe.table_route_id,
13228: cpe.dml_operation,cpe.datetrack_mode
13229: from ben_copy_entity_results cpe,
13230: pqh_table_route tr
13231: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13232: and cpe.table_route_id = tr.table_route_id
13233: -- and tr.where_clause = l_BEN_ELIG_STDNT_STAT_CVG_F
13234: and tr.table_alias = l_table_alias
13708: cpe.information3,
13709: cpe.table_route_id,
13710: cpe.dml_operation,cpe.datetrack_mode
13711: from ben_copy_entity_results cpe,
13712: pqh_table_route tr
13713: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13714: and cpe.table_route_id = tr.table_route_id
13715: -- and tr.where_clause = l_BEN_EXTRA_INPUT_VALUES
13716: and tr.table_alias = l_table_alias
13760: cursor c_element_type_id(c_acty_base_rt_id in number,
13761: c_copy_entity_txn_id in number) is
13762: select cpe.information176 element_type_id
13763: from ben_copy_entity_results cpe,
13764: pqh_table_route tre
13765: where cpe.information1 = c_acty_base_rt_id
13766: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
13767: and cpe.table_route_id = tre.table_route_id
13768: and tre.table_alias = 'ABR'
14143: cpe.table_route_id,
14144: cpe.dml_operation,
14145: cpe.datetrack_mode
14146: from ben_copy_entity_results cpe,
14147: pqh_table_route tr
14148: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14149: and cpe.table_route_id = tr.table_route_id
14150: -- and tr.where_clause = l_BEN_PYMT_SCHED_PY_FREQ
14151: and tr.table_alias = l_table_alias
14500: cpe.information3,
14501: cpe.table_route_id,
14502: cpe.dml_operation,cpe.datetrack_mode
14503: from ben_copy_entity_results cpe,
14504: pqh_table_route tr
14505: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14506: and cpe.table_route_id = tr.table_route_id
14507: -- and tr.where_clause = l_BEN_ACTY_RT_PYMT_SCHED_F
14508: and tr.table_alias = l_table_alias
14978: cpe.information3,
14979: cpe.table_route_id,
14980: cpe.dml_operation,cpe.datetrack_mode
14981: from ben_copy_entity_results cpe,
14982: pqh_table_route tr
14983: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14984: and cpe.table_route_id = tr.table_route_id
14985: -- and tr.where_clause = l_BEN_ACTY_BASE_RT_CTFN_F
14986: and tr.table_alias = l_table_alias
15468: cpe.information3,
15469: cpe.table_route_id,
15470: cpe.dml_operation,cpe.datetrack_mode
15471: from ben_copy_entity_results cpe,
15472: pqh_table_route tr
15473: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15474: and cpe.table_route_id = tr.table_route_id
15475: -- and tr.where_clause = l_BEN_PRTL_MO_RT_PRTN_VAL_F
15476: and tr.table_alias = l_table_alias
15990: cpe.information3,
15991: cpe.table_route_id,
15992: cpe.dml_operation,cpe.datetrack_mode
15993: from ben_copy_entity_results cpe,
15994: pqh_table_route tr
15995: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15996: and cpe.table_route_id = tr.table_route_id
15997: -- and tr.where_clause = l_BEN_VRBL_RT_ELIG_PRFL_F
15998: and tr.table_alias = l_table_alias