[Home] [Help]
83: -- and pln.business_group_id = p_business_group_id
84: and not exists (
85: select /*+ */ null
86: from ben_copy_entity_results cpe
87: -- ,pqh_table_route trt
88: where copy_entity_txn_id = p_copy_entity_txn_id
89: -- and trt.table_route_id = cpe.table_route_id
90: and ( c_mirror_src_entity_result_id is null or
91: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
105: c_parent_table_alias varchar2,
106: c_copy_entity_txn_id number) is
107: select copy_entity_result_id mirror_src_entity_result_id
108: from ben_copy_entity_results cpe
109: -- ,pqh_table_route trt
110: where cpe.information1= c_parent_pk_id
111: and cpe.result_type_cd = l_cv_result_type_cd
112: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
113: -- and cpe.table_route_id = trt.table_route_id
120: c_parent_table_alias varchar2,
121: c_copy_entity_txn_id number) is
122: select min(copy_entity_result_id) mirror_src_entity_result_id
123: from ben_copy_entity_results cpe
124: -- ,pqh_table_route trt
125: where cpe.information1= c_parent_pk_id
126: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
127: -- and cpe.table_route_id = trt.table_route_id
128: and cpe.table_alias = c_parent_table_alias ;
132: --
133: -- Cursor to get table_route_id
134: -- cursor c_table_route(c_parent_table_alias varchar2)is
135: -- select table_route_id
136: -- from pqh_table_route trt
137: -- where trt.table_alias = c_parent_table_alias;
138: -- trt.from_clause = 'OAB'
139: -- and trt.where_clause = upper(c_parent_table_name) ;
140: ---
146: c_parent_table_alias varchar2,
147: c_copy_entity_txn_id number) is
148: select min(cpe.information2) min_esd
149: from ben_copy_entity_results cpe
150: -- ,pqh_table_route trt
151: where cpe.information1= c_parent_pk_id
152: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
153: -- and cpe.table_route_id = trt.table_route_id
154: -- and trt.from_clause = 'OAB'
200: -- and vgs.business_group_id = p_business_group_id
201: and not exists (
202: select /*+ */ null
203: from ben_copy_entity_results cpe
204: -- ,pqh_table_route trt
205: where copy_entity_txn_id = p_copy_entity_txn_id
206: -- and trt.table_route_id = cpe.table_route_id
207: and ( -- c_mirror_src_entity_result_id is null or
208: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
232: and cwg.business_group_id = p_business_group_id
233: and not exists (
234: select /*+ */ null
235: from ben_copy_entity_results cpe
236: -- ,pqh_table_route trt
237: where copy_entity_txn_id = p_copy_entity_txn_id
238: -- and trt.table_route_id = cpe.table_route_id
239: and ( --c_mirror_src_entity_result_id is null or
240: c_mirror_src_entity_result_id = c_mirror_src_entity_result_id )
283: -- and vrp.business_group_id = p_business_group_id
284: and not exists (
285: select /*+ */ null
286: from ben_copy_entity_results cpe
287: -- ,pqh_table_route trt
288: where copy_entity_txn_id = p_copy_entity_txn_id
289: -- and trt.table_route_id = cpe.table_route_id
290: and ( -- c_mirror_src_entity_result_id is null or
291: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
316: -- and wpn.business_group_id = p_business_group_id
317: and not exists (
318: select /*+ */ null
319: from ben_copy_entity_results cpe
320: -- ,pqh_table_route trt
321: where copy_entity_txn_id = p_copy_entity_txn_id
322: -- and trt.table_route_id = cpe.table_route_id
323: and ( -- c_mirror_src_entity_result_id is null or
324: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
350: -- and brc.business_group_id = p_business_group_id
351: and not exists (
352: select /*+ */ null
353: from ben_copy_entity_results cpe
354: -- ,pqh_table_route trt
355: where copy_entity_txn_id = p_copy_entity_txn_id
356: -- and trt.table_route_id = cpe.table_route_id
357: and ( -- c_mirror_src_entity_result_id is null or
358: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
384: -- and lbr.business_group_id = p_business_group_id
385: and not exists (
386: select /*+ */ null
387: from ben_copy_entity_results cpe
388: -- ,pqh_table_route trt
389: where copy_entity_txn_id = p_copy_entity_txn_id
390: -- and trt.table_route_id = cpe.table_route_id
391: and ( -- c_mirror_src_entity_result_id is null or
392: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
399: );
400: cursor c_lbr_drp(c_ler_bnft_rstrn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
401: select distinct cpe.information257 ler_id
402: from ben_copy_entity_results cpe
403: -- ,pqh_table_route trt
404: where copy_entity_txn_id = p_copy_entity_txn_id
405: -- and trt.table_route_id = cpe.table_route_id
406: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
407: -- and trt.where_clause = 'BEN_LER_BNFT_RSTRN_F'
430: -- and ecf.business_group_id = p_business_group_id
431: and not exists (
432: select /*+ */ null
433: from ben_copy_entity_results cpe
434: -- ,pqh_table_route trt
435: where copy_entity_txn_id = p_copy_entity_txn_id
436: -- and trt.table_route_id = cpe.table_route_id
437: and ( -- c_mirror_src_entity_result_id is null or
438: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
463: -- and ldc.business_group_id = p_business_group_id
464: and not exists (
465: select /*+ */ null
466: from ben_copy_entity_results cpe
467: -- ,pqh_table_route trt
468: where copy_entity_txn_id = p_copy_entity_txn_id
469: -- and trt.table_route_id = cpe.table_route_id
470: and ( -- c_mirror_src_entity_result_id is null or
471: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
478: );
479: cursor c_ldc_drp(c_ler_chg_dpnt_cvg_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
480: select distinct cpe.information257 ler_id
481: from ben_copy_entity_results cpe
482: -- ,pqh_table_route trt
483: where copy_entity_txn_id = p_copy_entity_txn_id
484: -- and trt.table_route_id = cpe.table_route_id
485: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
486: -- and trt.where_clause = 'BEN_LER_CHG_DPNT_CVG_F'
509: -- and lpe.business_group_id = p_business_group_id
510: and not exists (
511: select /*+ */ null
512: from ben_copy_entity_results cpe
513: -- ,pqh_table_route trt
514: where copy_entity_txn_id = p_copy_entity_txn_id
515: -- and trt.table_route_id = cpe.table_route_id
516: and ( -- c_mirror_src_entity_result_id is null or
517: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
524: );
525: cursor c_lpe_drp(c_ler_chg_pl_nip_enrt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
526: select distinct cpe.information257 ler_id
527: from ben_copy_entity_results cpe
528: -- ,pqh_table_route trt
529: where copy_entity_txn_id = p_copy_entity_txn_id
530: -- and trt.table_route_id = cpe.table_route_id
531: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
532: -- and trt.where_clause = 'BEN_LER_CHG_PL_NIP_ENRT_F'
555: -- and lre.business_group_id = p_business_group_id
556: and not exists (
557: select /*+ */ null
558: from ben_copy_entity_results cpe
559: -- ,pqh_table_route trt
560: where copy_entity_txn_id = p_copy_entity_txn_id
561: -- and trt.table_route_id = cpe.table_route_id
562: and ( -- c_mirror_src_entity_result_id is null or
563: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
570: );
571: cursor c_lre_drp(c_ler_rqrs_enrt_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
572: select distinct cpe.information257 ler_id
573: from ben_copy_entity_results cpe
574: -- ,pqh_table_route trt
575: where copy_entity_txn_id = p_copy_entity_txn_id
576: -- and trt.table_route_id = cpe.table_route_id
577: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
578: -- and trt.where_clause = 'BEN_LER_RQRS_ENRT_CTFN_F'
601: -- and pcp.business_group_id = p_business_group_id
602: and not exists (
603: select /*+ */ null
604: from ben_copy_entity_results cpe
605: -- ,pqh_table_route trt
606: where copy_entity_txn_id = p_copy_entity_txn_id
607: -- and trt.table_route_id = cpe.table_route_id
608: and ( -- c_mirror_src_entity_result_id is null or
609: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
633: -- and pty.business_group_id = p_business_group_id
634: and not exists (
635: select /*+ */ null
636: from ben_copy_entity_results cpe
637: -- pqh_table_route trt
638: where copy_entity_txn_id = p_copy_entity_txn_id
639: -- and trt.table_route_id = cpe.table_route_id
640: and ( -- c_mirror_src_entity_result_id is null or
641: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
665: -- and pcx.business_group_id = p_business_group_id
666: and not exists (
667: select /*+ */ null
668: from ben_copy_entity_results cpe
669: -- ,pqh_table_route trt
670: where copy_entity_txn_id = p_copy_entity_txn_id
671: -- and trt.table_route_id = cpe.table_route_id
672: and ( -- c_mirror_src_entity_result_id is null or
673: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
698: -- and pnd.business_group_id = p_business_group_id
699: and not exists (
700: select /*+ */ null
701: from ben_copy_entity_results cpe
702: -- ,pqh_table_route trt
703: where copy_entity_txn_id = p_copy_entity_txn_id
704: -- and trt.table_route_id = cpe.table_route_id
705: and ( -- c_mirror_src_entity_result_id is null or
706: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
731: -- and peo.business_group_id = p_business_group_id
732: and not exists (
733: select /*+ */ null
734: from ben_copy_entity_results cpe
735: -- ,pqh_table_route trt
736: where copy_entity_txn_id = p_copy_entity_txn_id
737: -- and trt.table_route_id = cpe.table_route_id
738: and ( -- c_mirror_src_entity_result_id is null or
739: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
765: -- and gos.business_group_id = p_business_group_id
766: and not exists (
767: select /*+ */ null
768: from ben_copy_entity_results cpe
769: -- ,pqh_table_route trt
770: where copy_entity_txn_id = p_copy_entity_txn_id
771: -- and trt.table_route_id = cpe.table_route_id
772: and ( -- c_mirror_src_entity_result_id is null or
773: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
796: -- and pct.business_group_id = p_business_group_id
797: and not exists (
798: select /*+ */ null
799: from ben_copy_entity_results cpe
800: -- pqh_table_route trt
801: where copy_entity_txn_id = p_copy_entity_txn_id
802: -- and trt.table_route_id = cpe.table_route_id
803: and ( -- c_mirror_src_entity_result_id is null or
804: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
830: -- and prg.business_group_id = p_business_group_id
831: and not exists (
832: select /*+ */ null
833: from ben_copy_entity_results cpe
834: -- ,pqh_table_route trt
835: where copy_entity_txn_id = p_copy_entity_txn_id
836: -- and trt.table_route_id = cpe.table_route_id
837: and ( -- c_mirror_src_entity_result_id is null or
838: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
863: -- and reg.business_group_id = p_business_group_id
864: and not exists (
865: select /*+ */ null
866: from ben_copy_entity_results cpe
867: -- ,pqh_table_route trt
868: where copy_entity_txn_id = p_copy_entity_txn_id
869: -- and trt.table_route_id = cpe.table_route_id
870: and ( -- c_mirror_src_entity_result_id is null or
871: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
897: -- and bnr.business_group_id = p_business_group_id
898: and not exists (
899: select /*+ */ null
900: from ben_copy_entity_results cpe
901: -- ,pqh_table_route trt
902: where copy_entity_txn_id = p_copy_entity_txn_id
903: -- and trt.table_route_id = cpe.table_route_id
904: and ( -- c_mirror_src_entity_result_id is null or
905: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
927: -- and wcn.business_group_id = p_business_group_id
928: and not exists (
929: select /*+ */ null
930: from ben_copy_entity_results cpe
931: -- ,pqh_table_route trt
932: where copy_entity_txn_id = p_copy_entity_txn_id
933: -- and trt.table_route_id = cpe.table_route_id
934: and ( -- c_mirror_src_entity_result_id is null or
935: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
960: -- and lbc.business_group_id = p_business_group_id
961: and not exists (
962: select /*+ */ null
963: from ben_copy_entity_results cpe
964: -- ,pqh_table_route trt
965: where copy_entity_txn_id = p_copy_entity_txn_id
966: -- and trt.table_route_id = cpe.table_route_id
967: and ( -- c_mirror_src_entity_result_id is null or
968: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
994: -- and lnc.business_group_id = p_business_group_id
995: and not exists (
996: select /*+ */ null
997: from ben_copy_entity_results cpe
998: -- ,pqh_table_route trt
999: where copy_entity_txn_id = p_copy_entity_txn_id
1000: -- and trt.table_route_id = cpe.table_route_id
1001: and ( -- c_mirror_src_entity_result_id is null or
1002: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1027: -- and lcc.business_group_id = p_business_group_id
1028: and not exists (
1029: select /*+ */ null
1030: from ben_copy_entity_results cpe
1031: -- ,pqh_table_route trt
1032: where copy_entity_txn_id = p_copy_entity_txn_id
1033: -- and trt.table_route_id = cpe.table_route_id
1034: and ( -- c_mirror_src_entity_result_id is null or
1035: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1061: -- and ddr.business_group_id = p_business_group_id
1062: and not exists (
1063: select /*+ */ null
1064: from ben_copy_entity_results cpe
1065: -- pqh_table_route trt
1066: where copy_entity_txn_id = p_copy_entity_txn_id
1067: -- and trt.table_route_id = cpe.table_route_id
1068: and ( -- c_mirror_src_entity_result_id is null or
1069: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1095: -- and drr.business_group_id = p_business_group_id
1096: and not exists (
1097: select /*+ */ null
1098: from ben_copy_entity_results cpe
1099: -- pqh_table_route trt
1100: where copy_entity_txn_id = p_copy_entity_txn_id
1101: -- and trt.table_route_id = cpe.table_route_id
1102: and ( -- c_mirror_src_entity_result_id is null or
1103: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1134: -- and prg.business_group_id = p_business_group_id
1135: and not exists (
1136: select /*+ */ null
1137: from ben_copy_entity_results cpe
1138: -- pqh_table_route trt
1139: where copy_entity_txn_id = p_copy_entity_txn_id
1140: -- and trt.table_route_id = cpe.table_route_id
1141: and ( -- c_mirror_src_entity_result_id is null or
1142: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1168: -- and prb.business_group_id = p_business_group_id
1169: and not exists (
1170: select /*+ */ null
1171: from ben_copy_entity_results cpe
1172: -- pqh_table_route trt
1173: where copy_entity_txn_id = p_copy_entity_txn_id
1174: -- and trt.table_route_id = cpe.table_route_id
1175: and ( -- c_mirror_src_entity_result_id is null or
1176: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1202: -- and prp.business_group_id = p_business_group_id
1203: and not exists (
1204: select /*+ */ null
1205: from ben_copy_entity_results cpe
1206: -- pqh_table_route trt
1207: where copy_entity_txn_id = p_copy_entity_txn_id
1208: -- and trt.table_route_id = cpe.table_route_id
1209: and ( -- c_mirror_src_entity_result_id is null or
1210: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1236: -- and rgr.business_group_id = p_business_group_id
1237: and not exists (
1238: select /*+ */ null
1239: from ben_copy_entity_results cpe
1240: -- pqh_table_route trt
1241: where copy_entity_txn_id = p_copy_entity_txn_id
1242: -- and trt.table_route_id = cpe.table_route_id
1243: and ( -- c_mirror_src_entity_result_id is null or
1244: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1269: -- and reg.business_group_id = p_business_group_id
1270: and not exists (
1271: select /*+ */ null
1272: from ben_copy_entity_results cpe
1273: --- pqh_table_route trt
1274: where copy_entity_txn_id = p_copy_entity_txn_id
1275: -- and trt.table_route_id = cpe.table_route_id
1276: and ( -- c_mirror_src_entity_result_id is null or
1277: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1290: cursor c_object_exists(c_pk_id number,
1291: c_table_alias varchar2) is
1292: select null
1293: from ben_copy_entity_results cpe
1294: -- pqh_table_route trt
1295: where copy_entity_txn_id = p_copy_entity_txn_id
1296: -- and trt.table_route_id = cpe.table_route_id
1297: and cpe.table_alias = c_table_alias
1298: and information1 = c_pk_id;
5898: c_parent_table_alias varchar2,
5899: c_copy_entity_txn_id number) is
5900: select copy_entity_result_id mirror_src_entity_result_id
5901: from ben_copy_entity_results cpe
5902: -- pqh_table_route trt
5903: where cpe.information1= c_parent_pk_id
5904: and cpe.result_type_cd = l_cv_result_type_cd
5905: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
5906: -- and cpe.table_route_id = trt.table_route_id
5914: --
5915: -- Cursor to get table_route_id
5916: -- cursor c_table_route(c_parent_table_alias varchar2) is
5917: -- select table_route_id
5918: -- from pqh_table_route trt
5919: -- where trt.table_alias = c_parent_table_alias;
5920: -- trt.from_clause = 'OAB'
5921: -- and trt.where_clause = upper(c_parent_table_name) ;
5922: ---
5939: -- and pat.business_group_id = p_business_group_id
5940: and not exists (
5941: select /*+ */ null
5942: from ben_copy_entity_results cpe
5943: -- pqh_table_route trt
5944: where copy_entity_txn_id = p_copy_entity_txn_id
5945: -- and trt.table_route_id = cpe.table_route_id
5946: and ( -- c_mirror_src_entity_result_id is null or
5947: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5972: -- and pet.business_group_id = p_business_group_id
5973: and not exists (
5974: select /*+ */ null
5975: from ben_copy_entity_results cpe
5976: -- pqh_table_route trt
5977: where copy_entity_txn_id = p_copy_entity_txn_id
5978: -- and trt.table_route_id = cpe.table_route_id
5979: and ( -- c_mirror_src_entity_result_id is null or
5980: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6008: -- and cpo.business_group_id = p_business_group_id
6009: and not exists (
6010: select /*+ */ null
6011: from ben_copy_entity_results cpe
6012: -- pqh_table_route trt
6013: where copy_entity_txn_id = p_copy_entity_txn_id
6014: -- and trt.table_route_id = cpe.table_route_id
6015: and ( -- c_mirror_src_entity_result_id is null or
6016: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6061: -- and cpy.business_group_id = p_business_group_id
6062: and not exists (
6063: select /*+ */ null
6064: from ben_copy_entity_results cpe
6065: -- pqh_table_route trt
6066: where copy_entity_txn_id = p_copy_entity_txn_id
6067: -- and trt.table_route_id = cpe.table_route_id
6068: and ( -- c_mirror_src_entity_result_id is null or
6069: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6094: -- and rgr.business_group_id = p_business_group_id
6095: and not exists (
6096: select /*+ */ null
6097: from ben_copy_entity_results cpe
6098: --pqh_table_route trt
6099: where copy_entity_txn_id = p_copy_entity_txn_id
6100: -- and trt.table_route_id = cpe.table_route_id
6101: and ( -- c_mirror_src_entity_result_id is null or
6102: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6139: -- and cpr.business_group_id = p_business_group_id
6140: and not exists (
6141: select /*+ */ null
6142: from ben_copy_entity_results cpe
6143: -- pqh_table_route trt
6144: where copy_entity_txn_id = p_copy_entity_txn_id
6145: -- and trt.table_route_id = cpe.table_route_id
6146: and ( -- c_mirror_src_entity_result_id is null or
6147: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6172: -- and bnr.business_group_id = p_business_group_id
6173: and not exists (
6174: select /*+ */ null
6175: from ben_copy_entity_results cpe
6176: -- pqh_table_route trt
6177: where copy_entity_txn_id = p_copy_entity_txn_id
6178: -- and trt.table_route_id = cpe.table_route_id
6179: and ( -- c_mirror_src_entity_result_id is null or
6180: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6203: -- and len.business_group_id = p_business_group_id
6204: and not exists (
6205: select /*+ */ null
6206: from ben_copy_entity_results cpe
6207: -- pqh_table_route trt
6208: where copy_entity_txn_id = p_copy_entity_txn_id
6209: -- and trt.table_route_id = cpe.table_route_id
6210: and ( -- c_mirror_src_entity_result_id is null or
6211: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6219: cursor c_len_drp(c_lee_rsn_id number,c_mirror_src_entity_result_id number,
6220: c_table_alias varchar2) is
6221: select distinct cpe.information257 ler_id
6222: from ben_copy_entity_results cpe,
6223: pqh_table_route trt
6224: where copy_entity_txn_id = p_copy_entity_txn_id
6225: and trt.table_route_id = cpe.table_route_id
6226: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
6227: -- and trt.where_clause = 'BEN_LEE_RSN_F'
6249: -- and enp.business_group_id = p_business_group_id
6250: and not exists (
6251: select /*+ */ null
6252: from ben_copy_entity_results cpe
6253: -- pqh_table_route trt
6254: where copy_entity_txn_id = p_copy_entity_txn_id
6255: -- and trt.table_route_id = cpe.table_route_id
6256: and ( -- c_mirror_src_entity_result_id is null or
6257: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6322: -- and erp.business_group_id = p_business_group_id
6323: and not exists (
6324: select /*+ */ null
6325: from ben_copy_entity_results cpe
6326: -- pqh_table_route trt
6327: where copy_entity_txn_id = p_copy_entity_txn_id
6328: -- and trt.table_route_id = cpe.table_route_id
6329: and ( -- c_mirror_src_entity_result_id is null or
6330: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6355: -- and ser.business_group_id = p_business_group_id
6356: and not exists (
6357: select /*+ */ null
6358: from ben_copy_entity_results cpe
6359: -- pqh_table_route trt
6360: where copy_entity_txn_id = p_copy_entity_txn_id
6361: -- and trt.table_route_id = cpe.table_route_id
6362: and ( -- c_mirror_src_entity_result_id is null or
6363: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6388: -- and lrr.business_group_id = p_business_group_id
6389: and not exists (
6390: select /*+ */ null
6391: from ben_copy_entity_results cpe
6392: -- pqh_table_route trt
6393: where copy_entity_txn_id = p_copy_entity_txn_id
6394: -- and trt.table_route_id = cpe.table_route_id
6395: and ( -- c_mirror_src_entity_result_id is null or
6396: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6426: -- and erp.business_group_id = p_business_group_id
6427: and not exists (
6428: select /*+ */ null
6429: from ben_copy_entity_results cpe
6430: -- pqh_table_route trt
6431: where copy_entity_txn_id = p_copy_entity_txn_id
6432: -- and trt.table_route_id = cpe.table_route_id
6433: and ( -- c_mirror_src_entity_result_id is null or
6434: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6460: -- and eat.business_group_id = p_business_group_id
6461: and not exists (
6462: select /*+ */ null
6463: from ben_copy_entity_results cpe
6464: -- pqh_table_route trt
6465: where copy_entity_txn_id = p_copy_entity_txn_id
6466: -- and trt.table_route_id = cpe.table_route_id
6467: and ( -- c_mirror_src_entity_result_id is null or
6468: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6491: -- and prg.business_group_id = p_business_group_id
6492: and not exists (
6493: select /*+ */ null
6494: from ben_copy_entity_results cpe
6495: -- pqh_table_route trt
6496: where copy_entity_txn_id = p_copy_entity_txn_id
6497: -- and trt.table_route_id = cpe.table_route_id
6498: and ( -- c_mirror_src_entity_result_id is null or
6499: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6525: -- and prb.business_group_id = p_business_group_id
6526: and not exists (
6527: select /*+ */ null
6528: from ben_copy_entity_results cpe
6529: -- pqh_table_route trt
6530: where copy_entity_txn_id = p_copy_entity_txn_id
6531: -- and trt.table_route_id = cpe.table_route_id
6532: and ( -- c_mirror_src_entity_result_id is null or
6533: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6559: -- and prp.business_group_id = p_business_group_id
6560: and not exists (
6561: select /*+ */ null
6562: from ben_copy_entity_results cpe
6563: -- pqh_table_route trt
6564: where copy_entity_txn_id = p_copy_entity_txn_id
6565: -- and trt.table_route_id = cpe.table_route_id
6566: and ( -- c_mirror_src_entity_result_id is null or
6567: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6593: -- and rgr.business_group_id = p_business_group_id
6594: and not exists (
6595: select /*+ */ null
6596: from ben_copy_entity_results cpe
6597: -- pqh_table_route trt
6598: where copy_entity_txn_id = p_copy_entity_txn_id
6599: -- and trt.table_route_id = cpe.table_route_id
6600: and ( -- c_mirror_src_entity_result_id is null or
6601: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6625: -- and reg.business_group_id = p_business_group_id
6626: and not exists (
6627: select /*+ */ null
6628: from ben_copy_entity_results cpe
6629: -- pqh_table_route trt
6630: where copy_entity_txn_id = p_copy_entity_txn_id
6631: -- and trt.table_route_id = cpe.table_route_id
6632: and ( -- c_mirror_src_entity_result_id is null or
6633: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6647: cursor c_object_exists(c_pk_id number,
6648: c_table_alias varchar2) is
6649: select null
6650: from ben_copy_entity_results cpe
6651: -- pqh_table_route trt
6652: where copy_entity_txn_id = p_copy_entity_txn_id
6653: -- and trt.table_route_id = cpe.table_route_id
6654: and cpe.table_alias = c_table_alias
6655: and information1 = c_pk_id;
9021: --
9022: -- Cursor to get table_route_id
9023: -- cursor c_table_route(c_parent_table_alias varchar2) is
9024: -- select table_route_id
9025: -- from pqh_table_route trt
9026: -- where trt.table_alias = c_parent_table_alias;
9027: -- trt.from_clause = 'OAB'
9028: -- and trt.where_clause = upper(c_parent_table_name) ;
9029: --
9035: c_parent_table_alias varchar2,
9036: c_copy_entity_txn_id number) is
9037: select copy_entity_result_id mirror_src_entity_result_id
9038: from ben_copy_entity_results cpe
9039: -- pqh_table_route trt
9040: where cpe.information1= c_parent_pk_id
9041: and cpe.result_type_cd = l_cv_result_type_cd
9042: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
9043: -- and cpe.table_route_id = trt.table_route_id
9056: -- and ler.business_group_id = p_business_group_id
9057: and not exists (
9058: select /*+ */ null
9059: from ben_copy_entity_results cpe
9060: -- pqh_table_route trt
9061: where copy_entity_txn_id = p_copy_entity_txn_id
9062: -- and trt.table_route_id = cpe.table_route_id
9063: and ( -- c_mirror_src_entity_result_id is null or
9064: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
9087: -- and csr.business_group_id = p_business_group_id
9088: and not exists (
9089: select /*+ */ null
9090: from ben_copy_entity_results cpe
9091: -- pqh_table_route trt
9092: where copy_entity_txn_id = p_copy_entity_txn_id
9093: -- and trt.table_route_id = cpe.table_route_id
9094: and ( -- c_mirror_src_entity_result_id is null or
9095: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
9124: -- and lpl.business_group_id = p_business_group_id
9125: and not exists (
9126: select /*+ */ null
9127: from ben_copy_entity_results cpe
9128: -- pqh_table_route trt
9129: where copy_entity_txn_id = p_copy_entity_txn_id
9130: -- and trt.table_route_id = cpe.table_route_id
9131: and ( -- c_mirror_src_entity_result_id is null or
9132: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
9156: -- and lrc.business_group_id = p_business_group_id
9157: and not exists (
9158: select /*+ */ null
9159: from ben_copy_entity_results cpe
9160: -- pqh_table_route trt
9161: where copy_entity_txn_id = p_copy_entity_txn_id
9162: -- and trt.table_route_id = cpe.table_route_id
9163: and ( -- c_mirror_src_entity_result_id is null or
9164: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
9191: -- and psl.business_group_id = p_business_group_id
9192: and not exists (
9193: select /*+ */ null
9194: from ben_copy_entity_results cpe
9195: -- pqh_table_route trt
9196: where copy_entity_txn_id = p_copy_entity_txn_id
9197: -- and trt.table_route_id = cpe.table_route_id
9198: and ( -- c_mirror_src_entity_result_id is null or
9199: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
9244: -- and rcl.business_group_id = p_business_group_id
9245: and not exists (
9246: select /*+ */ null
9247: from ben_copy_entity_results cpe
9248: -- pqh_table_route trt
9249: where copy_entity_txn_id = p_copy_entity_txn_id
9250: -- and trt.table_route_id = cpe.table_route_id
9251: and ( -- c_mirror_src_entity_result_id is null or
9252: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
9265: cursor c_object_exists(c_pk_id number,
9266: c_table_alias varchar2) is
9267: select null
9268: from ben_copy_entity_results cpe
9269: -- pqh_table_route trt
9270: where copy_entity_txn_id = p_copy_entity_txn_id
9271: -- and trt.table_route_id = cpe.table_route_id
9272: and cpe.table_alias = c_table_alias
9273: and information1 = c_pk_id;
10073: c_parent_table_alias varchar2,
10074: c_copy_entity_txn_id number) is
10075: select copy_entity_result_id mirror_src_entity_result_id
10076: from ben_copy_entity_results cpe
10077: -- pqh_table_route trt
10078: where cpe.information1 = c_parent_pk_id
10079: and cpe.result_type_cd = l_result_type_cd
10080: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
10081: -- and cpe.table_route_id = trt.table_route_id
10086: -- Bug : 3752407 : Global cursor g_table_route will now be used
10087: --
10088: -- cursor c_table_route(c_parent_table_alias varchar2) is
10089: -- select table_route_id
10090: -- from pqh_table_route trt
10091: -- where trt.table_alias = c_parent_table_alias;
10092: --
10093: ---------------------------------------------------------------
10094: -- START OF BEN_OIPL_F ----------------------
10101: -- and cop.business_group_id = p_business_group_id
10102: and not exists (
10103: select /*+ */ null
10104: from ben_copy_entity_results cpe
10105: -- pqh_table_route trt
10106: where copy_entity_txn_id = p_copy_entity_txn_id
10107: -- and trt.table_route_id = cpe.table_route_id
10108: and ( -- c_mirror_src_entity_result_id is null or
10109: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10135: -- and ddr.business_group_id = p_business_group_id
10136: and not exists (
10137: select /*+ */ null
10138: from ben_copy_entity_results cpe
10139: -- pqh_table_route trt
10140: where copy_entity_txn_id = p_copy_entity_txn_id
10141: -- and trt.table_route_id = cpe.table_route_id
10142: and ( -- c_mirror_src_entity_result_id is null or
10143: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10169: -- and drr.business_group_id = p_business_group_id
10170: and not exists (
10171: select /*+ */ null
10172: from ben_copy_entity_results cpe
10173: -- pqh_table_route trt
10174: where copy_entity_txn_id = p_copy_entity_txn_id
10175: -- and trt.table_route_id = cpe.table_route_id
10176: and ( -- c_mirror_src_entity_result_id is null or
10177: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10200: -- and peo.business_group_id = p_business_group_id
10201: and not exists (
10202: select /*+ */ null
10203: from ben_copy_entity_results cpe
10204: -- pqh_table_route trt
10205: where copy_entity_txn_id = p_copy_entity_txn_id
10206: -- and trt.table_route_id = cpe.table_route_id
10207: and ( -- c_mirror_src_entity_result_id is null or
10208: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10232: -- and lop.business_group_id = p_business_group_id
10233: and not exists (
10234: select /*+ */ null
10235: from ben_copy_entity_results cpe
10236: -- pqh_table_route trt
10237: where copy_entity_txn_id = p_copy_entity_txn_id
10238: -- and trt.table_route_id = cpe.table_route_id
10239: and ( -- c_mirror_src_entity_result_id is null or
10240: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10249: l_out_lop_result_id number(15);
10250: cursor c_lop_drp(c_ler_chg_oipl_enrt_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
10251: select distinct cpe.information257 ler_id
10252: from ben_copy_entity_results cpe
10253: -- pqh_table_route trt
10254: where copy_entity_txn_id = p_copy_entity_txn_id
10255: -- and trt.table_route_id = cpe.table_route_id
10256: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
10257: -- and trt.where_clause = 'BEN_LER_CHG_OIPL_ENRT_F'
10278: -- and ecf.business_group_id = p_business_group_id
10279: and not exists (
10280: select /*+ */ null
10281: from ben_copy_entity_results cpe
10282: -- pqh_table_route trt
10283: where copy_entity_txn_id = p_copy_entity_txn_id
10284: -- and trt.table_route_id = cpe.table_route_id
10285: and ( -- c_mirror_src_entity_result_id is null or
10286: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10310: -- and lre.business_group_id = p_business_group_id
10311: and not exists (
10312: select /*+ */ null
10313: from ben_copy_entity_results cpe
10314: -- pqh_table_route trt
10315: where copy_entity_txn_id = p_copy_entity_txn_id
10316: -- and trt.table_route_id = cpe.table_route_id
10317: and ( -- c_mirror_src_entity_result_id is null or
10318: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
10326: l_out_lre_result_id number(15);
10327: cursor c_lre1_drp(c_ler_rqrs_enrt_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
10328: select distinct cpe.information257 ler_id
10329: from ben_copy_entity_results cpe
10330: -- pqh_table_route trt
10331: where copy_entity_txn_id = p_copy_entity_txn_id
10332: -- and trt.table_route_id = cpe.table_route_id
10333: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
10334: -- and trt.where_clause = 'BEN_LER_RQRS_ENRT_CTFN_F'
10354: -- and lnc.business_group_id = p_business_group_id
10355: and not exists (
10356: select /*+ */ null
10357: from ben_copy_entity_results cpe
10358: -- pqh_table_route trt
10359: where copy_entity_txn_id = p_copy_entity_txn_id
10360: -- and trt.table_route_id = cpe.table_route_id
10361: and ( -- c_mirror_src_entity_result_id is null or
10362: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
11559: c_parent_table_alias varchar2,
11560: c_copy_entity_txn_id number) is
11561: select copy_entity_result_id mirror_src_entity_result_id
11562: from ben_copy_entity_results cpe
11563: -- pqh_table_route trt
11564: where cpe.information1 = c_parent_pk_id
11565: and cpe.result_type_cd = l_result_type_cd
11566: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
11567: -- and cpe.table_route_id = trt.table_route_id
11572: -- Cursor to get table_route_id
11573: --
11574: -- cursor c_table_route(c_parent_table_alias varchar2) is
11575: -- select table_route_id
11576: -- from pqh_table_route trt
11577: -- where trt.table_alias = c_parent_table_alias;
11578: --
11579: ---------------------------------------------------------------
11580: -- START OF BEN_OPT_F ----------------------
11587: -- and opt.business_group_id = p_business_group_id
11588: and not exists (
11589: select /*+ */ null
11590: from ben_copy_entity_results cpe
11591: -- pqh_table_route trt
11592: where copy_entity_txn_id = p_copy_entity_txn_id
11593: -- and trt.table_route_id = cpe.table_route_id
11594: and ( -- c_mirror_src_entity_result_id is null or
11595: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
11638: -- and ddr.business_group_id = p_business_group_id
11639: and not exists (
11640: select /*+ */ null
11641: from ben_copy_entity_results cpe
11642: -- pqh_table_route trt
11643: where copy_entity_txn_id = p_copy_entity_txn_id
11644: -- and trt.table_route_id = cpe.table_route_id
11645: and ( -- c_mirror_src_entity_result_id is null or
11646: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
11671: -- and pon.business_group_id = p_business_group_id
11672: and not exists (
11673: select /*+ */ null
11674: from ben_copy_entity_results cpe
11675: -- pqh_table_route trt
11676: where copy_entity_txn_id = p_copy_entity_txn_id
11677: -- and trt.table_route_id = cpe.table_route_id
11678: and ( -- c_mirror_src_entity_result_id is null or
11679: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
11704: -- and drr.business_group_id = p_business_group_id
11705: and not exists (
11706: select /*+ */ null
11707: from ben_copy_entity_results cpe
11708: -- pqh_table_route trt
11709: where copy_entity_txn_id = p_copy_entity_txn_id
11710: -- and trt.table_route_id = cpe.table_route_id
11711: and ( -- c_mirror_src_entity_result_id is null or
11712: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
11733: cursor c_opt_exists(c_opt_id number,
11734: c_table_alias varchar2) is
11735: select null
11736: from ben_copy_entity_results cpe
11737: -- pqh_table_route trt
11738: where copy_entity_txn_id = p_copy_entity_txn_id
11739: -- and trt.table_route_id = cpe.table_route_id
11740: and cpe.table_alias = c_table_alias
11741: and information1 = c_opt_id;
12313: c_parent_table_alias varchar2,
12314: c_copy_entity_txn_id number) is
12315: select copy_entity_result_id mirror_src_entity_result_id
12316: from ben_copy_entity_results cpe
12317: -- pqh_table_route trt
12318: where cpe.information1 = c_parent_pk_id
12319: and cpe.result_type_cd = l_result_type_cd
12320: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
12321: -- and cpe.table_route_id = trt.table_route_id
12325: -- Cursor to get table_route_id
12326: --
12327: -- cursor c_table_route(c_parent_table_alias varchar2) is
12328: -- select table_route_id
12329: -- from pqh_table_route trt
12330: -- where trt.table_alias = c_parent_table_alias;
12331: --
12332: ---------------------------------------------------------------
12333: -- START OF BEN_PL_TYP_F ----------------------
12340: -- and ptp.business_group_id = p_business_group_id
12341: and not exists (
12342: select /*+ */ null
12343: from ben_copy_entity_results cpe
12344: -- pqh_table_route trt
12345: where copy_entity_txn_id = p_copy_entity_txn_id
12346: -- and trt.table_route_id = cpe.table_route_id
12347: and ( -- c_mirror_src_entity_result_id is null or
12348: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12363: cursor c_object_exists(c_pk_id number,
12364: c_table_alias varchar2) is
12365: select null
12366: from ben_copy_entity_results cpe
12367: -- pqh_table_route trt
12368: where copy_entity_txn_id = p_copy_entity_txn_id
12369: -- and trt.table_route_id = cpe.table_route_id
12370: and cpe.table_alias = c_table_alias
12371: and information1 = c_pk_id;
12526: c_parent_table_alias varchar2,
12527: c_copy_entity_txn_id number) is
12528: select copy_entity_result_id mirror_src_entity_result_id
12529: from ben_copy_entity_results cpe
12530: -- pqh_table_route trt
12531: where cpe.information1 = c_parent_pk_id
12532: and cpe.result_type_cd = l_result_type_cd
12533: and cpe.copy_entity_txn_id = c_copy_entity_txn_id
12534: -- and cpe.table_route_id = trt.table_route_id
12538: -- Cursor to get table_route_id
12539: --
12540: -- cursor c_table_route(c_parent_table_alias varchar2) is
12541: -- select table_route_id
12542: -- from pqh_table_route trt
12543: -- where trt.table_alias = c_parent_table_alias;
12544: --
12545: ---------------------------------------------------------------
12546: -- START OF BEN_YR_PERD ----------------------
12554: -- and yrp.business_group_id = p_business_group_id
12555: and not exists (
12556: select /*+ */ null
12557: from ben_copy_entity_results cpe
12558: -- pqh_table_route trt
12559: where copy_entity_txn_id = p_copy_entity_txn_id
12560: -- and trt.table_route_id = cpe.table_route_id
12561: and ( -- c_mirror_src_entity_result_id is null or
12562: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12586: -- and wyp.business_group_id = p_business_group_id
12587: and not exists (
12588: select /*+ */ null
12589: from ben_copy_entity_results cpe
12590: -- pqh_table_route trt
12591: where copy_entity_txn_id = p_copy_entity_txn_id
12592: -- and trt.table_route_id = cpe.table_route_id
12593: and ( -- c_mirror_src_entity_result_id is null or
12594: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
12608: cursor c_object_exists(c_pk_id number,
12609: c_table_alias varchar2) is
12610: select null
12611: from ben_copy_entity_results cpe
12612: -- pqh_table_route trt
12613: where copy_entity_txn_id = p_copy_entity_txn_id
12614: -- and trt.table_route_id = cpe.table_route_id
12615: and cpe.table_alias = c_table_alias
12616: and information1 = c_pk_id;