162: --
163: procedure update_cer_with_target(c_pk_rec BEN_PD_COPY_TO_BEN_ONE.g_pk_rec_type, p_copy_entity_txn_id in number) is
164: begin
165: hr_utility.set_location('Inside update_cer_with_target ',233);
166: update ben_copy_entity_results
167: set information9 = c_pk_rec.copy_reuse_type||'-'||c_pk_rec.new_value
168: where copy_entity_txn_id = p_copy_entity_txn_id
169: and table_route_id = c_pk_rec.table_route_id
170: and information1 = c_pk_rec.old_value ;
222: cpe.information3,
223: cpe.table_route_id,
224: cpe.dml_operation,
225: cpe.datetrack_mode
226: from ben_copy_entity_results cpe,
227: pqh_table_route tr
228: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
229: and cpe.table_route_id = tr.table_route_id
230: -- and tr.where_clause = l_BEN_PL_REGY_BOD_F
238: c_information1 number) is
239: select
240: min(cpe.information2) min_esd,
241: max(cpe.information3) min_eed
242: from ben_copy_entity_results cpe
243: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
244: and cpe.table_route_id = c_table_route_id
245: and cpe.information1 = c_information1 ;
246: --
249: c_information2 date,
250: c_information3 date ) is
251: select
252: cpe.*
253: from ben_copy_entity_results cpe
254: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
255: and cpe.table_route_id = c_table_route_id
256: and cpe.information1 = c_information1
257: and cpe.information2 = c_information2
303: --
304: l_update boolean := false ;
305: l_datetrack_mode varchar2(80) := hr_api.g_update;
306: l_process_date date;
307: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
308: --
309: --UPD END
310: l_current_pk_id number := null ;
311: l_prev_pk_id number := null ;
704: cpe.information3,
705: cpe.table_route_id,
706: cpe.dml_operation,
707: cpe.datetrack_mode
708: from ben_copy_entity_results cpe,
709: pqh_table_route tr
710: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
711: and cpe.table_route_id = tr.table_route_id
712: -- and tr.where_clause = l_BEN_SVC_AREA_PSTL_ZIP_RNG_F
720: c_information1 number) is
721: select
722: min(cpe.information2) min_esd,
723: max(cpe.information3) min_eed
724: from ben_copy_entity_results cpe
725: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
726: and cpe.table_route_id = c_table_route_id
727: and cpe.information1 = c_information1 ;
728: --
731: c_information2 date,
732: c_information3 date ) is
733: select
734: cpe.*
735: from ben_copy_entity_results cpe
736: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
737: and cpe.table_route_id = c_table_route_id
738: and cpe.information1 = c_information1
739: and cpe.information2 = c_information2
782: --
783: l_update boolean := false ;
784: l_datetrack_mode varchar2(80) := hr_api.g_update;
785: l_process_date date;
786: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
787: --
788: --UPD END
789: l_current_pk_id number := null ;
790: l_prev_pk_id number := null ;
1165: select distinct cpe.information1,
1166: cpe.information2,
1167: cpe.information3,
1168: cpe.table_route_id
1169: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
1170: pqh_table_route tr
1171: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1172: and cpe.table_route_id = tr.table_route_id
1173: -- and tr.where_clause = l_BEN_PL_BNF_CTFN_F
1181: c_information1 number) is
1182: select
1183: min(cpe.information2) min_esd,
1184: max(cpe.information3) min_eed
1185: from ben_copy_entity_results cpe
1186: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1187: and cpe.table_route_id = c_table_route_id
1188: and cpe.information1 = c_information1 ;
1189: --
1192: c_information2 date,
1193: c_information3 date ) is
1194: select
1195: cpe.*
1196: from ben_copy_entity_results cpe
1197: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1198: and cpe.table_route_id = c_table_route_id
1199: and cpe.information1 = c_information1
1200: and cpe.information2 = c_information2
1246: --
1247: l_update boolean := false ;
1248: l_datetrack_mode varchar2(80) := hr_api.g_update;
1249: l_process_date date;
1250: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1251: --
1252: --UPD END
1253: l_current_pk_id number := null ;
1254: l_prev_pk_id number := null ;
1653: select distinct cpe.information1,
1654: cpe.information2,
1655: cpe.information3,
1656: cpe.table_route_id
1657: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
1658: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1659: and cpe.table_route_id = tr.table_route_id
1660: -- and tr.where_clause = l_BEN_PL_DPNT_CVG_CTFN_F
1661: and tr.table_alias = l_table_alias
1668: c_information1 number) is
1669: select
1670: min(cpe.information2) min_esd,
1671: max(cpe.information3) min_eed
1672: from ben_copy_entity_results cpe
1673: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1674: and cpe.table_route_id = c_table_route_id
1675: and cpe.information1 = c_information1 ;
1676: --
1679: c_information2 date,
1680: c_information3 date ) is
1681: select
1682: cpe.*
1683: from ben_copy_entity_results cpe
1684: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1685: and cpe.table_route_id = c_table_route_id
1686: and cpe.information1 = c_information1
1687: and cpe.information2 = c_information2
1727: --
1728: l_update boolean := false ;
1729: l_datetrack_mode varchar2(80) := hr_api.g_update;
1730: l_process_date date;
1731: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1732: --
1733: --UPD END
1734: l_current_pk_id number := null ;
1735: l_prev_pk_id number := null ;
2128: select distinct cpe.information1,
2129: cpe.information2,
2130: cpe.information3,
2131: cpe.table_route_id
2132: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
2133: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2134: and cpe.table_route_id = tr.table_route_id
2135: -- and tr.where_clause = l_BEN_LER_CHG_PL_NIP_ENRT_F
2136: and tr.table_alias = l_table_alias
2143: c_information1 number) is
2144: select
2145: min(cpe.information2) min_esd,
2146: max(cpe.information3) min_eed
2147: from ben_copy_entity_results cpe
2148: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2149: and cpe.table_route_id = c_table_route_id
2150: and cpe.information1 = c_information1 ;
2151: --
2154: c_information2 date,
2155: c_information3 date ) is
2156: select
2157: cpe.*
2158: from ben_copy_entity_results cpe
2159: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2160: and cpe.table_route_id = c_table_route_id
2161: and cpe.information1 = c_information1
2162: and cpe.information2 = c_information2
2205: --
2206: l_update boolean := false ;
2207: l_datetrack_mode varchar2(80) := hr_api.g_update;
2208: l_process_date date;
2209: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2210: --
2211: --UPD END
2212:
2213: l_current_pk_id number := null ;
2616: select distinct cpe.information1,
2617: cpe.information2,
2618: cpe.information3,
2619: cpe.table_route_id
2620: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
2621: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2622: and cpe.table_route_id = tr.table_route_id
2623: -- and tr.where_clause = l_BEN_LER_CHG_OIPL_ENRT_F
2624: and tr.table_alias = l_table_alias
2631: c_information1 number) is
2632: select
2633: min(cpe.information2) min_esd,
2634: max(cpe.information3) min_eed
2635: from ben_copy_entity_results cpe
2636: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2637: and cpe.table_route_id = c_table_route_id
2638: and cpe.information1 = c_information1 ;
2639: --
2642: c_information2 date,
2643: c_information3 date ) is
2644: select
2645: cpe.*
2646: from ben_copy_entity_results cpe
2647: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2648: and cpe.table_route_id = c_table_route_id
2649: and cpe.information1 = c_information1
2650: and cpe.information2 = c_information2
2693: --
2694: l_update boolean := false ;
2695: l_datetrack_mode varchar2(80) := hr_api.g_update;
2696: l_process_date date;
2697: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2698: --
2699: --UPD END
2700:
2701: l_current_pk_id number := null ;
3096: select distinct cpe.information1,
3097: cpe.information2,
3098: cpe.information3,
3099: cpe.table_route_id
3100: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
3101: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3102: and cpe.table_route_id = tr.table_route_id
3103: -- and tr.where_clause = l_BEN_LER_ENRT_CTFN_F
3104: and tr.table_alias = l_table_alias
3111: c_information1 number) is
3112: select
3113: min(cpe.information2) min_esd,
3114: max(cpe.information3) min_eed
3115: from ben_copy_entity_results cpe
3116: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3117: and cpe.table_route_id = c_table_route_id
3118: and cpe.information1 = c_information1 ;
3119: --
3122: c_information2 date,
3123: c_information3 date ) is
3124: select
3125: cpe.*
3126: from ben_copy_entity_results cpe
3127: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3128: and cpe.table_route_id = c_table_route_id
3129: and cpe.information1 = c_information1
3130: and cpe.information2 = c_information2
3173: --
3174: l_update boolean := false ;
3175: l_datetrack_mode varchar2(80) := hr_api.g_update;
3176: l_process_date date;
3177: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3178: --
3179: --UPD END
3180: l_current_pk_id number := null ;
3181: l_prev_pk_id number := null ;
3571: select distinct cpe.information1,
3572: cpe.information2,
3573: cpe.information3,
3574: cpe.table_route_id
3575: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
3576: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3577: and cpe.table_route_id = tr.table_route_id
3578: -- and tr.where_clause = l_BEN_LER_RQRS_ENRT_CTFN_F
3579: and tr.table_alias = l_table_alias
3586: c_information1 number) is
3587: select
3588: min(cpe.information2) min_esd,
3589: max(cpe.information3) min_eed
3590: from ben_copy_entity_results cpe
3591: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3592: and cpe.table_route_id = c_table_route_id
3593: and cpe.information1 = c_information1 ;
3594: --
3597: c_information2 date,
3598: c_information3 date ) is
3599: select
3600: cpe.*
3601: from ben_copy_entity_results cpe
3602: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3603: and cpe.table_route_id = c_table_route_id
3604: and cpe.information1 = c_information1
3605: and cpe.information2 = c_information2
3651: --
3652: l_update boolean := false ;
3653: l_datetrack_mode varchar2(80) := hr_api.g_update;
3654: l_process_date date;
3655: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3656: --
3657: --UPD END
3658: l_current_pk_id number := null ;
3659: l_prev_pk_id number := null ;
4060: select distinct cpe.information1,
4061: cpe.information2,
4062: cpe.information3,
4063: cpe.table_route_id
4064: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4065: pqh_table_route tr
4066: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4067: and cpe.table_route_id = tr.table_route_id
4068: -- and tr.where_clause = l_BEN_LER_BNFT_RSTRN_CTFN_F
4076: c_information1 number) is
4077: select
4078: min(cpe.information2) min_esd,
4079: max(cpe.information3) min_eed
4080: from ben_copy_entity_results cpe
4081: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4082: and cpe.table_route_id = c_table_route_id
4083: and cpe.information1 = c_information1 ;
4084: --
4087: c_information2 date,
4088: c_information3 date) is
4089: select
4090: cpe.*
4091: from ben_copy_entity_results cpe
4092: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4093: and cpe.table_route_id = c_table_route_id
4094: and cpe.information1 = c_information1
4095: and cpe.information2 = c_information2
4138: --
4139: l_update boolean := false ;
4140: l_datetrack_mode varchar2(80) := hr_api.g_update;
4141: l_process_date date;
4142: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4143: --
4144: --UPD END
4145: l_current_pk_id number := null ;
4146: l_prev_pk_id number := null ;
4534: select distinct cpe.information1,
4535: cpe.information2,
4536: cpe.information3,
4537: cpe.table_route_id
4538: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4539: pqh_table_route tr
4540: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4541: and cpe.table_route_id = tr.table_route_id
4542: -- and tr.where_clause = l_BEN_BNFT_RSTRN_CTFN_F
4550: c_information1 number) is
4551: select
4552: min(cpe.information2) min_esd,
4553: max(cpe.information3) min_eed
4554: from ben_copy_entity_results cpe
4555: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4556: and cpe.table_route_id = c_table_route_id
4557: and cpe.information1 = c_information1 ;
4558: --
4561: c_information2 date,
4562: c_information3 date) is
4563: select
4564: cpe.*
4565: from ben_copy_entity_results cpe
4566: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4567: and cpe.table_route_id = c_table_route_id
4568: and cpe.information1 = c_information1
4569: and cpe.information2 = c_information2
4612: --
4613: l_update boolean := false ;
4614: l_datetrack_mode varchar2(80) := hr_api.g_update;
4615: l_process_date date;
4616: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4617: --
4618: --UPD END
4619: l_current_pk_id number := null ;
4620: l_prev_pk_id number := null ;
5001: select distinct cpe.information1,
5002: cpe.information2,
5003: cpe.information3,
5004: cpe.table_route_id
5005: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5006: pqh_table_route tr
5007: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5008: and cpe.table_route_id = tr.table_route_id
5009: -- and tr.where_clause = l_BEN_WV_PRTN_RSN_CTFN_PL_F
5017: c_information1 number) is
5018: select
5019: min(cpe.information2) min_esd,
5020: max(cpe.information3) min_eed
5021: from ben_copy_entity_results cpe
5022: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5023: and cpe.table_route_id = c_table_route_id
5024: and cpe.information1 = c_information1 ;
5025: --
5028: c_information2 date,
5029: c_information3 date ) is
5030: select
5031: cpe.*
5032: from ben_copy_entity_results cpe
5033: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5034: and cpe.table_route_id = c_table_route_id
5035: and cpe.information1 = c_information1
5036: and cpe.information2 = c_information2
5079: --
5080: l_update boolean := false ;
5081: l_datetrack_mode varchar2(80) := hr_api.g_update;
5082: l_process_date date;
5083: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5084: --
5085: --UPD END
5086:
5087: l_current_pk_id number := null ;
5479: select distinct cpe.information1,
5480: cpe.information2,
5481: cpe.information3,
5482: cpe.table_route_id
5483: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5484: pqh_table_route tr
5485: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5486: and cpe.table_route_id = tr.table_route_id
5487: -- and tr.where_clause = l_BEN_WV_PRTN_RSN_PL_F
5495: c_information1 number) is
5496: select
5497: min(cpe.information2) min_esd,
5498: max(cpe.information3) min_eed
5499: from ben_copy_entity_results cpe
5500: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5501: and cpe.table_route_id = c_table_route_id
5502: and cpe.information1 = c_information1 ;
5503: --
5506: c_information2 date,
5507: c_information3 date ) is
5508: select
5509: cpe.*
5510: from ben_copy_entity_results cpe
5511: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5512: and cpe.table_route_id = c_table_route_id
5513: and cpe.information1 = c_information1
5514: and cpe.information2 = c_information2
5557: --
5558: l_update boolean := false ;
5559: l_datetrack_mode varchar2(80) := hr_api.g_update;
5560: l_process_date date;
5561: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5562: --
5563: --UPD END
5564: l_current_pk_id number := null ;
5565: l_prev_pk_id number := null ;
5948: select distinct cpe.information1,
5949: cpe.information2,
5950: cpe.information3,
5951: cpe.table_route_id
5952: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5953: pqh_table_route tr
5954: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5955: and cpe.table_route_id = tr.table_route_id
5956: -- and tr.where_clause = l_BEN_VALD_RLSHP_FOR_REIMB_F
5964: c_information1 number) is
5965: select
5966: min(cpe.information2) min_esd,
5967: max(cpe.information3) min_eed
5968: from ben_copy_entity_results cpe
5969: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5970: and cpe.table_route_id = c_table_route_id
5971: and cpe.information1 = c_information1 ;
5972: --
5975: c_information2 date,
5976: c_information3 date ) is
5977: select
5978: cpe.*
5979: from ben_copy_entity_results cpe
5980: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5981: and cpe.table_route_id = c_table_route_id
5982: and cpe.information1 = c_information1
5983: and cpe.information2 = c_information2
6026: --
6027: l_update boolean := false ;
6028: l_datetrack_mode varchar2(80) := hr_api.g_update;
6029: l_process_date date;
6030: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6031: --
6032: --UPD END
6033: l_current_pk_id number := null ;
6034: l_prev_pk_id number := null ;
6417: select distinct cpe.information1,
6418: cpe.information2,
6419: cpe.information3,
6420: cpe.table_route_id
6421: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6422: pqh_table_route tr
6423: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6424: and cpe.table_route_id = tr.table_route_id
6425: -- and tr.where_clause = l_BEN_PL_GD_R_SVC_CTFN_F
6433: c_information1 number) is
6434: select
6435: min(cpe.information2) min_esd,
6436: max(cpe.information3) min_eed
6437: from ben_copy_entity_results cpe
6438: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6439: and cpe.table_route_id = c_table_route_id
6440: and cpe.information1 = c_information1 ;
6441: --
6444: c_information2 date,
6445: c_information3 date ) is
6446: select
6447: cpe.*
6448: from ben_copy_entity_results cpe
6449: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6450: and cpe.table_route_id = c_table_route_id
6451: and cpe.information1 = c_information1
6452: and cpe.information2 = c_information2
6495: --
6496: l_update boolean := false ;
6497: l_datetrack_mode varchar2(80) := hr_api.g_update;
6498: l_process_date date;
6499: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6500: --
6501: --UPD END
6502: l_current_pk_id number := null ;
6503: l_prev_pk_id number := null ;
6895: select distinct cpe.information1,
6896: cpe.information2,
6897: cpe.information3,
6898: cpe.table_route_id
6899: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6900: pqh_table_route tr
6901: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6902: and cpe.table_route_id = tr.table_route_id
6903: -- and tr.where_clause = l_BEN_PL_GD_OR_SVC_F
6911: c_information1 number) is
6912: select
6913: min(cpe.information2) min_esd,
6914: max(cpe.information3) min_eed
6915: from ben_copy_entity_results cpe
6916: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6917: and cpe.table_route_id = c_table_route_id
6918: and cpe.information1 = c_information1 ;
6919: --
6922: c_information2 date,
6923: c_information3 date ) is
6924: select
6925: cpe.*
6926: from ben_copy_entity_results cpe
6927: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6928: and cpe.table_route_id = c_table_route_id
6929: and cpe.information1 = c_information1
6930: and cpe.information2 = c_information2
6973: --
6974: l_update boolean := false ;
6975: l_datetrack_mode varchar2(80) := hr_api.g_update;
6976: l_process_date date;
6977: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6978: --
6979: --UPD END
6980: l_current_pk_id number := null ;
6981: l_prev_pk_id number := null ;
7375: select distinct cpe.information1,
7376: cpe.information2,
7377: cpe.information3,
7378: cpe.table_route_id
7379: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7380: pqh_table_route tr
7381: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7382: and cpe.table_route_id = tr.table_route_id
7383: -- and tr.where_clause = l_BEN_LER_BNFT_RSTRN_F
7391: c_information1 number) is
7392: select
7393: min(cpe.information2) min_esd,
7394: max(cpe.information3) min_eed
7395: from ben_copy_entity_results cpe
7396: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7397: and cpe.table_route_id = c_table_route_id
7398: and cpe.information1 = c_information1 ;
7399: --
7402: c_information2 date,
7403: c_information3 date ) is
7404: select
7405: cpe.*
7406: from ben_copy_entity_results cpe
7407: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7408: and cpe.table_route_id = c_table_route_id
7409: and cpe.information1 = c_information1
7410: and cpe.information2 = c_information2
7456: --
7457: l_update boolean := false ;
7458: l_datetrack_mode varchar2(80) := hr_api.g_update;
7459: l_process_date date;
7460: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7461: --
7462: --UPD END
7463: l_current_pk_id number := null ;
7464: l_prev_pk_id number := null ;
7896: select distinct cpe.information1,
7897: cpe.information2,
7898: cpe.information3,
7899: cpe.table_route_id
7900: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7901: pqh_table_route tr
7902: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7903: and cpe.table_route_id = tr.table_route_id
7904: -- and tr.where_clause = l_BEN_LER_CHG_PLIP_ENRT_F
7912: c_information1 number) is
7913: select
7914: min(cpe.information2) min_esd,
7915: max(cpe.information3) min_eed
7916: from ben_copy_entity_results cpe
7917: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7918: and cpe.table_route_id = c_table_route_id
7919: and cpe.information1 = c_information1 ;
7920: --
7923: c_information2 date,
7924: c_information3 date ) is
7925: select
7926: cpe.*
7927: from ben_copy_entity_results cpe
7928: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7929: and cpe.table_route_id = c_table_route_id
7930: and cpe.information1 = c_information1
7931: and cpe.information2 = c_information2
7974: --
7975: l_update boolean := false ;
7976: l_datetrack_mode varchar2(80) := hr_api.g_update;
7977: l_process_date date;
7978: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7979: --
7980: --UPD END
7981: l_current_pk_id number := null ;
7982: l_prev_pk_id number := null ;
8398: select distinct cpe.information1,
8399: cpe.information2,
8400: cpe.information3,
8401: cpe.table_route_id
8402: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8403: pqh_table_route tr
8404: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8405: and cpe.table_route_id = tr.table_route_id
8406: -- and tr.where_clause = l_BEN_PLIP_F
8414: c_information1 number) is
8415: select
8416: min(cpe.information2) min_esd,
8417: max(cpe.information3) min_eed
8418: from ben_copy_entity_results cpe
8419: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8420: and cpe.table_route_id = c_table_route_id
8421: and cpe.information1 = c_information1 ;
8422: --
8425: c_information2 date,
8426: c_information3 date ) is
8427: select
8428: cpe.*
8429: from ben_copy_entity_results cpe
8430: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8431: and cpe.table_route_id = c_table_route_id
8432: and cpe.information1 = c_information1
8433: and cpe.information2 = c_information2
8479: --
8480: l_update boolean := false ;
8481: l_datetrack_mode varchar2(80) := hr_api.g_update;
8482: l_process_date date;
8483: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8484: --
8485: --UPD END
8486: l_current_pk_id number := null ;
8487: l_prev_pk_id number := null ;
8991: select distinct cpe.information1,
8992: cpe.information2,
8993: cpe.information3,
8994: cpe.table_route_id
8995: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8996: pqh_table_route tr
8997: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8998: and cpe.table_route_id = tr.table_route_id
8999: -- and tr.where_clause = l_BEN_PTIP_DPNT_CVG_CTFN_F
9007: c_information1 number) is
9008: select
9009: min(cpe.information2) min_esd,
9010: max(cpe.information3) min_eed
9011: from ben_copy_entity_results cpe
9012: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9013: and cpe.table_route_id = c_table_route_id
9014: and cpe.information1 = c_information1 ;
9015: --
9018: c_information2 date,
9019: c_information3 date ) is
9020: select
9021: cpe.*
9022: from ben_copy_entity_results cpe
9023: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9024: and cpe.table_route_id = c_table_route_id
9025: and cpe.information1 = c_information1
9026: and cpe.information2 = c_information2
9072: --
9073: l_update boolean := false ;
9074: l_datetrack_mode varchar2(80) := hr_api.g_update;
9075: l_process_date date;
9076: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9077: --
9078: --UPD END
9079: l_current_pk_id number := null ;
9080: l_prev_pk_id number := null ;
9476: select distinct cpe.information1,
9477: cpe.information2,
9478: cpe.information3,
9479: cpe.table_route_id
9480: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9481: pqh_table_route tr
9482: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9483: and cpe.table_route_id = tr.table_route_id
9484: -- and tr.where_clause = l_BEN_LER_CHG_PTIP_ENRT_F
9492: c_information1 number) is
9493: select
9494: min(cpe.information2) min_esd,
9495: max(cpe.information3) min_eed
9496: from ben_copy_entity_results cpe
9497: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9498: and cpe.table_route_id = c_table_route_id
9499: and cpe.information1 = c_information1 ;
9500: --
9503: c_information2 date,
9504: c_information3 date ) is
9505: select
9506: cpe.*
9507: from ben_copy_entity_results cpe
9508: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9509: and cpe.table_route_id = c_table_route_id
9510: and cpe.information1 = c_information1
9511: and cpe.information2 = c_information2
9554: --
9555: l_update boolean := false ;
9556: l_datetrack_mode varchar2(80) := hr_api.g_update;
9557: l_process_date date;
9558: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9559: --
9560: --UPD END
9561: l_current_pk_id number := null ;
9562: l_prev_pk_id number := null ;
9971: select distinct cpe.information1,
9972: cpe.information2,
9973: cpe.information3,
9974: cpe.table_route_id
9975: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9976: pqh_table_route tr
9977: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9978: and cpe.table_route_id = tr.table_route_id
9979: -- and tr.where_clause = l_BEN_WV_PRTN_RSN_CTFN_PTIP_F
9987: c_information1 number) is
9988: select
9989: min(cpe.information2) min_esd,
9990: max(cpe.information3) min_eed
9991: from ben_copy_entity_results cpe
9992: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9993: and cpe.table_route_id = c_table_route_id
9994: and cpe.information1 = c_information1 ;
9995: --
9998: c_information2 date,
9999: c_information3 date ) is
10000: select
10001: cpe.*
10002: from ben_copy_entity_results cpe
10003: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10004: and cpe.table_route_id = c_table_route_id
10005: and cpe.information1 = c_information1
10006: and cpe.information2 = c_information2
10049: --
10050: l_update boolean := false ;
10051: l_datetrack_mode varchar2(80) := hr_api.g_update;
10052: l_process_date date;
10053: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10054: --
10055: --UPD END
10056: l_current_pk_id number := null ;
10057: l_prev_pk_id number := null ;
10449: select distinct cpe.information1,
10450: cpe.information2,
10451: cpe.information3,
10452: cpe.table_route_id
10453: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10454: pqh_table_route tr
10455: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10456: and cpe.table_route_id = tr.table_route_id
10457: -- and tr.where_clause = l_BEN_WV_PRTN_RSN_PTIP_F
10465: c_information1 number) is
10466: select
10467: min(cpe.information2) min_esd,
10468: max(cpe.information3) min_eed
10469: from ben_copy_entity_results cpe
10470: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10471: and cpe.table_route_id = c_table_route_id
10472: and cpe.information1 = c_information1 ;
10473: --
10476: c_information2 date,
10477: c_information3 date ) is
10478: select
10479: cpe.*
10480: from ben_copy_entity_results cpe
10481: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10482: and cpe.table_route_id = c_table_route_id
10483: and cpe.information1 = c_information1
10484: and cpe.information2 = c_information2
10527: --
10528: l_update boolean := false ;
10529: l_datetrack_mode varchar2(80) := hr_api.g_update;
10530: l_process_date date;
10531: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10532: --
10533: --UPD END
10534: l_current_pk_id number := null ;
10535: l_prev_pk_id number := null ;
10933: select distinct cpe.information1,
10934: cpe.information2,
10935: cpe.information3,
10936: cpe.table_route_id
10937: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10938: pqh_table_route tr
10939: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10940: and cpe.table_route_id = tr.table_route_id
10941: -- and tr.where_clause = l_BEN_PTIP_F
10949: c_information1 number) is
10950: select
10951: min(cpe.information2) min_esd,
10952: max(cpe.information3) min_eed
10953: from ben_copy_entity_results cpe
10954: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10955: and cpe.table_route_id = c_table_route_id
10956: and cpe.information1 = c_information1 ;
10957: --
10960: c_information2 date,
10961: c_information3 date ) is
10962: select
10963: cpe.*
10964: from ben_copy_entity_results cpe
10965: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10966: and cpe.table_route_id = c_table_route_id
10967: and cpe.information1 = c_information1
10968: and cpe.information2 = c_information2
11020: --
11021: l_update boolean := false ;
11022: l_datetrack_mode varchar2(80) := hr_api.g_update;
11023: l_process_date date;
11024: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11025: --
11026: --UPD END
11027: l_current_pk_id number := null ;
11028: l_prev_pk_id number := null ;
11578: select distinct cpe.information1,
11579: cpe.information2,
11580: cpe.information3,
11581: cpe.table_route_id
11582: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
11583: pqh_table_route tr
11584: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11585: and cpe.table_route_id = tr.table_route_id
11586: -- and tr.where_clause = l_BEN_LER_CHG_DPNT_CVG_CTFN_F
11594: c_information1 number) is
11595: select
11596: min(cpe.information2) min_esd,
11597: max(cpe.information3) min_eed
11598: from ben_copy_entity_results cpe
11599: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11600: and cpe.table_route_id = c_table_route_id
11601: and cpe.information1 = c_information1 ;
11602: --
11605: c_information2 date,
11606: c_information3 date ) is
11607: select
11608: cpe.*
11609: from ben_copy_entity_results cpe
11610: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11611: and cpe.table_route_id = c_table_route_id
11612: and cpe.information1 = c_information1
11613: and cpe.information2 = c_information2
11656: --
11657: l_update boolean := false ;
11658: l_datetrack_mode varchar2(80) := hr_api.g_update;
11659: l_process_date date;
11660: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11661: --
11662: --UPD END
11663: l_current_pk_id number := null ;
11664: l_prev_pk_id number := null ;
12054: select distinct cpe.information1,
12055: cpe.information2,
12056: cpe.information3,
12057: cpe.table_route_id
12058: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12059: pqh_table_route tr
12060: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12061: and cpe.table_route_id = tr.table_route_id
12062: -- and tr.where_clause = l_BEN_PRTN_ELIGY_RL_F
12070: c_information1 number) is
12071: select
12072: min(cpe.information2) min_esd,
12073: max(cpe.information3) min_eed
12074: from ben_copy_entity_results cpe
12075: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12076: and cpe.table_route_id = c_table_route_id
12077: and cpe.information1 = c_information1 ;
12078: --
12081: c_information2 date,
12082: c_information3 date ) is
12083: select
12084: cpe.*
12085: from ben_copy_entity_results cpe
12086: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12087: and cpe.table_route_id = c_table_route_id
12088: and cpe.information1 = c_information1
12089: and cpe.information2 = c_information2
12132: --
12133: l_update boolean := false ;
12134: l_datetrack_mode varchar2(80) := hr_api.g_update;
12135: l_process_date date;
12136: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12137: --
12138: --UPD END
12139: l_current_pk_id number := null ;
12140: l_prev_pk_id number := null ;
12526: select distinct cpe.information1,
12527: cpe.information2,
12528: cpe.information3,
12529: cpe.table_route_id
12530: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12531: pqh_table_route tr
12532: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12533: and cpe.table_route_id = tr.table_route_id
12534: -- and tr.where_clause = l_BEN_PRTN_ELIG_PRFL_F
12542: c_information1 number) is
12543: select
12544: min(cpe.information2) min_esd,
12545: max(cpe.information3) min_eed
12546: from ben_copy_entity_results cpe
12547: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12548: and cpe.table_route_id = c_table_route_id
12549: and cpe.information1 = c_information1 ;
12550: --
12553: c_information2 date,
12554: c_information3 date ) is
12555: select
12556: cpe.*
12557: from ben_copy_entity_results cpe
12558: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12559: and cpe.table_route_id = c_table_route_id
12560: and cpe.information1 = c_information1
12561: and cpe.information2 = c_information2
12604: --
12605: l_update boolean := false ;
12606: l_datetrack_mode varchar2(80) := hr_api.g_update;
12607: l_process_date date;
12608: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12609: --
12610: --UPD END
12611: l_current_pk_id number := null ;
12612: l_prev_pk_id number := null ;
12998: select distinct cpe.information1,
12999: cpe.information2,
13000: cpe.information3,
13001: cpe.table_route_id
13002: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13003: pqh_table_route tr
13004: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13005: and cpe.table_route_id = tr.table_route_id
13006: -- and tr.where_clause = l_BEN_POPL_ORG_ROLE_F
13014: c_information1 number) is
13015: select
13016: min(cpe.information2) min_esd,
13017: max(cpe.information3) min_eed
13018: from ben_copy_entity_results cpe
13019: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13020: and cpe.table_route_id = c_table_route_id
13021: and cpe.information1 = c_information1 ;
13022: --
13025: c_information2 date,
13026: c_information3 date ) is
13027: select
13028: cpe.*
13029: from ben_copy_entity_results cpe
13030: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13031: and cpe.table_route_id = c_table_route_id
13032: and cpe.information1 = c_information1
13033: and cpe.information2 = c_information2
13079: --
13080: l_update boolean := false ;
13081: l_datetrack_mode varchar2(80) := hr_api.g_update;
13082: l_process_date date;
13083: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13084: --
13085: --UPD END
13086: l_current_pk_id number := null ;
13087: l_prev_pk_id number := null ;
13478: select distinct cpe.information1,
13479: cpe.information2,
13480: cpe.information3,
13481: cpe.table_route_id
13482: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13483: pqh_table_route tr
13484: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13485: and cpe.table_route_id = tr.table_route_id
13486: -- and tr.where_clause = l_BEN_POPL_ORG_F
13494: c_information1 number) is
13495: select
13496: min(cpe.information2) min_esd,
13497: max(cpe.information3) min_eed
13498: from ben_copy_entity_results cpe
13499: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13500: and cpe.table_route_id = c_table_route_id
13501: and cpe.information1 = c_information1 ;
13502: --
13505: c_information2 date,
13506: c_information3 date ) is
13507: select
13508: cpe.*
13509: from ben_copy_entity_results cpe
13510: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13511: and cpe.table_route_id = c_table_route_id
13512: and cpe.information1 = c_information1
13513: and cpe.information2 = c_information2
13559: --
13560: l_update boolean := false ;
13561: l_datetrack_mode varchar2(80) := hr_api.g_update;
13562: l_process_date date;
13563: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13564: --
13565: --UPD END
13566: l_current_pk_id number := null ;
13567: l_prev_pk_id number := null ;
13997: select distinct cpe.information1,
13998: cpe.information2,
13999: cpe.information3,
14000: cpe.table_route_id
14001: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14002: pqh_table_route tr
14003: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14004: and cpe.table_route_id = tr.table_route_id
14005: -- and tr.where_clause = l_BEN_PL_REGN_F
14013: c_information1 number) is
14014: select
14015: min(cpe.information2) min_esd,
14016: max(cpe.information3) min_eed
14017: from ben_copy_entity_results cpe
14018: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14019: and cpe.table_route_id = c_table_route_id
14020: and cpe.information1 = c_information1 ;
14021: --
14024: c_information2 date,
14025: c_information3 date ) is
14026: select
14027: cpe.*
14028: from ben_copy_entity_results cpe
14029: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14030: and cpe.table_route_id = c_table_route_id
14031: and cpe.information1 = c_information1
14032: and cpe.information2 = c_information2
14089: --
14090: l_update boolean := false ;
14091: l_datetrack_mode varchar2(80) := hr_api.g_update;
14092: l_process_date date;
14093: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14094: --
14095: --UPD END
14096: l_current_pk_id number := null ;
14097: l_prev_pk_id number := null ;
14524: select distinct cpe.information1,
14525: cpe.information2,
14526: cpe.information3,
14527: cpe.table_route_id
14528: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14529: pqh_table_route tr
14530: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14531: and cpe.table_route_id = tr.table_route_id
14532: -- and tr.where_clause = l_BEN_POPL_RPTG_GRP_F
14540: c_information1 number) is
14541: select
14542: min(cpe.information2) min_esd,
14543: max(cpe.information3) min_eed
14544: from ben_copy_entity_results cpe
14545: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14546: and cpe.table_route_id = c_table_route_id
14547: and cpe.information1 = c_information1 ;
14548: --
14551: c_information2 date,
14552: c_information3 date ) is
14553: select
14554: cpe.*
14555: from ben_copy_entity_results cpe
14556: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14557: and cpe.table_route_id = c_table_route_id
14558: and cpe.information1 = c_information1
14559: and cpe.information2 = c_information2
14605: --
14606: l_update boolean := false ;
14607: l_datetrack_mode varchar2(80) := hr_api.g_update;
14608: l_process_date date;
14609: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14610: --
14611: --UPD END
14612: l_current_pk_id number := null ;
14613: l_prev_pk_id number := null ;
15006: select distinct cpe.information1,
15007: cpe.information2,
15008: cpe.information3,
15009: cpe.table_route_id
15010: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15011: pqh_table_route tr
15012: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15013: and cpe.table_route_id = tr.table_route_id
15014: -- and tr.where_clause = l_BEN_ENRT_CTFN_F
15022: c_information1 number) is
15023: select
15024: min(cpe.information2) min_esd,
15025: max(cpe.information3) min_eed
15026: from ben_copy_entity_results cpe
15027: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15028: and cpe.table_route_id = c_table_route_id
15029: and cpe.information1 = c_information1 ;
15030: --
15033: c_information2 date,
15034: c_information3 date) is
15035: select
15036: cpe.*
15037: from ben_copy_entity_results cpe
15038: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15039: and cpe.table_route_id = c_table_route_id
15040: and cpe.information1 = c_information1
15041: and cpe.information2 = c_information2
15087: --
15088: l_update boolean := false ;
15089: l_datetrack_mode varchar2(80) := hr_api.g_update;
15090: l_process_date date;
15091: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15092: --
15093: --UPD END
15094: l_current_pk_id number := null ;
15095: l_prev_pk_id number := null ;
15491: select distinct cpe.information1,
15492: cpe.information2,
15493: cpe.information3,
15494: cpe.table_route_id
15495: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15496: pqh_table_route tr
15497: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15498: and cpe.table_route_id = tr.table_route_id
15499: -- and tr.where_clause = l_BEN_PRTN_ELIG_F
15507: c_information1 number) is
15508: select
15509: min(cpe.information2) min_esd,
15510: max(cpe.information3) min_eed
15511: from ben_copy_entity_results cpe
15512: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15513: and cpe.table_route_id = c_table_route_id
15514: and cpe.information1 = c_information1 ;
15515: --
15518: c_information2 date,
15519: c_information3 date ) is
15520: select
15521: cpe.*
15522: from ben_copy_entity_results cpe
15523: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15524: and cpe.table_route_id = c_table_route_id
15525: and cpe.information1 = c_information1
15526: and cpe.information2 = c_information2
15578: --
15579: l_update boolean := false ;
15580: l_datetrack_mode varchar2(80) := hr_api.g_update;
15581: l_process_date date;
15582: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15583: --
15584: --UPD END
15585: l_current_pk_id number := null ;
15586: l_prev_pk_id number := null ;
16010: select distinct cpe.information1,
16011: cpe.information2,
16012: cpe.information3,
16013: cpe.table_route_id
16014: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16015: pqh_table_route tr
16016: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16017: and cpe.table_route_id = tr.table_route_id
16018: -- and tr.where_clause = l_BEN_POPL_YR_PERD
16026: c_information1 number) is
16027: select
16028: min(cpe.information2) min_esd,
16029: max(cpe.information3) min_eed
16030: from ben_copy_entity_results cpe
16031: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16032: and cpe.table_route_id = c_table_route_id
16033: and cpe.information1 = c_information1 ;
16034: --
16037: c_information2 date,
16038: c_information3 date ) is
16039: select
16040: cpe.*
16041: from ben_copy_entity_results cpe
16042: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16043: and cpe.table_route_id = c_table_route_id
16044: and cpe.information1 = c_information1
16045: and rownum = 1 ;
16064: --
16065: l_update boolean := false ;
16066: l_datetrack_mode varchar2(80) := hr_api.g_update;
16067: l_process_date date;
16068: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16069: --
16070: --UPD END
16071: l_current_pk_id number := null ;
16072: l_prev_pk_id number := null ;
16356: select distinct cpe.information1,
16357: cpe.information2,
16358: cpe.information3,
16359: cpe.table_route_id
16360: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16361: pqh_table_route tr
16362: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16363: and cpe.table_route_id = tr.table_route_id
16364: -- and tr.where_clause = l_BEN_POPL_ENRT_TYP_CYCL_F
16372: c_information1 number) is
16373: select
16374: min(cpe.information2) min_esd,
16375: max(cpe.information3) min_eed
16376: from ben_copy_entity_results cpe
16377: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16378: and cpe.table_route_id = c_table_route_id
16379: and cpe.information1 = c_information1 ;
16380: --
16383: c_information2 date,
16384: c_information3 date ) is
16385: select
16386: cpe.*
16387: from ben_copy_entity_results cpe
16388: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16389: and cpe.table_route_id = c_table_route_id
16390: and cpe.information1 = c_information1
16391: and cpe.information2 = c_information2
16437: --
16438: l_update boolean := false ;
16439: l_datetrack_mode varchar2(80) := hr_api.g_update;
16440: l_process_date date;
16441: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16442: --
16443: --UPD END
16444: l_current_pk_id number := null ;
16445: l_prev_pk_id number := null ;
16832: select distinct cpe.information1,
16833: cpe.information2,
16834: cpe.information3,
16835: cpe.table_route_id
16836: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16837: pqh_table_route tr
16838: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16839: and cpe.table_route_id = tr.table_route_id
16840: -- and tr.where_clause = l_BEN_ENRT_PERD
16849: c_information1 number) is
16850: select
16851: min(cpe.information2) min_esd,
16852: max(cpe.information3) min_eed
16853: from ben_copy_entity_results cpe
16854: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16855: and cpe.table_route_id = c_table_route_id
16856: and cpe.information1 = c_information1 ;
16857: --
16860: c_information2 date,
16861: c_information3 date) is
16862: select
16863: cpe.*
16864: from ben_copy_entity_results cpe
16865: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16866: and cpe.table_route_id = c_table_route_id
16867: and cpe.information1 = c_information1
16868: and rownum = 1 ;
16887: --
16888: l_update boolean := false ;
16889: l_datetrack_mode varchar2(80) := hr_api.g_update;
16890: l_process_date date;
16891: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16892: --
16893: --UPD END
16894: l_current_pk_id number := null ;
16895: l_prev_pk_id number := null ;
17295: select distinct cpe.information1,
17296: cpe.information2,
17297: cpe.information3,
17298: cpe.table_route_id
17299: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17300: pqh_table_route tr
17301: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17302: and cpe.table_route_id = tr.table_route_id
17303: -- and tr.where_clause = l_BEN_LEE_RSN_F
17311: c_information1 number) is
17312: select
17313: min(cpe.information2) min_esd,
17314: max(cpe.information3) min_eed
17315: from ben_copy_entity_results cpe
17316: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17317: and cpe.table_route_id = c_table_route_id
17318: and cpe.information1 = c_information1 ;
17319: --
17322: c_information2 date,
17323: c_information3 date) is
17324: select
17325: cpe.*
17326: from ben_copy_entity_results cpe
17327: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17328: and cpe.table_route_id = c_table_route_id
17329: and cpe.information1 = c_information1
17330: and cpe.information2 = c_information2
17370: --
17371: l_update boolean := false ;
17372: l_datetrack_mode varchar2(80) := hr_api.g_update;
17373: l_process_date date;
17374: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17375: --
17376: --UPD END
17377: l_current_pk_id number := null ;
17378: l_prev_pk_id number := null ;
17815: select distinct cpe.information1,
17816: cpe.information2,
17817: cpe.information3,
17818: cpe.table_route_id
17819: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17820: pqh_table_route tr
17821: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17822: and cpe.table_route_id = tr.table_route_id
17823: -- and tr.where_clause = l_BEN_ENRT_PERD_FOR_PL_F
17831: c_information1 number) is
17832: select
17833: min(cpe.information2) min_esd,
17834: max(cpe.information3) min_eed
17835: from ben_copy_entity_results cpe
17836: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17837: and cpe.table_route_id = c_table_route_id
17838: and cpe.information1 = c_information1 ;
17839: --
17842: c_information2 date,
17843: c_information3 date) is
17844: select
17845: cpe.*
17846: from ben_copy_entity_results cpe
17847: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17848: and cpe.table_route_id = c_table_route_id
17849: and cpe.information1 = c_information1
17850: and cpe.information2 = c_information2
17895: --
17896: l_update boolean := false ;
17897: l_datetrack_mode varchar2(80) := hr_api.g_update;
17898: l_process_date date;
17899: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17900: --
17901: --UPD END
17902: l_current_pk_id number := null ;
17903: l_prev_pk_id number := null ;
18308: select distinct cpe.information1,
18309: cpe.information2,
18310: cpe.information3,
18311: cpe.table_route_id
18312: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18313: pqh_table_route tr
18314: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18315: and cpe.table_route_id = tr.table_route_id
18316: -- and tr.where_clause = l_BEN_SCHEDD_ENRT_RL_F
18324: c_information1 number) is
18325: select
18326: min(cpe.information2) min_esd,
18327: max(cpe.information3) min_eed
18328: from ben_copy_entity_results cpe
18329: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18330: and cpe.table_route_id = c_table_route_id
18331: and cpe.information1 = c_information1 ;
18332: --
18335: c_information2 date,
18336: c_information3 date ) is
18337: select
18338: cpe.*
18339: from ben_copy_entity_results cpe
18340: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18341: and cpe.table_route_id = c_table_route_id
18342: and cpe.information1 = c_information1
18343: and cpe.information2 = c_information2
18383: --
18384: l_update boolean := false ;
18385: l_datetrack_mode varchar2(80) := hr_api.g_update;
18386: l_process_date date;
18387: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18388: --
18389: --UPD END
18390: l_current_pk_id number := null ;
18391: l_prev_pk_id number := null ;
18771: select distinct cpe.information1,
18772: cpe.information2,
18773: cpe.information3,
18774: cpe.table_route_id
18775: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18776: pqh_table_route tr
18777: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18778: and cpe.table_route_id = tr.table_route_id
18779: -- and tr.where_clause = l_BEN_LEE_RSN_RL_F
18787: c_information1 number) is
18788: select
18789: min(cpe.information2) min_esd,
18790: max(cpe.information3) min_eed
18791: from ben_copy_entity_results cpe
18792: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18793: and cpe.table_route_id = c_table_route_id
18794: and cpe.information1 = c_information1 ;
18795: --
18798: c_information2 date,
18799: c_information3 date) is
18800: select
18801: cpe.*
18802: from ben_copy_entity_results cpe
18803: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18804: and cpe.table_route_id = c_table_route_id
18805: and cpe.information1 = c_information1
18806: and cpe.information2 = c_information2
18846: --
18847: l_update boolean := false ;
18848: l_datetrack_mode varchar2(80) := hr_api.g_update;
18849: l_process_date date;
18850: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18851: --
18852: --UPD END
18853: l_current_pk_id number := null ;
18854: l_prev_pk_id number := null ;
19236: select distinct cpe.information1,
19237: cpe.information2,
19238: cpe.information3,
19239: cpe.table_route_id
19240: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19241: pqh_table_route tr
19242: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19243: and cpe.table_route_id = tr.table_route_id
19244: -- and tr.where_clause = l_APLD_DPNT_CVG_ELIG_PRFL_F
19252: c_information1 number) is
19253: select
19254: min(cpe.information2) min_esd,
19255: max(cpe.information3) min_eed
19256: from ben_copy_entity_results cpe
19257: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19258: and cpe.table_route_id = c_table_route_id
19259: and cpe.information1 = c_information1 ;
19260: --
19263: c_information2 date,
19264: c_information3 date) is
19265: select
19266: cpe.*
19267: from ben_copy_entity_results cpe
19268: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19269: and cpe.table_route_id = c_table_route_id
19270: and cpe.information1 = c_information1
19271: and cpe.information2 = c_information2
19317: --
19318: l_update boolean := false ;
19319: l_datetrack_mode varchar2(80) := hr_api.g_update;
19320: l_process_date date;
19321: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19322: --
19323: --UPD END
19324: l_current_pk_id number := null ;
19325: l_prev_pk_id number := null ;
19716: select distinct cpe.information1,
19717: cpe.information2,
19718: cpe.information3,
19719: cpe.table_route_id
19720: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19721: pqh_table_route tr
19722: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19723: and cpe.table_route_id = tr.table_route_id
19724: -- and tr.where_clause = l_BEN_PGM_DPNT_CVG_CTFN_F
19732: c_information1 number) is
19733: select
19734: min(cpe.information2) min_esd,
19735: max(cpe.information3) min_eed
19736: from ben_copy_entity_results cpe
19737: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19738: and cpe.table_route_id = c_table_route_id
19739: and cpe.information1 = c_information1 ;
19740: --
19743: c_information2 date,
19744: c_information3 date ) is
19745: select
19746: cpe.*
19747: from ben_copy_entity_results cpe
19748: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19749: and cpe.table_route_id = c_table_route_id
19750: and cpe.information1 = c_information1
19751: and cpe.information2 = c_information2
19791: --
19792: l_update boolean := false ;
19793: l_datetrack_mode varchar2(80) := hr_api.g_update;
19794: l_process_date date;
19795: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19796: --
19797: --UPD END
19798: l_current_pk_id number := null ;
19799: l_prev_pk_id number := null ;
20191: select distinct cpe.information1,
20192: cpe.information2,
20193: cpe.information3,
20194: cpe.table_route_id
20195: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20196: pqh_table_route tr
20197: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20198: and cpe.table_route_id = tr.table_route_id
20199: -- and tr.where_clause = l_BEN_LER_CHG_PGM_ENRT_F
20207: c_information1 number) is
20208: select
20209: min(cpe.information2) min_esd,
20210: max(cpe.information3) min_eed
20211: from ben_copy_entity_results cpe
20212: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20213: and cpe.table_route_id = c_table_route_id
20214: and cpe.information1 = c_information1 ;
20215: --
20218: c_information2 date,
20219: c_information3 date ) is
20220: select
20221: cpe.*
20222: from ben_copy_entity_results cpe
20223: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20224: and cpe.table_route_id = c_table_route_id
20225: and cpe.information1 = c_information1
20226: and cpe.information2 = c_information2
20266: --
20267: l_update boolean := false ;
20268: l_datetrack_mode varchar2(80) := hr_api.g_update;
20269: l_process_date date;
20270: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20271: --
20272: --UPD END
20273: l_current_pk_id number := null ;
20274: l_prev_pk_id number := null ;
20679: select distinct cpe.information1,
20680: cpe.information2,
20681: cpe.information3,
20682: cpe.table_route_id
20683: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20684: pqh_table_route tr
20685: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20686: and cpe.table_route_id = tr.table_route_id
20687: -- and tr.where_clause = l_BEN_LER_CHG_DPNT_CVG_F
20695: c_information1 number) is
20696: select
20697: min(cpe.information2) min_esd,
20698: max(cpe.information3) min_eed
20699: from ben_copy_entity_results cpe
20700: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20701: and cpe.table_route_id = c_table_route_id
20702: and cpe.information1 = c_information1 ;
20703: --
20706: c_information2 date,
20707: c_information3 date ) is
20708: select
20709: cpe.*
20710: from ben_copy_entity_results cpe
20711: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20712: and cpe.table_route_id = c_table_route_id
20713: and cpe.information1 = c_information1
20714: and cpe.information2 = c_information2
20760: --
20761: l_update boolean := false ;
20762: l_datetrack_mode varchar2(80) := hr_api.g_update;
20763: l_process_date date;
20764: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20765: --
20766: --UPD END
20767:
20768: l_current_pk_id number := null ;
21178: select distinct cpe.information1,
21179: cpe.information2,
21180: cpe.information3,
21181: cpe.table_route_id
21182: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21183: pqh_table_route tr
21184: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21185: and cpe.table_route_id = tr.table_route_id
21186: -- and tr.where_clause = l_BEN_POPL_ACTN_TYP_F
21194: c_information1 number) is
21195: select
21196: min(cpe.information2) min_esd,
21197: max(cpe.information3) min_eed
21198: from ben_copy_entity_results cpe
21199: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21200: and cpe.table_route_id = c_table_route_id
21201: and cpe.information1 = c_information1 ;
21202: --
21205: c_information2 date,
21206: c_information3 date ) is
21207: select
21208: cpe.*
21209: from ben_copy_entity_results cpe
21210: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21211: and cpe.table_route_id = c_table_route_id
21212: and cpe.information1 = c_information1
21213: and cpe.information2 = c_information2
21252: --
21253: l_update boolean := false ;
21254: l_datetrack_mode varchar2(80) := hr_api.g_update;
21255: l_process_date date;
21256: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21257: --
21258: --UPD END
21259: l_current_pk_id number := null ;
21260: l_prev_pk_id number := null ;
21668: select distinct cpe.information1,
21669: cpe.information2,
21670: cpe.information3,
21671: cpe.table_route_id
21672: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21673: pqh_table_route tr
21674: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21675: and cpe.table_route_id = tr.table_route_id
21676: -- and tr.where_clause = l_BEN_ELIG_TO_PRTE_RSN_F
21684: c_information1 number) is
21685: select
21686: min(cpe.information2) min_esd,
21687: max(cpe.information3) min_eed
21688: from ben_copy_entity_results cpe
21689: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21690: and cpe.table_route_id = c_table_route_id
21691: and cpe.information1 = c_information1 ;
21692: --
21695: c_information2 date,
21696: c_information3 date) is
21697: select
21698: cpe.*
21699: from ben_copy_entity_results cpe
21700: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21701: and cpe.table_route_id = c_table_route_id
21702: and cpe.information1 = c_information1
21703: and cpe.information2 = c_information2
21755: --
21756: l_update boolean := false ;
21757: l_datetrack_mode varchar2(80) := hr_api.g_update;
21758: l_process_date date;
21759: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21760: --
21761: --UPD END
21762: l_current_pk_id number := null ;
21763: l_prev_pk_id number := null ;
22209: select distinct cpe.information1,
22210: cpe.information2,
22211: cpe.information3,
22212: cpe.table_route_id
22213: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22214: pqh_table_route tr
22215: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22216: and cpe.table_route_id = tr.table_route_id
22217: -- and tr.where_clause = l_BEN_CWB_WKSHT_GRP
22225: c_information1 number) is
22226: select
22227: min(cpe.information2) min_esd,
22228: max(cpe.information3) min_eed
22229: from ben_copy_entity_results cpe
22230: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22231: and cpe.table_route_id = c_table_route_id
22232: and cpe.information1 = c_information1 ;
22233: --
22236: c_information2 date,
22237: c_information3 date ) is
22238: select
22239: cpe.*
22240: from ben_copy_entity_results cpe
22241: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22242: and cpe.table_route_id = c_table_route_id
22243: and cpe.information1 = c_information1
22244: and rownum = 1 ;
22262: --
22263: l_update boolean := false ;
22264: l_datetrack_mode varchar2(80) := hr_api.g_update;
22265: l_process_date date;
22266: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22267: --
22268: --UPD END
22269: l_current_pk_id number := null ;
22270: l_prev_pk_id number := null ;
22552: cpe.information12,
22553: cpe.information13,
22554: cpe.INFORMATION14,
22555: cpe.table_route_id,dml_operation,cpe.datetrack_mode
22556: from ben_copy_entity_results cpe,
22557: pqh_table_route tr
22558: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22559: and cpe.table_route_id = tr.table_route_id
22560: -- and tr.where_clause = l_BEN_AGE_FCTR
22574: c_information14 varchar2
22575: ) is
22576: select
22577: cpe.*
22578: from ben_copy_entity_results cpe
22579: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22580: and cpe.table_route_id = c_table_route_id
22581: and cpe.information11 = c_information11
22582: and cpe.information12 = c_information12
22602: --
22603: l_update boolean := false ;
22604: l_process_date date;
22605: l_debug_item_name ben_custom_region_items.item_name%type;
22606: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22607: r_find_CRI_in_target c_find_CRI_in_target%rowtype;
22608: r_CRI c_CRI%rowtype;
22609: --
22610: --UPD END
22739: select distinct cpe.information1,
22740: cpe.information2,
22741: cpe.information3,
22742: cpe.table_route_id
22743: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22744: pqh_table_route tr
22745: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22746: and cpe.table_route_id = tr.table_route_id
22747: -- and tr.where_clause = l_BEN_PL_PCP
22755: c_information1 number) is
22756: select
22757: min(cpe.information2) min_esd,
22758: max(cpe.information3) min_eed
22759: from ben_copy_entity_results cpe
22760: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22761: and cpe.table_route_id = c_table_route_id
22762: and cpe.information1 = c_information1 ;
22763: --
22766: c_information2 date,
22767: c_information3 date ) is
22768: select
22769: cpe.*
22770: from ben_copy_entity_results cpe
22771: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22772: and cpe.table_route_id = c_table_route_id
22773: and cpe.information1 = c_information1
22774: and rownum = 1 ;
22799: --
22800: l_update boolean := false ;
22801: l_datetrack_mode varchar2(80) := hr_api.g_update;
22802: l_process_date date;
22803: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22804: --
22805: --UPD END
22806: l_current_pk_id number := null ;
22807: l_prev_pk_id number := null ;
23143: select distinct cpe.information1,
23144: cpe.information2,
23145: cpe.information3,
23146: cpe.table_route_id
23147: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23148: pqh_table_route tr
23149: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23150: and cpe.table_route_id = tr.table_route_id
23151: -- and tr.where_clause = l_BEN_OIPL_F
23159: c_information1 number) is
23160: select
23161: min(cpe.information2) min_esd,
23162: max(cpe.information3) min_eed
23163: from ben_copy_entity_results cpe
23164: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23165: and cpe.table_route_id = c_table_route_id
23166: and cpe.information1 = c_information1 ;
23167: --
23170: c_information2 date,
23171: c_information3 date ) is
23172: select
23173: cpe.*
23174: from ben_copy_entity_results cpe
23175: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23176: and cpe.table_route_id = c_table_route_id
23177: and cpe.information1 = c_information1
23178: and cpe.information2 = c_information2
23221: --
23222: l_update boolean := false ;
23223: l_datetrack_mode varchar2(80) := hr_api.g_update;
23224: l_process_date date;
23225: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23226: --
23227: --UPD END
23228: l_current_pk_id number := null ;
23229: l_prev_pk_id number := null ;
23691: select distinct cpe.information1,
23692: cpe.information2,
23693: cpe.information3,
23694: cpe.table_route_id
23695: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23696: pqh_table_route tr
23697: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23698: and cpe.table_route_id = tr.table_route_id
23699: -- and tr.where_clause = l_BEN_DSGN_RQMT_F
23707: c_information1 number) is
23708: select
23709: min(cpe.information2) min_esd,
23710: max(cpe.information3) min_eed
23711: from ben_copy_entity_results cpe
23712: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23713: and cpe.table_route_id = c_table_route_id
23714: and cpe.information1 = c_information1 ;
23715: --
23718: c_information2 date,
23719: c_information3 date) is
23720: select
23721: cpe.*
23722: from ben_copy_entity_results cpe
23723: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23724: and cpe.table_route_id = c_table_route_id
23725: and cpe.information1 = c_information1
23726: and cpe.information2 = c_information2
23775: --
23776: l_update boolean := false ;
23777: l_datetrack_mode varchar2(80) := hr_api.g_update;
23778: l_process_date date;
23779: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23780: --
23781: --UPD END
23782: l_current_pk_id number := null ;
23783: l_prev_pk_id number := null ;
24183: select distinct cpe.information1,
24184: cpe.information2,
24185: cpe.information3,
24186: cpe.table_route_id
24187: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24188: pqh_table_route tr
24189: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24190: and cpe.table_route_id = tr.table_route_id
24191: -- and tr.where_clause = l_BEN_DSGN_RQMT_RLSHP_TYP
24199: c_information1 number) is
24200: select
24201: min(cpe.information2) min_esd,
24202: max(cpe.information3) min_eed
24203: from ben_copy_entity_results cpe
24204: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24205: and cpe.table_route_id = c_table_route_id
24206: and cpe.information1 = c_information1 ;
24207: --
24210: c_information2 date,
24211: c_information3 date) is
24212: select
24213: cpe.*
24214: from ben_copy_entity_results cpe
24215: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24216: and cpe.table_route_id = c_table_route_id
24217: and cpe.information1 = c_information1
24218: and rownum = 1 ;
24236: --
24237: l_update boolean := false ;
24238: l_datetrack_mode varchar2(80) := hr_api.g_update;
24239: l_process_date date;
24240: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
24241: --
24242: --UPD END
24243: l_current_pk_id number := null ;
24244: l_prev_pk_id number := null ;
24532: select distinct cpe.information1,
24533: cpe.information2,
24534: cpe.information3,
24535: cpe.table_route_id
24536: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24537: pqh_table_route tr
24538: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24539: and cpe.table_route_id = tr.table_route_id
24540: -- and tr.where_clause = l_BEN_OIPLIP_F
24548: c_information1 number) is
24549: select
24550: min(cpe.information2) min_esd,
24551: max(cpe.information3) min_eed
24552: from ben_copy_entity_results cpe
24553: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24554: and cpe.table_route_id = c_table_route_id
24555: and cpe.information1 = c_information1 ;
24556: --
24559: c_information2 date,
24560: c_information3 date ) is
24561: select
24562: cpe.*
24563: from ben_copy_entity_results cpe
24564: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24565: and cpe.table_route_id = c_table_route_id
24566: and cpe.information1 = c_information1
24567: and cpe.information2 = c_information2
24924: select distinct cpe.information1,
24925: cpe.information2,
24926: cpe.information3,
24927: cpe.table_route_id
24928: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24929: pqh_table_route tr
24930: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24931: and cpe.table_route_id = tr.table_route_id
24932: -- and tr.where_clause = l_BEN_OPTIP_F
24939: c_information1 number) is
24940: select
24941: min(cpe.information2) min_esd,
24942: max(cpe.information3) min_eed
24943: from ben_copy_entity_results cpe
24944: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24945: and cpe.table_route_id = c_table_route_id
24946: and cpe.information1 = c_information1 ;
24947: --
24950: c_information2 date,
24951: c_information3 date ) is
24952: select
24953: cpe.*
24954: from ben_copy_entity_results cpe
24955: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24956: and cpe.table_route_id = c_table_route_id
24957: and cpe.information1 = c_information1
24958: and cpe.information2 = c_information2
25326: select distinct cpe.information1,
25327: cpe.information2,
25328: cpe.information3,
25329: cpe.table_route_id
25330: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25331: pqh_table_route tr
25332: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25333: and cpe.table_route_id = tr.table_route_id
25334: -- and tr.where_clause = l_BEN_PL_PCP_TYP
25342: c_information1 number) is
25343: select
25344: min(cpe.information2) min_esd,
25345: max(cpe.information3) min_eed
25346: from ben_copy_entity_results cpe
25347: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25348: and cpe.table_route_id = c_table_route_id
25349: and cpe.information1 = c_information1 ;
25350: --
25353: c_information2 date,
25354: c_information3 date ) is
25355: select
25356: cpe.*
25357: from ben_copy_entity_results cpe
25358: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25359: and cpe.table_route_id = c_table_route_id
25360: and cpe.information1 = c_information1
25361: and rownum = 1 ;
25390: --
25391: l_update boolean := false ;
25392: l_datetrack_mode varchar2(80) := hr_api.g_update;
25393: l_process_date date;
25394: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25395: --
25396: --UPD END
25397: l_current_pk_id number := null ;
25398: l_prev_pk_id number := null ;
25689: select distinct cpe.information1,
25690: cpe.information2,
25691: cpe.information3,
25692: cpe.table_route_id
25693: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25694: pqh_table_route tr
25695: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25696: and cpe.table_route_id = tr.table_route_id
25697: -- and tr.where_clause = l_BEN_PL_REGY_PRP_F
25705: c_information1 number) is
25706: select
25707: min(cpe.information2) min_esd,
25708: max(cpe.information3) min_eed
25709: from ben_copy_entity_results cpe
25710: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25711: and cpe.table_route_id = c_table_route_id
25712: and cpe.information1 = c_information1 ;
25713: --
25716: c_information2 date,
25717: c_information3 date ) is
25718: select
25719: cpe.*
25720: from ben_copy_entity_results cpe
25721: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25722: and cpe.table_route_id = c_table_route_id
25723: and cpe.information1 = c_information1
25724: and cpe.information2 = c_information2
25764: --
25765: l_update boolean := false ;
25766: l_datetrack_mode varchar2(80) := hr_api.g_update;
25767: l_process_date date;
25768: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25769: --
25770: --UPD END
25771: l_current_pk_id number := null ;
25772: l_prev_pk_id number := null ;
26170: cpe.information2,
26171: cpe.information3,
26172: cpe.INFORMATION170 name ,
26173: cpe.table_route_id
26174: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26175: pqh_table_route tr
26176: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26177: and cpe.table_route_id = tr.table_route_id
26178: -- and tr.where_clause = l_BEN_BNFT_PRVDR_POOL_F
26186: c_information1 number) is
26187: select
26188: min(cpe.information2) min_esd,
26189: max(cpe.information3) min_eed
26190: from ben_copy_entity_results cpe
26191: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26192: and cpe.table_route_id = c_table_route_id
26193: and cpe.information1 = c_information1 ;
26194: --
26197: c_information2 date,
26198: c_information3 date) is
26199: select
26200: cpe.*
26201: from ben_copy_entity_results cpe
26202: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26203: and cpe.table_route_id = c_table_route_id
26204: and cpe.information1 = c_information1
26205: and cpe.information2 = c_information2
26290: --
26291: l_update boolean := false ;
26292: l_datetrack_mode varchar2(80) := hr_api.g_update;
26293: l_process_date date;
26294: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26295: --
26296: --UPD END
26297: l_current_pk_id number := null ;
26298: l_prev_pk_id number := null ;
26794: cpe.information2,
26795: cpe.information3,
26796: cpe.information170 name,
26797: cpe.table_route_id
26798: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26799: pqh_table_route tr
26800: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26801: and cpe.table_route_id = tr.table_route_id
26802: -- and tr.where_clause = l_BEN_ACRS_PTIP_CVG_F
26810: c_information1 number) is
26811: select
26812: min(cpe.information2) min_esd,
26813: max(cpe.information3) min_eed
26814: from ben_copy_entity_results cpe
26815: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26816: and cpe.table_route_id = c_table_route_id
26817: and cpe.information1 = c_information1 ;
26818: --
26821: c_information2 date,
26822: c_information3 date) is
26823: select
26824: cpe.*
26825: from ben_copy_entity_results cpe
26826: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26827: and cpe.table_route_id = c_table_route_id
26828: and cpe.information1 = c_information1
26829: and cpe.information2 = c_information2
26866: --
26867: l_update boolean := false ;
26868: l_datetrack_mode varchar2(80) := hr_api.g_update;
26869: l_process_date date;
26870: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26871: --
26872: --UPD END
26873: l_current_pk_id number := null ;
26874: l_prev_pk_id number := null ;
28203:
28204: -- Update information9 to NULL
28205: -- Required for reusing Copy Process
28206:
28207: update ben_copy_entity_results
28208: set information9 = null
28209: where copy_entity_txn_id = p_copy_entity_txn_id;
28210:
28211: