[Home] [Help]
19: where cer.copy_entity_txn_id = p_copy_entity_txn_id);
20: --
21: begin
22: --
23: ben_pd_copy_to_ben_one.g_table_data_in_cer.delete;
24: ben_pd_copy_to_ben_one.g_table_data_in_cer(0) := null ;
25: ben_pd_copy_to_ben_one.g_table_data_in_cer_count := 0 ;
26: --
27: for l_table_data_in_cer in c_table_data_in_cer loop
20: --
21: begin
22: --
23: ben_pd_copy_to_ben_one.g_table_data_in_cer.delete;
24: ben_pd_copy_to_ben_one.g_table_data_in_cer(0) := null ;
25: ben_pd_copy_to_ben_one.g_table_data_in_cer_count := 0 ;
26: --
27: for l_table_data_in_cer in c_table_data_in_cer loop
28: --
21: begin
22: --
23: ben_pd_copy_to_ben_one.g_table_data_in_cer.delete;
24: ben_pd_copy_to_ben_one.g_table_data_in_cer(0) := null ;
25: ben_pd_copy_to_ben_one.g_table_data_in_cer_count := 0 ;
26: --
27: for l_table_data_in_cer in c_table_data_in_cer loop
28: --
29: ben_pd_copy_to_ben_one.g_table_data_in_cer(ben_pd_copy_to_ben_one.g_table_data_in_cer_count).table_alias
25: ben_pd_copy_to_ben_one.g_table_data_in_cer_count := 0 ;
26: --
27: for l_table_data_in_cer in c_table_data_in_cer loop
28: --
29: ben_pd_copy_to_ben_one.g_table_data_in_cer(ben_pd_copy_to_ben_one.g_table_data_in_cer_count).table_alias
30: := l_table_data_in_cer.table_alias;
31: ben_pd_copy_to_ben_one.g_table_data_in_cer(ben_pd_copy_to_ben_one.g_table_data_in_cer_count).table_route_id
32: := l_table_data_in_cer.table_route_id;
33: ben_pd_copy_to_ben_one.g_table_data_in_cer_count := ben_pd_copy_to_ben_one.g_table_data_in_cer_count + 1;
27: for l_table_data_in_cer in c_table_data_in_cer loop
28: --
29: ben_pd_copy_to_ben_one.g_table_data_in_cer(ben_pd_copy_to_ben_one.g_table_data_in_cer_count).table_alias
30: := l_table_data_in_cer.table_alias;
31: ben_pd_copy_to_ben_one.g_table_data_in_cer(ben_pd_copy_to_ben_one.g_table_data_in_cer_count).table_route_id
32: := l_table_data_in_cer.table_route_id;
33: ben_pd_copy_to_ben_one.g_table_data_in_cer_count := ben_pd_copy_to_ben_one.g_table_data_in_cer_count + 1;
34: --
35: end loop;
29: ben_pd_copy_to_ben_one.g_table_data_in_cer(ben_pd_copy_to_ben_one.g_table_data_in_cer_count).table_alias
30: := l_table_data_in_cer.table_alias;
31: ben_pd_copy_to_ben_one.g_table_data_in_cer(ben_pd_copy_to_ben_one.g_table_data_in_cer_count).table_route_id
32: := l_table_data_in_cer.table_route_id;
33: ben_pd_copy_to_ben_one.g_table_data_in_cer_count := ben_pd_copy_to_ben_one.g_table_data_in_cer_count + 1;
34: --
35: end loop;
36: --
37: end init_table_data_in_cer;
134:
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,
401: ---------------------------------------------------------------
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,
550: ---------------------------------------------------------------
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,
755: ---------------------------------------------------------------
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,
902: ---------------------------------------------------------------
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,
1051: ---------------------------------------------------------------
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,
1198: ---------------------------------------------------------------
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,
1347: ---------------------------------------------------------------
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,
1660: ---------------------------------------------------------------
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,
1805: ---------------------------------------------------------------
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,
1952: ---------------------------------------------------------------
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,
2099: ---------------------------------------------------------------
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,
2264: ---------------------------------------------------------------
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,
2413: ---------------------------------------------------------------
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,
2558: ---------------------------------------------------------------
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,
2711: ---------------------------------------------------------------
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,
2858: ---------------------------------------------------------------
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,
3003: ---------------------------------------------------------------
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,
3152: ---------------------------------------------------------------
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,
3303: ---------------------------------------------------------------
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,
3486: ---------------------------------------------------------------
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,
3693: ---------------------------------------------------------------
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,
3842: ---------------------------------------------------------------
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,
3989: ---------------------------------------------------------------
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,
4136: ---------------------------------------------------------------
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,
4285: ---------------------------------------------------------------
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,
4436: ---------------------------------------------------------------
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,
4589: ---------------------------------------------------------------
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,
4738: ---------------------------------------------------------------
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,
4883: ---------------------------------------------------------------
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,
5028: ---------------------------------------------------------------
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,
5177: ---------------------------------------------------------------
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,
5328: ---------------------------------------------------------------
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,
5479: ---------------------------------------------------------------
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,
5626: ---------------------------------------------------------------
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,
5797: ---------------------------------------------------------------
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,
5946: ---------------------------------------------------------------
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,
6093: ---------------------------------------------------------------
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,
6290: ---------------------------------------------------------------
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,
6439: ---------------------------------------------------------------
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,
6608: ---------------------------------------------------------------
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,
6761: ---------------------------------------------------------------
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,
6912: ---------------------------------------------------------------
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,
7065: ---------------------------------------------------------------
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,
7216: ---------------------------------------------------------------
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,
7369: ---------------------------------------------------------------
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,
7520: ---------------------------------------------------------------
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,
7669: ---------------------------------------------------------------
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,
7818: ---------------------------------------------------------------
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,
7963: ---------------------------------------------------------------
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,
8124: ---------------------------------------------------------------
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,
8269: ---------------------------------------------------------------
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,
8416: ---------------------------------------------------------------
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,
8695: ---------------------------------------------------------------
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,
8844: ---------------------------------------------------------------
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,
8999: ---------------------------------------------------------------
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,
9148: ---------------------------------------------------------------
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,
9295: ---------------------------------------------------------------
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,
9444: ---------------------------------------------------------------
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,
9593: ---------------------------------------------------------------
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,
9744: ---------------------------------------------------------------
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,
9895: ---------------------------------------------------------------
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,
10042: ---------------------------------------------------------------
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,
10191: ---------------------------------------------------------------
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,
10340: ---------------------------------------------------------------
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,
10493: ---------------------------------------------------------------
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,
10644: ---------------------------------------------------------------
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,
10797: ---------------------------------------------------------------
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,
10948: ---------------------------------------------------------------
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,
11097: ---------------------------------------------------------------
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,
11246: ---------------------------------------------------------------
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,
11399: ---------------------------------------------------------------
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,
11548: ---------------------------------------------------------------
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,
11697: ---------------------------------------------------------------
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,
11848: ---------------------------------------------------------------
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,
11999: ---------------------------------------------------------------
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,
12146: ---------------------------------------------------------------
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,
12297: ---------------------------------------------------------------
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,
12448: ---------------------------------------------------------------
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,
12599: ---------------------------------------------------------------
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,
12750: ---------------------------------------------------------------
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,
12903: ---------------------------------------------------------------
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,
13052: ---------------------------------------------------------------
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,
13201: ---------------------------------------------------------------
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,
13348: ---------------------------------------------------------------
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,
13497: ---------------------------------------------------------------
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,
13646: ---------------------------------------------------------------
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,
13793: ---------------------------------------------------------------
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,
13942: ---------------------------------------------------------------
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,
14089: ---------------------------------------------------------------
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,
14236: ---------------------------------------------------------------
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,
14385: ---------------------------------------------------------------
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,
14534: ---------------------------------------------------------------
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,
14687: ---------------------------------------------------------------
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,
14840: ---------------------------------------------------------------
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,
14987: ---------------------------------------------------------------
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,
15132: ---------------------------------------------------------------
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,
15279: ---------------------------------------------------------------
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,
15426: ---------------------------------------------------------------
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,
15577: ---------------------------------------------------------------
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,
15726: ---------------------------------------------------------------
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,
15877: ---------------------------------------------------------------
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,
16026: ---------------------------------------------------------------
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,
16175: ---------------------------------------------------------------
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,
16326: ---------------------------------------------------------------
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,
16475: ---------------------------------------------------------------
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,
16624: ---------------------------------------------------------------
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,
16773: ---------------------------------------------------------------
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,
16922: ---------------------------------------------------------------
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,
17069: ---------------------------------------------------------------
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,
17216: ---------------------------------------------------------------
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,
17363: ---------------------------------------------------------------
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,
17512: ---------------------------------------------------------------
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,
17661: ---------------------------------------------------------------
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,
17824: ---------------------------------------------------------------
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,
17971: ---------------------------------------------------------------
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,
18124: ---------------------------------------------------------------
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,
18271: ---------------------------------------------------------------
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,
18420: ---------------------------------------------------------------
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,
18569: ---------------------------------------------------------------
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,
18762: ---------------------------------------------------------------
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,
18921: ---------------------------------------------------------------
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,
19080: ---------------------------------------------------------------
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,
19227: ---------------------------------------------------------------
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,
19378: ---------------------------------------------------------------
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,
19529: ---------------------------------------------------------------
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,
19680: ---------------------------------------------------------------
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,
19831: ---------------------------------------------------------------
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,
19984: ---------------------------------------------------------------
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,
20137: ---------------------------------------------------------------
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,
20344: ---------------------------------------------------------------
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,
20507: ---------------------------------------------------------------
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,
20658: ---------------------------------------------------------------
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,
20807: ---------------------------------------------------------------
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,
20954: ---------------------------------------------------------------
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,
21103: ---------------------------------------------------------------
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,
21250: ---------------------------------------------------------------
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,
21399: ---------------------------------------------------------------
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,
21572: ---------------------------------------------------------------
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,
21721: ---------------------------------------------------------------
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,
21868: ---------------------------------------------------------------
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,
22017: ---------------------------------------------------------------
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,
22198: ---------------------------------------------------------------
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,
22345: ---------------------------------------------------------------
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,
22494: ---------------------------------------------------------------
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,
22675: ---------------------------------------------------------------
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,
22828: ---------------------------------------------------------------
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,
22991: ---------------------------------------------------------------
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,
23154: ---------------------------------------------------------------
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,
23315: ---------------------------------------------------------------
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,
23480: ---------------------------------------------------------------
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,
23645: ---------------------------------------------------------------
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,
23808: ---------------------------------------------------------------
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,
23957: ---------------------------------------------------------------
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,
24138: ---------------------------------------------------------------
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,
24285: ---------------------------------------------------------------
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,
24432: ---------------------------------------------------------------
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,
24585: ---------------------------------------------------------------
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,
24732: ---------------------------------------------------------------
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,
24881: ---------------------------------------------------------------
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,
25054: ---------------------------------------------------------------
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,
25203: ---------------------------------------------------------------
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,
25352: ---------------------------------------------------------------
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,
25523: ---------------------------------------------------------------
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,
25668: ---------------------------------------------------------------
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,
25813: ---------------------------------------------------------------
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,
26020: ---------------------------------------------------------------
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,
26167: ---------------------------------------------------------------
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,
26318: ---------------------------------------------------------------
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,
26481: ---------------------------------------------------------------
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,
26628: ---------------------------------------------------------------
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,
26779: ---------------------------------------------------------------
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,
26938: ---------------------------------------------------------------
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,
27087: ---------------------------------------------------------------
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,
27238: ---------------------------------------------------------------
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,
27397: ---------------------------------------------------------------
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,
27546: ---------------------------------------------------------------
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,
27701: ---------------------------------------------------------------
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,
27952: ---------------------------------------------------------------
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,
28109: ---------------------------------------------------------------
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,
28264: ---------------------------------------------------------------
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,
28669: ---------------------------------------------------------------
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,
28824: ---------------------------------------------------------------
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,
28979: ---------------------------------------------------------------
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,
29142: ---------------------------------------------------------------
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,
29293: ---------------------------------------------------------------
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,
29452: ---------------------------------------------------------------
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,
29607: ---------------------------------------------------------------
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,
29754: ---------------------------------------------------------------
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,
29919: ---------------------------------------------------------------
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,
30066: ---------------------------------------------------------------
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,
30225: ---------------------------------------------------------------
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,
30376: ---------------------------------------------------------------
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,
30523: ---------------------------------------------------------------
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,
30674: ---------------------------------------------------------------
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,
30821: ---------------------------------------------------------------
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,
30968: ---------------------------------------------------------------
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,
31121: ---------------------------------------------------------------
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,
31270: ---------------------------------------------------------------
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,
31431: ---------------------------------------------------------------
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,
31582: ---------------------------------------------------------------
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,
31763: ---------------------------------------------------------------
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,
31912: ---------------------------------------------------------------
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,
32061: ---------------------------------------------------------------
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,
32206: ---------------------------------------------------------------
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,
32355: ---------------------------------------------------------------
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,
32502: ---------------------------------------------------------------
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,
32659: ---------------------------------------------------------------
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,
32814: ---------------------------------------------------------------
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,
33075: ---------------------------------------------------------------
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,
33222: ---------------------------------------------------------------
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,
33369: ---------------------------------------------------------------
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,
33516: ---------------------------------------------------------------
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,
33665: ---------------------------------------------------------------
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,
33814: ---------------------------------------------------------------
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,
33961: ---------------------------------------------------------------
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,
34116: ---------------------------------------------------------------
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,
34263: ---------------------------------------------------------------
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,
34410: ---------------------------------------------------------------
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,
34573: ---------------------------------------------------------------
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,
34718: ---------------------------------------------------------------
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,
34863: ---------------------------------------------------------------
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,
35012: ---------------------------------------------------------------
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,
35161: ---------------------------------------------------------------
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,
35320: ---------------------------------------------------------------
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,
35479: ---------------------------------------------------------------
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,
35624: ---------------------------------------------------------------
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,
35793: ---------------------------------------------------------------
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,
36122: ---------------------------------------------------------------
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,
36271: ---------------------------------------------------------------
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,
36418: ---------------------------------------------------------------
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,
36571: ---------------------------------------------------------------
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,
36724: ---------------------------------------------------------------
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,
36879: ---------------------------------------------------------------
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,
37026: ---------------------------------------------------------------
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,
37173: ---------------------------------------------------------------
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,
37328: ---------------------------------------------------------------
37329: ---------------------------------------------------------------
37330: -- START OF FF_FORMULAS_F ----------------------
37331: ---------------------------------------------------------------
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