167: cursor c_parent_data(p_parent_pk_id number,
168: p_copy_entity_txn_id number,
169: p_table_route_id number) is
170: select information5
171: from ben_copy_entity_results
172: where table_route_id = p_table_route_id
173: and copy_entity_txn_id = p_copy_entity_txn_id
174: and information1 = p_parent_pk_id;
175:
213: --
214: 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
215: begin
216: hr_utility.set_location('Inside update_cer_with_target ',233);
217: update ben_copy_entity_results
218: set information9 = c_pk_rec.copy_reuse_type||'-'||c_pk_rec.new_value
219: where copy_entity_txn_id = p_copy_entity_txn_id
220: and table_route_id = c_pk_rec.table_route_id
221: and information1 = c_pk_rec.old_value ;
247: select distinct cpe.information1,
248: cpe.information2,
249: cpe.information3,
250: cpe.table_route_id
251: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
252: pqh_table_route tr
253: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
254: and cpe.table_route_id = tr.table_route_id
255: -- and tr.where_clause = l_BEN_JOB_RT_F
263: c_information1 Number) is
264: select
265: min(cpe.information2) min_esd,
266: max(cpe.information3) min_eed
267: from ben_copy_entity_results cpe
268: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
269: and cpe.table_route_id = c_table_route_id
270: and cpe.information1 = c_information1 ;
271: --
274: c_information2 Date,
275: c_information3 Date) is
276: select
277: cpe.*
278: from ben_copy_entity_results cpe
279: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
280: and cpe.table_route_id = c_table_route_id
281: and cpe.information1 = c_information1
282: and cpe.information2 = c_information2
329: --
330: l_update boolean := false ;
331: l_datetrack_mode varchar2(80) := hr_api.g_update;
332: l_process_date date;
333: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
334: --
335: --UPD END
336: l_prev_pk_id number := null ;
337: l_first_rec boolean := true ;
736: select distinct cpe.information1,
737: cpe.information2,
738: cpe.information3,
739: cpe.table_route_id
740: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
741: pqh_table_route tr
742: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
743: and cpe.table_route_id = tr.table_route_id
744: -- and tr.where_clause = l_BEN_HRLY_SLRD_RT_F
752: c_information1 Number) is
753: select
754: min(cpe.information2) min_esd,
755: max(cpe.information3) min_eed
756: from ben_copy_entity_results cpe
757: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
758: and cpe.table_route_id = c_table_route_id
759: and cpe.information1 = c_information1 ;
760: --
763: c_information2 Date,
764: c_information3 Date) is
765: select
766: cpe.*
767: from ben_copy_entity_results cpe
768: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
769: and cpe.table_route_id = c_table_route_id
770: and cpe.information1 = c_information1
771: and cpe.information2 = c_information2
818: --
819: l_update boolean := false ;
820: l_datetrack_mode varchar2(80) := hr_api.g_update;
821: l_process_date date;
822: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
823: --
824: --UPD END
825: l_prev_pk_id number := null ;
826: l_first_rec boolean := true ;
1201: select distinct cpe.information1,
1202: cpe.information2,
1203: cpe.information3,
1204: cpe.table_route_id
1205: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
1206: pqh_table_route tr
1207: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1208: and cpe.table_route_id = tr.table_route_id
1209: -- and tr.where_clause = l_BEN_GRADE_RT_F
1217: c_information1 Number) is
1218: select
1219: min(cpe.information2) min_esd,
1220: max(cpe.information3) min_eed
1221: from ben_copy_entity_results cpe
1222: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1223: and cpe.table_route_id = c_table_route_id
1224: and cpe.information1 = c_information1 ;
1225: --
1228: c_information2 date,
1229: c_information3 date) is
1230: select
1231: cpe.*
1232: from ben_copy_entity_results cpe
1233: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1234: and cpe.table_route_id = c_table_route_id
1235: and cpe.information1 = c_information1
1236: and cpe.information2 = c_information2
1283: --
1284: l_update boolean := false ;
1285: l_datetrack_mode varchar2(80) := hr_api.g_update;
1286: l_process_date date;
1287: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1288: --
1289: --UPD END
1290: l_prev_pk_id number := null ;
1291: l_first_rec boolean := true ;
1686: select distinct cpe.information1,
1687: cpe.information2,
1688: cpe.information3,
1689: cpe.table_route_id
1690: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
1691: pqh_table_route tr
1692: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1693: and cpe.table_route_id = tr.table_route_id
1694: -- and tr.where_clause = l_BEN_FL_TM_PT_TM_RT_F
1702: c_information1 Number) is
1703: select
1704: min(cpe.information2) min_esd,
1705: max(cpe.information3) min_eed
1706: from ben_copy_entity_results cpe
1707: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1708: and cpe.table_route_id = c_table_route_id
1709: and cpe.information1 = c_information1 ;
1710: --
1713: c_information2 Date,
1714: c_information3 Date) is
1715: select
1716: cpe.*
1717: from ben_copy_entity_results cpe
1718: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1719: and cpe.table_route_id = c_table_route_id
1720: and cpe.information1 = c_information1
1721: and cpe.information2 = c_information2
1768: --
1769: l_update boolean := false ;
1770: l_datetrack_mode varchar2(80) := hr_api.g_update;
1771: l_process_date date;
1772: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1773: --
1774: --UPD END
1775: l_prev_pk_id number := null ;
1776: l_first_rec boolean := true ;
2151: select distinct cpe.information1,
2152: cpe.information2,
2153: cpe.information3,
2154: cpe.table_route_id
2155: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
2156: pqh_table_route tr
2157: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2158: and cpe.table_route_id = tr.table_route_id
2159: -- and tr.where_clause = l_BEN_BRGNG_UNIT_RT_F
2167: c_information1 Number) is
2168: select
2169: min(cpe.information2) min_esd,
2170: max(cpe.information3) min_eed
2171: from ben_copy_entity_results cpe
2172: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2173: and cpe.table_route_id = c_table_route_id
2174: and cpe.information1 = c_information1 ;
2175: --
2178: c_information2 date,
2179: c_information3 date) is
2180: select
2181: cpe.*
2182: from ben_copy_entity_results cpe
2183: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2184: and cpe.table_route_id = c_table_route_id
2185: and cpe.information1 = c_information1
2186: and cpe.information2 = c_information2
2233: --
2234: l_update boolean := false ;
2235: l_datetrack_mode varchar2(80) := hr_api.g_update;
2236: l_process_date date;
2237: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2238: --
2239: --UPD END
2240: l_prev_pk_id number := null ;
2241: l_first_rec boolean := true ;
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,
2621: pqh_table_route tr
2622: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2623: and cpe.table_route_id = tr.table_route_id
2624: -- and tr.where_clause = l_BEN_EE_STAT_RT_F
2632: c_information1 Number) is
2633: select
2634: min(cpe.information2) min_esd,
2635: max(cpe.information3) min_eed
2636: from ben_copy_entity_results cpe
2637: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2638: and cpe.table_route_id = c_table_route_id
2639: and cpe.information1 = c_information1 ;
2640: --
2643: c_information2 date,
2644: c_information3 Date) is
2645: select
2646: cpe.*
2647: from ben_copy_entity_results cpe
2648: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2649: and cpe.table_route_id = c_table_route_id
2650: and cpe.information1 = c_information1
2651: and cpe.information2 = c_information2
2698: --
2699: l_update boolean := false ;
2700: l_datetrack_mode varchar2(80) := hr_api.g_update;
2701: l_process_date date;
2702: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2703: --
2704: --UPD END
2705: l_prev_pk_id number := null ;
2706: l_first_rec boolean := true ;
3098: select distinct cpe.information1,
3099: cpe.information2,
3100: cpe.information3,
3101: cpe.table_route_id
3102: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
3103: pqh_table_route tr
3104: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3105: and cpe.table_route_id = tr.table_route_id
3106: -- and tr.where_clause = l_BEN_ASNT_SET_RT_F
3114: c_information1 number) is
3115: select
3116: min(cpe.information2) min_esd,
3117: max(cpe.information3) min_eed
3118: from ben_copy_entity_results cpe
3119: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3120: and cpe.table_route_id = c_table_route_id
3121: and cpe.information1 = c_information1 ;
3122: --
3125: c_information2 Date,
3126: c_information3 Date ) is
3127: select
3128: cpe.*
3129: from ben_copy_entity_results cpe
3130: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3131: and cpe.table_route_id = c_table_route_id
3132: and cpe.information1 = c_information1
3133: and cpe.information2 = c_information2
3180: --
3181: l_update boolean := false ;
3182: l_datetrack_mode varchar2(80) := hr_api.g_update;
3183: l_process_date date;
3184: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3185: --
3186: --UPD END
3187: l_prev_pk_id number := null ;
3188: l_first_rec boolean := true ;
3579: select distinct cpe.information1,
3580: cpe.information2,
3581: cpe.information3,
3582: cpe.table_route_id
3583: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
3584: pqh_table_route tr
3585: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3586: and cpe.table_route_id = tr.table_route_id
3587: -- and tr.where_clause = l_BEN_TBCO_USE_RT_F
3595: c_information1 Number) is
3596: select
3597: min(cpe.information2) min_esd,
3598: max(cpe.information3) min_eed
3599: from ben_copy_entity_results cpe
3600: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3601: and cpe.table_route_id = c_table_route_id
3602: and cpe.information1 = c_information1 ;
3603: --
3606: c_information2 Date,
3607: c_information3 Date ) is
3608: select
3609: cpe.*
3610: from ben_copy_entity_results cpe
3611: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3612: and cpe.table_route_id = c_table_route_id
3613: and cpe.information1 = c_information1
3614: and cpe.information2 = c_information2
3661: --
3662: l_update boolean := false ;
3663: l_datetrack_mode varchar2(80) := hr_api.g_update;
3664: l_process_date date;
3665: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3666: --
3667: --UPD END
3668: l_prev_pk_id number := null ;
3669: l_first_rec boolean := true ;
4046: select distinct cpe.information1,
4047: cpe.information2,
4048: cpe.information3,
4049: cpe.table_route_id
4050: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4051: pqh_table_route tr
4052: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4053: and cpe.table_route_id = tr.table_route_id
4054: -- and tr.where_clause = l_BEN_SVC_AREA_RT_F
4062: c_information1 Number) is
4063: select
4064: min(cpe.information2) min_esd,
4065: max(cpe.information3) min_eed
4066: from ben_copy_entity_results cpe
4067: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4068: and cpe.table_route_id = c_table_route_id
4069: and cpe.information1 = c_information1 ;
4070: --
4073: c_information2 Date,
4074: c_information3 Date ) is
4075: select
4076: cpe.*
4077: from ben_copy_entity_results cpe
4078: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4079: and cpe.table_route_id = c_table_route_id
4080: and cpe.information1 = c_information1
4081: and cpe.information2 = c_information2
4128: --
4129: l_update boolean := false ;
4130: l_datetrack_mode varchar2(80) := hr_api.g_update;
4131: l_process_date date;
4132: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4133: --
4134: --UPD END
4135: l_prev_pk_id number := null ;
4136: l_first_rec boolean := true ;
4511: select distinct cpe.information1,
4512: cpe.information2,
4513: cpe.information3,
4514: cpe.table_route_id
4515: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4516: pqh_table_route tr
4517: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4518: and cpe.table_route_id = tr.table_route_id
4519: -- and tr.where_clause = l_BEN_QUAL_TITL_RT_F
4527: c_information1 Number) is
4528: select
4529: min(cpe.information2) min_esd,
4530: max(cpe.information3) min_eed
4531: from ben_copy_entity_results cpe
4532: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4533: and cpe.table_route_id = c_table_route_id
4534: and cpe.information1 = c_information1 ;
4535: --
4538: c_information2 Date,
4539: c_information3 Date ) is
4540: select
4541: cpe.*
4542: from ben_copy_entity_results cpe
4543: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4544: and cpe.table_route_id = c_table_route_id
4545: and cpe.information1 = c_information1
4546: and cpe.information2 = c_information2
4593: --
4594: l_update boolean := false ;
4595: l_datetrack_mode varchar2(80) := hr_api.g_update;
4596: l_process_date date;
4597: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4598: --
4599: --UPD END
4600: l_prev_pk_id number := null ;
4601: l_first_rec boolean := true ;
4993: select distinct cpe.information1,
4994: cpe.information2,
4995: cpe.information3,
4996: cpe.table_route_id
4997: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4998: pqh_table_route tr
4999: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5000: and cpe.table_route_id = tr.table_route_id
5001: -- and tr.where_clause = l_BEN_PSTL_ZIP_RT_F
5009: c_information1 Number) is
5010: select
5011: min(cpe.information2) min_esd,
5012: max(cpe.information3) min_eed
5013: from ben_copy_entity_results cpe
5014: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5015: and cpe.table_route_id = c_table_route_id
5016: and cpe.information1 = c_information1 ;
5017: --
5020: c_information2 Date,
5021: c_information3 Date ) is
5022: select
5023: cpe.*
5024: from ben_copy_entity_results cpe
5025: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5026: and cpe.table_route_id = c_table_route_id
5027: and cpe.information1 = c_information1
5028: and cpe.information2 = c_information2
5075: --
5076: l_update boolean := false ;
5077: l_datetrack_mode varchar2(80) := hr_api.g_update;
5078: l_process_date date;
5079: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5080: --
5081: --UPD END
5082: l_prev_pk_id number := null ;
5083: l_first_rec boolean := true ;
5458: select distinct cpe.information1,
5459: cpe.information2,
5460: cpe.information3,
5461: cpe.table_route_id
5462: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5463: pqh_table_route tr
5464: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5465: and cpe.table_route_id = tr.table_route_id
5466: -- and tr.where_clause = l_BEN_PER_TYP_RT_F
5474: c_information1 Number) is
5475: select
5476: min(cpe.information2) min_esd,
5477: max(cpe.information3) min_eed
5478: from ben_copy_entity_results cpe
5479: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5480: and cpe.table_route_id = c_table_route_id
5481: and cpe.information1 = c_information1 ;
5482: --
5485: c_information2 Date,
5486: c_information3 Date ) is
5487: select
5488: cpe.*
5489: from ben_copy_entity_results cpe
5490: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5491: and cpe.table_route_id = c_table_route_id
5492: and cpe.information1 = c_information1
5493: and cpe.information2 = c_information2
5540: --
5541: l_update boolean := false ;
5542: l_datetrack_mode varchar2(80) := hr_api.g_update;
5543: l_process_date date;
5544: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5545: --
5546: --UPD END
5547: l_prev_pk_id number := null ;
5548: l_first_rec boolean := true ;
5941: select distinct cpe.information1,
5942: cpe.information2,
5943: cpe.information3,
5944: cpe.table_route_id
5945: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5946: pqh_table_route tr
5947: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5948: and cpe.table_route_id = tr.table_route_id
5949: -- and tr.where_clause = l_BEN_GNDR_RT_F
5957: c_information1 Number) is
5958: select
5959: min(cpe.information2) min_esd,
5960: max(cpe.information3) min_eed
5961: from ben_copy_entity_results cpe
5962: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5963: and cpe.table_route_id = c_table_route_id
5964: and cpe.information1 = c_information1 ;
5965: --
5968: c_information2 Date,
5969: c_information3 Date) is
5970: select
5971: cpe.*
5972: from ben_copy_entity_results cpe
5973: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5974: and cpe.table_route_id = c_table_route_id
5975: and cpe.information1 = c_information1
5976: and cpe.information2 = c_information2
6020: --
6021: l_update boolean := false ;
6022: l_datetrack_mode varchar2(80) := hr_api.g_update;
6023: l_process_date date;
6024: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6025: --
6026: --UPD END
6027: l_prev_pk_id number := null ;
6028: l_first_rec boolean := true ;
6403: select distinct cpe.information1,
6404: cpe.information2,
6405: cpe.information3,
6406: cpe.table_route_id
6407: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6408: pqh_table_route tr
6409: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6410: and cpe.table_route_id = tr.table_route_id
6411: -- and tr.where_clause = l_BEN_DSBLD_RT_F
6419: c_information1 Number) is
6420: select
6421: min(cpe.information2) min_esd,
6422: max(cpe.information3) min_eed
6423: from ben_copy_entity_results cpe
6424: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6425: and cpe.table_route_id = c_table_route_id
6426: and cpe.information1 = c_information1 ;
6427: --
6430: c_information2 Date,
6431: c_information3 Date ) is
6432: select
6433: cpe.*
6434: from ben_copy_entity_results cpe
6435: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6436: and cpe.table_route_id = c_table_route_id
6437: and cpe.information1 = c_information1
6438: and cpe.information2 = c_information2
6485: --
6486: l_update boolean := false ;
6487: l_datetrack_mode varchar2(80) := hr_api.g_update;
6488: l_process_date date;
6489: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6490: --
6491: --UPD END
6492: l_prev_pk_id number := null ;
6493: l_first_rec boolean := true ;
6869: select distinct cpe.information1,
6870: cpe.information2,
6871: cpe.information3,
6872: cpe.table_route_id
6873: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6874: pqh_table_route tr
6875: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6876: and cpe.table_route_id = tr.table_route_id
6877: -- and tr.where_clause = l_BEN_COMPTNCY_RT_F
6885: c_information1 Number) is
6886: select
6887: min(cpe.information2) min_esd,
6888: max(cpe.information3) min_eed
6889: from ben_copy_entity_results cpe
6890: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6891: and cpe.table_route_id = c_table_route_id
6892: and cpe.information1 = c_information1 ;
6893: --
6896: c_information2 Date,
6897: c_information3 Date) is
6898: select
6899: cpe.*
6900: from ben_copy_entity_results cpe
6901: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6902: and cpe.table_route_id = c_table_route_id
6903: and cpe.information1 = c_information1
6904: and cpe.information2 = c_information2
6954: --
6955: l_update boolean := false ;
6956: l_datetrack_mode varchar2(80) := hr_api.g_update;
6957: l_process_date date;
6958: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6959: --
6960: --UPD END
6961: l_prev_pk_id number := null ;
6962: l_first_rec boolean := true ;
7365: select distinct cpe.information1,
7366: cpe.information2,
7367: cpe.information3,
7368: cpe.table_route_id
7369: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7370: pqh_table_route tr
7371: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7372: and cpe.table_route_id = tr.table_route_id
7373: -- and tr.where_clause = l_BEN_LBR_MMBR_RT_F
7381: c_information1 Number) is
7382: select
7383: min(cpe.information2) min_esd,
7384: max(cpe.information3) min_eed
7385: from ben_copy_entity_results cpe
7386: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7387: and cpe.table_route_id = c_table_route_id
7388: and cpe.information1 = c_information1 ;
7389: --
7392: c_information2 Date,
7393: c_information3 Date) is
7394: select
7395: cpe.*
7396: from ben_copy_entity_results cpe
7397: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7398: and cpe.table_route_id = c_table_route_id
7399: and cpe.information1 = c_information1
7400: and cpe.information2 = c_information2
7444: --
7445: l_update boolean := false ;
7446: l_datetrack_mode varchar2(80) := hr_api.g_update;
7447: l_process_date date;
7448: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7449: --
7450: --UPD END
7451: l_prev_pk_id number := null ;
7452: l_first_rec boolean := true ;
7824: select distinct cpe.information1,
7825: cpe.information2,
7826: cpe.information3,
7827: cpe.table_route_id
7828: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7829: pqh_table_route tr
7830: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7831: and cpe.table_route_id = tr.table_route_id
7832: -- and tr.where_clause = l_BEN_LOA_RSN_RT_F
7840: c_information1 Number) is
7841: select
7842: min(cpe.information2) min_esd,
7843: max(cpe.information3) min_eed
7844: from ben_copy_entity_results cpe
7845: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7846: and cpe.table_route_id = c_table_route_id
7847: and cpe.information1 = c_information1 ;
7848: --
7851: c_information2 Date,
7852: c_information3 Date ) is
7853: select
7854: cpe.*
7855: from ben_copy_entity_results cpe
7856: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7857: and cpe.table_route_id = c_table_route_id
7858: and cpe.information1 = c_information1
7859: and cpe.information2 = c_information2
7906: --
7907: l_update boolean := false ;
7908: l_datetrack_mode varchar2(80) := hr_api.g_update;
7909: l_process_date date;
7910: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7911: --
7912: --UPD END
7913: l_prev_pk_id number := null ;
7914: l_first_rec boolean := true ;
8315: select distinct cpe.information1,
8316: cpe.information2,
8317: cpe.information3,
8318: cpe.table_route_id
8319: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8320: pqh_table_route tr
8321: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8322: and cpe.table_route_id = tr.table_route_id
8323: -- and tr.where_clause = l_BEN_ORG_UNIT_RT_F
8331: c_information1 Number) is
8332: select
8333: min(cpe.information2) min_esd,
8334: max(cpe.information3) min_eed
8335: from ben_copy_entity_results cpe
8336: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8337: and cpe.table_route_id = c_table_route_id
8338: and cpe.information1 = c_information1 ;
8339: --
8342: c_information2 Date,
8343: c_information3 Date ) is
8344: select
8345: cpe.*
8346: from ben_copy_entity_results cpe
8347: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8348: and cpe.table_route_id = c_table_route_id
8349: and cpe.information1 = c_information1
8350: and cpe.information2 = c_information2
8394: --
8395: l_update boolean := false ;
8396: l_datetrack_mode varchar2(80) := hr_api.g_update;
8397: l_process_date date;
8398: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8399: --
8400: --UPD END
8401: l_prev_pk_id number := null ;
8402: l_first_rec boolean := true ;
8790: select distinct cpe.information1,
8791: cpe.information2,
8792: cpe.information3,
8793: cpe.table_route_id
8794: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8795: pqh_table_route tr
8796: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8797: and cpe.table_route_id = tr.table_route_id
8798: -- and tr.where_clause = l_BEN_LGL_ENTY_RT_F
8806: c_information1 Number) is
8807: select
8808: min(cpe.information2) min_esd,
8809: max(cpe.information3) min_eed
8810: from ben_copy_entity_results cpe
8811: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8812: and cpe.table_route_id = c_table_route_id
8813: and cpe.information1 = c_information1 ;
8814: --
8817: c_information2 Date,
8818: c_information3 Date ) is
8819: select
8820: cpe.*
8821: from ben_copy_entity_results cpe
8822: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8823: and cpe.table_route_id = c_table_route_id
8824: and cpe.information1 = c_information1
8825: and cpe.information2 = c_information2
8869: --
8870: l_update boolean := false ;
8871: l_datetrack_mode varchar2(80) := hr_api.g_update;
8872: l_process_date date;
8873: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8874: --
8875: --UPD END
8876: l_prev_pk_id number := null ;
8877: l_first_rec boolean := true ;
9266: select distinct cpe.information1,
9267: cpe.information2,
9268: cpe.information3,
9269: cpe.table_route_id
9270: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9271: pqh_table_route tr
9272: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9273: and cpe.table_route_id = tr.table_route_id
9274: -- and tr.where_clause = l_BEN_PYRL_RT_F
9281: c_information1 Number) is
9282: select
9283: min(cpe.information2) min_esd,
9284: max(cpe.information3) min_eed
9285: from ben_copy_entity_results cpe
9286: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9287: and cpe.table_route_id = c_table_route_id
9288: and cpe.information1 = c_information1 ;
9289: --
9292: c_information2 Date,
9293: c_information3 Date) is
9294: select
9295: cpe.*
9296: from ben_copy_entity_results cpe
9297: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9298: and cpe.table_route_id = c_table_route_id
9299: and cpe.information1 = c_information1
9300: and cpe.information2 = c_information2
9344: --
9345: l_update boolean := false ;
9346: l_datetrack_mode varchar2(80) := hr_api.g_update;
9347: l_process_date date;
9348: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9349: --
9350: --UPD END
9351: l_prev_pk_id number := null ;
9352: l_first_rec boolean := true ;
9740: select distinct cpe.information1,
9741: cpe.information2,
9742: cpe.information3,
9743: cpe.table_route_id
9744: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9745: pqh_table_route tr
9746: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9747: and cpe.table_route_id = tr.table_route_id
9748: -- and tr.where_clause = l_BEN_PY_BSS_RT_F
9756: c_information1 Number) is
9757: select
9758: min(cpe.information2) min_esd,
9759: max(cpe.information3) min_eed
9760: from ben_copy_entity_results cpe
9761: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9762: and cpe.table_route_id = c_table_route_id
9763: and cpe.information1 = c_information1 ;
9764: --
9767: c_information2 Date,
9768: c_information3 Date) is
9769: select
9770: cpe.*
9771: from ben_copy_entity_results cpe
9772: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9773: and cpe.table_route_id = c_table_route_id
9774: and cpe.information1 = c_information1
9775: and cpe.information2 = c_information2
9819: --
9820: l_update boolean := false ;
9821: l_datetrack_mode varchar2(80) := hr_api.g_update;
9822: l_process_date date;
9823: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9824: --
9825: --UPD END
9826: l_prev_pk_id number := null ;
9827: l_first_rec boolean := true ;
10218: select distinct cpe.information1,
10219: cpe.information2,
10220: cpe.information3,
10221: cpe.table_route_id
10222: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10223: pqh_table_route tr
10224: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10225: and cpe.table_route_id = tr.table_route_id
10226: -- and tr.where_clause = l_BEN_CBR_QUALD_BNF_RT_F
10234: c_information1 Number) is
10235: select
10236: min(cpe.information2) min_esd,
10237: max(cpe.information3) min_eed
10238: from ben_copy_entity_results cpe
10239: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10240: and cpe.table_route_id = c_table_route_id
10241: and cpe.information1 = c_information1 ;
10242: --
10245: c_information2 Date,
10246: c_information3 Date) is
10247: select
10248: cpe.*
10249: from ben_copy_entity_results cpe
10250: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10251: and cpe.table_route_id = c_table_route_id
10252: and cpe.information1 = c_information1
10253: and cpe.information2 = c_information2
10300: --
10301: l_update boolean := false ;
10302: l_datetrack_mode varchar2(80) := hr_api.g_update;
10303: l_process_date date;
10304: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10305: --
10306: --UPD END
10307: l_prev_pk_id number := null ;
10308: l_first_rec boolean := true ;
10686: select distinct cpe.information1,
10687: cpe.information2,
10688: cpe.information3,
10689: cpe.table_route_id
10690: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10691: pqh_table_route tr
10692: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10693: and cpe.table_route_id = tr.table_route_id
10694: -- and tr.where_clause = l_BEN_BENFTS_GRP_RT_F
10702: c_information1 number) is
10703: select
10704: min(cpe.information2) min_esd,
10705: max(cpe.information3) min_eed
10706: from ben_copy_entity_results cpe
10707: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10708: and cpe.table_route_id = c_table_route_id
10709: and cpe.information1 = c_information1 ;
10710: --
10713: c_information2 Date,
10714: c_information3 Date) is
10715: select
10716: cpe.*
10717: from ben_copy_entity_results cpe
10718: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10719: and cpe.table_route_id = c_table_route_id
10720: and cpe.information1 = c_information1
10721: and cpe.information2 = c_information2
10765: --
10766: l_update boolean := false ;
10767: l_datetrack_mode varchar2(80) := hr_api.g_update;
10768: l_process_date date;
10769: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10770: --
10771: --UPD END
10772: l_prev_pk_id number := null ;
10773: l_first_rec boolean := true ;
11143: select distinct cpe.information1,
11144: cpe.information2,
11145: cpe.information3,
11146: cpe.table_route_id
11147: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
11148: pqh_table_route tr
11149: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11150: and cpe.table_route_id = tr.table_route_id
11151: -- and tr.where_clause = l_BEN_CMBN_AGE_LOS_RT_F
11159: c_information1 Number) is
11160: select
11161: min(cpe.information2) min_esd,
11162: max(cpe.information3) min_eed
11163: from ben_copy_entity_results cpe
11164: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11165: and cpe.table_route_id = c_table_route_id
11166: and cpe.information1 = c_information1 ;
11167: --
11170: c_information2 Date,
11171: c_information3 Date) is
11172: select
11173: cpe.*
11174: from ben_copy_entity_results cpe
11175: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11176: and cpe.table_route_id = c_table_route_id
11177: and cpe.information1 = c_information1
11178: and cpe.information2 = c_information2
11222: --
11223: l_update boolean := false ;
11224: l_datetrack_mode varchar2(80) := hr_api.g_update;
11225: l_process_date date;
11226: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11227: --
11228: --UPD END
11229: l_prev_pk_id number := null ;
11230: l_first_rec boolean := true ;
11600: select distinct cpe.information1,
11601: cpe.information2,
11602: cpe.information3,
11603: cpe.table_route_id
11604: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
11605: pqh_table_route tr
11606: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11607: and cpe.table_route_id = tr.table_route_id
11608: -- and tr.where_clause = l_BEN_VRBL_MTCHG_RT_F
11616: c_information1 Number) is
11617: select
11618: min(cpe.information2) min_esd,
11619: max(cpe.information3) min_eed
11620: from ben_copy_entity_results cpe
11621: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11622: and cpe.table_route_id = c_table_route_id
11623: and cpe.information1 = c_information1 ;
11624: --
11627: c_information2 Date,
11628: c_information3 Date) is
11629: select
11630: cpe.*
11631: from ben_copy_entity_results cpe
11632: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11633: and cpe.table_route_id = c_table_route_id
11634: and cpe.information1 = c_information1
11635: and cpe.information2 = c_information2
11679: --
11680: l_update boolean := false ;
11681: l_datetrack_mode varchar2(80) := hr_api.g_update;
11682: l_process_date date;
11683: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11684: --
11685: --UPD END
11686: l_prev_pk_id number := null ;
11687: l_first_rec boolean := true ;
12076: select distinct cpe.information1,
12077: cpe.information2,
12078: cpe.information3,
12079: cpe.table_route_id
12080: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12081: pqh_table_route tr
12082: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12083: and cpe.table_route_id = tr.table_route_id
12084: -- and tr.where_clause = l_BEN_PRTT_ANTHR_PL_RT_F
12092: c_information1 Number) is
12093: select
12094: min(cpe.information2) min_esd,
12095: max(cpe.information3) min_eed
12096: from ben_copy_entity_results cpe
12097: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12098: and cpe.table_route_id = c_table_route_id
12099: and cpe.information1 = c_information1 ;
12100: --
12103: c_information2 Date,
12104: c_information3 Date) is
12105: select
12106: cpe.*
12107: from ben_copy_entity_results cpe
12108: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12109: and cpe.table_route_id = c_table_route_id
12110: and cpe.information1 = c_information1
12111: and cpe.information2 = c_information2
12155: --
12156: l_update boolean := false ;
12157: l_datetrack_mode varchar2(80) := hr_api.g_update;
12158: l_process_date date;
12159: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12160: --
12161: --UPD END
12162: l_prev_pk_id number := null ;
12163: l_first_rec boolean := true ;
12536: select distinct cpe.information1,
12537: cpe.information2,
12538: cpe.information3,
12539: cpe.table_route_id
12540: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12541: pqh_table_route tr
12542: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12543: and cpe.table_route_id = tr.table_route_id
12544: -- and tr.where_clause = l_BEN_OTHR_PTIP_RT_F
12552: c_information1 Number) is
12553: select
12554: min(cpe.information2) min_esd,
12555: max(cpe.information3) min_eed
12556: from ben_copy_entity_results cpe
12557: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12558: and cpe.table_route_id = c_table_route_id
12559: and cpe.information1 = c_information1 ;
12560: --
12563: c_information2 Date,
12564: c_information3 Date ) is
12565: select
12566: cpe.*
12567: from ben_copy_entity_results cpe
12568: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12569: and cpe.table_route_id = c_table_route_id
12570: and cpe.information1 = c_information1
12571: and cpe.information2 = c_information2
12615: --
12616: l_update boolean := false ;
12617: l_datetrack_mode varchar2(80) := hr_api.g_update;
12618: l_process_date date;
12619: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12620: --
12621: --UPD END
12622: l_prev_pk_id number := null ;
12623: l_first_rec boolean := true ;
12997: select distinct cpe.information1,
12998: cpe.information2,
12999: cpe.information3,
13000: cpe.table_route_id
13001: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13002: pqh_table_route tr
13003: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13004: and cpe.table_route_id = tr.table_route_id
13005: -- and tr.where_clause = l_BEN_NO_OTHR_CVG_RT_F
13013: c_information1 Number) is
13014: select
13015: min(cpe.information2) min_esd,
13016: max(cpe.information3) min_eed
13017: from ben_copy_entity_results cpe
13018: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13019: and cpe.table_route_id = c_table_route_id
13020: and cpe.information1 = c_information1 ;
13021: --
13024: c_information2 Date,
13025: c_information3 Date) is
13026: select
13027: cpe.*
13028: from ben_copy_entity_results cpe
13029: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13030: and cpe.table_route_id = c_table_route_id
13031: and cpe.information1 = c_information1
13032: and cpe.information2 = c_information2
13076: --
13077: l_update boolean := false ;
13078: l_datetrack_mode varchar2(80) := hr_api.g_update;
13079: l_process_date date;
13080: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13081: --
13082: --UPD END
13083: l_prev_pk_id number := null ;
13084: l_first_rec boolean := true ;
13451: select distinct cpe.information1,
13452: cpe.information2,
13453: cpe.information3,
13454: cpe.table_route_id
13455: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13456: pqh_table_route tr
13457: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13458: and cpe.table_route_id = tr.table_route_id
13459: -- and tr.where_clause = l_BEN_OPTD_MDCR_RT_F
13466: c_information1 Number) is
13467: select
13468: min(cpe.information2) min_esd,
13469: max(cpe.information3) min_eed
13470: from ben_copy_entity_results cpe
13471: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13472: and cpe.table_route_id = c_table_route_id
13473: and cpe.information1 = c_information1 ;
13474: --
13477: c_information2 Date,
13478: c_information3 Date ) is
13479: select
13480: cpe.*
13481: from ben_copy_entity_results cpe
13482: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13483: and cpe.table_route_id = c_table_route_id
13484: and cpe.information1 = c_information1
13485: and cpe.information2 = c_information2
13529: --
13530: l_update boolean := false ;
13531: l_datetrack_mode varchar2(80) := hr_api.g_update;
13532: l_process_date date;
13533: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13534: --
13535: --UPD END
13536: l_prev_pk_id number := null ;
13537: l_first_rec boolean := true ;
13904: select distinct cpe.information1,
13905: cpe.information2,
13906: cpe.information3,
13907: cpe.table_route_id
13908: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13909: pqh_table_route tr
13910: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13911: and cpe.table_route_id = tr.table_route_id
13912: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PGM_RT_F
13920: c_information1 Number) is
13921: select
13922: min(cpe.information2) min_esd,
13923: max(cpe.information3) min_eed
13924: from ben_copy_entity_results cpe
13925: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13926: and cpe.table_route_id = c_table_route_id
13927: and cpe.information1 = c_information1 ;
13928: --
13931: c_information2 Date,
13932: c_information3 Date) is
13933: select
13934: cpe.*
13935: from ben_copy_entity_results cpe
13936: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13937: and cpe.table_route_id = c_table_route_id
13938: and cpe.information1 = c_information1
13939: and cpe.information2 = c_information2
13983: --
13984: l_update boolean := false ;
13985: l_datetrack_mode varchar2(80) := hr_api.g_update;
13986: l_process_date date;
13987: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13988: --
13989: --UPD END
13990: l_prev_pk_id number := null ;
13991: l_first_rec boolean := true ;
14365: select distinct cpe.information1,
14366: cpe.information2,
14367: cpe.information3,
14368: cpe.table_route_id
14369: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14370: pqh_table_route tr
14371: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14372: and cpe.table_route_id = tr.table_route_id
14373: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PTIP_RT_F
14381: c_information1 Number) is
14382: select
14383: min(cpe.information2) min_esd,
14384: max(cpe.information3) min_eed
14385: from ben_copy_entity_results cpe
14386: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14387: and cpe.table_route_id = c_table_route_id
14388: and cpe.information1 = c_information1 ;
14389: --
14392: c_information2 Date,
14393: c_information3 Date) is
14394: select
14395: cpe.*
14396: from ben_copy_entity_results cpe
14397: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14398: and cpe.table_route_id = c_table_route_id
14399: and cpe.information1 = c_information1
14400: and cpe.information2 = c_information2
14444: --
14445: l_update boolean := false ;
14446: l_datetrack_mode varchar2(80) := hr_api.g_update;
14447: l_process_date date;
14448: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14449: --
14450: --UPD END
14451: l_prev_pk_id number := null ;
14452: l_first_rec boolean := true ;
14828: select distinct cpe.information1,
14829: cpe.information2,
14830: cpe.information3,
14831: cpe.table_route_id
14832: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14833: pqh_table_route tr
14834: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14835: and cpe.table_route_id = tr.table_route_id
14836: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PL_RT_F
14844: c_information1 number) is
14845: select
14846: min(cpe.information2) min_esd,
14847: max(cpe.information3) min_eed
14848: from ben_copy_entity_results cpe
14849: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14850: and cpe.table_route_id = c_table_route_id
14851: and cpe.information1 = c_information1 ;
14852: --
14855: c_information2 date,
14856: c_information3 Date) is
14857: select
14858: cpe.*
14859: from ben_copy_entity_results cpe
14860: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14861: and cpe.table_route_id = c_table_route_id
14862: and cpe.information1 = c_information1
14863: and cpe.information2 = c_information2
14907: --
14908: l_update boolean := false ;
14909: l_datetrack_mode varchar2(80) := hr_api.g_update;
14910: l_process_date date;
14911: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14912: --
14913: --UPD END
14914: l_prev_pk_id number := null ;
14915: l_first_rec boolean := true ;
15289: select distinct cpe.information1,
15290: cpe.information2,
15291: cpe.information3,
15292: cpe.table_route_id
15293: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15294: pqh_table_route tr
15295: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15296: and cpe.table_route_id = tr.table_route_id
15297: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PLIP_RT_F
15305: c_information1 number) is
15306: select
15307: min(cpe.information2) min_esd,
15308: max(cpe.information3) min_eed
15309: from ben_copy_entity_results cpe
15310: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15311: and cpe.table_route_id = c_table_route_id
15312: and cpe.information1 = c_information1 ;
15313: --
15316: c_information2 Date,
15317: c_information3 Date ) is
15318: select
15319: cpe.*
15320: from ben_copy_entity_results cpe
15321: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15322: and cpe.table_route_id = c_table_route_id
15323: and cpe.information1 = c_information1
15324: and cpe.information2 = c_information2
15368: --
15369: l_update boolean := false ;
15370: l_datetrack_mode varchar2(80) := hr_api.g_update;
15371: l_process_date date;
15372: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15373: --
15374: --UPD END
15375: l_prev_pk_id number := null ;
15376: l_first_rec boolean := true ;
15750: select distinct cpe.information1,
15751: cpe.information2,
15752: cpe.information3,
15753: cpe.table_route_id
15754: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15755: pqh_table_route tr
15756: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15757: and cpe.table_route_id = tr.table_route_id
15758: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_OIPL_RT_F
15766: c_information1 Number) is
15767: select
15768: min(cpe.information2) min_esd,
15769: max(cpe.information3) min_eed
15770: from ben_copy_entity_results cpe
15771: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15772: and cpe.table_route_id = c_table_route_id
15773: and cpe.information1 = c_information1 ;
15774: --
15777: c_information2 Date,
15778: c_information3 Date) is
15779: select
15780: cpe.*
15781: from ben_copy_entity_results cpe
15782: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15783: and cpe.table_route_id = c_table_route_id
15784: and cpe.information1 = c_information1
15785: and cpe.information2 = c_information2
15829: --
15830: l_update boolean := false ;
15831: l_datetrack_mode varchar2(80) := hr_api.g_update;
15832: l_process_date date;
15833: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15834: --
15835: --UPD END
15836: l_prev_pk_id number := null ;
15837: l_first_rec boolean := true ;
16211: select distinct cpe.information1,
16212: cpe.information2,
16213: cpe.information3,
16214: cpe.table_route_id
16215: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16216: pqh_table_route tr
16217: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16218: and cpe.table_route_id = tr.table_route_id
16219: -- and tr.where_clause = l_BEN_DPNT_OTHR_PTIP_RT_F
16227: c_information1 number) is
16228: select
16229: min(cpe.information2) min_esd,
16230: max(cpe.information3) min_eed
16231: from ben_copy_entity_results cpe
16232: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16233: and cpe.table_route_id = c_table_route_id
16234: and cpe.information1 = c_information1 ;
16235: --
16238: c_information2 Date,
16239: c_information3 Date) is
16240: select
16241: cpe.*
16242: from ben_copy_entity_results cpe
16243: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16244: and cpe.table_route_id = c_table_route_id
16245: and cpe.information1 = c_information1
16246: and cpe.information2 = c_information2
16290: --
16291: l_update boolean := false ;
16292: l_datetrack_mode varchar2(80) := hr_api.g_update;
16293: l_process_date date;
16294: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16295: --
16296: --UPD END
16297: l_prev_pk_id number := null ;
16298: l_first_rec boolean := true ;
16670: select distinct cpe.information1,
16671: cpe.information2,
16672: cpe.information3,
16673: cpe.table_route_id
16674: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16675: pqh_table_route tr
16676: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16677: and cpe.table_route_id = tr.table_route_id
16678: -- and tr.where_clause = l_BEN_DPNT_CVRD_OTHR_PGM_RT_F
16686: c_information1 number) is
16687: select
16688: min(cpe.information2) min_esd,
16689: max(cpe.information3) min_eed
16690: from ben_copy_entity_results cpe
16691: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16692: and cpe.table_route_id = c_table_route_id
16693: and cpe.information1 = c_information1 ;
16694: --
16697: c_information2 Date,
16698: c_information3 Date) is
16699: select
16700: cpe.*
16701: from ben_copy_entity_results cpe
16702: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16703: and cpe.table_route_id = c_table_route_id
16704: and cpe.information1 = c_information1
16705: and cpe.information2 = c_information2
16749: --
16750: l_update boolean := false ;
16751: l_datetrack_mode varchar2(80) := hr_api.g_update;
16752: l_process_date date;
16753: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16754: --
16755: --UPD END
16756: l_prev_pk_id number := null ;
16757: l_first_rec boolean := true ;
17133: select distinct cpe.information1,
17134: cpe.information2,
17135: cpe.information3,
17136: cpe.table_route_id
17137: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17138: pqh_table_route tr
17139: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17140: and cpe.table_route_id = tr.table_route_id
17141: -- and tr.where_clause = l_BEN_DPNT_CVRD_PLIP_RT_F
17149: c_information1 number) is
17150: select
17151: min(cpe.information2) min_esd,
17152: max(cpe.information3) min_eed
17153: from ben_copy_entity_results cpe
17154: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17155: and cpe.table_route_id = c_table_route_id
17156: and cpe.information1 = c_information1 ;
17157: --
17160: c_information2 Date,
17161: c_information3 Date) is
17162: select
17163: cpe.*
17164: from ben_copy_entity_results cpe
17165: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17166: and cpe.table_route_id = c_table_route_id
17167: and cpe.information1 = c_information1
17168: and cpe.information2 = c_information2
17212: --
17213: l_update boolean := false ;
17214: l_datetrack_mode varchar2(80) := hr_api.g_update;
17215: l_process_date date;
17216: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17217: --
17218: --UPD END
17219: l_prev_pk_id number := null ;
17220: l_first_rec boolean := true ;
17594: select distinct cpe.information1,
17595: cpe.information2,
17596: cpe.information3,
17597: cpe.table_route_id
17598: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17599: pqh_table_route tr
17600: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17601: and cpe.table_route_id = tr.table_route_id
17602: -- and tr.where_clause = l_BEN_DPNT_CVRD_OTHR_PTIP_RT_F
17610: c_information1 number) is
17611: select
17612: min(cpe.information2) min_esd,
17613: max(cpe.information3) min_eed
17614: from ben_copy_entity_results cpe
17615: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17616: and cpe.table_route_id = c_table_route_id
17617: and cpe.information1 = c_information1 ;
17618: --
17621: c_information2 Date,
17622: c_information3 Date) is
17623: select
17624: cpe.*
17625: from ben_copy_entity_results cpe
17626: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17627: and cpe.table_route_id = c_table_route_id
17628: and cpe.information1 = c_information1
17629: and cpe.information2 = c_information2
17673: --
17674: l_update boolean := false ;
17675: l_datetrack_mode varchar2(80) := hr_api.g_update;
17676: l_process_date date;
17677: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17678: --
17679: --UPD END
17680: l_prev_pk_id number := null ;
17681: l_first_rec boolean := true ;
18057: select distinct cpe.information1,
18058: cpe.information2,
18059: cpe.information3,
18060: cpe.table_route_id
18061: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18062: pqh_table_route tr
18063: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18064: and cpe.table_route_id = tr.table_route_id
18065: -- and tr.where_clause = l_BEN_DPNT_CVRD_OTHR_PL_RT_F
18073: c_information1 Number) is
18074: select
18075: min(cpe.information2) min_esd,
18076: max(cpe.information3) min_eed
18077: from ben_copy_entity_results cpe
18078: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18079: and cpe.table_route_id = c_table_route_id
18080: and cpe.information1 = c_information1 ;
18081: --
18084: c_information2 Date,
18085: c_information3 Date) is
18086: select
18087: cpe.*
18088: from ben_copy_entity_results cpe
18089: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18090: and cpe.table_route_id = c_table_route_id
18091: and cpe.information1 = c_information1
18092: and cpe.information2 = c_information2
18136: --
18137: l_update boolean := false ;
18138: l_datetrack_mode varchar2(80) := hr_api.g_update;
18139: l_process_date date;
18140: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18141: --
18142: --UPD END
18143: l_prev_pk_id number := null ;
18144: l_first_rec boolean := true ;
18525: select distinct cpe.information1,
18526: cpe.information2,
18527: cpe.information3,
18528: cpe.table_route_id
18529: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18530: pqh_table_route tr
18531: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18532: and cpe.table_route_id = tr.table_route_id
18533: -- and tr.where_clause = l_BEN_TTL_PRTT_RT_F
18541: c_information1 number) is
18542: select
18543: min(cpe.information2) min_esd,
18544: max(cpe.information3) min_eed
18545: from ben_copy_entity_results cpe
18546: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18547: and cpe.table_route_id = c_table_route_id
18548: and cpe.information1 = c_information1 ;
18549: --
18552: c_information2 Date,
18553: c_information3 Date) is
18554: select
18555: cpe.*
18556: from ben_copy_entity_results cpe
18557: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18558: and cpe.table_route_id = c_table_route_id
18559: and cpe.information1 = c_information1
18560: and cpe.information2 = c_information2
18622: --
18623: l_update boolean := false ;
18624: l_datetrack_mode varchar2(80) := hr_api.g_update;
18625: l_process_date date;
18626: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18627: --
18628: --UPD END
18629: l_prev_pk_id number := null ;
18630: l_first_rec boolean := true ;
19025: select distinct cpe.information1,
19026: cpe.information2,
19027: cpe.information3,
19028: cpe.table_route_id
19029: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19030: pqh_table_route tr
19031: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19032: and cpe.table_route_id = tr.table_route_id
19033: -- and tr.where_clause = l_BEN_TTL_CVG_VOL_RT_F
19041: c_information1 number) is
19042: select
19043: min(cpe.information2) min_esd,
19044: max(cpe.information3) min_eed
19045: from ben_copy_entity_results cpe
19046: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19047: and cpe.table_route_id = c_table_route_id
19048: and cpe.information1 = c_information1 ;
19049: --
19052: c_information2 Date,
19053: c_information3 Date) is
19054: select
19055: cpe.*
19056: from ben_copy_entity_results cpe
19057: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19058: and cpe.table_route_id = c_table_route_id
19059: and cpe.information1 = c_information1
19060: and cpe.information2 = c_information2
19122: --
19123: l_update boolean := false ;
19124: l_datetrack_mode varchar2(80) := hr_api.g_update;
19125: l_process_date date;
19126: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19127: --
19128: --UPD END
19129: l_prev_pk_id number := null ;
19130: l_first_rec boolean := true ;
19515: select distinct cpe.information1,
19516: cpe.information2,
19517: cpe.information3,
19518: cpe.table_route_id
19519: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19520: pqh_table_route tr
19521: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19522: and cpe.table_route_id = tr.table_route_id
19523: -- and tr.where_clause = l_BEN_VRBL_RT_PRFL_RL_F
19531: c_information1 Number) is
19532: select
19533: min(cpe.information2) min_esd,
19534: max(cpe.information3) min_eed
19535: from ben_copy_entity_results cpe
19536: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19537: and cpe.table_route_id = c_table_route_id
19538: and cpe.information1 = c_information1 ;
19539: --
19542: c_information2 Date,
19543: c_information3 Date) is
19544: select
19545: cpe.*
19546: from ben_copy_entity_results cpe
19547: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19548: and cpe.table_route_id = c_table_route_id
19549: and cpe.information1 = c_information1
19550: and cpe.information2 = c_information2
19594: --
19595: l_update boolean := false ;
19596: l_datetrack_mode varchar2(80) := hr_api.g_update;
19597: l_process_date date;
19598: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19599: --
19600: --UPD END
19601: l_prev_pk_id number := null ;
19602: l_first_rec boolean := true ;
19978: select distinct cpe.information1,
19979: cpe.information2,
19980: cpe.information3,
19981: cpe.table_route_id
19982: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19983: pqh_table_route tr
19984: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19985: and cpe.table_route_id = tr.table_route_id
19986: -- and tr.where_clause = l_BEN_POE_RT_F
19994: c_information1 Number) is
19995: select
19996: min(cpe.information2) min_esd,
19997: max(cpe.information3) min_eed
19998: from ben_copy_entity_results cpe
19999: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20000: and cpe.table_route_id = c_table_route_id
20001: and cpe.information1 = c_information1 ;
20002: --
20005: c_information2 Date,
20006: c_information3 Date) is
20007: select
20008: cpe.*
20009: from ben_copy_entity_results cpe
20010: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20011: and cpe.table_route_id = c_table_route_id
20012: and cpe.information1 = c_information1
20013: and cpe.information2 = c_information2
20075: --
20076: l_update boolean := false ;
20077: l_datetrack_mode varchar2(80) := hr_api.g_update;
20078: l_process_date date;
20079: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20080: --
20081: --UPD END
20082: l_prev_pk_id number := null ;
20083: l_first_rec boolean := true ;
20472: cpe.information2,
20473: cpe.information3,
20474: cpe.information170 name,
20475: cpe.table_route_id
20476: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20477: pqh_table_route tr
20478: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20479: and cpe.table_route_id = tr.table_route_id
20480: -- and tr.where_clause = l_BEN_CNTNG_PRTN_PRFL_RT_F
20488: c_information1 Number) is
20489: select
20490: min(cpe.information2) min_esd,
20491: max(cpe.information3) min_eed
20492: from ben_copy_entity_results cpe
20493: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20494: and cpe.table_route_id = c_table_route_id
20495: and cpe.information1 = c_information1 ;
20496: --
20499: c_information2 Date,
20500: c_information3 Date) is
20501: select
20502: cpe.*
20503: from ben_copy_entity_results cpe
20504: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20505: and cpe.table_route_id = c_table_route_id
20506: and cpe.information1 = c_information1
20507: and cpe.information2 = c_information2
20551: --
20552: l_update boolean := false ;
20553: l_datetrack_mode varchar2(80) := hr_api.g_update;
20554: l_process_date date;
20555: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20556: --
20557: --UPD END
20558: l_prev_pk_id number := null ;
20559: l_first_rec boolean := true ;
20938: select distinct cpe.information1,
20939: cpe.information2,
20940: cpe.information3,
20941: cpe.table_route_id
20942: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20943: pqh_table_route tr
20944: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20945: and cpe.table_route_id = tr.table_route_id
20946: -- and tr.where_clause = l_BEN_PSTN_RT_F
20954: c_information1 number) is
20955: select
20956: min(cpe.information2) min_esd,
20957: max(cpe.information3) min_eed
20958: from ben_copy_entity_results cpe
20959: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20960: and cpe.table_route_id = c_table_route_id
20961: and cpe.information1 = c_information1 ;
20962: --
20965: c_information2 Date,
20966: c_information3 Date) is
20967: select
20968: cpe.*
20969: from ben_copy_entity_results cpe
20970: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20971: and cpe.table_route_id = c_table_route_id
20972: and cpe.information1 = c_information1
20973: and cpe.information2 = c_information2
21020: --
21021: l_update boolean := false ;
21022: l_datetrack_mode varchar2(80) := hr_api.g_update;
21023: l_process_date date;
21024: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21025: --
21026: --UPD END
21027: l_prev_pk_id number := null ;
21028: l_first_rec boolean := true ;
21421: select distinct cpe.information1,
21422: cpe.information2,
21423: cpe.information3,
21424: cpe.table_route_id
21425: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21426: pqh_table_route tr
21427: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21428: and cpe.table_route_id = tr.table_route_id
21429: -- and tr.where_clause = l_BEN_WK_LOC_RT_F
21437: c_information1 number) is
21438: select
21439: min(cpe.information2) min_esd,
21440: max(cpe.information3) min_eed
21441: from ben_copy_entity_results cpe
21442: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21443: and cpe.table_route_id = c_table_route_id
21444: and cpe.information1 = c_information1 ;
21445: --
21448: c_information2 Date,
21449: c_information3 Date) is
21450: select
21451: cpe.*
21452: from ben_copy_entity_results cpe
21453: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21454: and cpe.table_route_id = c_table_route_id
21455: and cpe.information1 = c_information1
21456: and cpe.information2 = c_information2
21500: --
21501: l_update boolean := false ;
21502: l_datetrack_mode varchar2(80) := hr_api.g_update;
21503: l_process_date date;
21504: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21505: --
21506: --UPD END
21507: l_prev_pk_id number := null ;
21508: l_first_rec boolean := true ;
21900: select distinct cpe.information1,
21901: cpe.information2,
21902: cpe.information3,
21903: cpe.table_route_id
21904: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21905: pqh_table_route tr
21906: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21907: and cpe.table_route_id = tr.table_route_id
21908: -- and tr.where_clause = l_BEN_PCT_FL_TM_RT_F
21916: c_information1 number) is
21917: select
21918: min(cpe.information2) min_esd,
21919: max(cpe.information3) min_eed
21920: from ben_copy_entity_results cpe
21921: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21922: and cpe.table_route_id = c_table_route_id
21923: and cpe.information1 = c_information1 ;
21924: --
21927: c_information2 Date,
21928: c_information3 Date) is
21929: select
21930: cpe.*
21931: from ben_copy_entity_results cpe
21932: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21933: and cpe.table_route_id = c_table_route_id
21934: and cpe.information1 = c_information1
21935: and cpe.information2 = c_information2
21982: --
21983: l_update boolean := false ;
21984: l_datetrack_mode varchar2(80) := hr_api.g_update;
21985: l_process_date date;
21986: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21987: --
21988: --UPD END
21989: l_prev_pk_id number := null ;
21990: l_first_rec boolean := true ;
22363: select distinct cpe.information1,
22364: cpe.information2,
22365: cpe.information3,
22366: cpe.table_route_id
22367: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22368: pqh_table_route tr
22369: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22370: and cpe.table_route_id = tr.table_route_id
22371: -- and tr.where_clause = l_BEN_HRS_WKD_IN_PERD_RT_F
22379: c_information1 Number) is
22380: select
22381: min(cpe.information2) min_esd,
22382: max(cpe.information3) min_eed
22383: from ben_copy_entity_results cpe
22384: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22385: and cpe.table_route_id = c_table_route_id
22386: and cpe.information1 = c_information1 ;
22387: --
22390: c_information2 Date,
22391: c_information3 Date) is
22392: select
22393: cpe.*
22394: from ben_copy_entity_results cpe
22395: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22396: and cpe.table_route_id = c_table_route_id
22397: and cpe.information1 = c_information1
22398: and cpe.information2 = c_information2
22445: --
22446: l_update boolean := false ;
22447: l_datetrack_mode varchar2(80) := hr_api.g_update;
22448: l_process_date date;
22449: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22450: --
22451: --UPD END
22452: l_prev_pk_id number := null ;
22453: l_first_rec boolean := true ;
22827: select distinct cpe.information1,
22828: cpe.information2,
22829: cpe.information3,
22830: cpe.table_route_id
22831: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22832: pqh_table_route tr
22833: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22834: and cpe.table_route_id = tr.table_route_id
22835: -- and tr.where_clause = l_BEN_COMP_LVL_RT_F
22843: c_information1 number) is
22844: select
22845: min(cpe.information2) min_esd,
22846: max(cpe.information3) min_eed
22847: from ben_copy_entity_results cpe
22848: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22849: and cpe.table_route_id = c_table_route_id
22850: and cpe.information1 = c_information1 ;
22851: --
22854: c_information2 Date,
22855: c_information3 Date) is
22856: select
22857: cpe.*
22858: from ben_copy_entity_results cpe
22859: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22860: and cpe.table_route_id = c_table_route_id
22861: and cpe.information1 = c_information1
22862: and cpe.information2 = c_information2
22909: --
22910: l_update boolean := false ;
22911: l_datetrack_mode varchar2(80) := hr_api.g_update;
22912: l_process_date date;
22913: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22914: --
22915: --UPD END
22916: l_prev_pk_id number := null ;
22917: l_first_rec boolean := true ;
23289: select distinct cpe.information1,
23290: cpe.information2,
23291: cpe.information3,
23292: cpe.table_route_id
23293: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23294: pqh_table_route tr
23295: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23296: and cpe.table_route_id = tr.table_route_id
23297: -- and tr.where_clause = l_BEN_LOS_RT_F
23305: c_information1 number) is
23306: select
23307: min(cpe.information2) min_esd,
23308: max(cpe.information3) min_eed
23309: from ben_copy_entity_results cpe
23310: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23311: and cpe.table_route_id = c_table_route_id
23312: and cpe.information1 = c_information1 ;
23313: --
23316: c_information2 Date,
23317: c_information3 Date) is
23318: select
23319: cpe.*
23320: from ben_copy_entity_results cpe
23321: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23322: and cpe.table_route_id = c_table_route_id
23323: and cpe.information1 = c_information1
23324: and cpe.information2 = c_information2
23368: --
23369: l_update boolean := false ;
23370: l_datetrack_mode varchar2(80) := hr_api.g_update;
23371: l_process_date date;
23372: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23373: --
23374: --UPD END
23375: l_prev_pk_id number := null ;
23376: l_first_rec boolean := true ;
23746: select distinct cpe.information1,
23747: cpe.information2,
23748: cpe.information3,
23749: cpe.table_route_id
23750: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23751: pqh_table_route tr
23752: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23753: and cpe.table_route_id = tr.table_route_id
23754: -- and tr.where_clause = l_BEN_LVG_RSN_RT_F
23761: c_information1 number) is
23762: select
23763: min(cpe.information2) min_esd,
23764: max(cpe.information3) min_eed
23765: from ben_copy_entity_results cpe
23766: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23767: and cpe.table_route_id = c_table_route_id
23768: and cpe.information1 = c_information1 ;
23769: --
23772: c_information2 Date,
23773: c_information3 Date) is
23774: select
23775: cpe.*
23776: from ben_copy_entity_results cpe
23777: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23778: and cpe.table_route_id = c_table_route_id
23779: and cpe.information1 = c_information1
23780: and cpe.information2 = c_information2
23824: --
23825: l_update boolean := false ;
23826: l_datetrack_mode varchar2(80) := hr_api.g_update;
23827: l_process_date date;
23828: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23829: --
23830: --UPD END
23831: l_prev_pk_id number := null ;
23832: l_first_rec boolean := true ;
24204: select distinct cpe.information1,
24205: cpe.information2,
24206: cpe.information3,
24207: cpe.table_route_id
24208: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24209: pqh_table_route tr
24210: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24211: and cpe.table_route_id = tr.table_route_id
24212: -- and tr.where_clause = l_BEN_AGE_RT_F
24220: c_information1 number) is
24221: select
24222: min(cpe.information2) min_esd,
24223: max(cpe.information3) min_eed
24224: from ben_copy_entity_results cpe
24225: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24226: and cpe.table_route_id = c_table_route_id
24227: and cpe.information1 = c_information1 ;
24228: --
24231: c_information2 Date,
24232: c_information3 Date) is
24233: select
24234: cpe.*
24235: from ben_copy_entity_results cpe
24236: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24237: and cpe.table_route_id = c_table_route_id
24238: and cpe.information1 = c_information1
24239: and cpe.information2 = c_information2
24286: --
24287: l_update boolean := false ;
24288: l_datetrack_mode varchar2(80) := hr_api.g_update;
24289: l_process_date date;
24290: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
24291: --
24292: --UPD END
24293: l_prev_pk_id number := null ;
24294: l_first_rec boolean := true ;
24676: select distinct cpe.information1,
24677: cpe.information2,
24678: cpe.information3,
24679: cpe.table_route_id
24680: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24681: pqh_table_route tr
24682: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24683: and cpe.table_route_id = tr.table_route_id
24684: -- and tr.where_clause = l_BEN_SCHEDD_HRS_RT_F
24692: c_information1 number) is
24693: select
24694: min(cpe.information2) min_esd,
24695: max(cpe.information3) min_eed
24696: from ben_copy_entity_results cpe
24697: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24698: and cpe.table_route_id = c_table_route_id
24699: and cpe.information1 = c_information1 ;
24700: --
24703: c_information2 Date,
24704: c_information3 Date) is
24705: select
24706: cpe.*
24707: from ben_copy_entity_results cpe
24708: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24709: and cpe.table_route_id = c_table_route_id
24710: and cpe.information1 = c_information1
24711: and cpe.information2 = c_information2
24779: --
24780: l_update boolean := false ;
24781: l_datetrack_mode varchar2(80) := hr_api.g_update;
24782: l_process_date date;
24783: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
24784: --
24785: --UPD END
24786: l_prev_pk_id number := null ;
24787: l_first_rec boolean := true ;
25183: select distinct cpe.information1,
25184: cpe.information2,
25185: cpe.information3,
25186: cpe.table_route_id
25187: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25188: pqh_table_route tr
25189: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25190: and cpe.table_route_id = tr.table_route_id
25191: -- and tr.where_clause = l_BEN_QUA_IN_GR_RT_F
25199: c_information1 Number) is
25200: select
25201: min(cpe.information2) min_esd,
25202: max(cpe.information3) min_eed
25203: from ben_copy_entity_results cpe
25204: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25205: and cpe.table_route_id = c_table_route_id
25206: and cpe.information1 = c_information1 ;
25207: --
25210: c_information2 Date,
25211: c_information3 date) is
25212: select
25213: cpe.*
25214: from ben_copy_entity_results cpe
25215: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25216: and cpe.table_route_id = c_table_route_id
25217: and cpe.information1 = c_information1
25218: and cpe.information2 = c_information2
25265: --
25266: l_update boolean := false ;
25267: l_datetrack_mode varchar2(80) := hr_api.g_update;
25268: l_process_date date;
25269: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25270: --
25271: --UPD END
25272: l_prev_pk_id number := null ;
25273: l_first_rec boolean := true ;
25648: select distinct cpe.information1,
25649: cpe.information2,
25650: cpe.information3,
25651: cpe.table_route_id
25652: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25653: pqh_table_route tr
25654: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25655: and cpe.table_route_id = tr.table_route_id
25656: -- and tr.where_clause = l_BEN_PERF_RTNG_RT_F
25664: c_information1 number) is
25665: select
25666: min(cpe.information2) min_esd,
25667: max(cpe.information3) min_eed
25668: from ben_copy_entity_results cpe
25669: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25670: and cpe.table_route_id = c_table_route_id
25671: and cpe.information1 = c_information1 ;
25672: --
25675: c_information2 Date,
25676: c_information3 Date) is
25677: select
25678: cpe.*
25679: from ben_copy_entity_results cpe
25680: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25681: and cpe.table_route_id = c_table_route_id
25682: and cpe.information1 = c_information1
25683: and cpe.information2 = c_information2
25733: --
25734: l_update boolean := false ;
25735: l_datetrack_mode varchar2(80) := hr_api.g_update;
25736: l_process_date date;
25737: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25738: --
25739: --UPD END
25740: l_prev_pk_id number := null ;
25741: l_first_rec boolean := true ;
26116: select distinct cpe.information1,
26117: cpe.information2,
26118: cpe.information3,
26119: cpe.table_route_id
26120: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26121: pqh_table_route tr
26122: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26123: and cpe.table_route_id = tr.table_route_id
26124: -- and tr.where_clause = l_BEN_PPL_GRP_RT_F
26132: c_information1 number) is
26133: select
26134: min(cpe.information2) min_esd,
26135: max(cpe.information3) min_eed
26136: from ben_copy_entity_results cpe
26137: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26138: and cpe.table_route_id = c_table_route_id
26139: and cpe.information1 = c_information1 ;
26140: --
26143: c_information2 Date,
26144: c_information3 Date) is
26145: select
26146: cpe.*
26147: from ben_copy_entity_results cpe
26148: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26149: and cpe.table_route_id = c_table_route_id
26150: and cpe.information1 = c_information1
26151: and cpe.information2 = c_information2
26195: --
26196: l_update boolean := false ;
26197: l_datetrack_mode varchar2(80) := hr_api.g_update;
26198: l_process_date date;
26199: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26200: --
26201: --UPD END
26202: l_prev_pk_id number := null ;
26203: l_first_rec boolean := true ;