[Home] [Help]
34: c_parent_table_name varchar2,
35: c_copy_entity_txn_id number) is
36: select copy_entity_result_id mirror_src_entity_result_id
37: from ben_copy_entity_results cpe,
38: pqh_table_route trt
39: where cpe.information1= c_parent_pk_id
40: and cpe.result_type_cd = 'DISPLAY'
41: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
42: and cpe.table_route_id = trt.table_route_id
48: -- Cursor to get table_route_id
49: --
50: -- cursor c_table_route(c_parent_table_alias varchar2) is
51: -- select table_route_id
52: -- from pqh_table_route trt
53: -- where trt.table_alias = c_parent_table_alias;
54: -- trt.from_clause = 'OAB'
55: -- and trt.where_clause = upper(c_parent_table_name) ;
56: ---
93: -- and abr.business_group_id = p_business_group_id
94: and not exists (
95: select /* */ null
96: from ben_copy_entity_results cpe
97: -- pqh_table_route trt
98: where copy_entity_txn_id = p_copy_entity_txn_id
99: -- and trt.table_route_id = cpe.table_route_id
100: and ( -- c_mirror_src_entity_result_id is null or
101: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
197: --and apf.business_group_id = p_business_group_id
198: and not exists (
199: select /* */ null
200: from ben_copy_entity_results cpe
201: -- pqh_table_route trt
202: where copy_entity_txn_id = p_copy_entity_txn_id
203: -- and trt.table_route_id = cpe.table_route_id
204: and ( --l_mirror_src_entity_result_id is null or
205: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
229: --and psq.business_group_id = p_business_group_id
230: and not exists (
231: select /* */ null
232: from ben_copy_entity_results cpe
233: -- pqh_table_route trt
234: where copy_entity_txn_id = p_copy_entity_txn_id
235: -- and trt.table_route_id = cpe.table_route_id
236: and ( --c_mirror_src_entity_result_id is null or
237: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
261: -- and apr.business_group_id = p_business_group_id
262: and not exists (
263: select /* */ null
264: from ben_copy_entity_results cpe
265: -- pqh_table_route trt
266: where copy_entity_txn_id = p_copy_entity_txn_id
267: -- and trt.table_route_id = cpe.table_route_id
268: and ( -- c_mirror_src_entity_result_id is null or
269: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
293: -- and apl.business_group_id = p_business_group_id
294: and not exists (
295: select /* */ null
296: from ben_copy_entity_results cpe
297: -- pqh_table_route trt
298: where copy_entity_txn_id = p_copy_entity_txn_id
299: -- and trt.table_route_id = cpe.table_route_id
300: and ( -- c_mirror_src_entity_result_id is null or
301: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
326: -- and avr.business_group_id = p_business_group_id
327: and not exists (
328: select /* */ null
329: from ben_copy_entity_results cpe
330: -- pqh_table_route trt
331: where copy_entity_txn_id = p_copy_entity_txn_id
332: -- and trt.table_route_id = cpe.table_route_id
333: and ( -- c_mirror_src_entity_result_id is null or
334: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
341: --
342: cursor c_avr_drp(c_acty_vrbl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
343: select distinct cpe.information262 vrbl_rt_prfl_id
344: from ben_copy_entity_results cpe
345: -- pqh_table_route trt
346: where copy_entity_txn_id = p_copy_entity_txn_id
347: -- and trt.table_route_id = cpe.table_route_id
348: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
349: -- and trt.where_clause = 'BEN_ACTY_VRBL_RT_F'
373: -- and mtr.business_group_id = p_business_group_id
374: and not exists (
375: select /* */ null
376: from ben_copy_entity_results cpe
377: -- pqh_table_route trt
378: where copy_entity_txn_id = p_copy_entity_txn_id
379: -- and trt.table_route_id = cpe.table_route_id
380: and ( -- c_mirror_src_entity_result_id is null or
381: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
405: -- and pmr.business_group_id = p_business_group_id
406: and not exists (
407: select /* */ null
408: from ben_copy_entity_results cpe
409: -- pqh_table_route trt
410: where copy_entity_txn_id = p_copy_entity_txn_id
411: -- and trt.table_route_id = cpe.table_route_id
412: and ( -- c_mirror_src_entity_result_id is null or
413: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
438: -- and pdl.business_group_id = p_business_group_id
439: and not exists (
440: select /* */ null
441: from ben_copy_entity_results cpe
442: -- pqh_table_route trt
443: where copy_entity_txn_id = p_copy_entity_txn_id
444: -- and trt.table_route_id = cpe.table_route_id
445: and ( -- c_mirror_src_entity_result_id is null or
446: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
470: -- and eiv.business_group_id = p_business_group_id
471: and not exists (
472: select /* */ null
473: from ben_copy_entity_results cpe
474: -- pqh_table_route trt
475: where copy_entity_txn_id = p_copy_entity_txn_id
476: -- and trt.table_route_id = cpe.table_route_id
477: and ( -- c_mirror_src_entity_result_id is null or
478: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
486: c_copy_entity_txn_id in number,
487: c_table_alias varchar2) is
488: select cpe.information174 element_type_id
489: from ben_copy_entity_results cpe
490: -- pqh_table_route tre
491: where cpe.information1 = c_acty_base_rt_id
492: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
493: -- and cpe.table_route_id = tre.table_route_id
494: and cpe.table_alias = c_table_alias
515: -- and abc.business_group_id = p_business_group_id
516: and not exists (
517: select /* */ null
518: from ben_copy_entity_results cpe
519: -- pqh_table_route trt
520: where copy_entity_txn_id = p_copy_entity_txn_id
521: -- and trt.table_route_id = cpe.table_route_id
522: and ( -- c_mirror_src_entity_result_id is null or
523: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
536: cursor c_object_exists(c_pk_id number,
537: c_table_alias varchar2) is
538: select null
539: from ben_copy_entity_results cpe
540: -- pqh_table_route trt
541: where copy_entity_txn_id = p_copy_entity_txn_id
542: -- and trt.table_route_id = cpe.table_route_id
543: and cpe.table_alias = c_table_alias
544: and information1 = c_pk_id;
2488: c_parent_table_name varchar2,
2489: c_copy_entity_txn_id number) is
2490: select copy_entity_result_id mirror_src_entity_result_id
2491: from ben_copy_entity_results cpe,
2492: pqh_table_route trt
2493: where cpe.information1= c_parent_pk_id
2494: and cpe.result_type_cd = 'DISPLAY'
2495: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
2496: and cpe.table_route_id = trt.table_route_id
2501: -- Cursor to get table_route_id
2502: --
2503: -- cursor c_table_route(c_parent_table_alias varchar2) is
2504: -- select table_route_id
2505: -- from pqh_table_route trt
2506: -- where trt.table_alias = c_parent_table_alias;
2507: -- trt.from_clause = 'OAB'
2508: -- and trt.where_clause = upper(c_parent_table_name) ;
2509: ---
2529: -- and ccm.business_group_id = p_business_group_id
2530: and not exists (
2531: select /* */ null
2532: from ben_copy_entity_results cpe
2533: -- pqh_table_route trt
2534: where copy_entity_txn_id = p_copy_entity_txn_id
2535: -- and trt.table_route_id = cpe.table_route_id
2536: and ( -- c_mirror_src_entity_result_id is null or
2537: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2561: -- and brr.business_group_id = p_business_group_id
2562: and not exists (
2563: select /* */ null
2564: from ben_copy_entity_results cpe
2565: -- pqh_table_route trt
2566: where copy_entity_txn_id = p_copy_entity_txn_id
2567: -- and trt.table_route_id = cpe.table_route_id
2568: and ( -- c_mirror_src_entity_result_id is null or
2569: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2594: -- and bvr.business_group_id = p_business_group_id
2595: and not exists (
2596: select /* */ null
2597: from ben_copy_entity_results cpe
2598: -- pqh_table_route trt
2599: where copy_entity_txn_id = p_copy_entity_txn_id
2600: -- and trt.table_route_id = cpe.table_route_id
2601: and ( -- c_mirror_src_entity_result_id is null or
2602: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2609: --
2610: cursor c_bvr_drp(c_bnft_vrbl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
2611: select distinct cpe.information262 vrbl_rt_prfl_id
2612: from ben_copy_entity_results cpe
2613: -- pqh_table_route trt
2614: where copy_entity_txn_id = p_copy_entity_txn_id
2615: -- and trt.table_route_id = cpe.table_route_id
2616: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
2617: -- and trt.where_clause = 'BEN_BNFT_VRBL_RT_F'
3125: c_parent_table_name varchar2,
3126: c_copy_entity_txn_id number) is
3127: select copy_entity_result_id mirror_src_entity_result_id
3128: from ben_copy_entity_results cpe,
3129: pqh_table_route trt
3130: where cpe.information1= c_parent_pk_id
3131: and cpe.result_type_cd = 'DISPLAY'
3132: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
3133: and cpe.table_route_id = trt.table_route_id
3138: -- Cursor to get table_route_id
3139: --
3140: -- cursor c_table_route(c_parent_table_alias varchar2) is
3141: -- select table_route_id
3142: -- from pqh_table_route trt
3143: -- where trt.table_alias = c_parent_table_alias;
3144: -- trt.from_clause = 'OAB'
3145: -- and trt.where_clause = upper(c_parent_table_name) ;
3146: ---
3166: -- and apr.business_group_id = p_business_group_id
3167: and not exists (
3168: select /* */ null
3169: from ben_copy_entity_results cpe
3170: -- pqh_table_route trt
3171: where copy_entity_txn_id = p_copy_entity_txn_id
3172: -- and trt.table_route_id = cpe.table_route_id
3173: and ( -- c_mirror_src_entity_result_id is null or
3174: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3199: -- and pmr.business_group_id = p_business_group_id
3200: and not exists (
3201: select /* */ null
3202: from ben_copy_entity_results cpe
3203: -- pqh_table_route trt
3204: where copy_entity_txn_id = p_copy_entity_txn_id
3205: -- and trt.table_route_id = cpe.table_route_id
3206: and ( -- c_mirror_src_entity_result_id is null or
3207: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3231: -- and apv.business_group_id = p_business_group_id
3232: and not exists (
3233: select /* */ null
3234: from ben_copy_entity_results cpe
3235: -- pqh_table_route trt
3236: where copy_entity_txn_id = p_copy_entity_txn_id
3237: -- and trt.table_route_id = cpe.table_route_id
3238: and ( -- c_mirror_src_entity_result_id is null or
3239: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3246: --
3247: cursor c_apv_dpr(c_actl_prem_vrbl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
3248: select distinct cpe.information262 vrbl_rt_prfl_id
3249: from ben_copy_entity_results cpe
3250: -- pqh_table_route trt
3251: where copy_entity_txn_id = p_copy_entity_txn_id
3252: -- and trt.table_route_id = cpe.table_route_id
3253: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
3254: -- and trt.where_clause = 'BEN_ACTL_PREM_VRBL_RT_F'
3278: -- and ava.business_group_id = p_business_group_id
3279: and not exists (
3280: select /* */ null
3281: from ben_copy_entity_results cpe
3282: -- pqh_table_route trt
3283: where copy_entity_txn_id = p_copy_entity_txn_id
3284: -- and trt.table_route_id = cpe.table_route_id
3285: and ( -- c_mirror_src_entity_result_id is null or
3286: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
4012: c_parent_table_name varchar2,
4013: c_copy_entity_txn_id number) is
4014: select copy_entity_result_id mirror_src_entity_result_id
4015: from ben_copy_entity_results cpe,
4016: pqh_table_route trt
4017: where cpe.information1= c_parent_pk_id
4018: and cpe.result_type_cd = 'DISPLAY'
4019: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
4020: and cpe.table_route_id = trt.table_route_id
4025: -- Cursor to get table_route_id
4026: --
4027: -- cursor c_table_route(c_parent_table_alias varchar2) is
4028: -- select table_route_id
4029: -- from pqh_table_route trt
4030: -- where trt.table_alias = c_parent_table_alias;
4031: -- trt.from_clause = 'OAB'
4032: -- and trt.where_clause = upper(c_parent_table_name) ;
4033: ---
4039: c_parent_table_alias varchar2,
4040: c_copy_entity_txn_id number) is
4041: select min(cpe.information2) min_esd
4042: from ben_copy_entity_results cpe
4043: -- pqh_table_route trt
4044: where cpe.information1= c_parent_pk_id
4045: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
4046: --and cpe.table_route_id = trt.table_route_id
4047: and cpe.table_alias = c_parent_table_alias;
4067: -- and agf.business_group_id = p_business_group_id
4068: and not exists (
4069: select /* */ null
4070: from ben_copy_entity_results cpe
4071: -- pqh_table_route trt
4072: where copy_entity_txn_id = p_copy_entity_txn_id
4073: -- and trt.table_route_id = cpe.table_route_id
4074: and ( -- c_mirror_src_entity_result_id is null or
4075: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
4093: -- and cla.business_group_id = p_business_group_id
4094: and not exists (
4095: select /* */ null
4096: from ben_copy_entity_results cpe
4097: -- pqh_table_route trt
4098: where copy_entity_txn_id = p_copy_entity_txn_id
4099: -- and trt.table_route_id = cpe.table_route_id
4100: and ( -- c_mirror_src_entity_result_id is null or
4101: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
4121: -- and clf.business_group_id = p_business_group_id
4122: and not exists (
4123: select /* */ null
4124: from ben_copy_entity_results cpe
4125: -- pqh_table_route trt
4126: where copy_entity_txn_id = p_copy_entity_txn_id
4127: -- and trt.table_route_id = cpe.table_route_id
4128: and ( -- c_mirror_src_entity_result_id is null or
4129: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
4137: --
4138: cursor c_clf_drp(c_comp_lvl_fctr_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
4139: select distinct cpe.information225 bnfts_bal_id
4140: from ben_copy_entity_results cpe
4141: -- pqh_table_route trt
4142: where copy_entity_txn_id = p_copy_entity_txn_id
4143: -- and trt.table_route_id = cpe.table_route_id
4144: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
4145: -- and trt.where_clause = 'BEN_COMP_LVL_FCTR'
4160: -- and hwf.business_group_id = p_business_group_id
4161: and not exists (
4162: select /* */ null
4163: from ben_copy_entity_results cpe
4164: -- pqh_table_route trt
4165: where copy_entity_txn_id = p_copy_entity_txn_id
4166: -- and trt.table_route_id = cpe.table_route_id
4167: and ( -- c_mirror_src_entity_result_id is null or
4168: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
4177: --
4178: cursor c_hwf_drp(c_hrs_wkd_in_perd_fctr_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
4179: select distinct cpe.information225 bnfts_bal_id
4180: from ben_copy_entity_results cpe
4181: -- pqh_table_route trt
4182: where copy_entity_txn_id = p_copy_entity_txn_id
4183: -- and trt.table_route_id = cpe.table_route_id
4184: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
4185: -- and trt.where_clause = 'BEN_HRS_WKD_IN_PERD_FCTR'
4201: -- and lsf.business_group_id = p_business_group_id
4202: and not exists (
4203: select /* */ null
4204: from ben_copy_entity_results cpe
4205: -- pqh_table_route trt
4206: where copy_entity_txn_id = p_copy_entity_txn_id
4207: -- and trt.table_route_id = cpe.table_route_id
4208: and ( -- c_mirror_src_entity_result_id is null or
4209: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
4227: -- and pff.business_group_id = p_business_group_id
4228: and not exists (
4229: select /* */ null
4230: from ben_copy_entity_results cpe
4231: -- pqh_table_route trt
4232: where copy_entity_txn_id = p_copy_entity_txn_id
4233: -- and trt.table_route_id = cpe.table_route_id
4234: and ( -- c_mirror_src_entity_result_id is null or
4235: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
4272: cursor c_object_exists(c_pk_id number,
4273: c_table_alias varchar2) is
4274: select null
4275: from ben_copy_entity_results cpe
4276: -- pqh_table_route trt
4277: where copy_entity_txn_id = p_copy_entity_txn_id
4278: -- and trt.table_route_id = cpe.table_route_id
4279: and cpe.table_alias = c_table_alias
4280: and information1 = c_pk_id;
5457: -- and vep.business_group_id = p_business_group_id
5458: and not exists (
5459: select /* */ null
5460: from ben_copy_entity_results cpe
5461: -- pqh_table_route trt
5462: where copy_entity_txn_id = p_copy_entity_txn_id
5463: -- and trt.table_route_id = cpe.table_route_id
5464: and ( -- c_mirror_src_entity_result_id is null or
5465: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5476: -- Cursor to get table_route_id
5477: --
5478: -- cursor c_table_route(c_parent_table_alias varchar2) is
5479: -- select table_route_id
5480: -- from pqh_table_route trt
5481: -- where trt.table_alias = c_parent_table_alias;
5482: -- trt.from_clause = 'OAB'
5483: -- and trt.where_clause = upper(c_parent_table_name) ;
5484:
5682: c_parent_table_name varchar2,
5683: c_copy_entity_txn_id number) is
5684: select copy_entity_result_id mirror_src_entity_result_id
5685: from ben_copy_entity_results cpe,
5686: pqh_table_route trt
5687: where cpe.information1= c_parent_pk_id
5688: and cpe.result_type_cd = 'DISPLAY'
5689: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
5690: and cpe.table_route_id = trt.table_route_id
5695: -- Cursor to get table_route_id
5696: --
5697: -- cursor c_table_route(c_parent_table_alias varchar2) is
5698: -- select table_route_id
5699: -- from pqh_table_route trt
5700: -- where trt.table_alias = c_parent_table_alias;
5701: -- trt.from_clause = 'OAB'
5702: -- and trt.where_clause = upper(c_parent_table_name) ;
5703: ---
5724: -- and vpf.business_group_id = p_business_group_id
5725: and not exists (
5726: select /* */ null
5727: from ben_copy_entity_results cpe
5728: -- pqh_table_route trt
5729: where copy_entity_txn_id = p_copy_entity_txn_id
5730: -- and trt.table_route_id = cpe.table_route_id
5731: and ( -- c_mirror_src_entity_result_id is null or
5732: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5757: -- and art.business_group_id = p_business_group_id
5758: and not exists (
5759: select /* */ null
5760: from ben_copy_entity_results cpe
5761: -- pqh_table_route trt
5762: where copy_entity_txn_id = p_copy_entity_txn_id
5763: -- and trt.table_route_id = cpe.table_route_id
5764: and ( -- c_mirror_src_entity_result_id is null or
5765: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5775: cursor c_art_drp(c_age_rt_id number,c_mirror_src_entity_result_id number,
5776: c_table_alias varchar2 ) is
5777: select distinct cpe.information246 age_fctr_id
5778: from ben_copy_entity_results cpe
5779: -- pqh_table_route trt
5780: where copy_entity_txn_id = p_copy_entity_txn_id
5781: -- and trt.table_route_id = cpe.table_route_id
5782: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
5783: -- and trt.where_clause = 'BEN_AGE_RT_F'
5804: -- and asr.business_group_id = p_business_group_id
5805: and not exists (
5806: select /* */ null
5807: from ben_copy_entity_results cpe
5808: -- pqh_table_route trt
5809: where copy_entity_txn_id = p_copy_entity_txn_id
5810: -- and trt.table_route_id = cpe.table_route_id
5811: and ( -- c_mirror_src_entity_result_id is null or
5812: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5846: -- and brg.business_group_id = p_business_group_id
5847: and not exists (
5848: select /* */ null
5849: from ben_copy_entity_results cpe
5850: -- pqh_table_route trt
5851: where copy_entity_txn_id = p_copy_entity_txn_id
5852: -- and trt.table_route_id = cpe.table_route_id
5853: and ( -- c_mirror_src_entity_result_id is null or
5854: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5863: --
5864: cursor c_brg_bg(c_benfts_grp_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
5865: select distinct cpe.information222 benfts_grp_id
5866: from ben_copy_entity_results cpe
5867: -- pqh_table_route trt
5868: where copy_entity_txn_id = p_copy_entity_txn_id
5869: -- and trt.table_route_id = cpe.table_route_id
5870: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
5871: -- and trt.where_clause = 'BEN_BENFTS_GRP_RT_F'
5893: -- and bur.business_group_id = p_business_group_id
5894: and not exists (
5895: select /* */ null
5896: from ben_copy_entity_results cpe
5897: -- pqh_table_route trt
5898: where copy_entity_txn_id = p_copy_entity_txn_id
5899: -- and trt.table_route_id = cpe.table_route_id
5900: and ( -- c_mirror_src_entity_result_id is null or
5901: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5925: -- and cmr.business_group_id = p_business_group_id
5926: and not exists (
5927: select /* */ null
5928: from ben_copy_entity_results cpe
5929: -- pqh_table_route trt
5930: where copy_entity_txn_id = p_copy_entity_txn_id
5931: -- and trt.table_route_id = cpe.table_route_id
5932: and ( -- c_mirror_src_entity_result_id is null or
5933: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5942: --
5943: cursor c_cmr_drp(c_cmbn_age_los_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
5944: select distinct cpe.information223 cmbn_age_los_fctr_id
5945: from ben_copy_entity_results cpe
5946: -- pqh_table_route trt
5947: where copy_entity_txn_id = p_copy_entity_txn_id
5948: -- and trt.table_route_id = cpe.table_route_id
5949: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
5950: -- and trt.where_clause = 'BEN_CMBN_AGE_LOS_RT_F'
5971: -- and clr.business_group_id = p_business_group_id
5972: and not exists (
5973: select /* */ null
5974: from ben_copy_entity_results cpe
5975: -- pqh_table_route trt
5976: where copy_entity_txn_id = p_copy_entity_txn_id
5977: -- and trt.table_route_id = cpe.table_route_id
5978: and ( -- c_mirror_src_entity_result_id is null or
5979: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5988: --
5989: cursor c_clr_drp(c_comp_lvl_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
5990: select distinct cpe.information254 comp_lvl_fctr_id
5991: from ben_copy_entity_results cpe
5992: -- pqh_table_route trt
5993: where copy_entity_txn_id = p_copy_entity_txn_id
5994: -- and trt.table_route_id = cpe.table_route_id
5995: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
5996: -- and trt.where_clause = 'BEN_COMP_LVL_RT_F'
6017: -- and dbr.business_group_id = p_business_group_id
6018: and not exists (
6019: select /* */ null
6020: from ben_copy_entity_results cpe
6021: -- pqh_table_route trt
6022: where copy_entity_txn_id = p_copy_entity_txn_id
6023: -- and trt.table_route_id = cpe.table_route_id
6024: and ( -- c_mirror_src_entity_result_id is null or
6025: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6050: -- and esr.business_group_id = p_business_group_id
6051: and not exists (
6052: select /* */ null
6053: from ben_copy_entity_results cpe
6054: -- pqh_table_route trt
6055: where copy_entity_txn_id = p_copy_entity_txn_id
6056: -- and trt.table_route_id = cpe.table_route_id
6057: and ( -- c_mirror_src_entity_result_id is null or
6058: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6106: -- and ftr.business_group_id = p_business_group_id
6107: and not exists (
6108: select /* */ null
6109: from ben_copy_entity_results cpe
6110: -- pqh_table_route trt
6111: where copy_entity_txn_id = p_copy_entity_txn_id
6112: -- and trt.table_route_id = cpe.table_route_id
6113: and ( -- c_mirror_src_entity_result_id is null or
6114: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6140: -- and gnr.business_group_id = p_business_group_id
6141: and not exists (
6142: select /* */ null
6143: from ben_copy_entity_results cpe
6144: -- pqh_table_route trt
6145: where copy_entity_txn_id = p_copy_entity_txn_id
6146: -- and trt.table_route_id = cpe.table_route_id
6147: and ( -- c_mirror_src_entity_result_id is null or
6148: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6173: -- and grr.business_group_id = p_business_group_id
6174: and not exists (
6175: select /* */ null
6176: from ben_copy_entity_results cpe
6177: -- pqh_table_route trt
6178: where copy_entity_txn_id = p_copy_entity_txn_id
6179: -- and trt.table_route_id = cpe.table_route_id
6180: and ( -- c_mirror_src_entity_result_id is null or
6181: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6221: -- and hsr.business_group_id = p_business_group_id
6222: and not exists (
6223: select /* */ null
6224: from ben_copy_entity_results cpe
6225: -- pqh_table_route trt
6226: where copy_entity_txn_id = p_copy_entity_txn_id
6227: -- and trt.table_route_id = cpe.table_route_id
6228: and ( -- c_mirror_src_entity_result_id is null or
6229: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6253: -- and hwr.business_group_id = p_business_group_id
6254: and not exists (
6255: select /* */ null
6256: from ben_copy_entity_results cpe
6257: -- pqh_table_route trt
6258: where copy_entity_txn_id = p_copy_entity_txn_id
6259: -- and trt.table_route_id = cpe.table_route_id
6260: and ( -- c_mirror_src_entity_result_id is null or
6261: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6270: --
6271: cursor c_hwr_drp(c_hrs_wkd_in_perd_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
6272: select distinct cpe.information224 hrs_wkd_in_perd_fctr_id
6273: from ben_copy_entity_results cpe
6274: -- pqh_table_route trt
6275: where copy_entity_txn_id = p_copy_entity_txn_id
6276: -- and trt.table_route_id = cpe.table_route_id
6277: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
6278: -- and trt.where_clause = 'BEN_HRS_WKD_IN_PERD_RT_F'
6299: -- and lmm.business_group_id = p_business_group_id
6300: and not exists (
6301: select /* */ null
6302: from ben_copy_entity_results cpe
6303: -- pqh_table_route trt
6304: where copy_entity_txn_id = p_copy_entity_txn_id
6305: -- and trt.table_route_id = cpe.table_route_id
6306: and ( -- c_mirror_src_entity_result_id is null or
6307: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6332: -- and ler.business_group_id = p_business_group_id
6333: and not exists (
6334: select /* */ null
6335: from ben_copy_entity_results cpe
6336: -- pqh_table_route trt
6337: where copy_entity_txn_id = p_copy_entity_txn_id
6338: -- and trt.table_route_id = cpe.table_route_id
6339: and ( -- c_mirror_src_entity_result_id is null or
6340: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6386: -- and lar.business_group_id = p_business_group_id
6387: and not exists (
6388: select /* */ null
6389: from ben_copy_entity_results cpe
6390: -- pqh_table_route trt
6391: where copy_entity_txn_id = p_copy_entity_txn_id
6392: -- and trt.table_route_id = cpe.table_route_id
6393: and ( -- c_mirror_src_entity_result_id is null or
6394: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6453: -- and lsr.business_group_id = p_business_group_id
6454: and not exists (
6455: select /* */ null
6456: from ben_copy_entity_results cpe
6457: -- pqh_table_route trt
6458: where copy_entity_txn_id = p_copy_entity_txn_id
6459: -- and trt.table_route_id = cpe.table_route_id
6460: and ( -- c_mirror_src_entity_result_id is null or
6461: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6471: cursor c_lsr_drp(c_los_rt_id number,c_mirror_src_entity_result_id number,
6472: c_table_alias varchar2 ) is
6473: select distinct cpe.information243 los_fctr_id
6474: from ben_copy_entity_results cpe
6475: -- pqh_table_route trt
6476: where copy_entity_txn_id = p_copy_entity_txn_id
6477: -- and trt.table_route_id = cpe.table_route_id
6478: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
6479: -- and trt.where_clause = 'BEN_LOS_RT_F'
6500: -- and lrn.business_group_id = p_business_group_id
6501: and not exists (
6502: select /* */ null
6503: from ben_copy_entity_results cpe
6504: -- pqh_table_route trt
6505: where copy_entity_txn_id = p_copy_entity_txn_id
6506: -- and trt.table_route_id = cpe.table_route_id
6507: and ( -- c_mirror_src_entity_result_id is null or
6508: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6533: -- and our.business_group_id = p_business_group_id
6534: and not exists (
6535: select /* */ null
6536: from ben_copy_entity_results cpe
6537: -- pqh_table_route trt
6538: where copy_entity_txn_id = p_copy_entity_txn_id
6539: -- and trt.table_route_id = cpe.table_route_id
6540: and ( -- c_mirror_src_entity_result_id is null or
6541: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6581: -- and pfr.business_group_id = p_business_group_id
6582: and not exists (
6583: select /* */ null
6584: from ben_copy_entity_results cpe
6585: -- pqh_table_route trt
6586: where copy_entity_txn_id = p_copy_entity_txn_id
6587: -- and trt.table_route_id = cpe.table_route_id
6588: and ( -- c_mirror_src_entity_result_id is null or
6589: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6598: --
6599: cursor c_pfr_drp(c_pct_fl_tm_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
6600: select distinct cpe.information233 pct_fl_tm_fctr_id
6601: from ben_copy_entity_results cpe
6602: -- pqh_table_route trt
6603: where copy_entity_txn_id = p_copy_entity_txn_id
6604: -- and trt.table_route_id = cpe.table_route_id
6605: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
6606: -- and trt.where_clause = 'BEN_PCT_FL_TM_RT_F'
6627: -- and ptr.business_group_id = p_business_group_id
6628: and not exists (
6629: select /* */ null
6630: from ben_copy_entity_results cpe
6631: -- pqh_table_route trt
6632: where copy_entity_txn_id = p_copy_entity_txn_id
6633: -- and trt.table_route_id = cpe.table_route_id
6634: and ( -- c_mirror_src_entity_result_id is null or
6635: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6680: -- and prt.business_group_id = p_business_group_id
6681: and not exists (
6682: select /* */ null
6683: from ben_copy_entity_results cpe
6684: -- pqh_table_route trt
6685: where copy_entity_txn_id = p_copy_entity_txn_id
6686: -- and trt.table_route_id = cpe.table_route_id
6687: and ( -- c_mirror_src_entity_result_id is null or
6688: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6713: -- and pgr.business_group_id = p_business_group_id
6714: and not exists (
6715: select /* */ null
6716: from ben_copy_entity_results cpe
6717: -- pqh_table_route trt
6718: where copy_entity_txn_id = p_copy_entity_txn_id
6719: -- and trt.table_route_id = cpe.table_route_id
6720: and ( -- c_mirror_src_entity_result_id is null or
6721: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6746: -- and pzr.business_group_id = p_business_group_id
6747: and not exists (
6748: select /* */ null
6749: from ben_copy_entity_results cpe
6750: -- pqh_table_route trt
6751: where copy_entity_txn_id = p_copy_entity_txn_id
6752: -- and trt.table_route_id = cpe.table_route_id
6753: and ( -- c_mirror_src_entity_result_id is null or
6754: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6763: --
6764: cursor c_pzr_pstl(c_pstl_zip_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
6765: select distinct cpe.information245 pstl_zip_rng_id
6766: from ben_copy_entity_results cpe
6767: -- pqh_table_route trt
6768: where copy_entity_txn_id = p_copy_entity_txn_id
6769: -- and trt.table_route_id = cpe.table_route_id
6770: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
6771: -- and trt.where_clause = 'BEN_PSTL_ZIP_RT_F'
6792: -- and pr_.business_group_id = p_business_group_id
6793: and not exists (
6794: select /* */ null
6795: from ben_copy_entity_results cpe
6796: -- pqh_table_route trt
6797: where copy_entity_txn_id = p_copy_entity_txn_id
6798: -- and trt.table_route_id = cpe.table_route_id
6799: and ( -- c_mirror_src_entity_result_id is null or
6800: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6840: -- and pbr.business_group_id = p_business_group_id
6841: and not exists (
6842: select /* */ null
6843: from ben_copy_entity_results cpe
6844: -- pqh_table_route trt
6845: where copy_entity_txn_id = p_copy_entity_txn_id
6846: -- and trt.table_route_id = cpe.table_route_id
6847: and ( -- c_mirror_src_entity_result_id is null or
6848: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6881: -- and shr.business_group_id = p_business_group_id
6882: and not exists (
6883: select /* */ null
6884: from ben_copy_entity_results cpe
6885: -- pqh_table_route trt
6886: where copy_entity_txn_id = p_copy_entity_txn_id
6887: -- and trt.table_route_id = cpe.table_route_id
6888: and ( -- c_mirror_src_entity_result_id is null or
6889: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6914: -- and sar.business_group_id = p_business_group_id
6915: and not exists (
6916: select /* */ null
6917: from ben_copy_entity_results cpe
6918: -- pqh_table_route trt
6919: where copy_entity_txn_id = p_copy_entity_txn_id
6920: -- and trt.table_route_id = cpe.table_route_id
6921: and ( -- c_mirror_src_entity_result_id is null or
6922: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6931: --
6932: cursor c_sar_srv(c_svc_area_rt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
6933: select distinct cpe.information241 svc_area_id
6934: from ben_copy_entity_results cpe
6935: -- pqh_table_route trt
6936: where copy_entity_txn_id = p_copy_entity_txn_id
6937: -- and trt.table_route_id = cpe.table_route_id
6938: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
6939: -- and trt.where_clause = 'BEN_SVC_AREA_RT_F'
6960: -- and tur.business_group_id = p_business_group_id
6961: and not exists (
6962: select /* */ null
6963: from ben_copy_entity_results cpe
6964: -- pqh_table_route trt
6965: where copy_entity_txn_id = p_copy_entity_txn_id
6966: -- and trt.table_route_id = cpe.table_route_id
6967: and ( -- c_mirror_src_entity_result_id is null or
6968: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6993: -- and tcv.business_group_id = p_business_group_id
6994: and not exists (
6995: select /* */ null
6996: from ben_copy_entity_results cpe
6997: -- pqh_table_route trt
6998: where copy_entity_txn_id = p_copy_entity_txn_id
6999: -- and trt.table_route_id = cpe.table_route_id
7000: and ( -- c_mirror_src_entity_result_id is null or
7001: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7026: -- and ttp.business_group_id = p_business_group_id
7027: and not exists (
7028: select /* */ null
7029: from ben_copy_entity_results cpe
7030: -- pqh_table_route trt
7031: where copy_entity_txn_id = p_copy_entity_txn_id
7032: -- and trt.table_route_id = cpe.table_route_id
7033: and ( -- c_mirror_src_entity_result_id is null or
7034: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7059: -- and vmr.business_group_id = p_business_group_id
7060: and not exists (
7061: select /* */ null
7062: from ben_copy_entity_results cpe
7063: -- pqh_table_route trt
7064: where copy_entity_txn_id = p_copy_entity_txn_id
7065: -- and trt.table_route_id = cpe.table_route_id
7066: and ( -- c_mirror_src_entity_result_id is null or
7067: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7091: -- and vpr.business_group_id = p_business_group_id
7092: and not exists (
7093: select /* */ null
7094: from ben_copy_entity_results cpe
7095: -- pqh_table_route trt
7096: where copy_entity_txn_id = p_copy_entity_txn_id
7097: -- and trt.table_route_id = cpe.table_route_id
7098: and ( -- c_mirror_src_entity_result_id is null or
7099: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7124: -- and wlr.business_group_id = p_business_group_id
7125: and not exists (
7126: select /* */ null
7127: from ben_copy_entity_results cpe
7128: -- pqh_table_route trt
7129: where copy_entity_txn_id = p_copy_entity_txn_id
7130: -- and trt.table_route_id = cpe.table_route_id
7131: and ( -- c_mirror_src_entity_result_id is null or
7132: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7172: -- and cty.business_group_id = p_business_group_id
7173: and not exists (
7174: select /* */ null
7175: from ben_copy_entity_results cpe
7176: -- pqh_table_route trt
7177: where copy_entity_txn_id = p_copy_entity_txn_id
7178: -- and trt.table_route_id = cpe.table_route_id
7179: and ( -- c_mirror_src_entity_result_id is null or
7180: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7226: -- and jrt.business_group_id = p_business_group_id
7227: and not exists (
7228: select /* */ null
7229: from ben_copy_entity_results cpe
7230: -- pqh_table_route trt
7231: where copy_entity_txn_id = p_copy_entity_txn_id
7232: -- and trt.table_route_id = cpe.table_route_id
7233: and ( -- c_mirror_src_entity_result_id is null or
7234: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7278: -- and pst.business_group_id = p_business_group_id
7279: and not exists (
7280: select /* */ null
7281: from ben_copy_entity_results cpe
7282: -- pqh_table_route trt
7283: where copy_entity_txn_id = p_copy_entity_txn_id
7284: -- and trt.table_route_id = cpe.table_route_id
7285: and ( -- c_mirror_src_entity_result_id is null or
7286: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7326: --and qtr.business_group_id = p_business_group_id
7327: and not exists (
7328: select /* */ null
7329: from ben_copy_entity_results cpe
7330: -- pqh_table_route trt
7331: where copy_entity_txn_id = p_copy_entity_txn_id
7332: -- and trt.table_route_id = cpe.table_route_id
7333: and ( -- c_mirror_src_entity_result_id is null or
7334: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7366: --and cqr.business_group_id = p_business_group_id
7367: and not exists (
7368: select /* */ null
7369: from ben_copy_entity_results cpe
7370: -- pqh_table_route trt
7371: where copy_entity_txn_id = p_copy_entity_txn_id
7372: -- and trt.table_route_id = cpe.table_route_id
7373: and ( -- c_mirror_src_entity_result_id is null or
7374: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7398: --and cpn.business_group_id = p_business_group_id
7399: and not exists (
7400: select /* */ null
7401: from ben_copy_entity_results cpe
7402: -- pqh_table_route trt
7403: where copy_entity_txn_id = p_copy_entity_txn_id
7404: -- and trt.table_route_id = cpe.table_route_id
7405: and ( -- c_mirror_src_entity_result_id is null or
7406: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7430: --and dcl.business_group_id = p_business_group_id
7431: and not exists (
7432: select /* */ null
7433: from ben_copy_entity_results cpe
7434: -- pqh_table_route trt
7435: where copy_entity_txn_id = p_copy_entity_txn_id
7436: -- and trt.table_route_id = cpe.table_route_id
7437: and ( -- c_mirror_src_entity_result_id is null or
7438: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7462: --and dcp.business_group_id = p_business_group_id
7463: and not exists (
7464: select /* */ null
7465: from ben_copy_entity_results cpe
7466: -- pqh_table_route trt
7467: where copy_entity_txn_id = p_copy_entity_txn_id
7468: -- and trt.table_route_id = cpe.table_route_id
7469: and ( -- c_mirror_src_entity_result_id is null or
7470: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7494: --and dco.business_group_id = p_business_group_id
7495: and not exists (
7496: select /* */ null
7497: from ben_copy_entity_results cpe
7498: -- pqh_table_route trt
7499: where copy_entity_txn_id = p_copy_entity_txn_id
7500: -- and trt.table_route_id = cpe.table_route_id
7501: and ( -- c_mirror_src_entity_result_id is null or
7502: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7526: --and dop.business_group_id = p_business_group_id
7527: and not exists (
7528: select /* */ null
7529: from ben_copy_entity_results cpe
7530: -- pqh_table_route trt
7531: where copy_entity_txn_id = p_copy_entity_txn_id
7532: -- and trt.table_route_id = cpe.table_route_id
7533: and ( -- c_mirror_src_entity_result_id is null or
7534: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7558: --and pap.business_group_id = p_business_group_id
7559: and not exists (
7560: select /* */ null
7561: from ben_copy_entity_results cpe
7562: -- pqh_table_route trt
7563: where copy_entity_txn_id = p_copy_entity_txn_id
7564: -- and trt.table_route_id = cpe.table_route_id
7565: and ( -- c_mirror_src_entity_result_id is null or
7566: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7590: --and eao.business_group_id = p_business_group_id
7591: and not exists (
7592: select /* */ null
7593: from ben_copy_entity_results cpe
7594: -- pqh_table_route trt
7595: where copy_entity_txn_id = p_copy_entity_txn_id
7596: -- and trt.table_route_id = cpe.table_route_id
7597: and ( -- c_mirror_src_entity_result_id is null or
7598: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7622: --and enl.business_group_id = p_business_group_id
7623: and not exists (
7624: select /* */ null
7625: from ben_copy_entity_results cpe
7626: -- pqh_table_route trt
7627: where copy_entity_txn_id = p_copy_entity_txn_id
7628: -- and trt.table_route_id = cpe.table_route_id
7629: and ( -- c_mirror_src_entity_result_id is null or
7630: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7654: --and ear.business_group_id = p_business_group_id
7655: and not exists (
7656: select /* */ null
7657: from ben_copy_entity_results cpe
7658: -- pqh_table_route trt
7659: where copy_entity_txn_id = p_copy_entity_txn_id
7660: -- and trt.table_route_id = cpe.table_route_id
7661: and ( -- c_mirror_src_entity_result_id is null or
7662: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7686: --and ent.business_group_id = p_business_group_id
7687: and not exists (
7688: select /* */ null
7689: from ben_copy_entity_results cpe
7690: -- pqh_table_route trt
7691: where copy_entity_txn_id = p_copy_entity_txn_id
7692: -- and trt.table_route_id = cpe.table_route_id
7693: and ( -- c_mirror_src_entity_result_id is null or
7694: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7718: --and epm.business_group_id = p_business_group_id
7719: and not exists (
7720: select /* */ null
7721: from ben_copy_entity_results cpe
7722: -- pqh_table_route trt
7723: where copy_entity_txn_id = p_copy_entity_txn_id
7724: -- and trt.table_route_id = cpe.table_route_id
7725: and ( -- c_mirror_src_entity_result_id is null or
7726: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7750: --and noc.business_group_id = p_business_group_id
7751: and not exists (
7752: select /* */ null
7753: from ben_copy_entity_results cpe
7754: -- pqh_table_route trt
7755: where copy_entity_txn_id = p_copy_entity_txn_id
7756: -- and trt.table_route_id = cpe.table_route_id
7757: and ( -- c_mirror_src_entity_result_id is null or
7758: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7783: --and omr.business_group_id = p_business_group_id
7784: and not exists (
7785: select /* */ null
7786: from ben_copy_entity_results cpe
7787: -- pqh_table_route trt
7788: where copy_entity_txn_id = p_copy_entity_txn_id
7789: -- and trt.table_route_id = cpe.table_route_id
7790: and ( -- c_mirror_src_entity_result_id is null or
7791: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7815: --and dot.business_group_id = p_business_group_id
7816: and not exists (
7817: select /* */ null
7818: from ben_copy_entity_results cpe
7819: -- pqh_table_route trt
7820: where copy_entity_txn_id = p_copy_entity_txn_id
7821: -- and trt.table_route_id = cpe.table_route_id
7822: and ( -- c_mirror_src_entity_result_id is null or
7823: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7848: --and prr.business_group_id = p_business_group_id
7849: and not exists (
7850: select /* */ null
7851: from ben_copy_entity_results cpe
7852: -- pqh_table_route trt
7853: where copy_entity_txn_id = p_copy_entity_txn_id
7854: -- and trt.table_route_id = cpe.table_route_id
7855: and ( -- c_mirror_src_entity_result_id is null or
7856: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7881: --and qig.business_group_id = p_business_group_id
7882: and not exists (
7883: select /* */ null
7884: from ben_copy_entity_results cpe
7885: -- pqh_table_route trt
7886: where copy_entity_txn_id = p_copy_entity_txn_id
7887: -- and trt.table_route_id = cpe.table_route_id
7888: and ( -- c_mirror_src_entity_result_id is null or
7889: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7914: --and opr.business_group_id = p_business_group_id
7915: and not exists (
7916: select /* */ null
7917: from ben_copy_entity_results cpe
7918: -- pqh_table_route trt
7919: where copy_entity_txn_id = p_copy_entity_txn_id
7920: -- and trt.table_route_id = cpe.table_route_id
7921: and ( -- c_mirror_src_entity_result_id is null or
7922: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
7935: cursor c_object_exists(c_pk_id number,
7936: c_table_alias varchar2) is
7937: select null
7938: from ben_copy_entity_results cpe
7939: -- pqh_table_route trt
7940: where copy_entity_txn_id = p_copy_entity_txn_id
7941: -- and trt.table_route_id = cpe.table_route_id
7942: and cpe.table_alias = c_table_alias
7943: and information1 = c_pk_id;
15099: c_parent_table_name varchar2,
15100: c_copy_entity_txn_id number) is
15101: select copy_entity_result_id mirror_src_entity_result_id
15102: from ben_copy_entity_results cpe,
15103: pqh_table_route trt
15104: where cpe.information1= c_parent_pk_id
15105: and cpe.result_type_cd = 'DISPLAY'
15106: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
15107: and cpe.table_route_id = trt.table_route_id
15112: -- Cursor to get table_route_id
15113: --
15114: -- cursor c_table_route(c_parent_table_alias varchar2) is
15115: -- select table_route_id
15116: -- from pqh_table_route trt
15117: -- where trt.table_alias = c_parent_table_alias;
15118: -- trt.from_clause = 'OAB'
15119: -- and trt.where_clause = upper(c_parent_table_name) ;
15120: ---
15150: --and bpp.business_group_id = p_business_group_id
15151: and not exists (
15152: select /* */ null
15153: from ben_copy_entity_results cpe
15154: -- pqh_table_route trt
15155: where copy_entity_txn_id = p_copy_entity_txn_id
15156: -- and trt.table_route_id = cpe.table_route_id
15157: and ( -- c_mirror_src_entity_result_id is null or
15158: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
15182: --and abp.business_group_id = p_business_group_id
15183: and not exists (
15184: select /* */ null
15185: from ben_copy_entity_results cpe
15186: -- pqh_table_route trt
15187: where copy_entity_txn_id = p_copy_entity_txn_id
15188: -- and trt.table_route_id = cpe.table_route_id
15189: and ( -- c_mirror_src_entity_result_id is null or
15190: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
15214: --and bpr.business_group_id = p_business_group_id
15215: and not exists (
15216: select /* */ null
15217: from ben_copy_entity_results cpe
15218: -- pqh_table_route trt
15219: where copy_entity_txn_id = p_copy_entity_txn_id
15220: -- and trt.table_route_id = cpe.table_route_id
15221: and ( -- c_mirror_src_entity_result_id is null or
15222: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
15784: c_parent_table_name varchar2,
15785: c_copy_entity_txn_id number) is
15786: select copy_entity_result_id mirror_src_entity_result_id
15787: from ben_copy_entity_results cpe,
15788: pqh_table_route trt
15789: where cpe.information1= c_parent_pk_id
15790: and cpe.result_type_cd = 'DISPLAY'
15791: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
15792: and cpe.table_route_id = trt.table_route_id
15797: -- Cursor to get table_route_id
15798: --
15799: -- cursor c_table_route(c_parent_table_alias varchar2) is
15800: -- select table_route_id
15801: -- from pqh_table_route trt
15802: -- where trt.table_alias = c_parent_table_alias;
15803: -- trt.from_clause = 'OAB'
15804: -- and trt.where_clause = upper(c_parent_table_name) ;
15805: ---
15819: --and sva.business_group_id = p_business_group_id
15820: and not exists (
15821: select /* */ null
15822: from ben_copy_entity_results cpe
15823: -- pqh_table_route trt
15824: where copy_entity_txn_id = p_copy_entity_txn_id
15825: -- and trt.table_route_id = cpe.table_route_id
15826: and ( -- c_mirror_src_entity_result_id is null or
15827: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
15851: --and saz.business_group_id = p_business_group_id
15852: and not exists (
15853: select /* */ null
15854: from ben_copy_entity_results cpe
15855: -- pqh_table_route trt
15856: where copy_entity_txn_id = p_copy_entity_txn_id
15857: -- and trt.table_route_id = cpe.table_route_id
15858: and ( -- c_mirror_src_entity_result_id is null or
15859: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
15868: --
15869: cursor c_saz_pstl(c_svc_area_pstl_zip_rng_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2 ) is
15870: select distinct cpe.information245 pstl_zip_rng_id
15871: from ben_copy_entity_results cpe
15872: -- pqh_table_route trt
15873: where copy_entity_txn_id = p_copy_entity_txn_id
15874: -- and trt.table_route_id = cpe.table_route_id
15875: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
15876: -- and trt.where_clause = 'BEN_SVC_AREA_PSTL_ZIP_RNG_F'
15886: cursor c_object_exists(c_pk_id number,
15887: c_table_alias varchar2) is
15888: select null
15889: from ben_copy_entity_results cpe
15890: -- pqh_table_route trt
15891: where copy_entity_txn_id = p_copy_entity_txn_id
15892: -- and trt.table_route_id = cpe.table_route_id
15893: and cpe.table_alias = c_table_alias
15894: and information1 = c_pk_id;
16138: c_parent_table_name varchar2,
16139: c_copy_entity_txn_id number) is
16140: select copy_entity_result_id mirror_src_entity_result_id
16141: from ben_copy_entity_results cpe,
16142: pqh_table_route trt
16143: where cpe.information1= c_parent_pk_id
16144: and cpe.result_type_cd = 'DISPLAY'
16145: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
16146: and cpe.table_route_id = trt.table_route_id
16151: -- Cursor to get table_route_id
16152: --
16153: -- cursor c_table_route(c_parent_table_alias varchar2) is
16154: -- select table_route_id
16155: -- from pqh_table_route trt
16156: -- where trt.table_alias = c_parent_table_alias;
16157: -- trt.from_clause = 'OAB'
16158: -- and trt.where_clause = upper(c_parent_table_name) ;
16159: ---
16173: --and rzr.business_group_id = p_business_group_id
16174: and not exists (
16175: select /* */ null
16176: from ben_copy_entity_results cpe
16177: -- pqh_table_route trt
16178: where copy_entity_txn_id = p_copy_entity_txn_id
16179: -- and trt.table_route_id = cpe.table_route_id
16180: and ( -- c_mirror_src_entity_result_id is null or
16181: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
16193: cursor c_object_exists(c_pk_id number,
16194: c_table_alias varchar2) is
16195: select null
16196: from ben_copy_entity_results cpe
16197: -- pqh_table_route trt
16198: where copy_entity_txn_id = p_copy_entity_txn_id
16199: -- and trt.table_route_id = cpe.table_route_id
16200: and cpe.table_alias = c_table_alias
16201: and information1 = c_pk_id;
16331: c_parent_table_name varchar2,
16332: c_copy_entity_txn_id number) is
16333: select copy_entity_result_id mirror_src_entity_result_id
16334: from ben_copy_entity_results cpe,
16335: pqh_table_route trt
16336: where cpe.information1= c_parent_pk_id
16337: and cpe.result_type_cd = 'DISPLAY'
16338: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
16339: and cpe.table_route_id = trt.table_route_id
16344: -- Cursor to get table_route_id
16345: --
16346: -- cursor c_table_route(c_parent_table_alias varchar2) is
16347: -- select table_route_id
16348: -- from pqh_table_route trt
16349: -- where trt.table_alias = c_parent_table_alias;
16350: -- trt.from_clause = 'OAB'
16351: -- and trt.where_clause = upper(c_parent_table_name) ;
16352: ---
16366: --and bnb.business_group_id = p_business_group_id
16367: and not exists (
16368: select /* */ null
16369: from ben_copy_entity_results cpe
16370: -- pqh_table_route trt
16371: where copy_entity_txn_id = p_copy_entity_txn_id
16372: -- and trt.table_route_id = cpe.table_route_id
16373: and ( -- c_mirror_src_entity_result_id is null or
16374: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
16386: cursor c_object_exists(c_pk_id number,
16387: c_table_alias varchar2) is
16388: select null
16389: from ben_copy_entity_results cpe
16390: -- pqh_table_route trt
16391: where copy_entity_txn_id = p_copy_entity_txn_id
16392: -- and trt.table_route_id = cpe.table_route_id
16393: and cpe.table_alias = c_table_alias
16394: and information1 = c_pk_id;
16525: c_parent_table_name varchar2,
16526: c_copy_entity_txn_id number) is
16527: select copy_entity_result_id mirror_src_entity_result_id
16528: from ben_copy_entity_results cpe,
16529: pqh_table_route trt
16530: where cpe.information1= c_parent_pk_id
16531: and cpe.result_type_cd = 'DISPLAY'
16532: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
16533: and cpe.table_route_id = trt.table_route_id
16538: -- Cursor to get table_route_id
16539: --
16540: -- cursor c_table_route(c_parent_table_alias varchar2) is
16541: -- select table_route_id
16542: -- from pqh_table_route trt
16543: -- where trt.table_alias = c_parent_table_alias;
16544: -- trt.from_clause = 'OAB'
16545: -- and trt.where_clause = upper(c_parent_table_name) ;
16546: ---
16560: --and bng.business_group_id = p_business_group_id
16561: and not exists (
16562: select /* */ null
16563: from ben_copy_entity_results cpe
16564: -- pqh_table_route trt
16565: where copy_entity_txn_id = p_copy_entity_txn_id
16566: -- and trt.table_route_id = cpe.table_route_id
16567: and ( -- c_mirror_src_entity_result_id is null or
16568: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
16579: cursor c_object_exists(c_pk_id number,
16580: c_table_alias varchar2) is
16581: select null
16582: from ben_copy_entity_results cpe
16583: -- pqh_table_route trt
16584: where copy_entity_txn_id = p_copy_entity_txn_id
16585: -- and trt.table_route_id = cpe.table_route_id
16586: and cpe.table_alias = c_table_alias
16587: and information1 = c_pk_id;
16707: c_parent_table_name varchar2,
16708: c_copy_entity_txn_id number) is
16709: select copy_entity_result_id mirror_src_entity_result_id
16710: from ben_copy_entity_results cpe,
16711: pqh_table_route trt
16712: where cpe.information1= c_parent_pk_id
16713: and cpe.result_type_cd = 'DISPLAY'
16714: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
16715: and cpe.table_route_id = trt.table_route_id
16720: -- Cursor to get table_route_id
16721: --
16722: -- cursor c_table_route(c_parent_table_alias varchar2) is
16723: -- select table_route_id
16724: -- from pqh_table_route trt
16725: -- where trt.table_alias = c_parent_table_alias;
16726: -- trt.from_clause = 'OAB'
16727: -- and trt.where_clause = upper(c_parent_table_name) ;
16728: ---
16748: --and apc.business_group_id = p_business_group_id
16749: and not exists (
16750: select /* */ null
16751: from ben_copy_entity_results cpe
16752: -- pqh_table_route trt
16753: where copy_entity_txn_id = p_copy_entity_txn_id
16754: -- and trt.table_route_id = cpe.table_route_id
16755: and ( -- c_mirror_src_entity_result_id is null or
16756: mirror_src_entity_result_id = c_mirror_src_entity_result_id )