[Home] [Help]
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 ;
16116: --
16117: l_update boolean := false ;
16118: l_datetrack_mode varchar2(80) := hr_api.g_update;
16119: l_process_date date;
16120: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16121: --
16122: --UPD END
16123: l_current_pk_id number := null ;
16124: l_prev_pk_id number := null ;
16443: select distinct cpe.information1,
16444: cpe.information2,
16445: cpe.information3,
16446: cpe.table_route_id
16447: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16448: pqh_table_route tr
16449: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16450: and cpe.table_route_id = tr.table_route_id
16451: -- and tr.where_clause = l_BEN_POPL_ENRT_TYP_CYCL_F
16459: c_information1 number) is
16460: select
16461: min(cpe.information2) min_esd,
16462: max(cpe.information3) min_eed
16463: from ben_copy_entity_results cpe
16464: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16465: and cpe.table_route_id = c_table_route_id
16466: and cpe.information1 = c_information1 ;
16467: --
16470: c_information2 date,
16471: c_information3 date ) is
16472: select
16473: cpe.*
16474: from ben_copy_entity_results cpe
16475: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16476: and cpe.table_route_id = c_table_route_id
16477: and cpe.information1 = c_information1
16478: and cpe.information2 = c_information2
16524: --
16525: l_update boolean := false ;
16526: l_datetrack_mode varchar2(80) := hr_api.g_update;
16527: l_process_date date;
16528: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16529: --
16530: --UPD END
16531: l_current_pk_id number := null ;
16532: l_prev_pk_id number := null ;
16919: select distinct cpe.information1,
16920: cpe.information2,
16921: cpe.information3,
16922: cpe.table_route_id
16923: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16924: pqh_table_route tr
16925: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16926: and cpe.table_route_id = tr.table_route_id
16927: -- and tr.where_clause = l_BEN_ENRT_PERD
16936: c_information1 number) is
16937: select
16938: min(cpe.information2) min_esd,
16939: max(cpe.information3) min_eed
16940: from ben_copy_entity_results cpe
16941: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16942: and cpe.table_route_id = c_table_route_id
16943: and cpe.information1 = c_information1 ;
16944: --
16947: c_information2 date,
16948: c_information3 date) is
16949: select
16950: cpe.*
16951: from ben_copy_entity_results cpe
16952: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16953: and cpe.table_route_id = c_table_route_id
16954: and cpe.information1 = c_information1
16955: and rownum = 1 ;
16974: --
16975: l_update boolean := false ;
16976: l_datetrack_mode varchar2(80) := hr_api.g_update;
16977: l_process_date date;
16978: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16979: --
16980: --UPD END
16981: l_current_pk_id number := null ;
16982: l_prev_pk_id number := null ;
17382: select distinct cpe.information1,
17383: cpe.information2,
17384: cpe.information3,
17385: cpe.table_route_id
17386: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17387: pqh_table_route tr
17388: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17389: and cpe.table_route_id = tr.table_route_id
17390: -- and tr.where_clause = l_BEN_LEE_RSN_F
17398: c_information1 number) is
17399: select
17400: min(cpe.information2) min_esd,
17401: max(cpe.information3) min_eed
17402: from ben_copy_entity_results cpe
17403: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17404: and cpe.table_route_id = c_table_route_id
17405: and cpe.information1 = c_information1 ;
17406: --
17409: c_information2 date,
17410: c_information3 date) is
17411: select
17412: cpe.*
17413: from ben_copy_entity_results cpe
17414: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17415: and cpe.table_route_id = c_table_route_id
17416: and cpe.information1 = c_information1
17417: and cpe.information2 = c_information2
17457: --
17458: l_update boolean := false ;
17459: l_datetrack_mode varchar2(80) := hr_api.g_update;
17460: l_process_date date;
17461: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17462: --
17463: --UPD END
17464: l_current_pk_id number := null ;
17465: l_prev_pk_id number := null ;
17902: select distinct cpe.information1,
17903: cpe.information2,
17904: cpe.information3,
17905: cpe.table_route_id
17906: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17907: pqh_table_route tr
17908: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17909: and cpe.table_route_id = tr.table_route_id
17910: -- and tr.where_clause = l_BEN_ENRT_PERD_FOR_PL_F
17918: c_information1 number) is
17919: select
17920: min(cpe.information2) min_esd,
17921: max(cpe.information3) min_eed
17922: from ben_copy_entity_results cpe
17923: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17924: and cpe.table_route_id = c_table_route_id
17925: and cpe.information1 = c_information1 ;
17926: --
17929: c_information2 date,
17930: c_information3 date) is
17931: select
17932: cpe.*
17933: from ben_copy_entity_results cpe
17934: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17935: and cpe.table_route_id = c_table_route_id
17936: and cpe.information1 = c_information1
17937: and cpe.information2 = c_information2
17982: --
17983: l_update boolean := false ;
17984: l_datetrack_mode varchar2(80) := hr_api.g_update;
17985: l_process_date date;
17986: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17987: --
17988: --UPD END
17989: l_current_pk_id number := null ;
17990: l_prev_pk_id number := null ;
18395: select distinct cpe.information1,
18396: cpe.information2,
18397: cpe.information3,
18398: cpe.table_route_id
18399: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18400: pqh_table_route tr
18401: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18402: and cpe.table_route_id = tr.table_route_id
18403: -- and tr.where_clause = l_BEN_SCHEDD_ENRT_RL_F
18411: c_information1 number) is
18412: select
18413: min(cpe.information2) min_esd,
18414: max(cpe.information3) min_eed
18415: from ben_copy_entity_results cpe
18416: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18417: and cpe.table_route_id = c_table_route_id
18418: and cpe.information1 = c_information1 ;
18419: --
18422: c_information2 date,
18423: c_information3 date ) is
18424: select
18425: cpe.*
18426: from ben_copy_entity_results cpe
18427: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18428: and cpe.table_route_id = c_table_route_id
18429: and cpe.information1 = c_information1
18430: and cpe.information2 = c_information2
18470: --
18471: l_update boolean := false ;
18472: l_datetrack_mode varchar2(80) := hr_api.g_update;
18473: l_process_date date;
18474: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18475: --
18476: --UPD END
18477: l_current_pk_id number := null ;
18478: l_prev_pk_id number := null ;
18858: select distinct cpe.information1,
18859: cpe.information2,
18860: cpe.information3,
18861: cpe.table_route_id
18862: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18863: pqh_table_route tr
18864: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18865: and cpe.table_route_id = tr.table_route_id
18866: -- and tr.where_clause = l_BEN_LEE_RSN_RL_F
18874: c_information1 number) is
18875: select
18876: min(cpe.information2) min_esd,
18877: max(cpe.information3) min_eed
18878: from ben_copy_entity_results cpe
18879: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18880: and cpe.table_route_id = c_table_route_id
18881: and cpe.information1 = c_information1 ;
18882: --
18885: c_information2 date,
18886: c_information3 date) is
18887: select
18888: cpe.*
18889: from ben_copy_entity_results cpe
18890: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18891: and cpe.table_route_id = c_table_route_id
18892: and cpe.information1 = c_information1
18893: and cpe.information2 = c_information2
18933: --
18934: l_update boolean := false ;
18935: l_datetrack_mode varchar2(80) := hr_api.g_update;
18936: l_process_date date;
18937: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18938: --
18939: --UPD END
18940: l_current_pk_id number := null ;
18941: l_prev_pk_id number := null ;
19323: select distinct cpe.information1,
19324: cpe.information2,
19325: cpe.information3,
19326: cpe.table_route_id
19327: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19328: pqh_table_route tr
19329: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19330: and cpe.table_route_id = tr.table_route_id
19331: -- and tr.where_clause = l_APLD_DPNT_CVG_ELIG_PRFL_F
19339: c_information1 number) is
19340: select
19341: min(cpe.information2) min_esd,
19342: max(cpe.information3) min_eed
19343: from ben_copy_entity_results cpe
19344: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19345: and cpe.table_route_id = c_table_route_id
19346: and cpe.information1 = c_information1 ;
19347: --
19350: c_information2 date,
19351: c_information3 date) is
19352: select
19353: cpe.*
19354: from ben_copy_entity_results cpe
19355: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19356: and cpe.table_route_id = c_table_route_id
19357: and cpe.information1 = c_information1
19358: and cpe.information2 = c_information2
19404: --
19405: l_update boolean := false ;
19406: l_datetrack_mode varchar2(80) := hr_api.g_update;
19407: l_process_date date;
19408: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19409: --
19410: --UPD END
19411: l_current_pk_id number := null ;
19412: l_prev_pk_id number := null ;
19803: select distinct cpe.information1,
19804: cpe.information2,
19805: cpe.information3,
19806: cpe.table_route_id
19807: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19808: pqh_table_route tr
19809: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19810: and cpe.table_route_id = tr.table_route_id
19811: -- and tr.where_clause = l_BEN_PGM_DPNT_CVG_CTFN_F
19819: c_information1 number) is
19820: select
19821: min(cpe.information2) min_esd,
19822: max(cpe.information3) min_eed
19823: from ben_copy_entity_results cpe
19824: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19825: and cpe.table_route_id = c_table_route_id
19826: and cpe.information1 = c_information1 ;
19827: --
19830: c_information2 date,
19831: c_information3 date ) is
19832: select
19833: cpe.*
19834: from ben_copy_entity_results cpe
19835: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19836: and cpe.table_route_id = c_table_route_id
19837: and cpe.information1 = c_information1
19838: and cpe.information2 = c_information2
19878: --
19879: l_update boolean := false ;
19880: l_datetrack_mode varchar2(80) := hr_api.g_update;
19881: l_process_date date;
19882: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19883: --
19884: --UPD END
19885: l_current_pk_id number := null ;
19886: l_prev_pk_id number := null ;
20278: select distinct cpe.information1,
20279: cpe.information2,
20280: cpe.information3,
20281: cpe.table_route_id
20282: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20283: pqh_table_route tr
20284: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20285: and cpe.table_route_id = tr.table_route_id
20286: -- and tr.where_clause = l_BEN_LER_CHG_PGM_ENRT_F
20294: c_information1 number) is
20295: select
20296: min(cpe.information2) min_esd,
20297: max(cpe.information3) min_eed
20298: from ben_copy_entity_results cpe
20299: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20300: and cpe.table_route_id = c_table_route_id
20301: and cpe.information1 = c_information1 ;
20302: --
20305: c_information2 date,
20306: c_information3 date ) is
20307: select
20308: cpe.*
20309: from ben_copy_entity_results cpe
20310: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20311: and cpe.table_route_id = c_table_route_id
20312: and cpe.information1 = c_information1
20313: and cpe.information2 = c_information2
20353: --
20354: l_update boolean := false ;
20355: l_datetrack_mode varchar2(80) := hr_api.g_update;
20356: l_process_date date;
20357: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20358: --
20359: --UPD END
20360: l_current_pk_id number := null ;
20361: l_prev_pk_id number := null ;
20766: select distinct cpe.information1,
20767: cpe.information2,
20768: cpe.information3,
20769: cpe.table_route_id
20770: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20771: pqh_table_route tr
20772: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20773: and cpe.table_route_id = tr.table_route_id
20774: -- and tr.where_clause = l_BEN_LER_CHG_DPNT_CVG_F
20782: c_information1 number) is
20783: select
20784: min(cpe.information2) min_esd,
20785: max(cpe.information3) min_eed
20786: from ben_copy_entity_results cpe
20787: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20788: and cpe.table_route_id = c_table_route_id
20789: and cpe.information1 = c_information1 ;
20790: --
20793: c_information2 date,
20794: c_information3 date ) is
20795: select
20796: cpe.*
20797: from ben_copy_entity_results cpe
20798: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20799: and cpe.table_route_id = c_table_route_id
20800: and cpe.information1 = c_information1
20801: and cpe.information2 = c_information2
20847: --
20848: l_update boolean := false ;
20849: l_datetrack_mode varchar2(80) := hr_api.g_update;
20850: l_process_date date;
20851: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20852: --
20853: --UPD END
20854:
20855: l_current_pk_id number := null ;
21265: select distinct cpe.information1,
21266: cpe.information2,
21267: cpe.information3,
21268: cpe.table_route_id
21269: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21270: pqh_table_route tr
21271: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21272: and cpe.table_route_id = tr.table_route_id
21273: -- and tr.where_clause = l_BEN_POPL_ACTN_TYP_F
21281: c_information1 number) is
21282: select
21283: min(cpe.information2) min_esd,
21284: max(cpe.information3) min_eed
21285: from ben_copy_entity_results cpe
21286: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21287: and cpe.table_route_id = c_table_route_id
21288: and cpe.information1 = c_information1 ;
21289: --
21292: c_information2 date,
21293: c_information3 date ) is
21294: select
21295: cpe.*
21296: from ben_copy_entity_results cpe
21297: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21298: and cpe.table_route_id = c_table_route_id
21299: and cpe.information1 = c_information1
21300: and cpe.information2 = c_information2
21339: --
21340: l_update boolean := false ;
21341: l_datetrack_mode varchar2(80) := hr_api.g_update;
21342: l_process_date date;
21343: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21344: --
21345: --UPD END
21346: l_current_pk_id number := null ;
21347: l_prev_pk_id number := null ;
21755: select distinct cpe.information1,
21756: cpe.information2,
21757: cpe.information3,
21758: cpe.table_route_id
21759: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21760: pqh_table_route tr
21761: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21762: and cpe.table_route_id = tr.table_route_id
21763: -- and tr.where_clause = l_BEN_ELIG_TO_PRTE_RSN_F
21771: c_information1 number) is
21772: select
21773: min(cpe.information2) min_esd,
21774: max(cpe.information3) min_eed
21775: from ben_copy_entity_results cpe
21776: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21777: and cpe.table_route_id = c_table_route_id
21778: and cpe.information1 = c_information1 ;
21779: --
21782: c_information2 date,
21783: c_information3 date) is
21784: select
21785: cpe.*
21786: from ben_copy_entity_results cpe
21787: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21788: and cpe.table_route_id = c_table_route_id
21789: and cpe.information1 = c_information1
21790: and cpe.information2 = c_information2
21842: --
21843: l_update boolean := false ;
21844: l_datetrack_mode varchar2(80) := hr_api.g_update;
21845: l_process_date date;
21846: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21847: --
21848: --UPD END
21849: l_current_pk_id number := null ;
21850: l_prev_pk_id number := null ;
22296: select distinct cpe.information1,
22297: cpe.information2,
22298: cpe.information3,
22299: cpe.table_route_id
22300: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22301: pqh_table_route tr
22302: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22303: and cpe.table_route_id = tr.table_route_id
22304: -- and tr.where_clause = l_BEN_CWB_WKSHT_GRP
22312: c_information1 number) is
22313: select
22314: min(cpe.information2) min_esd,
22315: max(cpe.information3) min_eed
22316: from ben_copy_entity_results cpe
22317: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22318: and cpe.table_route_id = c_table_route_id
22319: and cpe.information1 = c_information1 ;
22320: --
22323: c_information2 date,
22324: c_information3 date ) is
22325: select
22326: cpe.*
22327: from ben_copy_entity_results cpe
22328: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22329: and cpe.table_route_id = c_table_route_id
22330: and cpe.information1 = c_information1
22331: and rownum = 1 ;
22349: --
22350: l_update boolean := false ;
22351: l_datetrack_mode varchar2(80) := hr_api.g_update;
22352: l_process_date date;
22353: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22354: --
22355: --UPD END
22356: l_current_pk_id number := null ;
22357: l_prev_pk_id number := null ;
22639: cpe.information12,
22640: cpe.information13,
22641: cpe.INFORMATION14,
22642: cpe.table_route_id,dml_operation,cpe.datetrack_mode
22643: from ben_copy_entity_results cpe,
22644: pqh_table_route tr
22645: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22646: and cpe.table_route_id = tr.table_route_id
22647: -- and tr.where_clause = l_BEN_AGE_FCTR
22661: c_information14 varchar2
22662: ) is
22663: select
22664: cpe.*
22665: from ben_copy_entity_results cpe
22666: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22667: and cpe.table_route_id = c_table_route_id
22668: and cpe.information11 = c_information11
22669: and cpe.information12 = c_information12
22689: --
22690: l_update boolean := false ;
22691: l_process_date date;
22692: l_debug_item_name ben_custom_region_items.item_name%type;
22693: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22694: r_find_CRI_in_target c_find_CRI_in_target%rowtype;
22695: r_CRI c_CRI%rowtype;
22696: --
22697: --UPD END
22841: select distinct cpe.information1,
22842: cpe.information2,
22843: cpe.information3,
22844: cpe.table_route_id
22845: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22846: pqh_table_route tr
22847: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22848: and cpe.table_route_id = tr.table_route_id
22849: -- and tr.where_clause = l_BEN_PL_PCP
22857: c_information1 number) is
22858: select
22859: min(cpe.information2) min_esd,
22860: max(cpe.information3) min_eed
22861: from ben_copy_entity_results cpe
22862: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22863: and cpe.table_route_id = c_table_route_id
22864: and cpe.information1 = c_information1 ;
22865: --
22868: c_information2 date,
22869: c_information3 date ) is
22870: select
22871: cpe.*
22872: from ben_copy_entity_results cpe
22873: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22874: and cpe.table_route_id = c_table_route_id
22875: and cpe.information1 = c_information1
22876: and rownum = 1 ;
22901: --
22902: l_update boolean := false ;
22903: l_datetrack_mode varchar2(80) := hr_api.g_update;
22904: l_process_date date;
22905: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22906: --
22907: --UPD END
22908: l_current_pk_id number := null ;
22909: l_prev_pk_id number := null ;
23245: select distinct cpe.information1,
23246: cpe.information2,
23247: cpe.information3,
23248: cpe.table_route_id
23249: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23250: pqh_table_route tr
23251: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23252: and cpe.table_route_id = tr.table_route_id
23253: -- and tr.where_clause = l_BEN_OIPL_F
23261: c_information1 number) is
23262: select
23263: min(cpe.information2) min_esd,
23264: max(cpe.information3) min_eed
23265: from ben_copy_entity_results cpe
23266: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23267: and cpe.table_route_id = c_table_route_id
23268: and cpe.information1 = c_information1 ;
23269: --
23272: c_information2 date,
23273: c_information3 date ) is
23274: select
23275: cpe.*
23276: from ben_copy_entity_results cpe
23277: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23278: and cpe.table_route_id = c_table_route_id
23279: and cpe.information1 = c_information1
23280: and cpe.information2 = c_information2
23323: --
23324: l_update boolean := false ;
23325: l_datetrack_mode varchar2(80) := hr_api.g_update;
23326: l_process_date date;
23327: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23328: --
23329: --UPD END
23330: l_current_pk_id number := null ;
23331: l_prev_pk_id number := null ;
23793: select distinct cpe.information1,
23794: cpe.information2,
23795: cpe.information3,
23796: cpe.table_route_id
23797: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23798: pqh_table_route tr
23799: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23800: and cpe.table_route_id = tr.table_route_id
23801: -- and tr.where_clause = l_BEN_DSGN_RQMT_F
23809: c_information1 number) is
23810: select
23811: min(cpe.information2) min_esd,
23812: max(cpe.information3) min_eed
23813: from ben_copy_entity_results cpe
23814: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23815: and cpe.table_route_id = c_table_route_id
23816: and cpe.information1 = c_information1 ;
23817: --
23820: c_information2 date,
23821: c_information3 date) is
23822: select
23823: cpe.*
23824: from ben_copy_entity_results cpe
23825: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23826: and cpe.table_route_id = c_table_route_id
23827: and cpe.information1 = c_information1
23828: and cpe.information2 = c_information2
23877: --
23878: l_update boolean := false ;
23879: l_datetrack_mode varchar2(80) := hr_api.g_update;
23880: l_process_date date;
23881: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23882: --
23883: --UPD END
23884: l_current_pk_id number := null ;
23885: l_prev_pk_id number := null ;
24285: select distinct cpe.information1,
24286: cpe.information2,
24287: cpe.information3,
24288: cpe.table_route_id
24289: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24290: pqh_table_route tr
24291: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24292: and cpe.table_route_id = tr.table_route_id
24293: -- and tr.where_clause = l_BEN_DSGN_RQMT_RLSHP_TYP
24301: c_information1 number) is
24302: select
24303: min(cpe.information2) min_esd,
24304: max(cpe.information3) min_eed
24305: from ben_copy_entity_results cpe
24306: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24307: and cpe.table_route_id = c_table_route_id
24308: and cpe.information1 = c_information1 ;
24309: --
24312: c_information2 date,
24313: c_information3 date) is
24314: select
24315: cpe.*
24316: from ben_copy_entity_results cpe
24317: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24318: and cpe.table_route_id = c_table_route_id
24319: and cpe.information1 = c_information1
24320: and rownum = 1 ;
24338: --
24339: l_update boolean := false ;
24340: l_datetrack_mode varchar2(80) := hr_api.g_update;
24341: l_process_date date;
24342: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
24343: --
24344: --UPD END
24345: l_current_pk_id number := null ;
24346: l_prev_pk_id number := null ;
24634: select distinct cpe.information1,
24635: cpe.information2,
24636: cpe.information3,
24637: cpe.table_route_id
24638: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24639: pqh_table_route tr
24640: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24641: and cpe.table_route_id = tr.table_route_id
24642: -- and tr.where_clause = l_BEN_OIPLIP_F
24650: c_information1 number) is
24651: select
24652: min(cpe.information2) min_esd,
24653: max(cpe.information3) min_eed
24654: from ben_copy_entity_results cpe
24655: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24656: and cpe.table_route_id = c_table_route_id
24657: and cpe.information1 = c_information1 ;
24658: --
24661: c_information2 date,
24662: c_information3 date ) is
24663: select
24664: cpe.*
24665: from ben_copy_entity_results cpe
24666: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24667: and cpe.table_route_id = c_table_route_id
24668: and cpe.information1 = c_information1
24669: and cpe.information2 = c_information2
25026: select distinct cpe.information1,
25027: cpe.information2,
25028: cpe.information3,
25029: cpe.table_route_id
25030: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25031: pqh_table_route tr
25032: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25033: and cpe.table_route_id = tr.table_route_id
25034: -- and tr.where_clause = l_BEN_OPTIP_F
25041: c_information1 number) is
25042: select
25043: min(cpe.information2) min_esd,
25044: max(cpe.information3) min_eed
25045: from ben_copy_entity_results cpe
25046: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25047: and cpe.table_route_id = c_table_route_id
25048: and cpe.information1 = c_information1 ;
25049: --
25052: c_information2 date,
25053: c_information3 date ) is
25054: select
25055: cpe.*
25056: from ben_copy_entity_results cpe
25057: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25058: and cpe.table_route_id = c_table_route_id
25059: and cpe.information1 = c_information1
25060: and cpe.information2 = c_information2
25428: select distinct cpe.information1,
25429: cpe.information2,
25430: cpe.information3,
25431: cpe.table_route_id
25432: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25433: pqh_table_route tr
25434: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25435: and cpe.table_route_id = tr.table_route_id
25436: -- and tr.where_clause = l_BEN_PL_PCP_TYP
25444: c_information1 number) is
25445: select
25446: min(cpe.information2) min_esd,
25447: max(cpe.information3) min_eed
25448: from ben_copy_entity_results cpe
25449: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25450: and cpe.table_route_id = c_table_route_id
25451: and cpe.information1 = c_information1 ;
25452: --
25455: c_information2 date,
25456: c_information3 date ) is
25457: select
25458: cpe.*
25459: from ben_copy_entity_results cpe
25460: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25461: and cpe.table_route_id = c_table_route_id
25462: and cpe.information1 = c_information1
25463: and rownum = 1 ;
25492: --
25493: l_update boolean := false ;
25494: l_datetrack_mode varchar2(80) := hr_api.g_update;
25495: l_process_date date;
25496: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25497: --
25498: --UPD END
25499: l_current_pk_id number := null ;
25500: l_prev_pk_id number := null ;
25791: select distinct cpe.information1,
25792: cpe.information2,
25793: cpe.information3,
25794: cpe.table_route_id
25795: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25796: pqh_table_route tr
25797: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25798: and cpe.table_route_id = tr.table_route_id
25799: -- and tr.where_clause = l_BEN_PL_REGY_PRP_F
25807: c_information1 number) is
25808: select
25809: min(cpe.information2) min_esd,
25810: max(cpe.information3) min_eed
25811: from ben_copy_entity_results cpe
25812: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25813: and cpe.table_route_id = c_table_route_id
25814: and cpe.information1 = c_information1 ;
25815: --
25818: c_information2 date,
25819: c_information3 date ) is
25820: select
25821: cpe.*
25822: from ben_copy_entity_results cpe
25823: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25824: and cpe.table_route_id = c_table_route_id
25825: and cpe.information1 = c_information1
25826: and cpe.information2 = c_information2
25866: --
25867: l_update boolean := false ;
25868: l_datetrack_mode varchar2(80) := hr_api.g_update;
25869: l_process_date date;
25870: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25871: --
25872: --UPD END
25873: l_current_pk_id number := null ;
25874: l_prev_pk_id number := null ;
26272: cpe.information2,
26273: cpe.information3,
26274: cpe.INFORMATION170 name ,
26275: cpe.table_route_id
26276: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26277: pqh_table_route tr
26278: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26279: and cpe.table_route_id = tr.table_route_id
26280: -- and tr.where_clause = l_BEN_BNFT_PRVDR_POOL_F
26288: c_information1 number) is
26289: select
26290: min(cpe.information2) min_esd,
26291: max(cpe.information3) min_eed
26292: from ben_copy_entity_results cpe
26293: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26294: and cpe.table_route_id = c_table_route_id
26295: and cpe.information1 = c_information1 ;
26296: --
26299: c_information2 date,
26300: c_information3 date) is
26301: select
26302: cpe.*
26303: from ben_copy_entity_results cpe
26304: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26305: and cpe.table_route_id = c_table_route_id
26306: and cpe.information1 = c_information1
26307: and cpe.information2 = c_information2
26392: --
26393: l_update boolean := false ;
26394: l_datetrack_mode varchar2(80) := hr_api.g_update;
26395: l_process_date date;
26396: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26397: --
26398: --UPD END
26399: l_current_pk_id number := null ;
26400: l_prev_pk_id number := null ;
26896: cpe.information2,
26897: cpe.information3,
26898: cpe.information170 name,
26899: cpe.table_route_id
26900: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26901: pqh_table_route tr
26902: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26903: and cpe.table_route_id = tr.table_route_id
26904: -- and tr.where_clause = l_BEN_ACRS_PTIP_CVG_F
26912: c_information1 number) is
26913: select
26914: min(cpe.information2) min_esd,
26915: max(cpe.information3) min_eed
26916: from ben_copy_entity_results cpe
26917: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26918: and cpe.table_route_id = c_table_route_id
26919: and cpe.information1 = c_information1 ;
26920: --
26923: c_information2 date,
26924: c_information3 date) is
26925: select
26926: cpe.*
26927: from ben_copy_entity_results cpe
26928: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26929: and cpe.table_route_id = c_table_route_id
26930: and cpe.information1 = c_information1
26931: and cpe.information2 = c_information2
26968: --
26969: l_update boolean := false ;
26970: l_datetrack_mode varchar2(80) := hr_api.g_update;
26971: l_process_date date;
26972: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26973: --
26974: --UPD END
26975: l_current_pk_id number := null ;
26976: l_prev_pk_id number := null ;
28305:
28306: -- Update information9 to NULL
28307: -- Required for reusing Copy Process
28308:
28309: update ben_copy_entity_results
28310: set information9 = null
28311: where copy_entity_txn_id = p_copy_entity_txn_id;
28312:
28313: