[Home] [Help]
48: --
49:
50: cursor c_cpe_exists(c_copy_entity_txn_id number) is
51: select null
52: from ben_copy_entity_results
53: where copy_entity_txn_id = c_copy_entity_txn_id
54: and rownum = 1;
55:
56: cursor c_cer_exists(c_copy_entity_txn_id number) is
109:
110: begin
111: --
112:
113: -- Check for rows in ben_copy_entity_results
114: -- If rows found, then exit
115: open c_cpe_exists(p_copy_entity_txn_id);
116: fetch c_cpe_exists into l_dummy;
117: if c_cpe_exists%found then
135: ---------------------------------------------------------------
136: -- START OF BEN_PGM_F ----------------------
137: ---------------------------------------------------------------
138: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PGM') then
139: insert into ben_copy_entity_results
140: (
141: copy_entity_result_id,
142: copy_entity_txn_id,
143: src_copy_entity_result_id,
264: information182,
265: object_version_number
266: )
267: select
268: ben_copy_entity_results_s.nextval,
269: copy_entity_txn_id,
270: src_copy_entity_result_id,
271: result_type_cd,
272: number_of_copies,
402: ---------------------------------------------------------------
403: -- START OF BEN_ACRS_PTIP_CVG_F ----------------------
404: ---------------------------------------------------------------
405: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ACP') then
406: insert into ben_copy_entity_results
407: (
408: copy_entity_result_id,
409: copy_entity_txn_id,
410: src_copy_entity_result_id,
472: information182,
473: object_version_number
474: )
475: select
476: ben_copy_entity_results_s.nextval,
477: copy_entity_txn_id,
478: src_copy_entity_result_id,
479: result_type_cd,
480: number_of_copies,
551: ---------------------------------------------------------------
552: -- START OF BEN_ACTL_PREM_F ----------------------
553: ---------------------------------------------------------------
554: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('APR') then
555: insert into ben_copy_entity_results
556: (
557: copy_entity_result_id,
558: copy_entity_txn_id,
559: src_copy_entity_result_id,
649: information182,
650: object_version_number
651: )
652: select
653: ben_copy_entity_results_s.nextval,
654: copy_entity_txn_id,
655: src_copy_entity_result_id,
656: result_type_cd,
657: number_of_copies,
756: ---------------------------------------------------------------
757: -- START OF BEN_ACTL_PREM_VRBL_RT_F ----------------------
758: ---------------------------------------------------------------
759: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('APV') then
760: insert into ben_copy_entity_results
761: (
762: copy_entity_result_id,
763: copy_entity_txn_id,
764: src_copy_entity_result_id,
825: information182,
826: object_version_number
827: )
828: select
829: ben_copy_entity_results_s.nextval,
830: copy_entity_txn_id,
831: src_copy_entity_result_id,
832: result_type_cd,
833: number_of_copies,
903: ---------------------------------------------------------------
904: -- START OF BEN_ACTL_PREM_VRBL_RT_RL_F ----------------------
905: ---------------------------------------------------------------
906: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('AVA') then
907: insert into ben_copy_entity_results
908: (
909: copy_entity_result_id,
910: copy_entity_txn_id,
911: src_copy_entity_result_id,
973: information182,
974: object_version_number
975: )
976: select
977: ben_copy_entity_results_s.nextval,
978: copy_entity_txn_id,
979: src_copy_entity_result_id,
980: result_type_cd,
981: number_of_copies,
1052: ---------------------------------------------------------------
1053: -- START OF BEN_ACTN_TYP ----------------------
1054: ---------------------------------------------------------------
1055: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EAT') then
1056: insert into ben_copy_entity_results
1057: (
1058: copy_entity_result_id,
1059: copy_entity_txn_id,
1060: src_copy_entity_result_id,
1121: information182,
1122: object_version_number
1123: )
1124: select
1125: ben_copy_entity_results_s.nextval,
1126: copy_entity_txn_id,
1127: src_copy_entity_result_id,
1128: result_type_cd,
1129: number_of_copies,
1199: ---------------------------------------------------------------
1200: -- START OF BEN_ACTY_BASE_RT_CTFN_F ----------------------
1201: ---------------------------------------------------------------
1202: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ABC') then
1203: insert into ben_copy_entity_results
1204: (
1205: copy_entity_result_id,
1206: copy_entity_txn_id,
1207: src_copy_entity_result_id,
1269: information182,
1270: object_version_number
1271: )
1272: select
1273: ben_copy_entity_results_s.nextval,
1274: copy_entity_txn_id,
1275: src_copy_entity_result_id,
1276: result_type_cd,
1277: number_of_copies,
1348: ---------------------------------------------------------------
1349: -- START OF BEN_ACTY_BASE_RT_F ----------------------
1350: ---------------------------------------------------------------
1351: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ABR') then
1352: insert into ben_copy_entity_results
1353: (
1354: copy_entity_result_id,
1355: copy_entity_txn_id,
1356: src_copy_entity_result_id,
1500: information182,
1501: object_version_number
1502: )
1503: select
1504: ben_copy_entity_results_s.nextval,
1505: copy_entity_txn_id,
1506: src_copy_entity_result_id,
1507: result_type_cd,
1508: number_of_copies,
1661: ---------------------------------------------------------------
1662: -- START OF BEN_ACTY_RT_PTD_LMT_F ----------------------
1663: ---------------------------------------------------------------
1664: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('APL1') then
1665: insert into ben_copy_entity_results
1666: (
1667: copy_entity_result_id,
1668: copy_entity_txn_id,
1669: src_copy_entity_result_id,
1729: information182,
1730: object_version_number
1731: )
1732: select
1733: ben_copy_entity_results_s.nextval,
1734: copy_entity_txn_id,
1735: src_copy_entity_result_id,
1736: result_type_cd,
1737: number_of_copies,
1806: ---------------------------------------------------------------
1807: -- START OF BEN_ACTY_RT_PYMT_SCHED_F ----------------------
1808: ---------------------------------------------------------------
1809: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('APF') then
1810: insert into ben_copy_entity_results
1811: (
1812: copy_entity_result_id,
1813: copy_entity_txn_id,
1814: src_copy_entity_result_id,
1875: information182,
1876: object_version_number
1877: )
1878: select
1879: ben_copy_entity_results_s.nextval,
1880: copy_entity_txn_id,
1881: src_copy_entity_result_id,
1882: result_type_cd,
1883: number_of_copies,
1953: ---------------------------------------------------------------
1954: -- START OF BEN_ACTY_VRBL_RT_F ----------------------
1955: ---------------------------------------------------------------
1956: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('AVR') then
1957: insert into ben_copy_entity_results
1958: (
1959: copy_entity_result_id,
1960: copy_entity_txn_id,
1961: src_copy_entity_result_id,
2022: information182,
2023: object_version_number
2024: )
2025: select
2026: ben_copy_entity_results_s.nextval,
2027: copy_entity_txn_id,
2028: src_copy_entity_result_id,
2029: result_type_cd,
2030: number_of_copies,
2100: ---------------------------------------------------------------
2101: -- START OF BEN_AGE_FCTR ----------------------
2102: ---------------------------------------------------------------
2103: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('AGF') then
2104: insert into ben_copy_entity_results
2105: (
2106: copy_entity_result_id,
2107: copy_entity_txn_id,
2108: src_copy_entity_result_id,
2178: information182,
2179: object_version_number
2180: )
2181: select
2182: ben_copy_entity_results_s.nextval,
2183: copy_entity_txn_id,
2184: src_copy_entity_result_id,
2185: result_type_cd,
2186: number_of_copies,
2265: ---------------------------------------------------------------
2266: -- START OF BEN_AGE_RT_F ----------------------
2267: ---------------------------------------------------------------
2268: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ART') then
2269: insert into ben_copy_entity_results
2270: (
2271: copy_entity_result_id,
2272: copy_entity_txn_id,
2273: src_copy_entity_result_id,
2335: information182,
2336: object_version_number
2337: )
2338: select
2339: ben_copy_entity_results_s.nextval,
2340: copy_entity_txn_id,
2341: src_copy_entity_result_id,
2342: result_type_cd,
2343: number_of_copies,
2414: ---------------------------------------------------------------
2415: -- START OF BEN_APLCN_TO_BNFT_POOL_F ----------------------
2416: ---------------------------------------------------------------
2417: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ABP') then
2418: insert into ben_copy_entity_results
2419: (
2420: copy_entity_result_id,
2421: copy_entity_txn_id,
2422: src_copy_entity_result_id,
2482: information182,
2483: object_version_number
2484: )
2485: select
2486: ben_copy_entity_results_s.nextval,
2487: copy_entity_txn_id,
2488: src_copy_entity_result_id,
2489: result_type_cd,
2490: number_of_copies,
2559: ---------------------------------------------------------------
2560: -- START OF BEN_APLD_DPNT_CVG_ELIG_PRFL_F ----------------------
2561: ---------------------------------------------------------------
2562: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ADE') then
2563: insert into ben_copy_entity_results
2564: (
2565: copy_entity_result_id,
2566: copy_entity_txn_id,
2567: src_copy_entity_result_id,
2631: information182,
2632: object_version_number
2633: )
2634: select
2635: ben_copy_entity_results_s.nextval,
2636: copy_entity_txn_id,
2637: src_copy_entity_result_id,
2638: result_type_cd,
2639: number_of_copies,
2712: ---------------------------------------------------------------
2713: -- START OF BEN_ASNT_SET_RT_F ----------------------
2714: ---------------------------------------------------------------
2715: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ASR') then
2716: insert into ben_copy_entity_results
2717: (
2718: copy_entity_result_id,
2719: copy_entity_txn_id,
2720: src_copy_entity_result_id,
2781: information182,
2782: object_version_number
2783: )
2784: select
2785: ben_copy_entity_results_s.nextval,
2786: copy_entity_txn_id,
2787: src_copy_entity_result_id,
2788: result_type_cd,
2789: number_of_copies,
2859: ---------------------------------------------------------------
2860: -- START OF BEN_BENFTS_GRP ----------------------
2861: ---------------------------------------------------------------
2862: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BNG') then
2863: insert into ben_copy_entity_results
2864: (
2865: copy_entity_result_id,
2866: copy_entity_txn_id,
2867: src_copy_entity_result_id,
2927: information182,
2928: object_version_number
2929: )
2930: select
2931: ben_copy_entity_results_s.nextval,
2932: copy_entity_txn_id,
2933: src_copy_entity_result_id,
2934: result_type_cd,
2935: number_of_copies,
3004: ---------------------------------------------------------------
3005: -- START OF BEN_BENFTS_GRP_RT_F ----------------------
3006: ---------------------------------------------------------------
3007: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BRG') then
3008: insert into ben_copy_entity_results
3009: (
3010: copy_entity_result_id,
3011: copy_entity_txn_id,
3012: src_copy_entity_result_id,
3074: information182,
3075: object_version_number
3076: )
3077: select
3078: ben_copy_entity_results_s.nextval,
3079: copy_entity_txn_id,
3080: src_copy_entity_result_id,
3081: result_type_cd,
3082: number_of_copies,
3153: ---------------------------------------------------------------
3154: -- START OF BEN_BNFTS_BAL_F ----------------------
3155: ---------------------------------------------------------------
3156: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BNB') then
3157: insert into ben_copy_entity_results
3158: (
3159: copy_entity_result_id,
3160: copy_entity_txn_id,
3161: src_copy_entity_result_id,
3224: information182,
3225: object_version_number
3226: )
3227: select
3228: ben_copy_entity_results_s.nextval,
3229: copy_entity_txn_id,
3230: src_copy_entity_result_id,
3231: result_type_cd,
3232: number_of_copies,
3304: ---------------------------------------------------------------
3305: -- START OF BEN_BNFT_POOL_RLOVR_RQMT_F ----------------------
3306: ---------------------------------------------------------------
3307: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BPR1') then
3308: insert into ben_copy_entity_results
3309: (
3310: copy_entity_result_id,
3311: copy_entity_txn_id,
3312: src_copy_entity_result_id,
3391: information182,
3392: object_version_number
3393: )
3394: select
3395: ben_copy_entity_results_s.nextval,
3396: copy_entity_txn_id,
3397: src_copy_entity_result_id,
3398: result_type_cd,
3399: number_of_copies,
3487: ---------------------------------------------------------------
3488: -- START OF BEN_BNFT_PRVDR_POOL_F ----------------------
3489: ---------------------------------------------------------------
3490: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BPP') then
3491: insert into ben_copy_entity_results
3492: (
3493: copy_entity_result_id,
3494: copy_entity_txn_id,
3495: src_copy_entity_result_id,
3586: information182,
3587: object_version_number
3588: )
3589: select
3590: ben_copy_entity_results_s.nextval,
3591: copy_entity_txn_id,
3592: src_copy_entity_result_id,
3593: result_type_cd,
3594: number_of_copies,
3694: ---------------------------------------------------------------
3695: -- START OF BEN_BNFT_RSTRN_CTFN_F ----------------------
3696: ---------------------------------------------------------------
3697: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BRC') then
3698: insert into ben_copy_entity_results
3699: (
3700: copy_entity_result_id,
3701: copy_entity_txn_id,
3702: src_copy_entity_result_id,
3764: information182,
3765: object_version_number
3766: )
3767: select
3768: ben_copy_entity_results_s.nextval,
3769: copy_entity_txn_id,
3770: src_copy_entity_result_id,
3771: result_type_cd,
3772: number_of_copies,
3843: ---------------------------------------------------------------
3844: -- START OF BEN_BNFT_VRBL_RT_F ----------------------
3845: ---------------------------------------------------------------
3846: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BVR1') then
3847: insert into ben_copy_entity_results
3848: (
3849: copy_entity_result_id,
3850: copy_entity_txn_id,
3851: src_copy_entity_result_id,
3912: information182,
3913: object_version_number
3914: )
3915: select
3916: ben_copy_entity_results_s.nextval,
3917: copy_entity_txn_id,
3918: src_copy_entity_result_id,
3919: result_type_cd,
3920: number_of_copies,
3990: ---------------------------------------------------------------
3991: -- START OF BEN_BNFT_VRBL_RT_RL_F ----------------------
3992: ---------------------------------------------------------------
3993: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BRR') then
3994: insert into ben_copy_entity_results
3995: (
3996: copy_entity_result_id,
3997: copy_entity_txn_id,
3998: src_copy_entity_result_id,
4059: information182,
4060: object_version_number
4061: )
4062: select
4063: ben_copy_entity_results_s.nextval,
4064: copy_entity_txn_id,
4065: src_copy_entity_result_id,
4066: result_type_cd,
4067: number_of_copies,
4137: ---------------------------------------------------------------
4138: -- START OF BEN_BRGNG_UNIT_RT_F ----------------------
4139: ---------------------------------------------------------------
4140: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BUR') then
4141: insert into ben_copy_entity_results
4142: (
4143: copy_entity_result_id,
4144: copy_entity_txn_id,
4145: src_copy_entity_result_id,
4207: information182,
4208: object_version_number
4209: )
4210: select
4211: ben_copy_entity_results_s.nextval,
4212: copy_entity_txn_id,
4213: src_copy_entity_result_id,
4214: result_type_cd,
4215: number_of_copies,
4286: ---------------------------------------------------------------
4287: -- START OF BEN_CBR_QUALD_BNF_RT_F ----------------------
4288: ---------------------------------------------------------------
4289: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CQR') then
4290: insert into ben_copy_entity_results
4291: (
4292: copy_entity_result_id,
4293: copy_entity_txn_id,
4294: src_copy_entity_result_id,
4357: information182,
4358: object_version_number
4359: )
4360: select
4361: ben_copy_entity_results_s.nextval,
4362: copy_entity_txn_id,
4363: src_copy_entity_result_id,
4364: result_type_cd,
4365: number_of_copies,
4437: ---------------------------------------------------------------
4438: -- START OF BEN_CMBN_AGE_LOS_FCTR ----------------------
4439: ---------------------------------------------------------------
4440: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CLA') then
4441: insert into ben_copy_entity_results
4442: (
4443: copy_entity_result_id,
4444: copy_entity_txn_id,
4445: src_copy_entity_result_id,
4509: information182,
4510: object_version_number
4511: )
4512: select
4513: ben_copy_entity_results_s.nextval,
4514: copy_entity_txn_id,
4515: src_copy_entity_result_id,
4516: result_type_cd,
4517: number_of_copies,
4590: ---------------------------------------------------------------
4591: -- START OF BEN_CMBN_AGE_LOS_RT_F ----------------------
4592: ---------------------------------------------------------------
4593: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CMR') then
4594: insert into ben_copy_entity_results
4595: (
4596: copy_entity_result_id,
4597: copy_entity_txn_id,
4598: src_copy_entity_result_id,
4660: information182,
4661: object_version_number
4662: )
4663: select
4664: ben_copy_entity_results_s.nextval,
4665: copy_entity_txn_id,
4666: src_copy_entity_result_id,
4667: result_type_cd,
4668: number_of_copies,
4739: ---------------------------------------------------------------
4740: -- START OF BEN_CMBN_PLIP_F ----------------------
4741: ---------------------------------------------------------------
4742: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPL') then
4743: insert into ben_copy_entity_results
4744: (
4745: copy_entity_result_id,
4746: copy_entity_txn_id,
4747: src_copy_entity_result_id,
4807: information182,
4808: object_version_number
4809: )
4810: select
4811: ben_copy_entity_results_s.nextval,
4812: copy_entity_txn_id,
4813: src_copy_entity_result_id,
4814: result_type_cd,
4815: number_of_copies,
4884: ---------------------------------------------------------------
4885: -- START OF BEN_CMBN_PTIP_F ----------------------
4886: ---------------------------------------------------------------
4887: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CBP') then
4888: insert into ben_copy_entity_results
4889: (
4890: copy_entity_result_id,
4891: copy_entity_txn_id,
4892: src_copy_entity_result_id,
4952: information182,
4953: object_version_number
4954: )
4955: select
4956: ben_copy_entity_results_s.nextval,
4957: copy_entity_txn_id,
4958: src_copy_entity_result_id,
4959: result_type_cd,
4960: number_of_copies,
5029: ---------------------------------------------------------------
5030: -- START OF BEN_CMBN_PTIP_OPT_F ----------------------
5031: ---------------------------------------------------------------
5032: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPT') then
5033: insert into ben_copy_entity_results
5034: (
5035: copy_entity_result_id,
5036: copy_entity_txn_id,
5037: src_copy_entity_result_id,
5099: information182,
5100: object_version_number
5101: )
5102: select
5103: ben_copy_entity_results_s.nextval,
5104: copy_entity_txn_id,
5105: src_copy_entity_result_id,
5106: result_type_cd,
5107: number_of_copies,
5178: ---------------------------------------------------------------
5179: -- START OF BEN_CNTNG_PRTN_ELIG_PRFL_F ----------------------
5180: ---------------------------------------------------------------
5181: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CGP') then
5182: insert into ben_copy_entity_results
5183: (
5184: copy_entity_result_id,
5185: copy_entity_txn_id,
5186: src_copy_entity_result_id,
5249: information182,
5250: object_version_number
5251: )
5252: select
5253: ben_copy_entity_results_s.nextval,
5254: copy_entity_txn_id,
5255: src_copy_entity_result_id,
5256: result_type_cd,
5257: number_of_copies,
5329: ---------------------------------------------------------------
5330: -- START OF BEN_CNTNG_PRTN_PRFL_RT_F ----------------------
5331: ---------------------------------------------------------------
5332: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPN') then
5333: insert into ben_copy_entity_results
5334: (
5335: copy_entity_result_id,
5336: copy_entity_txn_id,
5337: src_copy_entity_result_id,
5400: information182,
5401: object_version_number
5402: )
5403: select
5404: ben_copy_entity_results_s.nextval,
5405: copy_entity_txn_id,
5406: src_copy_entity_result_id,
5407: result_type_cd,
5408: number_of_copies,
5480: ---------------------------------------------------------------
5481: -- START OF BEN_COMPTNCY_RT_F ----------------------
5482: ---------------------------------------------------------------
5483: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CTY') then
5484: insert into ben_copy_entity_results
5485: (
5486: copy_entity_result_id,
5487: copy_entity_txn_id,
5488: src_copy_entity_result_id,
5549: information182,
5550: object_version_number
5551: )
5552: select
5553: ben_copy_entity_results_s.nextval,
5554: copy_entity_txn_id,
5555: src_copy_entity_result_id,
5556: result_type_cd,
5557: number_of_copies,
5627: ---------------------------------------------------------------
5628: -- START OF BEN_COMP_LVL_FCTR ----------------------
5629: ---------------------------------------------------------------
5630: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CLF') then
5631: insert into ben_copy_entity_results
5632: (
5633: copy_entity_result_id,
5634: copy_entity_txn_id,
5635: src_copy_entity_result_id,
5708: information182,
5709: object_version_number
5710: )
5711: select
5712: ben_copy_entity_results_s.nextval,
5713: copy_entity_txn_id,
5714: src_copy_entity_result_id,
5715: result_type_cd,
5716: number_of_copies,
5798: ---------------------------------------------------------------
5799: -- START OF BEN_COMP_LVL_RT_F ----------------------
5800: ---------------------------------------------------------------
5801: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CLR') then
5802: insert into ben_copy_entity_results
5803: (
5804: copy_entity_result_id,
5805: copy_entity_txn_id,
5806: src_copy_entity_result_id,
5868: information182,
5869: object_version_number
5870: )
5871: select
5872: ben_copy_entity_results_s.nextval,
5873: copy_entity_txn_id,
5874: src_copy_entity_result_id,
5875: result_type_cd,
5876: number_of_copies,
5947: ---------------------------------------------------------------
5948: -- START OF BEN_CSS_RLTD_PER_PER_IN_LER_F ----------------------
5949: ---------------------------------------------------------------
5950: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CSR') then
5951: insert into ben_copy_entity_results
5952: (
5953: copy_entity_result_id,
5954: copy_entity_txn_id,
5955: src_copy_entity_result_id,
6016: information182,
6017: object_version_number
6018: )
6019: select
6020: ben_copy_entity_results_s.nextval,
6021: copy_entity_txn_id,
6022: src_copy_entity_result_id,
6023: result_type_cd,
6024: number_of_copies,
6094: ---------------------------------------------------------------
6095: -- START OF BEN_CVG_AMT_CALC_MTHD_F ----------------------
6096: ---------------------------------------------------------------
6097: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CCM') then
6098: insert into ben_copy_entity_results
6099: (
6100: copy_entity_result_id,
6101: copy_entity_txn_id,
6102: src_copy_entity_result_id,
6188: information182,
6189: object_version_number
6190: )
6191: select
6192: ben_copy_entity_results_s.nextval,
6193: copy_entity_txn_id,
6194: src_copy_entity_result_id,
6195: result_type_cd,
6196: number_of_copies,
6291: ---------------------------------------------------------------
6292: -- START OF BEN_CWB_WKSHT_GRP ----------------------
6293: ---------------------------------------------------------------
6294: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CWG') then
6295: insert into ben_copy_entity_results
6296: (
6297: copy_entity_result_id,
6298: copy_entity_txn_id,
6299: src_copy_entity_result_id,
6361: information182,
6362: object_version_number
6363: )
6364: select
6365: ben_copy_entity_results_s.nextval,
6366: copy_entity_txn_id,
6367: src_copy_entity_result_id,
6368: result_type_cd,
6369: number_of_copies,
6440: ---------------------------------------------------------------
6441: -- START OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------
6442: ---------------------------------------------------------------
6443: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DCE') then
6444: insert into ben_copy_entity_results
6445: (
6446: copy_entity_result_id,
6447: copy_entity_txn_id,
6448: src_copy_entity_result_id,
6520: information182,
6521: object_version_number
6522: )
6523: select
6524: ben_copy_entity_results_s.nextval,
6525: copy_entity_txn_id,
6526: src_copy_entity_result_id,
6527: result_type_cd,
6528: number_of_copies,
6609: ---------------------------------------------------------------
6610: -- START OF BEN_DPNT_CVG_RQD_RLSHP_F ----------------------
6611: ---------------------------------------------------------------
6612: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DCR') then
6613: insert into ben_copy_entity_results
6614: (
6615: copy_entity_result_id,
6616: copy_entity_txn_id,
6617: src_copy_entity_result_id,
6681: information182,
6682: object_version_number
6683: )
6684: select
6685: ben_copy_entity_results_s.nextval,
6686: copy_entity_txn_id,
6687: src_copy_entity_result_id,
6688: result_type_cd,
6689: number_of_copies,
6762: ---------------------------------------------------------------
6763: -- START OF BEN_DPNT_CVRD_ANTHR_PL_CVG_F ----------------------
6764: ---------------------------------------------------------------
6765: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DPC') then
6766: insert into ben_copy_entity_results
6767: (
6768: copy_entity_result_id,
6769: copy_entity_txn_id,
6770: src_copy_entity_result_id,
6833: information182,
6834: object_version_number
6835: )
6836: select
6837: ben_copy_entity_results_s.nextval,
6838: copy_entity_txn_id,
6839: src_copy_entity_result_id,
6840: result_type_cd,
6841: number_of_copies,
6913: ---------------------------------------------------------------
6914: -- START OF BEN_DPNT_CVRD_OTHR_PGM_RT_F ----------------------
6915: ---------------------------------------------------------------
6916: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DOP') then
6917: insert into ben_copy_entity_results
6918: (
6919: copy_entity_result_id,
6920: copy_entity_txn_id,
6921: src_copy_entity_result_id,
6985: information182,
6986: object_version_number
6987: )
6988: select
6989: ben_copy_entity_results_s.nextval,
6990: copy_entity_txn_id,
6991: src_copy_entity_result_id,
6992: result_type_cd,
6993: number_of_copies,
7066: ---------------------------------------------------------------
7067: -- START OF BEN_DPNT_CVRD_OTHR_PL_RT_F ----------------------
7068: ---------------------------------------------------------------
7069: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DCL') then
7070: insert into ben_copy_entity_results
7071: (
7072: copy_entity_result_id,
7073: copy_entity_txn_id,
7074: src_copy_entity_result_id,
7137: information182,
7138: object_version_number
7139: )
7140: select
7141: ben_copy_entity_results_s.nextval,
7142: copy_entity_txn_id,
7143: src_copy_entity_result_id,
7144: result_type_cd,
7145: number_of_copies,
7217: ---------------------------------------------------------------
7218: -- START OF BEN_DPNT_CVRD_OTHR_PTIP_RT_F ----------------------
7219: ---------------------------------------------------------------
7220: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DCO') then
7221: insert into ben_copy_entity_results
7222: (
7223: copy_entity_result_id,
7224: copy_entity_txn_id,
7225: src_copy_entity_result_id,
7289: information182,
7290: object_version_number
7291: )
7292: select
7293: ben_copy_entity_results_s.nextval,
7294: copy_entity_txn_id,
7295: src_copy_entity_result_id,
7296: result_type_cd,
7297: number_of_copies,
7370: ---------------------------------------------------------------
7371: -- START OF BEN_DPNT_CVRD_PLIP_RT_F ----------------------
7372: ---------------------------------------------------------------
7373: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DCP') then
7374: insert into ben_copy_entity_results
7375: (
7376: copy_entity_result_id,
7377: copy_entity_txn_id,
7378: src_copy_entity_result_id,
7441: information182,
7442: object_version_number
7443: )
7444: select
7445: ben_copy_entity_results_s.nextval,
7446: copy_entity_txn_id,
7447: src_copy_entity_result_id,
7448: result_type_cd,
7449: number_of_copies,
7521: ---------------------------------------------------------------
7522: -- START OF BEN_DPNT_OTHR_PTIP_RT_F ----------------------
7523: ---------------------------------------------------------------
7524: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DOT') then
7525: insert into ben_copy_entity_results
7526: (
7527: copy_entity_result_id,
7528: copy_entity_txn_id,
7529: src_copy_entity_result_id,
7591: information182,
7592: object_version_number
7593: )
7594: select
7595: ben_copy_entity_results_s.nextval,
7596: copy_entity_txn_id,
7597: src_copy_entity_result_id,
7598: result_type_cd,
7599: number_of_copies,
7670: ---------------------------------------------------------------
7671: -- START OF BEN_DSBLD_RT_F ----------------------
7672: ---------------------------------------------------------------
7673: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DBR') then
7674: insert into ben_copy_entity_results
7675: (
7676: copy_entity_result_id,
7677: copy_entity_txn_id,
7678: src_copy_entity_result_id,
7740: information182,
7741: object_version_number
7742: )
7743: select
7744: ben_copy_entity_results_s.nextval,
7745: copy_entity_txn_id,
7746: src_copy_entity_result_id,
7747: result_type_cd,
7748: number_of_copies,
7819: ---------------------------------------------------------------
7820: -- START OF BEN_DSGNTR_ENRLD_CVG_F ----------------------
7821: ---------------------------------------------------------------
7822: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DEC') then
7823: insert into ben_copy_entity_results
7824: (
7825: copy_entity_result_id,
7826: copy_entity_txn_id,
7827: src_copy_entity_result_id,
7887: information182,
7888: object_version_number
7889: )
7890: select
7891: ben_copy_entity_results_s.nextval,
7892: copy_entity_txn_id,
7893: src_copy_entity_result_id,
7894: result_type_cd,
7895: number_of_copies,
7964: ---------------------------------------------------------------
7965: -- START OF BEN_DSGN_RQMT_F ----------------------
7966: ---------------------------------------------------------------
7967: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DDR') then
7968: insert into ben_copy_entity_results
7969: (
7970: copy_entity_result_id,
7971: copy_entity_txn_id,
7972: src_copy_entity_result_id,
8040: information182,
8041: object_version_number
8042: )
8043: select
8044: ben_copy_entity_results_s.nextval,
8045: copy_entity_txn_id,
8046: src_copy_entity_result_id,
8047: result_type_cd,
8048: number_of_copies,
8125: ---------------------------------------------------------------
8126: -- START OF BEN_DSGN_RQMT_RLSHP_TYP ----------------------
8127: ---------------------------------------------------------------
8128: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('DRR') then
8129: insert into ben_copy_entity_results
8130: (
8131: copy_entity_result_id,
8132: copy_entity_txn_id,
8133: src_copy_entity_result_id,
8193: information182,
8194: object_version_number
8195: )
8196: select
8197: ben_copy_entity_results_s.nextval,
8198: copy_entity_txn_id,
8199: src_copy_entity_result_id,
8200: result_type_cd,
8201: number_of_copies,
8270: ---------------------------------------------------------------
8271: -- START OF BEN_EE_STAT_RT_F ----------------------
8272: ---------------------------------------------------------------
8273: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ESR') then
8274: insert into ben_copy_entity_results
8275: (
8276: copy_entity_result_id,
8277: copy_entity_txn_id,
8278: src_copy_entity_result_id,
8339: information182,
8340: object_version_number
8341: )
8342: select
8343: ben_copy_entity_results_s.nextval,
8344: copy_entity_txn_id,
8345: src_copy_entity_result_id,
8346: result_type_cd,
8347: number_of_copies,
8417: ---------------------------------------------------------------
8418: -- START OF BEN_ELIGY_PRFL_F ----------------------
8419: ---------------------------------------------------------------
8420: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ELP') then
8421: insert into ben_copy_entity_results
8422: (
8423: copy_entity_result_id,
8424: copy_entity_txn_id,
8425: src_copy_entity_result_id,
8552: information182,
8553: object_version_number
8554: )
8555: select
8556: ben_copy_entity_results_s.nextval,
8557: copy_entity_txn_id,
8558: src_copy_entity_result_id,
8559: result_type_cd,
8560: number_of_copies,
8696: ---------------------------------------------------------------
8697: -- START OF BEN_ELIGY_PRFL_RL_F ----------------------
8698: ---------------------------------------------------------------
8699: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ERL') then
8700: insert into ben_copy_entity_results
8701: (
8702: copy_entity_result_id,
8703: copy_entity_txn_id,
8704: src_copy_entity_result_id,
8766: information182,
8767: object_version_number
8768: )
8769: select
8770: ben_copy_entity_results_s.nextval,
8771: copy_entity_txn_id,
8772: src_copy_entity_result_id,
8773: result_type_cd,
8774: number_of_copies,
8845: ---------------------------------------------------------------
8846: -- START OF BEN_ELIG_AGE_CVG_F ----------------------
8847: ---------------------------------------------------------------
8848: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EAC') then
8849: insert into ben_copy_entity_results
8850: (
8851: copy_entity_result_id,
8852: copy_entity_txn_id,
8853: src_copy_entity_result_id,
8918: information182,
8919: object_version_number
8920: )
8921: select
8922: ben_copy_entity_results_s.nextval,
8923: copy_entity_txn_id,
8924: src_copy_entity_result_id,
8925: result_type_cd,
8926: number_of_copies,
9000: ---------------------------------------------------------------
9001: -- START OF BEN_ELIG_AGE_PRTE_F ----------------------
9002: ---------------------------------------------------------------
9003: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EAP') then
9004: insert into ben_copy_entity_results
9005: (
9006: copy_entity_result_id,
9007: copy_entity_txn_id,
9008: src_copy_entity_result_id,
9070: information182,
9071: object_version_number
9072: )
9073: select
9074: ben_copy_entity_results_s.nextval,
9075: copy_entity_txn_id,
9076: src_copy_entity_result_id,
9077: result_type_cd,
9078: number_of_copies,
9149: ---------------------------------------------------------------
9150: -- START OF BEN_ELIG_ASNT_SET_PRTE_F ----------------------
9151: ---------------------------------------------------------------
9152: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EAN') then
9153: insert into ben_copy_entity_results
9154: (
9155: copy_entity_result_id,
9156: copy_entity_txn_id,
9157: src_copy_entity_result_id,
9218: information182,
9219: object_version_number
9220: )
9221: select
9222: ben_copy_entity_results_s.nextval,
9223: copy_entity_txn_id,
9224: src_copy_entity_result_id,
9225: result_type_cd,
9226: number_of_copies,
9296: ---------------------------------------------------------------
9297: -- START OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------
9298: ---------------------------------------------------------------
9299: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EBN') then
9300: insert into ben_copy_entity_results
9301: (
9302: copy_entity_result_id,
9303: copy_entity_txn_id,
9304: src_copy_entity_result_id,
9366: information182,
9367: object_version_number
9368: )
9369: select
9370: ben_copy_entity_results_s.nextval,
9371: copy_entity_txn_id,
9372: src_copy_entity_result_id,
9373: result_type_cd,
9374: number_of_copies,
9445: ---------------------------------------------------------------
9446: -- START OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------
9447: ---------------------------------------------------------------
9448: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EBU') then
9449: insert into ben_copy_entity_results
9450: (
9451: copy_entity_result_id,
9452: copy_entity_txn_id,
9453: src_copy_entity_result_id,
9515: information182,
9516: object_version_number
9517: )
9518: select
9519: ben_copy_entity_results_s.nextval,
9520: copy_entity_txn_id,
9521: src_copy_entity_result_id,
9522: result_type_cd,
9523: number_of_copies,
9594: ---------------------------------------------------------------
9595: -- START OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------
9596: ---------------------------------------------------------------
9597: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ECQ') then
9598: insert into ben_copy_entity_results
9599: (
9600: copy_entity_result_id,
9601: copy_entity_txn_id,
9602: src_copy_entity_result_id,
9665: information182,
9666: object_version_number
9667: )
9668: select
9669: ben_copy_entity_results_s.nextval,
9670: copy_entity_txn_id,
9671: src_copy_entity_result_id,
9672: result_type_cd,
9673: number_of_copies,
9745: ---------------------------------------------------------------
9746: -- START OF BEN_ELIG_CMBN_AGE_LOS_PRTE_F ----------------------
9747: ---------------------------------------------------------------
9748: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ECP') then
9749: insert into ben_copy_entity_results
9750: (
9751: copy_entity_result_id,
9752: copy_entity_txn_id,
9753: src_copy_entity_result_id,
9816: information182,
9817: object_version_number
9818: )
9819: select
9820: ben_copy_entity_results_s.nextval,
9821: copy_entity_txn_id,
9822: src_copy_entity_result_id,
9823: result_type_cd,
9824: number_of_copies,
9896: ---------------------------------------------------------------
9897: -- START OF BEN_ELIG_COMPTNCY_PRTE_F ----------------------
9898: ---------------------------------------------------------------
9899: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ECY') then
9900: insert into ben_copy_entity_results
9901: (
9902: copy_entity_result_id,
9903: copy_entity_txn_id,
9904: src_copy_entity_result_id,
9965: information182,
9966: object_version_number
9967: )
9968: select
9969: ben_copy_entity_results_s.nextval,
9970: copy_entity_txn_id,
9971: src_copy_entity_result_id,
9972: result_type_cd,
9973: number_of_copies,
10043: ---------------------------------------------------------------
10044: -- START OF BEN_ELIG_COMP_LVL_PRTE_F ----------------------
10045: ---------------------------------------------------------------
10046: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ECL') then
10047: insert into ben_copy_entity_results
10048: (
10049: copy_entity_result_id,
10050: copy_entity_txn_id,
10051: src_copy_entity_result_id,
10113: information182,
10114: object_version_number
10115: )
10116: select
10117: ben_copy_entity_results_s.nextval,
10118: copy_entity_txn_id,
10119: src_copy_entity_result_id,
10120: result_type_cd,
10121: number_of_copies,
10192: ---------------------------------------------------------------
10193: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F ----------------------
10194: ---------------------------------------------------------------
10195: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EDO') then
10196: insert into ben_copy_entity_results
10197: (
10198: copy_entity_result_id,
10199: copy_entity_txn_id,
10200: src_copy_entity_result_id,
10262: information182,
10263: object_version_number
10264: )
10265: select
10266: ben_copy_entity_results_s.nextval,
10267: copy_entity_txn_id,
10268: src_copy_entity_result_id,
10269: result_type_cd,
10270: number_of_copies,
10341: ---------------------------------------------------------------
10342: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PGM_F ----------------------
10343: ---------------------------------------------------------------
10344: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EDG') then
10345: insert into ben_copy_entity_results
10346: (
10347: copy_entity_result_id,
10348: copy_entity_txn_id,
10349: src_copy_entity_result_id,
10413: information182,
10414: object_version_number
10415: )
10416: select
10417: ben_copy_entity_results_s.nextval,
10418: copy_entity_txn_id,
10419: src_copy_entity_result_id,
10420: result_type_cd,
10421: number_of_copies,
10494: ---------------------------------------------------------------
10495: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------
10496: ---------------------------------------------------------------
10497: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EDP') then
10498: insert into ben_copy_entity_results
10499: (
10500: copy_entity_result_id,
10501: copy_entity_txn_id,
10502: src_copy_entity_result_id,
10565: information182,
10566: object_version_number
10567: )
10568: select
10569: ben_copy_entity_results_s.nextval,
10570: copy_entity_txn_id,
10571: src_copy_entity_result_id,
10572: result_type_cd,
10573: number_of_copies,
10645: ---------------------------------------------------------------
10646: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------
10647: ---------------------------------------------------------------
10648: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EDT') then
10649: insert into ben_copy_entity_results
10650: (
10651: copy_entity_result_id,
10652: copy_entity_txn_id,
10653: src_copy_entity_result_id,
10717: information182,
10718: object_version_number
10719: )
10720: select
10721: ben_copy_entity_results_s.nextval,
10722: copy_entity_txn_id,
10723: src_copy_entity_result_id,
10724: result_type_cd,
10725: number_of_copies,
10798: ---------------------------------------------------------------
10799: -- START OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------
10800: ---------------------------------------------------------------
10801: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EDI') then
10802: insert into ben_copy_entity_results
10803: (
10804: copy_entity_result_id,
10805: copy_entity_txn_id,
10806: src_copy_entity_result_id,
10869: information182,
10870: object_version_number
10871: )
10872: select
10873: ben_copy_entity_results_s.nextval,
10874: copy_entity_txn_id,
10875: src_copy_entity_result_id,
10876: result_type_cd,
10877: number_of_copies,
10949: ---------------------------------------------------------------
10950: -- START OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------
10951: ---------------------------------------------------------------
10952: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ETD') then
10953: insert into ben_copy_entity_results
10954: (
10955: copy_entity_result_id,
10956: copy_entity_txn_id,
10957: src_copy_entity_result_id,
11019: information182,
11020: object_version_number
11021: )
11022: select
11023: ben_copy_entity_results_s.nextval,
11024: copy_entity_txn_id,
11025: src_copy_entity_result_id,
11026: result_type_cd,
11027: number_of_copies,
11098: ---------------------------------------------------------------
11099: -- START OF BEN_ELIG_DSBLD_PRTE_F ----------------------
11100: ---------------------------------------------------------------
11101: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EDB') then
11102: insert into ben_copy_entity_results
11103: (
11104: copy_entity_result_id,
11105: copy_entity_txn_id,
11106: src_copy_entity_result_id,
11168: information182,
11169: object_version_number
11170: )
11171: select
11172: ben_copy_entity_results_s.nextval,
11173: copy_entity_txn_id,
11174: src_copy_entity_result_id,
11175: result_type_cd,
11176: number_of_copies,
11247: ---------------------------------------------------------------
11248: -- START OF BEN_ELIG_DSBLD_STAT_CVG_F ----------------------
11249: ---------------------------------------------------------------
11250: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EDC') then
11251: insert into ben_copy_entity_results
11252: (
11253: copy_entity_result_id,
11254: copy_entity_txn_id,
11255: src_copy_entity_result_id,
11319: information182,
11320: object_version_number
11321: )
11322: select
11323: ben_copy_entity_results_s.nextval,
11324: copy_entity_txn_id,
11325: src_copy_entity_result_id,
11326: result_type_cd,
11327: number_of_copies,
11400: ---------------------------------------------------------------
11401: -- START OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------
11402: ---------------------------------------------------------------
11403: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EDS') then
11404: insert into ben_copy_entity_results
11405: (
11406: copy_entity_result_id,
11407: copy_entity_txn_id,
11408: src_copy_entity_result_id,
11470: information182,
11471: object_version_number
11472: )
11473: select
11474: ben_copy_entity_results_s.nextval,
11475: copy_entity_txn_id,
11476: src_copy_entity_result_id,
11477: result_type_cd,
11478: number_of_copies,
11549: ---------------------------------------------------------------
11550: -- START OF BEN_ELIG_DSBLTY_CTG_PRTE_F ----------------------
11551: ---------------------------------------------------------------
11552: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ECT') then
11553: insert into ben_copy_entity_results
11554: (
11555: copy_entity_result_id,
11556: copy_entity_txn_id,
11557: src_copy_entity_result_id,
11619: information182,
11620: object_version_number
11621: )
11622: select
11623: ben_copy_entity_results_s.nextval,
11624: copy_entity_txn_id,
11625: src_copy_entity_result_id,
11626: result_type_cd,
11627: number_of_copies,
11698: ---------------------------------------------------------------
11699: -- START OF BEN_ELIG_DSBLTY_DGR_PRTE_F ----------------------
11700: ---------------------------------------------------------------
11701: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EDD') then
11702: insert into ben_copy_entity_results
11703: (
11704: copy_entity_result_id,
11705: copy_entity_txn_id,
11706: src_copy_entity_result_id,
11769: information182,
11770: object_version_number
11771: )
11772: select
11773: ben_copy_entity_results_s.nextval,
11774: copy_entity_txn_id,
11775: src_copy_entity_result_id,
11776: result_type_cd,
11777: number_of_copies,
11849: ---------------------------------------------------------------
11850: -- START OF BEN_ELIG_DSBLTY_RSN_PRTE_F ----------------------
11851: ---------------------------------------------------------------
11852: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EDR') then
11853: insert into ben_copy_entity_results
11854: (
11855: copy_entity_result_id,
11856: copy_entity_txn_id,
11857: src_copy_entity_result_id,
11920: information182,
11921: object_version_number
11922: )
11923: select
11924: ben_copy_entity_results_s.nextval,
11925: copy_entity_txn_id,
11926: src_copy_entity_result_id,
11927: result_type_cd,
11928: number_of_copies,
12000: ---------------------------------------------------------------
12001: -- START OF BEN_ELIG_EE_STAT_PRTE_F ----------------------
12002: ---------------------------------------------------------------
12003: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EES') then
12004: insert into ben_copy_entity_results
12005: (
12006: copy_entity_result_id,
12007: copy_entity_txn_id,
12008: src_copy_entity_result_id,
12069: information182,
12070: object_version_number
12071: )
12072: select
12073: ben_copy_entity_results_s.nextval,
12074: copy_entity_txn_id,
12075: src_copy_entity_result_id,
12076: result_type_cd,
12077: number_of_copies,
12147: ---------------------------------------------------------------
12148: -- START OF BEN_ELIG_ENRLD_ANTHR_OIPL_F ----------------------
12149: ---------------------------------------------------------------
12150: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EEI') then
12151: insert into ben_copy_entity_results
12152: (
12153: copy_entity_result_id,
12154: copy_entity_txn_id,
12155: src_copy_entity_result_id,
12218: information182,
12219: object_version_number
12220: )
12221: select
12222: ben_copy_entity_results_s.nextval,
12223: copy_entity_txn_id,
12224: src_copy_entity_result_id,
12225: result_type_cd,
12226: number_of_copies,
12298: ---------------------------------------------------------------
12299: -- START OF BEN_ELIG_ENRLD_ANTHR_PGM_F ----------------------
12300: ---------------------------------------------------------------
12301: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EEG') then
12302: insert into ben_copy_entity_results
12303: (
12304: copy_entity_result_id,
12305: copy_entity_txn_id,
12306: src_copy_entity_result_id,
12369: information182,
12370: object_version_number
12371: )
12372: select
12373: ben_copy_entity_results_s.nextval,
12374: copy_entity_txn_id,
12375: src_copy_entity_result_id,
12376: result_type_cd,
12377: number_of_copies,
12449: ---------------------------------------------------------------
12450: -- START OF BEN_ELIG_ENRLD_ANTHR_PLIP_F ----------------------
12451: ---------------------------------------------------------------
12452: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EAI') then
12453: insert into ben_copy_entity_results
12454: (
12455: copy_entity_result_id,
12456: copy_entity_txn_id,
12457: src_copy_entity_result_id,
12520: information182,
12521: object_version_number
12522: )
12523: select
12524: ben_copy_entity_results_s.nextval,
12525: copy_entity_txn_id,
12526: src_copy_entity_result_id,
12527: result_type_cd,
12528: number_of_copies,
12600: ---------------------------------------------------------------
12601: -- START OF BEN_ELIG_ENRLD_ANTHR_PL_F ----------------------
12602: ---------------------------------------------------------------
12603: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EEP') then
12604: insert into ben_copy_entity_results
12605: (
12606: copy_entity_result_id,
12607: copy_entity_txn_id,
12608: src_copy_entity_result_id,
12671: information182,
12672: object_version_number
12673: )
12674: select
12675: ben_copy_entity_results_s.nextval,
12676: copy_entity_txn_id,
12677: src_copy_entity_result_id,
12678: result_type_cd,
12679: number_of_copies,
12751: ---------------------------------------------------------------
12752: -- START OF BEN_ELIG_ENRLD_ANTHR_PTIP_F ----------------------
12753: ---------------------------------------------------------------
12754: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EET') then
12755: insert into ben_copy_entity_results
12756: (
12757: copy_entity_result_id,
12758: copy_entity_txn_id,
12759: src_copy_entity_result_id,
12823: information182,
12824: object_version_number
12825: )
12826: select
12827: ben_copy_entity_results_s.nextval,
12828: copy_entity_txn_id,
12829: src_copy_entity_result_id,
12830: result_type_cd,
12831: number_of_copies,
12904: ---------------------------------------------------------------
12905: -- START OF BEN_ELIG_FL_TM_PT_TM_PRTE_F ----------------------
12906: ---------------------------------------------------------------
12907: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EFP') then
12908: insert into ben_copy_entity_results
12909: (
12910: copy_entity_result_id,
12911: copy_entity_txn_id,
12912: src_copy_entity_result_id,
12974: information182,
12975: object_version_number
12976: )
12977: select
12978: ben_copy_entity_results_s.nextval,
12979: copy_entity_txn_id,
12980: src_copy_entity_result_id,
12981: result_type_cd,
12982: number_of_copies,
13053: ---------------------------------------------------------------
13054: -- START OF BEN_ELIG_GNDR_PRTE_F ----------------------
13055: ---------------------------------------------------------------
13056: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EGN') then
13057: insert into ben_copy_entity_results
13058: (
13059: copy_entity_result_id,
13060: copy_entity_txn_id,
13061: src_copy_entity_result_id,
13123: information182,
13124: object_version_number
13125: )
13126: select
13127: ben_copy_entity_results_s.nextval,
13128: copy_entity_txn_id,
13129: src_copy_entity_result_id,
13130: result_type_cd,
13131: number_of_copies,
13202: ---------------------------------------------------------------
13203: -- START OF BEN_ELIG_GRD_PRTE_F ----------------------
13204: ---------------------------------------------------------------
13205: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EGR') then
13206: insert into ben_copy_entity_results
13207: (
13208: copy_entity_result_id,
13209: copy_entity_txn_id,
13210: src_copy_entity_result_id,
13271: information182,
13272: object_version_number
13273: )
13274: select
13275: ben_copy_entity_results_s.nextval,
13276: copy_entity_txn_id,
13277: src_copy_entity_result_id,
13278: result_type_cd,
13279: number_of_copies,
13349: ---------------------------------------------------------------
13350: -- START OF BEN_ELIG_HRLY_SLRD_PRTE_F ----------------------
13351: ---------------------------------------------------------------
13352: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EHS') then
13353: insert into ben_copy_entity_results
13354: (
13355: copy_entity_result_id,
13356: copy_entity_txn_id,
13357: src_copy_entity_result_id,
13419: information182,
13420: object_version_number
13421: )
13422: select
13423: ben_copy_entity_results_s.nextval,
13424: copy_entity_txn_id,
13425: src_copy_entity_result_id,
13426: result_type_cd,
13427: number_of_copies,
13498: ---------------------------------------------------------------
13499: -- START OF BEN_ELIG_HRS_WKD_PRTE_F ----------------------
13500: ---------------------------------------------------------------
13501: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EHW') then
13502: insert into ben_copy_entity_results
13503: (
13504: copy_entity_result_id,
13505: copy_entity_txn_id,
13506: src_copy_entity_result_id,
13568: information182,
13569: object_version_number
13570: )
13571: select
13572: ben_copy_entity_results_s.nextval,
13573: copy_entity_txn_id,
13574: src_copy_entity_result_id,
13575: result_type_cd,
13576: number_of_copies,
13647: ---------------------------------------------------------------
13648: -- START OF BEN_ELIG_JOB_PRTE_F ----------------------
13649: ---------------------------------------------------------------
13650: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EJP') then
13651: insert into ben_copy_entity_results
13652: (
13653: copy_entity_result_id,
13654: copy_entity_txn_id,
13655: src_copy_entity_result_id,
13716: information182,
13717: object_version_number
13718: )
13719: select
13720: ben_copy_entity_results_s.nextval,
13721: copy_entity_txn_id,
13722: src_copy_entity_result_id,
13723: result_type_cd,
13724: number_of_copies,
13794: ---------------------------------------------------------------
13795: -- START OF BEN_ELIG_LBR_MMBR_PRTE_F ----------------------
13796: ---------------------------------------------------------------
13797: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ELU') then
13798: insert into ben_copy_entity_results
13799: (
13800: copy_entity_result_id,
13801: copy_entity_txn_id,
13802: src_copy_entity_result_id,
13864: information182,
13865: object_version_number
13866: )
13867: select
13868: ben_copy_entity_results_s.nextval,
13869: copy_entity_txn_id,
13870: src_copy_entity_result_id,
13871: result_type_cd,
13872: number_of_copies,
13943: ---------------------------------------------------------------
13944: -- START OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------
13945: ---------------------------------------------------------------
13946: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ELN') then
13947: insert into ben_copy_entity_results
13948: (
13949: copy_entity_result_id,
13950: copy_entity_txn_id,
13951: src_copy_entity_result_id,
14012: information182,
14013: object_version_number
14014: )
14015: select
14016: ben_copy_entity_results_s.nextval,
14017: copy_entity_txn_id,
14018: src_copy_entity_result_id,
14019: result_type_cd,
14020: number_of_copies,
14090: ---------------------------------------------------------------
14091: -- START OF BEN_ELIG_LOA_RSN_PRTE_F ----------------------
14092: ---------------------------------------------------------------
14093: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ELR') then
14094: insert into ben_copy_entity_results
14095: (
14096: copy_entity_result_id,
14097: copy_entity_txn_id,
14098: src_copy_entity_result_id,
14159: information182,
14160: object_version_number
14161: )
14162: select
14163: ben_copy_entity_results_s.nextval,
14164: copy_entity_txn_id,
14165: src_copy_entity_result_id,
14166: result_type_cd,
14167: number_of_copies,
14237: ---------------------------------------------------------------
14238: -- START OF BEN_ELIG_LOS_PRTE_F ----------------------
14239: ---------------------------------------------------------------
14240: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ELS') then
14241: insert into ben_copy_entity_results
14242: (
14243: copy_entity_result_id,
14244: copy_entity_txn_id,
14245: src_copy_entity_result_id,
14307: information182,
14308: object_version_number
14309: )
14310: select
14311: ben_copy_entity_results_s.nextval,
14312: copy_entity_txn_id,
14313: src_copy_entity_result_id,
14314: result_type_cd,
14315: number_of_copies,
14386: ---------------------------------------------------------------
14387: -- START OF BEN_ELIG_LVG_RSN_PRTE_F ----------------------
14388: ---------------------------------------------------------------
14389: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ELV') then
14390: insert into ben_copy_entity_results
14391: (
14392: copy_entity_result_id,
14393: copy_entity_txn_id,
14394: src_copy_entity_result_id,
14456: information182,
14457: object_version_number
14458: )
14459: select
14460: ben_copy_entity_results_s.nextval,
14461: copy_entity_txn_id,
14462: src_copy_entity_result_id,
14463: result_type_cd,
14464: number_of_copies,
14535: ---------------------------------------------------------------
14536: -- START OF BEN_ELIG_MLTRY_STAT_CVG_F ----------------------
14537: ---------------------------------------------------------------
14538: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EMC') then
14539: insert into ben_copy_entity_results
14540: (
14541: copy_entity_result_id,
14542: copy_entity_txn_id,
14543: src_copy_entity_result_id,
14607: information182,
14608: object_version_number
14609: )
14610: select
14611: ben_copy_entity_results_s.nextval,
14612: copy_entity_txn_id,
14613: src_copy_entity_result_id,
14614: result_type_cd,
14615: number_of_copies,
14688: ---------------------------------------------------------------
14689: -- START OF BEN_ELIG_MRTL_STAT_CVG_F ----------------------
14690: ---------------------------------------------------------------
14691: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EMS') then
14692: insert into ben_copy_entity_results
14693: (
14694: copy_entity_result_id,
14695: copy_entity_txn_id,
14696: src_copy_entity_result_id,
14760: information182,
14761: object_version_number
14762: )
14763: select
14764: ben_copy_entity_results_s.nextval,
14765: copy_entity_txn_id,
14766: src_copy_entity_result_id,
14767: result_type_cd,
14768: number_of_copies,
14841: ---------------------------------------------------------------
14842: -- START OF BEN_ELIG_MRTL_STS_PRTE_F ----------------------
14843: ---------------------------------------------------------------
14844: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EMP') then
14845: insert into ben_copy_entity_results
14846: (
14847: copy_entity_result_id,
14848: copy_entity_txn_id,
14849: src_copy_entity_result_id,
14910: information182,
14911: object_version_number
14912: )
14913: select
14914: ben_copy_entity_results_s.nextval,
14915: copy_entity_txn_id,
14916: src_copy_entity_result_id,
14917: result_type_cd,
14918: number_of_copies,
14988: ---------------------------------------------------------------
14989: -- START OF BEN_ELIG_NO_OTHR_CVG_PRTE_F ----------------------
14990: ---------------------------------------------------------------
14991: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ENO') then
14992: insert into ben_copy_entity_results
14993: (
14994: copy_entity_result_id,
14995: copy_entity_txn_id,
14996: src_copy_entity_result_id,
15056: information182,
15057: object_version_number
15058: )
15059: select
15060: ben_copy_entity_results_s.nextval,
15061: copy_entity_txn_id,
15062: src_copy_entity_result_id,
15063: result_type_cd,
15064: number_of_copies,
15133: ---------------------------------------------------------------
15134: -- START OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------
15135: ---------------------------------------------------------------
15136: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EOM') then
15137: insert into ben_copy_entity_results
15138: (
15139: copy_entity_result_id,
15140: copy_entity_txn_id,
15141: src_copy_entity_result_id,
15202: information182,
15203: object_version_number
15204: )
15205: select
15206: ben_copy_entity_results_s.nextval,
15207: copy_entity_txn_id,
15208: src_copy_entity_result_id,
15209: result_type_cd,
15210: number_of_copies,
15280: ---------------------------------------------------------------
15281: -- START OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------
15282: ---------------------------------------------------------------
15283: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EOU') then
15284: insert into ben_copy_entity_results
15285: (
15286: copy_entity_result_id,
15287: copy_entity_txn_id,
15288: src_copy_entity_result_id,
15349: information182,
15350: object_version_number
15351: )
15352: select
15353: ben_copy_entity_results_s.nextval,
15354: copy_entity_txn_id,
15355: src_copy_entity_result_id,
15356: result_type_cd,
15357: number_of_copies,
15427: ---------------------------------------------------------------
15428: -- START OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------
15429: ---------------------------------------------------------------
15430: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EOY') then
15431: insert into ben_copy_entity_results
15432: (
15433: copy_entity_result_id,
15434: copy_entity_txn_id,
15435: src_copy_entity_result_id,
15498: information182,
15499: object_version_number
15500: )
15501: select
15502: ben_copy_entity_results_s.nextval,
15503: copy_entity_txn_id,
15504: src_copy_entity_result_id,
15505: result_type_cd,
15506: number_of_copies,
15578: ---------------------------------------------------------------
15579: -- START OF BEN_ELIG_PCT_FL_TM_PRTE_F ----------------------
15580: ---------------------------------------------------------------
15581: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPF') then
15582: insert into ben_copy_entity_results
15583: (
15584: copy_entity_result_id,
15585: copy_entity_txn_id,
15586: src_copy_entity_result_id,
15648: information182,
15649: object_version_number
15650: )
15651: select
15652: ben_copy_entity_results_s.nextval,
15653: copy_entity_txn_id,
15654: src_copy_entity_result_id,
15655: result_type_cd,
15656: number_of_copies,
15727: ---------------------------------------------------------------
15728: -- START OF BEN_ELIG_PERF_RTNG_PRTE_F ----------------------
15729: ---------------------------------------------------------------
15730: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ERG') then
15731: insert into ben_copy_entity_results
15732: (
15733: copy_entity_result_id,
15734: copy_entity_txn_id,
15735: src_copy_entity_result_id,
15798: information182,
15799: object_version_number
15800: )
15801: select
15802: ben_copy_entity_results_s.nextval,
15803: copy_entity_txn_id,
15804: src_copy_entity_result_id,
15805: result_type_cd,
15806: number_of_copies,
15878: ---------------------------------------------------------------
15879: -- START OF BEN_ELIG_PER_TYP_PRTE_F ----------------------
15880: ---------------------------------------------------------------
15881: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPT') then
15882: insert into ben_copy_entity_results
15883: (
15884: copy_entity_result_id,
15885: copy_entity_txn_id,
15886: src_copy_entity_result_id,
15948: information182,
15949: object_version_number
15950: )
15951: select
15952: ben_copy_entity_results_s.nextval,
15953: copy_entity_txn_id,
15954: src_copy_entity_result_id,
15955: result_type_cd,
15956: number_of_copies,
16027: ---------------------------------------------------------------
16028: -- START OF BEN_ELIG_PPL_GRP_PRTE_F ----------------------
16029: ---------------------------------------------------------------
16030: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPG') then
16031: insert into ben_copy_entity_results
16032: (
16033: copy_entity_result_id,
16034: copy_entity_txn_id,
16035: src_copy_entity_result_id,
16097: information182,
16098: object_version_number
16099: )
16100: select
16101: ben_copy_entity_results_s.nextval,
16102: copy_entity_txn_id,
16103: src_copy_entity_result_id,
16104: result_type_cd,
16105: number_of_copies,
16176: ---------------------------------------------------------------
16177: -- START OF BEN_ELIG_PRBTN_PERD_PRTE_F ----------------------
16178: ---------------------------------------------------------------
16179: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPN') then
16180: insert into ben_copy_entity_results
16181: (
16182: copy_entity_result_id,
16183: copy_entity_txn_id,
16184: src_copy_entity_result_id,
16247: information182,
16248: object_version_number
16249: )
16250: select
16251: ben_copy_entity_results_s.nextval,
16252: copy_entity_txn_id,
16253: src_copy_entity_result_id,
16254: result_type_cd,
16255: number_of_copies,
16327: ---------------------------------------------------------------
16328: -- START OF BEN_ELIG_PRTT_ANTHR_PGM_F ----------------------
16329: ---------------------------------------------------------------
16330: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EAG') then
16331: insert into ben_copy_entity_results
16332: (
16333: copy_entity_result_id,
16334: copy_entity_txn_id,
16335: src_copy_entity_result_id,
16397: information182,
16398: object_version_number
16399: )
16400: select
16401: ben_copy_entity_results_s.nextval,
16402: copy_entity_txn_id,
16403: src_copy_entity_result_id,
16404: result_type_cd,
16405: number_of_copies,
16476: ---------------------------------------------------------------
16477: -- START OF BEN_ELIG_PRTT_ANTHR_PL_PRTE_F ----------------------
16478: ---------------------------------------------------------------
16479: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPP') then
16480: insert into ben_copy_entity_results
16481: (
16482: copy_entity_result_id,
16483: copy_entity_txn_id,
16484: src_copy_entity_result_id,
16546: information182,
16547: object_version_number
16548: )
16549: select
16550: ben_copy_entity_results_s.nextval,
16551: copy_entity_txn_id,
16552: src_copy_entity_result_id,
16553: result_type_cd,
16554: number_of_copies,
16625: ---------------------------------------------------------------
16626: -- START OF BEN_ELIG_PSTL_CD_R_RNG_CVG_F ----------------------
16627: ---------------------------------------------------------------
16628: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPL') then
16629: insert into ben_copy_entity_results
16630: (
16631: copy_entity_result_id,
16632: copy_entity_txn_id,
16633: src_copy_entity_result_id,
16695: information182,
16696: object_version_number
16697: )
16698: select
16699: ben_copy_entity_results_s.nextval,
16700: copy_entity_txn_id,
16701: src_copy_entity_result_id,
16702: result_type_cd,
16703: number_of_copies,
16774: ---------------------------------------------------------------
16775: -- START OF BEN_ELIG_PSTL_CD_R_RNG_PRTE_F ----------------------
16776: ---------------------------------------------------------------
16777: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPZ') then
16778: insert into ben_copy_entity_results
16779: (
16780: copy_entity_result_id,
16781: copy_entity_txn_id,
16782: src_copy_entity_result_id,
16844: information182,
16845: object_version_number
16846: )
16847: select
16848: ben_copy_entity_results_s.nextval,
16849: copy_entity_txn_id,
16850: src_copy_entity_result_id,
16851: result_type_cd,
16852: number_of_copies,
16923: ---------------------------------------------------------------
16924: -- START OF BEN_ELIG_PSTN_PRTE_F ----------------------
16925: ---------------------------------------------------------------
16926: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPS') then
16927: insert into ben_copy_entity_results
16928: (
16929: copy_entity_result_id,
16930: copy_entity_txn_id,
16931: src_copy_entity_result_id,
16992: information182,
16993: object_version_number
16994: )
16995: select
16996: ben_copy_entity_results_s.nextval,
16997: copy_entity_txn_id,
16998: src_copy_entity_result_id,
16999: result_type_cd,
17000: number_of_copies,
17070: ---------------------------------------------------------------
17071: -- START OF BEN_ELIG_PYRL_PRTE_F ----------------------
17072: ---------------------------------------------------------------
17073: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPY') then
17074: insert into ben_copy_entity_results
17075: (
17076: copy_entity_result_id,
17077: copy_entity_txn_id,
17078: src_copy_entity_result_id,
17139: information182,
17140: object_version_number
17141: )
17142: select
17143: ben_copy_entity_results_s.nextval,
17144: copy_entity_txn_id,
17145: src_copy_entity_result_id,
17146: result_type_cd,
17147: number_of_copies,
17217: ---------------------------------------------------------------
17218: -- START OF BEN_ELIG_PY_BSS_PRTE_F ----------------------
17219: ---------------------------------------------------------------
17220: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPB') then
17221: insert into ben_copy_entity_results
17222: (
17223: copy_entity_result_id,
17224: copy_entity_txn_id,
17225: src_copy_entity_result_id,
17286: information182,
17287: object_version_number
17288: )
17289: select
17290: ben_copy_entity_results_s.nextval,
17291: copy_entity_txn_id,
17292: src_copy_entity_result_id,
17293: result_type_cd,
17294: number_of_copies,
17364: ---------------------------------------------------------------
17365: -- START OF BEN_ELIG_QUAL_TITL_PRTE_F ----------------------
17366: ---------------------------------------------------------------
17367: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EQT') then
17368: insert into ben_copy_entity_results
17369: (
17370: copy_entity_result_id,
17371: copy_entity_txn_id,
17372: src_copy_entity_result_id,
17434: information182,
17435: object_version_number
17436: )
17437: select
17438: ben_copy_entity_results_s.nextval,
17439: copy_entity_txn_id,
17440: src_copy_entity_result_id,
17441: result_type_cd,
17442: number_of_copies,
17513: ---------------------------------------------------------------
17514: -- START OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------
17515: ---------------------------------------------------------------
17516: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EQG') then
17517: insert into ben_copy_entity_results
17518: (
17519: copy_entity_result_id,
17520: copy_entity_txn_id,
17521: src_copy_entity_result_id,
17583: information182,
17584: object_version_number
17585: )
17586: select
17587: ben_copy_entity_results_s.nextval,
17588: copy_entity_txn_id,
17589: src_copy_entity_result_id,
17590: result_type_cd,
17591: number_of_copies,
17662: ---------------------------------------------------------------
17663: -- START OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------
17664: ---------------------------------------------------------------
17665: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ESH') then
17666: insert into ben_copy_entity_results
17667: (
17668: copy_entity_result_id,
17669: copy_entity_txn_id,
17670: src_copy_entity_result_id,
17739: information182,
17740: object_version_number
17741: )
17742: select
17743: ben_copy_entity_results_s.nextval,
17744: copy_entity_txn_id,
17745: src_copy_entity_result_id,
17746: result_type_cd,
17747: number_of_copies,
17825: ---------------------------------------------------------------
17826: -- START OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------
17827: ---------------------------------------------------------------
17828: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ESP') then
17829: insert into ben_copy_entity_results
17830: (
17831: copy_entity_result_id,
17832: copy_entity_txn_id,
17833: src_copy_entity_result_id,
17894: information182,
17895: object_version_number
17896: )
17897: select
17898: ben_copy_entity_results_s.nextval,
17899: copy_entity_txn_id,
17900: src_copy_entity_result_id,
17901: result_type_cd,
17902: number_of_copies,
17972: ---------------------------------------------------------------
17973: -- START OF BEN_ELIG_STDNT_STAT_CVG_F ----------------------
17974: ---------------------------------------------------------------
17975: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ESC') then
17976: insert into ben_copy_entity_results
17977: (
17978: copy_entity_result_id,
17979: copy_entity_txn_id,
17980: src_copy_entity_result_id,
18044: information182,
18045: object_version_number
18046: )
18047: select
18048: ben_copy_entity_results_s.nextval,
18049: copy_entity_txn_id,
18050: src_copy_entity_result_id,
18051: result_type_cd,
18052: number_of_copies,
18125: ---------------------------------------------------------------
18126: -- START OF BEN_ELIG_SUPPL_ROLE_PRTE_F ----------------------
18127: ---------------------------------------------------------------
18128: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EST') then
18129: insert into ben_copy_entity_results
18130: (
18131: copy_entity_result_id,
18132: copy_entity_txn_id,
18133: src_copy_entity_result_id,
18194: information182,
18195: object_version_number
18196: )
18197: select
18198: ben_copy_entity_results_s.nextval,
18199: copy_entity_txn_id,
18200: src_copy_entity_result_id,
18201: result_type_cd,
18202: number_of_copies,
18272: ---------------------------------------------------------------
18273: -- START OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------
18274: ---------------------------------------------------------------
18275: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ESA') then
18276: insert into ben_copy_entity_results
18277: (
18278: copy_entity_result_id,
18279: copy_entity_txn_id,
18280: src_copy_entity_result_id,
18342: information182,
18343: object_version_number
18344: )
18345: select
18346: ben_copy_entity_results_s.nextval,
18347: copy_entity_txn_id,
18348: src_copy_entity_result_id,
18349: result_type_cd,
18350: number_of_copies,
18421: ---------------------------------------------------------------
18422: -- START OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------
18423: ---------------------------------------------------------------
18424: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ETU') then
18425: insert into ben_copy_entity_results
18426: (
18427: copy_entity_result_id,
18428: copy_entity_txn_id,
18429: src_copy_entity_result_id,
18491: information182,
18492: object_version_number
18493: )
18494: select
18495: ben_copy_entity_results_s.nextval,
18496: copy_entity_txn_id,
18497: src_copy_entity_result_id,
18498: result_type_cd,
18499: number_of_copies,
18570: ---------------------------------------------------------------
18571: -- START OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
18572: ---------------------------------------------------------------
18573: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PEO') then
18574: insert into ben_copy_entity_results
18575: (
18576: copy_entity_result_id,
18577: copy_entity_txn_id,
18578: src_copy_entity_result_id,
18662: information182,
18663: object_version_number
18664: )
18665: select
18666: ben_copy_entity_results_s.nextval,
18667: copy_entity_txn_id,
18668: src_copy_entity_result_id,
18669: result_type_cd,
18670: number_of_copies,
18763: ---------------------------------------------------------------
18764: -- START OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------
18765: ---------------------------------------------------------------
18766: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ETC') then
18767: insert into ben_copy_entity_results
18768: (
18769: copy_entity_result_id,
18770: copy_entity_txn_id,
18771: src_copy_entity_result_id,
18838: information182,
18839: object_version_number
18840: )
18841: select
18842: ben_copy_entity_results_s.nextval,
18843: copy_entity_txn_id,
18844: src_copy_entity_result_id,
18845: result_type_cd,
18846: number_of_copies,
18922: ---------------------------------------------------------------
18923: -- START OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------
18924: ---------------------------------------------------------------
18925: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ETP') then
18926: insert into ben_copy_entity_results
18927: (
18928: copy_entity_result_id,
18929: copy_entity_txn_id,
18930: src_copy_entity_result_id,
18997: information182,
18998: object_version_number
18999: )
19000: select
19001: ben_copy_entity_results_s.nextval,
19002: copy_entity_txn_id,
19003: src_copy_entity_result_id,
19004: result_type_cd,
19005: number_of_copies,
19081: ---------------------------------------------------------------
19082: -- START OF BEN_ELIG_WK_LOC_PRTE_F ----------------------
19083: ---------------------------------------------------------------
19084: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EWL') then
19085: insert into ben_copy_entity_results
19086: (
19087: copy_entity_result_id,
19088: copy_entity_txn_id,
19089: src_copy_entity_result_id,
19150: information182,
19151: object_version_number
19152: )
19153: select
19154: ben_copy_entity_results_s.nextval,
19155: copy_entity_txn_id,
19156: src_copy_entity_result_id,
19157: result_type_cd,
19158: number_of_copies,
19228: ---------------------------------------------------------------
19229: -- START OF BEN_ENRLD_ANTHR_OIPL_RT_F ----------------------
19230: ---------------------------------------------------------------
19231: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EAO') then
19232: insert into ben_copy_entity_results
19233: (
19234: copy_entity_result_id,
19235: copy_entity_txn_id,
19236: src_copy_entity_result_id,
19299: information182,
19300: object_version_number
19301: )
19302: select
19303: ben_copy_entity_results_s.nextval,
19304: copy_entity_txn_id,
19305: src_copy_entity_result_id,
19306: result_type_cd,
19307: number_of_copies,
19379: ---------------------------------------------------------------
19380: -- START OF BEN_ENRLD_ANTHR_PGM_RT_F ----------------------
19381: ---------------------------------------------------------------
19382: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPM') then
19383: insert into ben_copy_entity_results
19384: (
19385: copy_entity_result_id,
19386: copy_entity_txn_id,
19387: src_copy_entity_result_id,
19450: information182,
19451: object_version_number
19452: )
19453: select
19454: ben_copy_entity_results_s.nextval,
19455: copy_entity_txn_id,
19456: src_copy_entity_result_id,
19457: result_type_cd,
19458: number_of_copies,
19530: ---------------------------------------------------------------
19531: -- START OF BEN_ENRLD_ANTHR_PLIP_RT_F ----------------------
19532: ---------------------------------------------------------------
19533: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EAR') then
19534: insert into ben_copy_entity_results
19535: (
19536: copy_entity_result_id,
19537: copy_entity_txn_id,
19538: src_copy_entity_result_id,
19601: information182,
19602: object_version_number
19603: )
19604: select
19605: ben_copy_entity_results_s.nextval,
19606: copy_entity_txn_id,
19607: src_copy_entity_result_id,
19608: result_type_cd,
19609: number_of_copies,
19681: ---------------------------------------------------------------
19682: -- START OF BEN_ENRLD_ANTHR_PL_RT_F ----------------------
19683: ---------------------------------------------------------------
19684: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ENL') then
19685: insert into ben_copy_entity_results
19686: (
19687: copy_entity_result_id,
19688: copy_entity_txn_id,
19689: src_copy_entity_result_id,
19752: information182,
19753: object_version_number
19754: )
19755: select
19756: ben_copy_entity_results_s.nextval,
19757: copy_entity_txn_id,
19758: src_copy_entity_result_id,
19759: result_type_cd,
19760: number_of_copies,
19832: ---------------------------------------------------------------
19833: -- START OF BEN_ENRLD_ANTHR_PTIP_RT_F ----------------------
19834: ---------------------------------------------------------------
19835: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ENT') then
19836: insert into ben_copy_entity_results
19837: (
19838: copy_entity_result_id,
19839: copy_entity_txn_id,
19840: src_copy_entity_result_id,
19904: information182,
19905: object_version_number
19906: )
19907: select
19908: ben_copy_entity_results_s.nextval,
19909: copy_entity_txn_id,
19910: src_copy_entity_result_id,
19911: result_type_cd,
19912: number_of_copies,
19985: ---------------------------------------------------------------
19986: -- START OF BEN_ENRT_CTFN_F ----------------------
19987: ---------------------------------------------------------------
19988: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ECF') then
19989: insert into ben_copy_entity_results
19990: (
19991: copy_entity_result_id,
19992: copy_entity_txn_id,
19993: src_copy_entity_result_id,
20057: information182,
20058: object_version_number
20059: )
20060: select
20061: ben_copy_entity_results_s.nextval,
20062: copy_entity_txn_id,
20063: src_copy_entity_result_id,
20064: result_type_cd,
20065: number_of_copies,
20138: ---------------------------------------------------------------
20139: -- START OF BEN_ENRT_PERD ----------------------
20140: ---------------------------------------------------------------
20141: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ENP') then
20142: insert into ben_copy_entity_results
20143: (
20144: copy_entity_result_id,
20145: copy_entity_txn_id,
20146: src_copy_entity_result_id,
20237: information182,
20238: object_version_number
20239: )
20240: select
20241: ben_copy_entity_results_s.nextval,
20242: copy_entity_txn_id,
20243: src_copy_entity_result_id,
20244: result_type_cd,
20245: number_of_copies,
20345: ---------------------------------------------------------------
20346: -- START OF BEN_ENRT_PERD_FOR_PL_F ----------------------
20347: ---------------------------------------------------------------
20348: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('ERP') then
20349: insert into ben_copy_entity_results
20350: (
20351: copy_entity_result_id,
20352: copy_entity_txn_id,
20353: src_copy_entity_result_id,
20422: information182,
20423: object_version_number
20424: )
20425: select
20426: ben_copy_entity_results_s.nextval,
20427: copy_entity_txn_id,
20428: src_copy_entity_result_id,
20429: result_type_cd,
20430: number_of_copies,
20508: ---------------------------------------------------------------
20509: -- START OF BEN_EXTRA_INPUT_VALUES ----------------------
20510: ---------------------------------------------------------------
20511: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EIV') then
20512: insert into ben_copy_entity_results
20513: (
20514: copy_entity_result_id,
20515: copy_entity_txn_id,
20516: src_copy_entity_result_id,
20579: information182,
20580: object_version_number
20581: )
20582: select
20583: ben_copy_entity_results_s.nextval,
20584: copy_entity_txn_id,
20585: src_copy_entity_result_id,
20586: result_type_cd,
20587: number_of_copies,
20659: ---------------------------------------------------------------
20660: -- START OF BEN_FL_TM_PT_TM_RT_F ----------------------
20661: ---------------------------------------------------------------
20662: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('FTR') then
20663: insert into ben_copy_entity_results
20664: (
20665: copy_entity_result_id,
20666: copy_entity_txn_id,
20667: src_copy_entity_result_id,
20729: information182,
20730: object_version_number
20731: )
20732: select
20733: ben_copy_entity_results_s.nextval,
20734: copy_entity_txn_id,
20735: src_copy_entity_result_id,
20736: result_type_cd,
20737: number_of_copies,
20808: ---------------------------------------------------------------
20809: -- START OF BEN_GD_OR_SVC_TYP ----------------------
20810: ---------------------------------------------------------------
20811: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('GOS') then
20812: insert into ben_copy_entity_results
20813: (
20814: copy_entity_result_id,
20815: copy_entity_txn_id,
20816: src_copy_entity_result_id,
20877: information182,
20878: object_version_number
20879: )
20880: select
20881: ben_copy_entity_results_s.nextval,
20882: copy_entity_txn_id,
20883: src_copy_entity_result_id,
20884: result_type_cd,
20885: number_of_copies,
20955: ---------------------------------------------------------------
20956: -- START OF BEN_GNDR_RT_F ----------------------
20957: ---------------------------------------------------------------
20958: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('GNR') then
20959: insert into ben_copy_entity_results
20960: (
20961: copy_entity_result_id,
20962: copy_entity_txn_id,
20963: src_copy_entity_result_id,
21025: information182,
21026: object_version_number
21027: )
21028: select
21029: ben_copy_entity_results_s.nextval,
21030: copy_entity_txn_id,
21031: src_copy_entity_result_id,
21032: result_type_cd,
21033: number_of_copies,
21104: ---------------------------------------------------------------
21105: -- START OF BEN_GRADE_RT_F ----------------------
21106: ---------------------------------------------------------------
21107: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('GRR') then
21108: insert into ben_copy_entity_results
21109: (
21110: copy_entity_result_id,
21111: copy_entity_txn_id,
21112: src_copy_entity_result_id,
21173: information182,
21174: object_version_number
21175: )
21176: select
21177: ben_copy_entity_results_s.nextval,
21178: copy_entity_txn_id,
21179: src_copy_entity_result_id,
21180: result_type_cd,
21181: number_of_copies,
21251: ---------------------------------------------------------------
21252: -- START OF BEN_HRLY_SLRD_RT_F ----------------------
21253: ---------------------------------------------------------------
21254: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('HSR') then
21255: insert into ben_copy_entity_results
21256: (
21257: copy_entity_result_id,
21258: copy_entity_txn_id,
21259: src_copy_entity_result_id,
21321: information182,
21322: object_version_number
21323: )
21324: select
21325: ben_copy_entity_results_s.nextval,
21326: copy_entity_txn_id,
21327: src_copy_entity_result_id,
21328: result_type_cd,
21329: number_of_copies,
21400: ---------------------------------------------------------------
21401: -- START OF BEN_HRS_WKD_IN_PERD_FCTR ----------------------
21402: ---------------------------------------------------------------
21403: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('HWF') then
21404: insert into ben_copy_entity_results
21405: (
21406: copy_entity_result_id,
21407: copy_entity_txn_id,
21408: src_copy_entity_result_id,
21482: information182,
21483: object_version_number
21484: )
21485: select
21486: ben_copy_entity_results_s.nextval,
21487: copy_entity_txn_id,
21488: src_copy_entity_result_id,
21489: result_type_cd,
21490: number_of_copies,
21573: ---------------------------------------------------------------
21574: -- START OF BEN_HRS_WKD_IN_PERD_RT_F ----------------------
21575: ---------------------------------------------------------------
21576: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('HWR') then
21577: insert into ben_copy_entity_results
21578: (
21579: copy_entity_result_id,
21580: copy_entity_txn_id,
21581: src_copy_entity_result_id,
21643: information182,
21644: object_version_number
21645: )
21646: select
21647: ben_copy_entity_results_s.nextval,
21648: copy_entity_txn_id,
21649: src_copy_entity_result_id,
21650: result_type_cd,
21651: number_of_copies,
21722: ---------------------------------------------------------------
21723: -- START OF BEN_JOB_RT_F ----------------------
21724: ---------------------------------------------------------------
21725: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('JRT') then
21726: insert into ben_copy_entity_results
21727: (
21728: copy_entity_result_id,
21729: copy_entity_txn_id,
21730: src_copy_entity_result_id,
21791: information182,
21792: object_version_number
21793: )
21794: select
21795: ben_copy_entity_results_s.nextval,
21796: copy_entity_txn_id,
21797: src_copy_entity_result_id,
21798: result_type_cd,
21799: number_of_copies,
21869: ---------------------------------------------------------------
21870: -- START OF BEN_LBR_MMBR_RT_F ----------------------
21871: ---------------------------------------------------------------
21872: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LMM') then
21873: insert into ben_copy_entity_results
21874: (
21875: copy_entity_result_id,
21876: copy_entity_txn_id,
21877: src_copy_entity_result_id,
21939: information182,
21940: object_version_number
21941: )
21942: select
21943: ben_copy_entity_results_s.nextval,
21944: copy_entity_txn_id,
21945: src_copy_entity_result_id,
21946: result_type_cd,
21947: number_of_copies,
22018: ---------------------------------------------------------------
22019: -- START OF BEN_LEE_RSN_F ----------------------
22020: ---------------------------------------------------------------
22021: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LEN') then
22022: insert into ben_copy_entity_results
22023: (
22024: copy_entity_result_id,
22025: copy_entity_txn_id,
22026: src_copy_entity_result_id,
22104: information182,
22105: object_version_number
22106: )
22107: select
22108: ben_copy_entity_results_s.nextval,
22109: copy_entity_txn_id,
22110: src_copy_entity_result_id,
22111: result_type_cd,
22112: number_of_copies,
22199: ---------------------------------------------------------------
22200: -- START OF BEN_LEE_RSN_RL_F ----------------------
22201: ---------------------------------------------------------------
22202: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LRR') then
22203: insert into ben_copy_entity_results
22204: (
22205: copy_entity_result_id,
22206: copy_entity_txn_id,
22207: src_copy_entity_result_id,
22268: information182,
22269: object_version_number
22270: )
22271: select
22272: ben_copy_entity_results_s.nextval,
22273: copy_entity_txn_id,
22274: src_copy_entity_result_id,
22275: result_type_cd,
22276: number_of_copies,
22346: ---------------------------------------------------------------
22347: -- START OF BEN_LER_BNFT_RSTRN_CTFN_F ----------------------
22348: ---------------------------------------------------------------
22349: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LBC') then
22350: insert into ben_copy_entity_results
22351: (
22352: copy_entity_result_id,
22353: copy_entity_txn_id,
22354: src_copy_entity_result_id,
22416: information182,
22417: object_version_number
22418: )
22419: select
22420: ben_copy_entity_results_s.nextval,
22421: copy_entity_txn_id,
22422: src_copy_entity_result_id,
22423: result_type_cd,
22424: number_of_copies,
22495: ---------------------------------------------------------------
22496: -- START OF BEN_LER_BNFT_RSTRN_F ----------------------
22497: ---------------------------------------------------------------
22498: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LBR') then
22499: insert into ben_copy_entity_results
22500: (
22501: copy_entity_result_id,
22502: copy_entity_txn_id,
22503: src_copy_entity_result_id,
22581: information182,
22582: object_version_number
22583: )
22584: select
22585: ben_copy_entity_results_s.nextval,
22586: copy_entity_txn_id,
22587: src_copy_entity_result_id,
22588: result_type_cd,
22589: number_of_copies,
22676: ---------------------------------------------------------------
22677: -- START OF BEN_LER_CHG_DPNT_CVG_CTFN_F ----------------------
22678: ---------------------------------------------------------------
22679: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LCC') then
22680: insert into ben_copy_entity_results
22681: (
22682: copy_entity_result_id,
22683: copy_entity_txn_id,
22684: src_copy_entity_result_id,
22748: information182,
22749: object_version_number
22750: )
22751: select
22752: ben_copy_entity_results_s.nextval,
22753: copy_entity_txn_id,
22754: src_copy_entity_result_id,
22755: result_type_cd,
22756: number_of_copies,
22829: ---------------------------------------------------------------
22830: -- START OF BEN_LER_CHG_DPNT_CVG_F ----------------------
22831: ---------------------------------------------------------------
22832: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LDC') then
22833: insert into ben_copy_entity_results
22834: (
22835: copy_entity_result_id,
22836: copy_entity_txn_id,
22837: src_copy_entity_result_id,
22906: information182,
22907: object_version_number
22908: )
22909: select
22910: ben_copy_entity_results_s.nextval,
22911: copy_entity_txn_id,
22912: src_copy_entity_result_id,
22913: result_type_cd,
22914: number_of_copies,
22992: ---------------------------------------------------------------
22993: -- START OF BEN_LER_CHG_OIPL_ENRT_F ----------------------
22994: ---------------------------------------------------------------
22995: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LOP') then
22996: insert into ben_copy_entity_results
22997: (
22998: copy_entity_result_id,
22999: copy_entity_txn_id,
23000: src_copy_entity_result_id,
23069: information182,
23070: object_version_number
23071: )
23072: select
23073: ben_copy_entity_results_s.nextval,
23074: copy_entity_txn_id,
23075: src_copy_entity_result_id,
23076: result_type_cd,
23077: number_of_copies,
23155: ---------------------------------------------------------------
23156: -- START OF BEN_LER_CHG_PGM_ENRT_F ----------------------
23157: ---------------------------------------------------------------
23158: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LGE') then
23159: insert into ben_copy_entity_results
23160: (
23161: copy_entity_result_id,
23162: copy_entity_txn_id,
23163: src_copy_entity_result_id,
23231: information182,
23232: object_version_number
23233: )
23234: select
23235: ben_copy_entity_results_s.nextval,
23236: copy_entity_txn_id,
23237: src_copy_entity_result_id,
23238: result_type_cd,
23239: number_of_copies,
23316: ---------------------------------------------------------------
23317: -- START OF BEN_LER_CHG_PLIP_ENRT_F ----------------------
23318: ---------------------------------------------------------------
23319: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LPR1') then
23320: insert into ben_copy_entity_results
23321: (
23322: copy_entity_result_id,
23323: copy_entity_txn_id,
23324: src_copy_entity_result_id,
23394: information182,
23395: object_version_number
23396: )
23397: select
23398: ben_copy_entity_results_s.nextval,
23399: copy_entity_txn_id,
23400: src_copy_entity_result_id,
23401: result_type_cd,
23402: number_of_copies,
23481: ---------------------------------------------------------------
23482: -- START OF BEN_LER_CHG_PL_NIP_ENRT_F ----------------------
23483: ---------------------------------------------------------------
23484: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LPE') then
23485: insert into ben_copy_entity_results
23486: (
23487: copy_entity_result_id,
23488: copy_entity_txn_id,
23489: src_copy_entity_result_id,
23559: information182,
23560: object_version_number
23561: )
23562: select
23563: ben_copy_entity_results_s.nextval,
23564: copy_entity_txn_id,
23565: src_copy_entity_result_id,
23566: result_type_cd,
23567: number_of_copies,
23646: ---------------------------------------------------------------
23647: -- START OF BEN_LER_CHG_PTIP_ENRT_F ----------------------
23648: ---------------------------------------------------------------
23649: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LCT') then
23650: insert into ben_copy_entity_results
23651: (
23652: copy_entity_result_id,
23653: copy_entity_txn_id,
23654: src_copy_entity_result_id,
23723: information182,
23724: object_version_number
23725: )
23726: select
23727: ben_copy_entity_results_s.nextval,
23728: copy_entity_txn_id,
23729: src_copy_entity_result_id,
23730: result_type_cd,
23731: number_of_copies,
23809: ---------------------------------------------------------------
23810: -- START OF BEN_LER_ENRT_CTFN_F ----------------------
23811: ---------------------------------------------------------------
23812: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LNC') then
23813: insert into ben_copy_entity_results
23814: (
23815: copy_entity_result_id,
23816: copy_entity_txn_id,
23817: src_copy_entity_result_id,
23879: information182,
23880: object_version_number
23881: )
23882: select
23883: ben_copy_entity_results_s.nextval,
23884: copy_entity_txn_id,
23885: src_copy_entity_result_id,
23886: result_type_cd,
23887: number_of_copies,
23958: ---------------------------------------------------------------
23959: -- START OF BEN_LER_F ----------------------
23960: ---------------------------------------------------------------
23961: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LER') then
23962: insert into ben_copy_entity_results
23963: (
23964: copy_entity_result_id,
23965: copy_entity_txn_id,
23966: src_copy_entity_result_id,
24044: information182,
24045: object_version_number
24046: )
24047: select
24048: ben_copy_entity_results_s.nextval,
24049: copy_entity_txn_id,
24050: src_copy_entity_result_id,
24051: result_type_cd,
24052: number_of_copies,
24139: ---------------------------------------------------------------
24140: -- START OF BEN_LER_PER_INFO_CS_LER_F ----------------------
24141: ---------------------------------------------------------------
24142: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LPL') then
24143: insert into ben_copy_entity_results
24144: (
24145: copy_entity_result_id,
24146: copy_entity_txn_id,
24147: src_copy_entity_result_id,
24208: information182,
24209: object_version_number
24210: )
24211: select
24212: ben_copy_entity_results_s.nextval,
24213: copy_entity_txn_id,
24214: src_copy_entity_result_id,
24215: result_type_cd,
24216: number_of_copies,
24286: ---------------------------------------------------------------
24287: -- START OF BEN_LER_RLTD_PER_CS_LER_F ----------------------
24288: ---------------------------------------------------------------
24289: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LRC') then
24290: insert into ben_copy_entity_results
24291: (
24292: copy_entity_result_id,
24293: copy_entity_txn_id,
24294: src_copy_entity_result_id,
24355: information182,
24356: object_version_number
24357: )
24358: select
24359: ben_copy_entity_results_s.nextval,
24360: copy_entity_txn_id,
24361: src_copy_entity_result_id,
24362: result_type_cd,
24363: number_of_copies,
24433: ---------------------------------------------------------------
24434: -- START OF BEN_LER_RQRS_ENRT_CTFN_F ----------------------
24435: ---------------------------------------------------------------
24436: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LRE') then
24437: insert into ben_copy_entity_results
24438: (
24439: copy_entity_result_id,
24440: copy_entity_txn_id,
24441: src_copy_entity_result_id,
24505: information182,
24506: object_version_number
24507: )
24508: select
24509: ben_copy_entity_results_s.nextval,
24510: copy_entity_txn_id,
24511: src_copy_entity_result_id,
24512: result_type_cd,
24513: number_of_copies,
24586: ---------------------------------------------------------------
24587: -- START OF BEN_LGL_ENTY_RT_F ----------------------
24588: ---------------------------------------------------------------
24589: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LER1') then
24590: insert into ben_copy_entity_results
24591: (
24592: copy_entity_result_id,
24593: copy_entity_txn_id,
24594: src_copy_entity_result_id,
24655: information182,
24656: object_version_number
24657: )
24658: select
24659: ben_copy_entity_results_s.nextval,
24660: copy_entity_txn_id,
24661: src_copy_entity_result_id,
24662: result_type_cd,
24663: number_of_copies,
24733: ---------------------------------------------------------------
24734: -- START OF BEN_LOA_RSN_RT_F ----------------------
24735: ---------------------------------------------------------------
24736: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LAR') then
24737: insert into ben_copy_entity_results
24738: (
24739: copy_entity_result_id,
24740: copy_entity_txn_id,
24741: src_copy_entity_result_id,
24803: information182,
24804: object_version_number
24805: )
24806: select
24807: ben_copy_entity_results_s.nextval,
24808: copy_entity_txn_id,
24809: src_copy_entity_result_id,
24810: result_type_cd,
24811: number_of_copies,
24882: ---------------------------------------------------------------
24883: -- START OF BEN_LOS_FCTR ----------------------
24884: ---------------------------------------------------------------
24885: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LSF') then
24886: insert into ben_copy_entity_results
24887: (
24888: copy_entity_result_id,
24889: copy_entity_txn_id,
24890: src_copy_entity_result_id,
24964: information182,
24965: object_version_number
24966: )
24967: select
24968: ben_copy_entity_results_s.nextval,
24969: copy_entity_txn_id,
24970: src_copy_entity_result_id,
24971: result_type_cd,
24972: number_of_copies,
25055: ---------------------------------------------------------------
25056: -- START OF BEN_LOS_RT_F ----------------------
25057: ---------------------------------------------------------------
25058: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LSR') then
25059: insert into ben_copy_entity_results
25060: (
25061: copy_entity_result_id,
25062: copy_entity_txn_id,
25063: src_copy_entity_result_id,
25125: information182,
25126: object_version_number
25127: )
25128: select
25129: ben_copy_entity_results_s.nextval,
25130: copy_entity_txn_id,
25131: src_copy_entity_result_id,
25132: result_type_cd,
25133: number_of_copies,
25204: ---------------------------------------------------------------
25205: -- START OF BEN_LVG_RSN_RT_F ----------------------
25206: ---------------------------------------------------------------
25207: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('LRN') then
25208: insert into ben_copy_entity_results
25209: (
25210: copy_entity_result_id,
25211: copy_entity_txn_id,
25212: src_copy_entity_result_id,
25274: information182,
25275: object_version_number
25276: )
25277: select
25278: ben_copy_entity_results_s.nextval,
25279: copy_entity_txn_id,
25280: src_copy_entity_result_id,
25281: result_type_cd,
25282: number_of_copies,
25353: ---------------------------------------------------------------
25354: -- START OF BEN_MTCHG_RT_F ----------------------
25355: ---------------------------------------------------------------
25356: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('MTR') then
25357: insert into ben_copy_entity_results
25358: (
25359: copy_entity_result_id,
25360: copy_entity_txn_id,
25361: src_copy_entity_result_id,
25434: information182,
25435: object_version_number
25436: )
25437: select
25438: ben_copy_entity_results_s.nextval,
25439: copy_entity_txn_id,
25440: src_copy_entity_result_id,
25441: result_type_cd,
25442: number_of_copies,
25524: ---------------------------------------------------------------
25525: -- START OF BEN_NO_OTHR_CVG_RT_F ----------------------
25526: ---------------------------------------------------------------
25527: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('NOC') then
25528: insert into ben_copy_entity_results
25529: (
25530: copy_entity_result_id,
25531: copy_entity_txn_id,
25532: src_copy_entity_result_id,
25592: information182,
25593: object_version_number
25594: )
25595: select
25596: ben_copy_entity_results_s.nextval,
25597: copy_entity_txn_id,
25598: src_copy_entity_result_id,
25599: result_type_cd,
25600: number_of_copies,
25669: ---------------------------------------------------------------
25670: -- START OF BEN_OIPLIP_F ----------------------
25671: ---------------------------------------------------------------
25672: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('OPP') then
25673: insert into ben_copy_entity_results
25674: (
25675: copy_entity_result_id,
25676: copy_entity_txn_id,
25677: src_copy_entity_result_id,
25737: information182,
25738: object_version_number
25739: )
25740: select
25741: ben_copy_entity_results_s.nextval,
25742: copy_entity_txn_id,
25743: src_copy_entity_result_id,
25744: result_type_cd,
25745: number_of_copies,
25814: ---------------------------------------------------------------
25815: -- START OF BEN_OIPL_F ----------------------
25816: ---------------------------------------------------------------
25817: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('COP') then
25818: insert into ben_copy_entity_results
25819: (
25820: copy_entity_result_id,
25821: copy_entity_txn_id,
25822: src_copy_entity_result_id,
25913: information182,
25914: object_version_number
25915: )
25916: select
25917: ben_copy_entity_results_s.nextval,
25918: copy_entity_txn_id,
25919: src_copy_entity_result_id,
25920: result_type_cd,
25921: number_of_copies,
26021: ---------------------------------------------------------------
26022: -- START OF BEN_OPTD_MDCR_RT_F ----------------------
26023: ---------------------------------------------------------------
26024: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('OMR') then
26025: insert into ben_copy_entity_results
26026: (
26027: copy_entity_result_id,
26028: copy_entity_txn_id,
26029: src_copy_entity_result_id,
26090: information182,
26091: object_version_number
26092: )
26093: select
26094: ben_copy_entity_results_s.nextval,
26095: copy_entity_txn_id,
26096: src_copy_entity_result_id,
26097: result_type_cd,
26098: number_of_copies,
26168: ---------------------------------------------------------------
26169: -- START OF BEN_OPTIP_F ----------------------
26170: ---------------------------------------------------------------
26171: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('OTP') then
26172: insert into ben_copy_entity_results
26173: (
26174: copy_entity_result_id,
26175: copy_entity_txn_id,
26176: src_copy_entity_result_id,
26239: information182,
26240: object_version_number
26241: )
26242: select
26243: ben_copy_entity_results_s.nextval,
26244: copy_entity_txn_id,
26245: src_copy_entity_result_id,
26246: result_type_cd,
26247: number_of_copies,
26319: ---------------------------------------------------------------
26320: -- START OF BEN_OPT_F ----------------------
26321: ---------------------------------------------------------------
26322: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('OPT') then
26323: insert into ben_copy_entity_results
26324: (
26325: copy_entity_result_id,
26326: copy_entity_txn_id,
26327: src_copy_entity_result_id,
26396: information182,
26397: object_version_number
26398: )
26399: select
26400: ben_copy_entity_results_s.nextval,
26401: copy_entity_txn_id,
26402: src_copy_entity_result_id,
26403: result_type_cd,
26404: number_of_copies,
26482: ---------------------------------------------------------------
26483: -- START OF BEN_ORG_UNIT_RT_F ----------------------
26484: ---------------------------------------------------------------
26485: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('OUR') then
26486: insert into ben_copy_entity_results
26487: (
26488: copy_entity_result_id,
26489: copy_entity_txn_id,
26490: src_copy_entity_result_id,
26551: information182,
26552: object_version_number
26553: )
26554: select
26555: ben_copy_entity_results_s.nextval,
26556: copy_entity_txn_id,
26557: src_copy_entity_result_id,
26558: result_type_cd,
26559: number_of_copies,
26629: ---------------------------------------------------------------
26630: -- START OF BEN_OTHR_PTIP_RT_F ----------------------
26631: ---------------------------------------------------------------
26632: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('OPR') then
26633: insert into ben_copy_entity_results
26634: (
26635: copy_entity_result_id,
26636: copy_entity_txn_id,
26637: src_copy_entity_result_id,
26700: information182,
26701: object_version_number
26702: )
26703: select
26704: ben_copy_entity_results_s.nextval,
26705: copy_entity_txn_id,
26706: src_copy_entity_result_id,
26707: result_type_cd,
26708: number_of_copies,
26780: ---------------------------------------------------------------
26781: -- START OF BEN_PCT_FL_TM_FCTR ----------------------
26782: ---------------------------------------------------------------
26783: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PFF') then
26784: insert into ben_copy_entity_results
26785: (
26786: copy_entity_result_id,
26787: copy_entity_txn_id,
26788: src_copy_entity_result_id,
26855: information182,
26856: object_version_number
26857: )
26858: select
26859: ben_copy_entity_results_s.nextval,
26860: copy_entity_txn_id,
26861: src_copy_entity_result_id,
26862: result_type_cd,
26863: number_of_copies,
26939: ---------------------------------------------------------------
26940: -- START OF BEN_PCT_FL_TM_RT_F ----------------------
26941: ---------------------------------------------------------------
26942: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PFR') then
26943: insert into ben_copy_entity_results
26944: (
26945: copy_entity_result_id,
26946: copy_entity_txn_id,
26947: src_copy_entity_result_id,
27009: information182,
27010: object_version_number
27011: )
27012: select
27013: ben_copy_entity_results_s.nextval,
27014: copy_entity_txn_id,
27015: src_copy_entity_result_id,
27016: result_type_cd,
27017: number_of_copies,
27088: ---------------------------------------------------------------
27089: -- START OF BEN_PERF_RTNG_RT_F ----------------------
27090: ---------------------------------------------------------------
27091: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PRR') then
27092: insert into ben_copy_entity_results
27093: (
27094: copy_entity_result_id,
27095: copy_entity_txn_id,
27096: src_copy_entity_result_id,
27159: information182,
27160: object_version_number
27161: )
27162: select
27163: ben_copy_entity_results_s.nextval,
27164: copy_entity_txn_id,
27165: src_copy_entity_result_id,
27166: result_type_cd,
27167: number_of_copies,
27239: ---------------------------------------------------------------
27240: -- START OF BEN_PER_INFO_CHG_CS_LER_F ----------------------
27241: ---------------------------------------------------------------
27242: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PSL') then
27243: insert into ben_copy_entity_results
27244: (
27245: copy_entity_result_id,
27246: copy_entity_txn_id,
27247: src_copy_entity_result_id,
27314: information182,
27315: object_version_number
27316: )
27317: select
27318: ben_copy_entity_results_s.nextval,
27319: copy_entity_txn_id,
27320: src_copy_entity_result_id,
27321: result_type_cd,
27322: number_of_copies,
27398: ---------------------------------------------------------------
27399: -- START OF BEN_PER_TYP_RT_F ----------------------
27400: ---------------------------------------------------------------
27401: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PTR') then
27402: insert into ben_copy_entity_results
27403: (
27404: copy_entity_result_id,
27405: copy_entity_txn_id,
27406: src_copy_entity_result_id,
27468: information182,
27469: object_version_number
27470: )
27471: select
27472: ben_copy_entity_results_s.nextval,
27473: copy_entity_txn_id,
27474: src_copy_entity_result_id,
27475: result_type_cd,
27476: number_of_copies,
27547: ---------------------------------------------------------------
27548: -- START OF BEN_PGM_DPNT_CVG_CTFN_F ----------------------
27549: ---------------------------------------------------------------
27550: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PGC') then
27551: insert into ben_copy_entity_results
27552: (
27553: copy_entity_result_id,
27554: copy_entity_txn_id,
27555: src_copy_entity_result_id,
27620: information182,
27621: object_version_number
27622: )
27623: select
27624: ben_copy_entity_results_s.nextval,
27625: copy_entity_txn_id,
27626: src_copy_entity_result_id,
27627: result_type_cd,
27628: number_of_copies,
27702: ---------------------------------------------------------------
27703: -- START OF BEN_PLIP_F ----------------------
27704: ---------------------------------------------------------------
27705: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPP') then
27706: insert into ben_copy_entity_results
27707: (
27708: copy_entity_result_id,
27709: copy_entity_txn_id,
27710: src_copy_entity_result_id,
27823: information182,
27824: object_version_number
27825: )
27826: select
27827: ben_copy_entity_results_s.nextval,
27828: copy_entity_txn_id,
27829: src_copy_entity_result_id,
27830: result_type_cd,
27831: number_of_copies,
27953: ---------------------------------------------------------------
27954: -- START OF BEN_PL_BNF_CTFN_F ----------------------
27955: ---------------------------------------------------------------
27956: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PCX') then
27957: insert into ben_copy_entity_results
27958: (
27959: copy_entity_result_id,
27960: copy_entity_txn_id,
27961: src_copy_entity_result_id,
28027: information182,
28028: object_version_number
28029: )
28030: select
28031: ben_copy_entity_results_s.nextval,
28032: copy_entity_txn_id,
28033: src_copy_entity_result_id,
28034: result_type_cd,
28035: number_of_copies,
28110: ---------------------------------------------------------------
28111: -- START OF BEN_PL_DPNT_CVG_CTFN_F ----------------------
28112: ---------------------------------------------------------------
28113: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PND') then
28114: insert into ben_copy_entity_results
28115: (
28116: copy_entity_result_id,
28117: copy_entity_txn_id,
28118: src_copy_entity_result_id,
28183: information182,
28184: object_version_number
28185: )
28186: select
28187: ben_copy_entity_results_s.nextval,
28188: copy_entity_txn_id,
28189: src_copy_entity_result_id,
28190: result_type_cd,
28191: number_of_copies,
28265: ---------------------------------------------------------------
28266: -- START OF BEN_PL_F ----------------------
28267: ---------------------------------------------------------------
28268: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PLN') then
28269: insert into ben_copy_entity_results
28270: (
28271: copy_entity_result_id,
28272: copy_entity_txn_id,
28273: src_copy_entity_result_id,
28463: information48,
28464: object_version_number
28465: )
28466: select
28467: ben_copy_entity_results_s.nextval,
28468: copy_entity_txn_id,
28469: src_copy_entity_result_id,
28470: result_type_cd,
28471: number_of_copies,
28670: ---------------------------------------------------------------
28671: -- START OF BEN_PL_GD_OR_SVC_F ----------------------
28672: ---------------------------------------------------------------
28673: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('VGS') then
28674: insert into ben_copy_entity_results
28675: (
28676: copy_entity_result_id,
28677: copy_entity_txn_id,
28678: src_copy_entity_result_id,
28743: information182,
28744: object_version_number
28745: )
28746: select
28747: ben_copy_entity_results_s.nextval,
28748: copy_entity_txn_id,
28749: src_copy_entity_result_id,
28750: result_type_cd,
28751: number_of_copies,
28825: ---------------------------------------------------------------
28826: -- START OF BEN_PL_GD_R_SVC_CTFN_F ----------------------
28827: ---------------------------------------------------------------
28828: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PCT') then
28829: insert into ben_copy_entity_results
28830: (
28831: copy_entity_result_id,
28832: copy_entity_txn_id,
28833: src_copy_entity_result_id,
28898: information182,
28899: object_version_number
28900: )
28901: select
28902: ben_copy_entity_results_s.nextval,
28903: copy_entity_txn_id,
28904: src_copy_entity_result_id,
28905: result_type_cd,
28906: number_of_copies,
28980: ---------------------------------------------------------------
28981: -- START OF BEN_PL_PCP ----------------------
28982: ---------------------------------------------------------------
28983: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PCP') then
28984: insert into ben_copy_entity_results
28985: (
28986: copy_entity_result_id,
28987: copy_entity_txn_id,
28988: src_copy_entity_result_id,
29057: information182,
29058: object_version_number
29059: )
29060: select
29061: ben_copy_entity_results_s.nextval,
29062: copy_entity_txn_id,
29063: src_copy_entity_result_id,
29064: result_type_cd,
29065: number_of_copies,
29143: ---------------------------------------------------------------
29144: -- START OF BEN_PL_PCP_TYP ----------------------
29145: ---------------------------------------------------------------
29146: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PTY') then
29147: insert into ben_copy_entity_results
29148: (
29149: copy_entity_result_id,
29150: copy_entity_txn_id,
29151: src_copy_entity_result_id,
29214: information182,
29215: object_version_number
29216: )
29217: select
29218: ben_copy_entity_results_s.nextval,
29219: copy_entity_txn_id,
29220: src_copy_entity_result_id,
29221: result_type_cd,
29222: number_of_copies,
29294: ---------------------------------------------------------------
29295: -- START OF BEN_PL_REGN_F ----------------------
29296: ---------------------------------------------------------------
29297: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PRG') then
29298: insert into ben_copy_entity_results
29299: (
29300: copy_entity_result_id,
29301: copy_entity_txn_id,
29302: src_copy_entity_result_id,
29369: information182,
29370: object_version_number
29371: )
29372: select
29373: ben_copy_entity_results_s.nextval,
29374: copy_entity_txn_id,
29375: src_copy_entity_result_id,
29376: result_type_cd,
29377: number_of_copies,
29453: ---------------------------------------------------------------
29454: -- START OF BEN_PL_REGY_BOD_F ----------------------
29455: ---------------------------------------------------------------
29456: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PRB') then
29457: insert into ben_copy_entity_results
29458: (
29459: copy_entity_result_id,
29460: copy_entity_txn_id,
29461: src_copy_entity_result_id,
29526: information182,
29527: object_version_number
29528: )
29529: select
29530: ben_copy_entity_results_s.nextval,
29531: copy_entity_txn_id,
29532: src_copy_entity_result_id,
29533: result_type_cd,
29534: number_of_copies,
29608: ---------------------------------------------------------------
29609: -- START OF BEN_PL_REGY_PRP_F ----------------------
29610: ---------------------------------------------------------------
29611: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PRP') then
29612: insert into ben_copy_entity_results
29613: (
29614: copy_entity_result_id,
29615: copy_entity_txn_id,
29616: src_copy_entity_result_id,
29677: information182,
29678: object_version_number
29679: )
29680: select
29681: ben_copy_entity_results_s.nextval,
29682: copy_entity_txn_id,
29683: src_copy_entity_result_id,
29684: result_type_cd,
29685: number_of_copies,
29755: ---------------------------------------------------------------
29756: -- START OF BEN_PL_TYP_F ----------------------
29757: ---------------------------------------------------------------
29758: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PTP') then
29759: insert into ben_copy_entity_results
29760: (
29761: copy_entity_result_id,
29762: copy_entity_txn_id,
29763: src_copy_entity_result_id,
29833: information182,
29834: object_version_number
29835: )
29836: select
29837: ben_copy_entity_results_s.nextval,
29838: copy_entity_txn_id,
29839: src_copy_entity_result_id,
29840: result_type_cd,
29841: number_of_copies,
29920: ---------------------------------------------------------------
29921: -- START OF BEN_PL_TYP_OPT_TYP_F ----------------------
29922: ---------------------------------------------------------------
29923: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PON') then
29924: insert into ben_copy_entity_results
29925: (
29926: copy_entity_result_id,
29927: copy_entity_txn_id,
29928: src_copy_entity_result_id,
29989: information182,
29990: object_version_number
29991: )
29992: select
29993: ben_copy_entity_results_s.nextval,
29994: copy_entity_txn_id,
29995: src_copy_entity_result_id,
29996: result_type_cd,
29997: number_of_copies,
30067: ---------------------------------------------------------------
30068: -- START OF BEN_POE_RT_F ----------------------
30069: ---------------------------------------------------------------
30070: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PRT') then
30071: insert into ben_copy_entity_results
30072: (
30073: copy_entity_result_id,
30074: copy_entity_txn_id,
30075: src_copy_entity_result_id,
30142: information182,
30143: object_version_number
30144: )
30145: select
30146: ben_copy_entity_results_s.nextval,
30147: copy_entity_txn_id,
30148: src_copy_entity_result_id,
30149: result_type_cd,
30150: number_of_copies,
30226: ---------------------------------------------------------------
30227: -- START OF BEN_POPL_ACTN_TYP_F ----------------------
30228: ---------------------------------------------------------------
30229: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PAT') then
30230: insert into ben_copy_entity_results
30231: (
30232: copy_entity_result_id,
30233: copy_entity_txn_id,
30234: src_copy_entity_result_id,
30297: information182,
30298: object_version_number
30299: )
30300: select
30301: ben_copy_entity_results_s.nextval,
30302: copy_entity_txn_id,
30303: src_copy_entity_result_id,
30304: result_type_cd,
30305: number_of_copies,
30377: ---------------------------------------------------------------
30378: -- START OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------
30379: ---------------------------------------------------------------
30380: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PET') then
30381: insert into ben_copy_entity_results
30382: (
30383: copy_entity_result_id,
30384: copy_entity_txn_id,
30385: src_copy_entity_result_id,
30446: information182,
30447: object_version_number
30448: )
30449: select
30450: ben_copy_entity_results_s.nextval,
30451: copy_entity_txn_id,
30452: src_copy_entity_result_id,
30453: result_type_cd,
30454: number_of_copies,
30524: ---------------------------------------------------------------
30525: -- START OF BEN_POPL_ORG_F ----------------------
30526: ---------------------------------------------------------------
30527: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPO') then
30528: insert into ben_copy_entity_results
30529: (
30530: copy_entity_result_id,
30531: copy_entity_txn_id,
30532: src_copy_entity_result_id,
30595: information182,
30596: object_version_number
30597: )
30598: select
30599: ben_copy_entity_results_s.nextval,
30600: copy_entity_txn_id,
30601: src_copy_entity_result_id,
30602: result_type_cd,
30603: number_of_copies,
30675: ---------------------------------------------------------------
30676: -- START OF BEN_POPL_ORG_ROLE_F ----------------------
30677: ---------------------------------------------------------------
30678: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPR') then
30679: insert into ben_copy_entity_results
30680: (
30681: copy_entity_result_id,
30682: copy_entity_txn_id,
30683: src_copy_entity_result_id,
30744: information182,
30745: object_version_number
30746: )
30747: select
30748: ben_copy_entity_results_s.nextval,
30749: copy_entity_txn_id,
30750: src_copy_entity_result_id,
30751: result_type_cd,
30752: number_of_copies,
30822: ---------------------------------------------------------------
30823: -- START OF BEN_POPL_RPTG_GRP_F ----------------------
30824: ---------------------------------------------------------------
30825: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('RGR') then
30826: insert into ben_copy_entity_results
30827: (
30828: copy_entity_result_id,
30829: copy_entity_txn_id,
30830: src_copy_entity_result_id,
30891: information182,
30892: object_version_number
30893: )
30894: select
30895: ben_copy_entity_results_s.nextval,
30896: copy_entity_txn_id,
30897: src_copy_entity_result_id,
30898: result_type_cd,
30899: number_of_copies,
30969: ---------------------------------------------------------------
30970: -- START OF BEN_POPL_YR_PERD ----------------------
30971: ---------------------------------------------------------------
30972: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CPY') then
30973: insert into ben_copy_entity_results
30974: (
30975: copy_entity_result_id,
30976: copy_entity_txn_id,
30977: src_copy_entity_result_id,
31041: information182,
31042: object_version_number
31043: )
31044: select
31045: ben_copy_entity_results_s.nextval,
31046: copy_entity_txn_id,
31047: src_copy_entity_result_id,
31048: result_type_cd,
31049: number_of_copies,
31122: ---------------------------------------------------------------
31123: -- START OF BEN_PPL_GRP_RT_F ----------------------
31124: ---------------------------------------------------------------
31125: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PGR') then
31126: insert into ben_copy_entity_results
31127: (
31128: copy_entity_result_id,
31129: copy_entity_txn_id,
31130: src_copy_entity_result_id,
31192: information182,
31193: object_version_number
31194: )
31195: select
31196: ben_copy_entity_results_s.nextval,
31197: copy_entity_txn_id,
31198: src_copy_entity_result_id,
31199: result_type_cd,
31200: number_of_copies,
31271: ---------------------------------------------------------------
31272: -- START OF BEN_PRTL_MO_RT_PRTN_VAL_F ----------------------
31273: ---------------------------------------------------------------
31274: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PMRPV') then
31275: insert into ben_copy_entity_results
31276: (
31277: copy_entity_result_id,
31278: copy_entity_txn_id,
31279: src_copy_entity_result_id,
31347: information182,
31348: object_version_number
31349: )
31350: select
31351: ben_copy_entity_results_s.nextval,
31352: copy_entity_txn_id,
31353: src_copy_entity_result_id,
31354: result_type_cd,
31355: number_of_copies,
31432: ---------------------------------------------------------------
31433: -- START OF BEN_PRTN_ELIGY_RL_F ----------------------
31434: ---------------------------------------------------------------
31435: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CER') then
31436: insert into ben_copy_entity_results
31437: (
31438: copy_entity_result_id,
31439: copy_entity_txn_id,
31440: src_copy_entity_result_id,
31503: information182,
31504: object_version_number
31505: )
31506: select
31507: ben_copy_entity_results_s.nextval,
31508: copy_entity_txn_id,
31509: src_copy_entity_result_id,
31510: result_type_cd,
31511: number_of_copies,
31583: ---------------------------------------------------------------
31584: -- START OF BEN_PRTN_ELIG_F ----------------------
31585: ---------------------------------------------------------------
31586: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('EPA') then
31587: insert into ben_copy_entity_results
31588: (
31589: copy_entity_result_id,
31590: copy_entity_txn_id,
31591: src_copy_entity_result_id,
31669: information182,
31670: object_version_number
31671: )
31672: select
31673: ben_copy_entity_results_s.nextval,
31674: copy_entity_txn_id,
31675: src_copy_entity_result_id,
31676: result_type_cd,
31677: number_of_copies,
31764: ---------------------------------------------------------------
31765: -- START OF BEN_PRTN_ELIG_PRFL_F ----------------------
31766: ---------------------------------------------------------------
31767: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CEP') then
31768: insert into ben_copy_entity_results
31769: (
31770: copy_entity_result_id,
31771: copy_entity_txn_id,
31772: src_copy_entity_result_id,
31834: information182,
31835: object_version_number
31836: )
31837: select
31838: ben_copy_entity_results_s.nextval,
31839: copy_entity_txn_id,
31840: src_copy_entity_result_id,
31841: result_type_cd,
31842: number_of_copies,
31913: ---------------------------------------------------------------
31914: -- START OF BEN_PRTT_ANTHR_PL_RT_F ----------------------
31915: ---------------------------------------------------------------
31916: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PAP') then
31917: insert into ben_copy_entity_results
31918: (
31919: copy_entity_result_id,
31920: copy_entity_txn_id,
31921: src_copy_entity_result_id,
31983: information182,
31984: object_version_number
31985: )
31986: select
31987: ben_copy_entity_results_s.nextval,
31988: copy_entity_txn_id,
31989: src_copy_entity_result_id,
31990: result_type_cd,
31991: number_of_copies,
32062: ---------------------------------------------------------------
32063: -- START OF BEN_PSTL_ZIP_RNG_F ----------------------
32064: ---------------------------------------------------------------
32065: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('RZR') then
32066: insert into ben_copy_entity_results
32067: (
32068: copy_entity_result_id,
32069: copy_entity_txn_id,
32070: src_copy_entity_result_id,
32130: information182,
32131: object_version_number
32132: )
32133: select
32134: ben_copy_entity_results_s.nextval,
32135: copy_entity_txn_id,
32136: src_copy_entity_result_id,
32137: result_type_cd,
32138: number_of_copies,
32207: ---------------------------------------------------------------
32208: -- START OF BEN_PSTL_ZIP_RT_F ----------------------
32209: ---------------------------------------------------------------
32210: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PZR') then
32211: insert into ben_copy_entity_results
32212: (
32213: copy_entity_result_id,
32214: copy_entity_txn_id,
32215: src_copy_entity_result_id,
32277: information182,
32278: object_version_number
32279: )
32280: select
32281: ben_copy_entity_results_s.nextval,
32282: copy_entity_txn_id,
32283: src_copy_entity_result_id,
32284: result_type_cd,
32285: number_of_copies,
32356: ---------------------------------------------------------------
32357: -- START OF BEN_PSTN_RT_F ----------------------
32358: ---------------------------------------------------------------
32359: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PST') then
32360: insert into ben_copy_entity_results
32361: (
32362: copy_entity_result_id,
32363: copy_entity_txn_id,
32364: src_copy_entity_result_id,
32425: information182,
32426: object_version_number
32427: )
32428: select
32429: ben_copy_entity_results_s.nextval,
32430: copy_entity_txn_id,
32431: src_copy_entity_result_id,
32432: result_type_cd,
32433: number_of_copies,
32503: ---------------------------------------------------------------
32504: -- START OF BEN_PTD_LMT_F ----------------------
32505: ---------------------------------------------------------------
32506: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PDL') then
32507: insert into ben_copy_entity_results
32508: (
32509: copy_entity_result_id,
32510: copy_entity_txn_id,
32511: src_copy_entity_result_id,
32577: information182,
32578: object_version_number
32579: )
32580: select
32581: ben_copy_entity_results_s.nextval,
32582: copy_entity_txn_id,
32583: src_copy_entity_result_id,
32584: result_type_cd,
32585: number_of_copies,
32660: ---------------------------------------------------------------
32661: -- START OF BEN_PTIP_DPNT_CVG_CTFN_F ----------------------
32662: ---------------------------------------------------------------
32663: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PYD') then
32664: insert into ben_copy_entity_results
32665: (
32666: copy_entity_result_id,
32667: copy_entity_txn_id,
32668: src_copy_entity_result_id,
32733: information182,
32734: object_version_number
32735: )
32736: select
32737: ben_copy_entity_results_s.nextval,
32738: copy_entity_txn_id,
32739: src_copy_entity_result_id,
32740: result_type_cd,
32741: number_of_copies,
32815: ---------------------------------------------------------------
32816: -- START OF BEN_PTIP_F ----------------------
32817: ---------------------------------------------------------------
32818: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('CTP') then
32819: insert into ben_copy_entity_results
32820: (
32821: copy_entity_result_id,
32822: copy_entity_txn_id,
32823: src_copy_entity_result_id,
32941: information182,
32942: object_version_number
32943: )
32944: select
32945: ben_copy_entity_results_s.nextval,
32946: copy_entity_txn_id,
32947: src_copy_entity_result_id,
32948: result_type_cd,
32949: number_of_copies,
33076: ---------------------------------------------------------------
33077: -- START OF BEN_PYMT_SCHED_PY_FREQ ----------------------
33078: ---------------------------------------------------------------
33079: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PSQ') then
33080: insert into ben_copy_entity_results
33081: (
33082: copy_entity_result_id,
33083: copy_entity_txn_id,
33084: src_copy_entity_result_id,
33145: information182,
33146: object_version_number
33147: )
33148: select
33149: ben_copy_entity_results_s.nextval,
33150: copy_entity_txn_id,
33151: src_copy_entity_result_id,
33152: result_type_cd,
33153: number_of_copies,
33223: ---------------------------------------------------------------
33224: -- START OF BEN_PYRL_RT_F ----------------------
33225: ---------------------------------------------------------------
33226: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PR_') then
33227: insert into ben_copy_entity_results
33228: (
33229: copy_entity_result_id,
33230: copy_entity_txn_id,
33231: src_copy_entity_result_id,
33292: information182,
33293: object_version_number
33294: )
33295: select
33296: ben_copy_entity_results_s.nextval,
33297: copy_entity_txn_id,
33298: src_copy_entity_result_id,
33299: result_type_cd,
33300: number_of_copies,
33370: ---------------------------------------------------------------
33371: -- START OF BEN_PY_BSS_RT_F ----------------------
33372: ---------------------------------------------------------------
33373: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('PBR') then
33374: insert into ben_copy_entity_results
33375: (
33376: copy_entity_result_id,
33377: copy_entity_txn_id,
33378: src_copy_entity_result_id,
33439: information182,
33440: object_version_number
33441: )
33442: select
33443: ben_copy_entity_results_s.nextval,
33444: copy_entity_txn_id,
33445: src_copy_entity_result_id,
33446: result_type_cd,
33447: number_of_copies,
33517: ---------------------------------------------------------------
33518: -- START OF BEN_QUAL_TITL_RT_F ----------------------
33519: ---------------------------------------------------------------
33520: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('QTR') then
33521: insert into ben_copy_entity_results
33522: (
33523: copy_entity_result_id,
33524: copy_entity_txn_id,
33525: src_copy_entity_result_id,
33587: information182,
33588: object_version_number
33589: )
33590: select
33591: ben_copy_entity_results_s.nextval,
33592: copy_entity_txn_id,
33593: src_copy_entity_result_id,
33594: result_type_cd,
33595: number_of_copies,
33666: ---------------------------------------------------------------
33667: -- START OF BEN_QUA_IN_GR_RT_F ----------------------
33668: ---------------------------------------------------------------
33669: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('QIG') then
33670: insert into ben_copy_entity_results
33671: (
33672: copy_entity_result_id,
33673: copy_entity_txn_id,
33674: src_copy_entity_result_id,
33736: information182,
33737: object_version_number
33738: )
33739: select
33740: ben_copy_entity_results_s.nextval,
33741: copy_entity_txn_id,
33742: src_copy_entity_result_id,
33743: result_type_cd,
33744: number_of_copies,
33815: ---------------------------------------------------------------
33816: -- START OF BEN_REGN_F ----------------------
33817: ---------------------------------------------------------------
33818: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('REG') then
33819: insert into ben_copy_entity_results
33820: (
33821: copy_entity_result_id,
33822: copy_entity_txn_id,
33823: src_copy_entity_result_id,
33884: information182,
33885: object_version_number
33886: )
33887: select
33888: ben_copy_entity_results_s.nextval,
33889: copy_entity_txn_id,
33890: src_copy_entity_result_id,
33891: result_type_cd,
33892: number_of_copies,
33962: ---------------------------------------------------------------
33963: -- START OF BEN_RLTD_PER_CHG_CS_LER_F ----------------------
33964: ---------------------------------------------------------------
33965: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('RCL') then
33966: insert into ben_copy_entity_results
33967: (
33968: copy_entity_result_id,
33969: copy_entity_txn_id,
33970: src_copy_entity_result_id,
34035: information182,
34036: object_version_number
34037: )
34038: select
34039: ben_copy_entity_results_s.nextval,
34040: copy_entity_txn_id,
34041: src_copy_entity_result_id,
34042: result_type_cd,
34043: number_of_copies,
34117: ---------------------------------------------------------------
34118: -- START OF BEN_RPTG_GRP ----------------------
34119: ---------------------------------------------------------------
34120: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('BNR') then
34121: insert into ben_copy_entity_results
34122: (
34123: copy_entity_result_id,
34124: copy_entity_txn_id,
34125: src_copy_entity_result_id,
34186: information182,
34187: object_version_number
34188: )
34189: select
34190: ben_copy_entity_results_s.nextval,
34191: copy_entity_txn_id,
34192: src_copy_entity_result_id,
34193: result_type_cd,
34194: number_of_copies,
34264: ---------------------------------------------------------------
34265: -- START OF BEN_SCHEDD_ENRT_RL_F ----------------------
34266: ---------------------------------------------------------------
34267: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('SER') then
34268: insert into ben_copy_entity_results
34269: (
34270: copy_entity_result_id,
34271: copy_entity_txn_id,
34272: src_copy_entity_result_id,
34333: information182,
34334: object_version_number
34335: )
34336: select
34337: ben_copy_entity_results_s.nextval,
34338: copy_entity_txn_id,
34339: src_copy_entity_result_id,
34340: result_type_cd,
34341: number_of_copies,
34411: ---------------------------------------------------------------
34412: -- START OF BEN_SCHEDD_HRS_RT_F ----------------------
34413: ---------------------------------------------------------------
34414: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('SHR') then
34415: insert into ben_copy_entity_results
34416: (
34417: copy_entity_result_id,
34418: copy_entity_txn_id,
34419: src_copy_entity_result_id,
34488: information182,
34489: object_version_number
34490: )
34491: select
34492: ben_copy_entity_results_s.nextval,
34493: copy_entity_txn_id,
34494: src_copy_entity_result_id,
34495: result_type_cd,
34496: number_of_copies,
34574: ---------------------------------------------------------------
34575: -- START OF BEN_SVC_AREA_F ----------------------
34576: ---------------------------------------------------------------
34577: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('SVA') then
34578: insert into ben_copy_entity_results
34579: (
34580: copy_entity_result_id,
34581: copy_entity_txn_id,
34582: src_copy_entity_result_id,
34642: information182,
34643: object_version_number
34644: )
34645: select
34646: ben_copy_entity_results_s.nextval,
34647: copy_entity_txn_id,
34648: src_copy_entity_result_id,
34649: result_type_cd,
34650: number_of_copies,
34719: ---------------------------------------------------------------
34720: -- START OF BEN_SVC_AREA_PSTL_ZIP_RNG_F ----------------------
34721: ---------------------------------------------------------------
34722: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('SAZ') then
34723: insert into ben_copy_entity_results
34724: (
34725: copy_entity_result_id,
34726: copy_entity_txn_id,
34727: src_copy_entity_result_id,
34787: information182,
34788: object_version_number
34789: )
34790: select
34791: ben_copy_entity_results_s.nextval,
34792: copy_entity_txn_id,
34793: src_copy_entity_result_id,
34794: result_type_cd,
34795: number_of_copies,
34864: ---------------------------------------------------------------
34865: -- START OF BEN_SVC_AREA_RT_F ----------------------
34866: ---------------------------------------------------------------
34867: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('SAR') then
34868: insert into ben_copy_entity_results
34869: (
34870: copy_entity_result_id,
34871: copy_entity_txn_id,
34872: src_copy_entity_result_id,
34934: information182,
34935: object_version_number
34936: )
34937: select
34938: ben_copy_entity_results_s.nextval,
34939: copy_entity_txn_id,
34940: src_copy_entity_result_id,
34941: result_type_cd,
34942: number_of_copies,
35013: ---------------------------------------------------------------
35014: -- START OF BEN_TBCO_USE_RT_F ----------------------
35015: ---------------------------------------------------------------
35016: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('TUR') then
35017: insert into ben_copy_entity_results
35018: (
35019: copy_entity_result_id,
35020: copy_entity_txn_id,
35021: src_copy_entity_result_id,
35083: information182,
35084: object_version_number
35085: )
35086: select
35087: ben_copy_entity_results_s.nextval,
35088: copy_entity_txn_id,
35089: src_copy_entity_result_id,
35090: result_type_cd,
35091: number_of_copies,
35162: ---------------------------------------------------------------
35163: -- START OF BEN_TTL_CVG_VOL_RT_F ----------------------
35164: ---------------------------------------------------------------
35165: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('TCV') then
35166: insert into ben_copy_entity_results
35167: (
35168: copy_entity_result_id,
35169: copy_entity_txn_id,
35170: src_copy_entity_result_id,
35237: information182,
35238: object_version_number
35239: )
35240: select
35241: ben_copy_entity_results_s.nextval,
35242: copy_entity_txn_id,
35243: src_copy_entity_result_id,
35244: result_type_cd,
35245: number_of_copies,
35321: ---------------------------------------------------------------
35322: -- START OF BEN_TTL_PRTT_RT_F ----------------------
35323: ---------------------------------------------------------------
35324: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('TTP') then
35325: insert into ben_copy_entity_results
35326: (
35327: copy_entity_result_id,
35328: copy_entity_txn_id,
35329: src_copy_entity_result_id,
35396: information182,
35397: object_version_number
35398: )
35399: select
35400: ben_copy_entity_results_s.nextval,
35401: copy_entity_txn_id,
35402: src_copy_entity_result_id,
35403: result_type_cd,
35404: number_of_copies,
35480: ---------------------------------------------------------------
35481: -- START OF BEN_VALD_RLSHP_FOR_REIMB_F ----------------------
35482: ---------------------------------------------------------------
35483: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('VRP') then
35484: insert into ben_copy_entity_results
35485: (
35486: copy_entity_result_id,
35487: copy_entity_txn_id,
35488: src_copy_entity_result_id,
35548: information182,
35549: object_version_number
35550: )
35551: select
35552: ben_copy_entity_results_s.nextval,
35553: copy_entity_txn_id,
35554: src_copy_entity_result_id,
35555: result_type_cd,
35556: number_of_copies,
35625: ---------------------------------------------------------------
35626: -- START OF BEN_VRBL_MTCHG_RT_F ----------------------
35627: ---------------------------------------------------------------
35628: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('VMR') then
35629: insert into ben_copy_entity_results
35630: (
35631: copy_entity_result_id,
35632: copy_entity_txn_id,
35633: src_copy_entity_result_id,
35705: information182,
35706: object_version_number
35707: )
35708: select
35709: ben_copy_entity_results_s.nextval,
35710: copy_entity_txn_id,
35711: src_copy_entity_result_id,
35712: result_type_cd,
35713: number_of_copies,
35794: ---------------------------------------------------------------
35795: -- START OF BEN_VRBL_RT_PRFL_F ----------------------
35796: ---------------------------------------------------------------
35797: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('VPF') then
35798: insert into ben_copy_entity_results
35799: (
35800: copy_entity_result_id,
35801: copy_entity_txn_id,
35802: src_copy_entity_result_id,
35954: information182,
35955: object_version_number
35956: )
35957: select
35958: ben_copy_entity_results_s.nextval,
35959: copy_entity_txn_id,
35960: src_copy_entity_result_id,
35961: result_type_cd,
35962: number_of_copies,
36123: ---------------------------------------------------------------
36124: -- START OF BEN_VRBL_RT_PRFL_RL_F ----------------------
36125: ---------------------------------------------------------------
36126: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('VPR') then
36127: insert into ben_copy_entity_results
36128: (
36129: copy_entity_result_id,
36130: copy_entity_txn_id,
36131: src_copy_entity_result_id,
36193: information182,
36194: object_version_number
36195: )
36196: select
36197: ben_copy_entity_results_s.nextval,
36198: copy_entity_txn_id,
36199: src_copy_entity_result_id,
36200: result_type_cd,
36201: number_of_copies,
36272: ---------------------------------------------------------------
36273: -- START OF BEN_WK_LOC_RT_F ----------------------
36274: ---------------------------------------------------------------
36275: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WLR') then
36276: insert into ben_copy_entity_results
36277: (
36278: copy_entity_result_id,
36279: copy_entity_txn_id,
36280: src_copy_entity_result_id,
36341: information182,
36342: object_version_number
36343: )
36344: select
36345: ben_copy_entity_results_s.nextval,
36346: copy_entity_txn_id,
36347: src_copy_entity_result_id,
36348: result_type_cd,
36349: number_of_copies,
36419: ---------------------------------------------------------------
36420: -- START OF BEN_WTHN_YR_PERD ----------------------
36421: ---------------------------------------------------------------
36422: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WYP') then
36423: insert into ben_copy_entity_results
36424: (
36425: copy_entity_result_id,
36426: copy_entity_txn_id,
36427: src_copy_entity_result_id,
36491: information182,
36492: object_version_number
36493: )
36494: select
36495: ben_copy_entity_results_s.nextval,
36496: copy_entity_txn_id,
36497: src_copy_entity_result_id,
36498: result_type_cd,
36499: number_of_copies,
36572: ---------------------------------------------------------------
36573: -- START OF BEN_WV_PRTN_RSN_CTFN_PL_F ----------------------
36574: ---------------------------------------------------------------
36575: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WCN') then
36576: insert into ben_copy_entity_results
36577: (
36578: copy_entity_result_id,
36579: copy_entity_txn_id,
36580: src_copy_entity_result_id,
36644: information182,
36645: object_version_number
36646: )
36647: select
36648: ben_copy_entity_results_s.nextval,
36649: copy_entity_txn_id,
36650: src_copy_entity_result_id,
36651: result_type_cd,
36652: number_of_copies,
36725: ---------------------------------------------------------------
36726: -- START OF BEN_WV_PRTN_RSN_CTFN_PTIP_F ----------------------
36727: ---------------------------------------------------------------
36728: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WCT') then
36729: insert into ben_copy_entity_results
36730: (
36731: copy_entity_result_id,
36732: copy_entity_txn_id,
36733: src_copy_entity_result_id,
36798: information182,
36799: object_version_number
36800: )
36801: select
36802: ben_copy_entity_results_s.nextval,
36803: copy_entity_txn_id,
36804: src_copy_entity_result_id,
36805: result_type_cd,
36806: number_of_copies,
36880: ---------------------------------------------------------------
36881: -- START OF BEN_WV_PRTN_RSN_PL_F ----------------------
36882: ---------------------------------------------------------------
36883: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WPN') then
36884: insert into ben_copy_entity_results
36885: (
36886: copy_entity_result_id,
36887: copy_entity_txn_id,
36888: src_copy_entity_result_id,
36949: information182,
36950: object_version_number
36951: )
36952: select
36953: ben_copy_entity_results_s.nextval,
36954: copy_entity_txn_id,
36955: src_copy_entity_result_id,
36956: result_type_cd,
36957: number_of_copies,
37027: ---------------------------------------------------------------
37028: -- START OF BEN_WV_PRTN_RSN_PTIP_F ----------------------
37029: ---------------------------------------------------------------
37030: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('WPT') then
37031: insert into ben_copy_entity_results
37032: (
37033: copy_entity_result_id,
37034: copy_entity_txn_id,
37035: src_copy_entity_result_id,
37096: information182,
37097: object_version_number
37098: )
37099: select
37100: ben_copy_entity_results_s.nextval,
37101: copy_entity_txn_id,
37102: src_copy_entity_result_id,
37103: result_type_cd,
37104: number_of_copies,
37174: ---------------------------------------------------------------
37175: -- START OF BEN_YR_PERD ----------------------
37176: ---------------------------------------------------------------
37177: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('YRP') then
37178: insert into ben_copy_entity_results
37179: (
37180: copy_entity_result_id,
37181: copy_entity_txn_id,
37182: src_copy_entity_result_id,
37247: information182,
37248: object_version_number
37249: )
37250: select
37251: ben_copy_entity_results_s.nextval,
37252: copy_entity_txn_id,
37253: src_copy_entity_result_id,
37254: result_type_cd,
37255: number_of_copies,
37332: if BEN_PD_COPY_TO_BEN_ONE.data_exists_for_table('FFF') then
37333:
37334: for r_fff in c_fff loop
37335:
37336: insert into ben_copy_entity_results
37337: (
37338: copy_entity_result_id,
37339: copy_entity_txn_id,
37340: src_copy_entity_result_id,
37376: object_version_number
37377: )
37378: values
37379: (
37380: ben_copy_entity_results_s.nextval,
37381: r_fff.copy_entity_txn_id,
37382: r_fff.src_copy_entity_result_id,
37383: r_fff.result_type_cd,
37384: r_fff.number_of_copies,