[Home] [Help]
195: --
196: 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
197: begin
198: hr_utility.set_location('Inside update_cer_with_target ',233);
199: update ben_copy_entity_results
200: set information9 = c_pk_rec.copy_reuse_type||'-'||c_pk_rec.new_value
201: where copy_entity_txn_id = p_copy_entity_txn_id
202: and table_route_id = c_pk_rec.table_route_id
203: and information1 = c_pk_rec.old_value ;
226: select distinct cpe.information1,
227: cpe.information2,
228: cpe.information3,
229: cpe.table_route_id
230: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
231: pqh_table_route tr
232: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
233: and cpe.table_route_id = tr.table_route_id
234: -- and tr.where_clause = l_BEN_ELIG_ASNT_SET_PRTE_F
242: c_information1 number) is
243: select
244: min(cpe.information2) min_esd,
245: max(cpe.information3) min_eed
246: from ben_copy_entity_results cpe
247: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
248: and cpe.table_route_id = c_table_route_id
249: and cpe.information1 = c_information1 ;
250: --
253: c_information2 date,
254: c_information3 date ) is
255: select
256: cpe.*
257: from ben_copy_entity_results cpe
258: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
259: and cpe.table_route_id = c_table_route_id
260: and cpe.information1 = c_information1
261: and cpe.information2 = c_information2
305: --
306: l_update boolean := false ;
307: l_datetrack_mode varchar2(80) := hr_api.g_update;
308: l_process_date date;
309: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
310: --
311: --UPD END
312: l_current_pk_id number := null ;
313:
753: cpe.information2,
754: cpe.information3,
755: cpe.information170 name,
756: cpe.table_route_id
757: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
758: pqh_table_route tr
759: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
760: and cpe.table_route_id = tr.table_route_id
761: -- and tr.where_clause = l_BEN_CNTNG_PRTN_ELIG_PRFL_F
769: c_information1 number) is
770: select
771: min(cpe.information2) min_esd,
772: max(cpe.information3) min_eed
773: from ben_copy_entity_results cpe
774: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
775: and cpe.table_route_id = c_table_route_id
776: and cpe.information1 = c_information1 ;
777: --
780: c_information2 date,
781: c_information3 date) is
782: select
783: cpe.*
784: from ben_copy_entity_results cpe
785: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
786: and cpe.table_route_id = c_table_route_id
787: and cpe.information1 = c_information1
788: and cpe.information2 = c_information2
844: --
845: l_update boolean := false ;
846: l_datetrack_mode varchar2(80) := hr_api.g_update;
847: l_process_date date;
848: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
849: --
850: --UPD END
851: l_current_pk_id number := null ;
852:
1260: select distinct cpe.information1,
1261: cpe.information2,
1262: cpe.information3,
1263: cpe.table_route_id
1264: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
1265: pqh_table_route tr
1266: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1267: and cpe.table_route_id = tr.table_route_id
1268: -- and tr.where_clause = l_BEN_ELIG_AGE_PRTE_F
1277: c_information1 number) is
1278: select
1279: min(cpe.information2) min_esd,
1280: max(cpe.information3) min_eed
1281: from ben_copy_entity_results cpe
1282: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1283: and cpe.table_route_id = c_table_route_id
1284: and cpe.information1 = c_information1 ;
1285: --
1288: c_information2 date,
1289: c_information3 date) is
1290: select
1291: cpe.*
1292: from ben_copy_entity_results cpe
1293: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1294: and cpe.table_route_id = c_table_route_id
1295: and cpe.information1 = c_information1
1296: and cpe.information2 = c_information2
1340: --
1341: l_update boolean := false ;
1342: l_datetrack_mode varchar2(80) := hr_api.g_update;
1343: l_process_date date;
1344: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1345: --
1346: --UPD END
1347: l_current_pk_id number := null ;
1348:
1752: select distinct cpe.information1,
1753: cpe.information2,
1754: cpe.information3,
1755: cpe.table_route_id
1756: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
1757: pqh_table_route tr
1758: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1759: and cpe.table_route_id = tr.table_route_id
1760: -- and tr.where_clause = l_BEN_ELIG_BENFTS_GRP_PRTE_F
1768: c_information1 number) is
1769: select
1770: min(cpe.information2) min_esd,
1771: max(cpe.information3) min_eed
1772: from ben_copy_entity_results cpe
1773: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1774: and cpe.table_route_id = c_table_route_id
1775: and cpe.information1 = c_information1 ;
1776: --
1779: c_information2 date,
1780: c_information3 date ) is
1781: select
1782: cpe.*
1783: from ben_copy_entity_results cpe
1784: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1785: and cpe.table_route_id = c_table_route_id
1786: and cpe.information1 = c_information1
1787: and cpe.information2 = c_information2
1831: --
1832: l_update boolean := false ;
1833: l_datetrack_mode varchar2(80) := hr_api.g_update;
1834: l_process_date date;
1835: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1836: --
1837: --UPD END
1838: l_current_pk_id number := null ;
1839:
2243: select distinct cpe.information1,
2244: cpe.information2,
2245: cpe.information3,
2246: cpe.table_route_id
2247: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
2248: pqh_table_route tr
2249: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2250: and cpe.table_route_id = tr.table_route_id
2251: -- and tr.where_clause = l_BEN_ELIG_BRGNG_UNIT_PRTE_F
2259: c_information1 number) is
2260: select
2261: min(cpe.information2) min_esd,
2262: max(cpe.information3) min_eed
2263: from ben_copy_entity_results cpe
2264: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2265: and cpe.table_route_id = c_table_route_id
2266: and cpe.information1 = c_information1 ;
2267: --
2270: c_information2 date,
2271: c_information3 date ) is
2272: select
2273: cpe.*
2274: from ben_copy_entity_results cpe
2275: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2276: and cpe.table_route_id = c_table_route_id
2277: and cpe.information1 = c_information1
2278: and cpe.information2 = c_information2
2322: --
2323: l_update boolean := false ;
2324: l_datetrack_mode varchar2(80) := hr_api.g_update;
2325: l_process_date date;
2326: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2327: --
2328: --UPD END
2329: l_current_pk_id number := null ;
2330:
2735: select distinct cpe.information1,
2736: cpe.information2,
2737: cpe.information3,
2738: cpe.table_route_id
2739: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
2740: pqh_table_route tr
2741: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2742: and cpe.table_route_id = tr.table_route_id
2743: -- and tr.where_clause = l_BEN_ELIG_COMP_LVL_PRTE_F
2751: c_information1 number) is
2752: select
2753: min(cpe.information2) min_esd,
2754: max(cpe.information3) min_eed
2755: from ben_copy_entity_results cpe
2756: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2757: and cpe.table_route_id = c_table_route_id
2758: and cpe.information1 = c_information1 ;
2759: --
2762: c_information2 date,
2763: c_information3 date ) is
2764: select
2765: cpe.*
2766: from ben_copy_entity_results cpe
2767: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2768: and cpe.table_route_id = c_table_route_id
2769: and cpe.information1 = c_information1
2770: and cpe.information2 = c_information2
2814: --
2815: l_update boolean := false ;
2816: l_datetrack_mode varchar2(80) := hr_api.g_update;
2817: l_process_date date;
2818: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2819: --
2820: --UPD END
2821: l_current_pk_id number := null ;
2822:
3225: select distinct cpe.information1,
3226: cpe.information2,
3227: cpe.information3,
3228: cpe.table_route_id
3229: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
3230: pqh_table_route tr
3231: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3232: and cpe.table_route_id = tr.table_route_id
3233: -- and tr.where_clause = l_BEN_ELIG_CMBN_AGE_LOS_PRTE_F
3241: c_information1 number) is
3242: select
3243: min(cpe.information2) min_esd,
3244: max(cpe.information3) min_eed
3245: from ben_copy_entity_results cpe
3246: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3247: and cpe.table_route_id = c_table_route_id
3248: and cpe.information1 = c_information1 ;
3249: --
3252: c_information2 date,
3253: c_information3 date ) is
3254: select
3255: cpe.*
3256: from ben_copy_entity_results cpe
3257: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3258: and cpe.table_route_id = c_table_route_id
3259: and cpe.information1 = c_information1
3260: and cpe.information2 = c_information2
3304: --
3305: l_update boolean := false ;
3306: l_datetrack_mode varchar2(80) := hr_api.g_update;
3307: l_process_date date;
3308: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3309: --
3310: --UPD END
3311: l_current_pk_id number := null ;
3312:
3721: select distinct cpe.information1,
3722: cpe.information2,
3723: cpe.information3,
3724: cpe.table_route_id
3725: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
3726: pqh_table_route tr
3727: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3728: and cpe.table_route_id = tr.table_route_id
3729: -- and tr.where_clause = l_BEN_ELIG_CBR_QUALD_BNF_F
3737: c_information1 number) is
3738: select
3739: min(cpe.information2) min_esd,
3740: max(cpe.information3) min_eed
3741: from ben_copy_entity_results cpe
3742: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3743: and cpe.table_route_id = c_table_route_id
3744: and cpe.information1 = c_information1 ;
3745: --
3748: c_information2 date,
3749: c_information3 date) is
3750: select
3751: cpe.*
3752: from ben_copy_entity_results cpe
3753: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3754: and cpe.table_route_id = c_table_route_id
3755: and cpe.information1 = c_information1
3756: and cpe.information2 = c_information2
3803: --
3804: l_update boolean := false ;
3805: l_datetrack_mode varchar2(80) := hr_api.g_update;
3806: l_process_date date;
3807: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3808: --
3809: --UPD END
3810: l_current_pk_id number := null ;
3811:
4232: select distinct cpe.information1,
4233: cpe.information2,
4234: cpe.information3,
4235: cpe.table_route_id
4236: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4237: pqh_table_route tr
4238: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4239: and cpe.table_route_id = tr.table_route_id
4240: -- and tr.where_clause = l_BEN_ELIG_COMPTNCY_PRTE_F
4248: c_information1 number) is
4249: select
4250: min(cpe.information2) min_esd,
4251: max(cpe.information3) min_eed
4252: from ben_copy_entity_results cpe
4253: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4254: and cpe.table_route_id = c_table_route_id
4255: and cpe.information1 = c_information1 ;
4256: --
4259: c_information2 date,
4260: c_information3 date) is
4261: select
4262: cpe.*
4263: from ben_copy_entity_results cpe
4264: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4265: and cpe.table_route_id = c_table_route_id
4266: and cpe.information1 = c_information1
4267: and cpe.information2 = c_information2
4314: --
4315: l_update boolean := false ;
4316: l_datetrack_mode varchar2(80) := hr_api.g_update;
4317: l_process_date date;
4318: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4319: --
4320: --UPD END
4321: l_current_pk_id number := null ;
4322:
4854: select distinct cpe.information1,
4855: cpe.information2,
4856: cpe.information3,
4857: cpe.table_route_id
4858: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
4859: pqh_table_route tr
4860: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4861: and cpe.table_route_id = tr.table_route_id
4862: -- and tr.where_clause = l_BEN_ELG_DPNT_CVR_OTHR_PGM_F
4870: c_information1 number) is
4871: select
4872: min(cpe.information2) min_esd,
4873: max(cpe.information3) min_eed
4874: from ben_copy_entity_results cpe
4875: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4876: and cpe.table_route_id = c_table_route_id
4877: and cpe.information1 = c_information1 ;
4878: --
4881: c_information2 date,
4882: c_information3 date) is
4883: select
4884: cpe.*
4885: from ben_copy_entity_results cpe
4886: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4887: and cpe.table_route_id = c_table_route_id
4888: and cpe.information1 = c_information1
4889: and cpe.information2 = c_information2
4935: --
4936: l_update boolean := false ;
4937: l_datetrack_mode varchar2(80) := hr_api.g_update;
4938: l_process_date date;
4939: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4940: --
4941: --UPD END
4942: l_current_pk_id number := null ;
4943:
5357: select distinct cpe.information1,
5358: cpe.information2,
5359: cpe.information3,
5360: cpe.table_route_id
5361: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5362: pqh_table_route tr
5363: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5364: and cpe.table_route_id = tr.table_route_id
5365: -- and tr.where_clause = l_BEN_ELIG_DPNT_CVRD_PLIP_F
5373: c_information1 number) is
5374: select
5375: min(cpe.information2) min_esd,
5376: max(cpe.information3) min_eed
5377: from ben_copy_entity_results cpe
5378: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5379: and cpe.table_route_id = c_table_route_id
5380: and cpe.information1 = c_information1 ;
5381: --
5384: c_information2 date,
5385: c_information3 date ) is
5386: select
5387: cpe.*
5388: from ben_copy_entity_results cpe
5389: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5390: and cpe.table_route_id = c_table_route_id
5391: and cpe.information1 = c_information1
5392: and cpe.information2 = c_information2
5438: --
5439: l_update boolean := false ;
5440: l_datetrack_mode varchar2(80) := hr_api.g_update;
5441: l_process_date date;
5442: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5443: --
5444: --UPD END
5445: l_current_pk_id number := null ;
5446:
5860: select distinct cpe.information1,
5861: cpe.information2,
5862: cpe.information3,
5863: cpe.table_route_id
5864: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5865: pqh_table_route tr
5866: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5867: and cpe.table_route_id = tr.table_route_id
5868: -- and tr.where_clause = l_BEN_ELIG_DPNT_CVRD_OTHR_PL_F
5876: c_information1 number) is
5877: select
5878: min(cpe.information2) min_esd,
5879: max(cpe.information3) min_eed
5880: from ben_copy_entity_results cpe
5881: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5882: and cpe.table_route_id = c_table_route_id
5883: and cpe.information1 = c_information1 ;
5884: --
5887: c_information2 date,
5888: c_information3 date) is
5889: select
5890: cpe.*
5891: from ben_copy_entity_results cpe
5892: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5893: and cpe.table_route_id = c_table_route_id
5894: and cpe.information1 = c_information1
5895: and cpe.information2 = c_information2
5941: --
5942: l_update boolean := false ;
5943: l_datetrack_mode varchar2(80) := hr_api.g_update;
5944: l_process_date date;
5945: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5946: --
5947: --UPD END
5948: l_current_pk_id number := null ;
5949:
6359: select distinct cpe.information1,
6360: cpe.information2,
6361: cpe.information3,
6362: cpe.table_route_id
6363: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6364: pqh_table_route tr
6365: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6366: and cpe.table_route_id = tr.table_route_id
6367: -- and tr.where_clause = l_BEN_ELG_DPNT_CVR_OTR_PTIP_F
6375: c_information1 number) is
6376: select
6377: min(cpe.information2) min_esd,
6378: max(cpe.information3) min_eed
6379: from ben_copy_entity_results cpe
6380: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6381: and cpe.table_route_id = c_table_route_id
6382: and cpe.information1 = c_information1 ;
6383: --
6386: c_information2 date,
6387: c_information3 date) is
6388: select
6389: cpe.*
6390: from ben_copy_entity_results cpe
6391: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6392: and cpe.table_route_id = c_table_route_id
6393: and cpe.information1 = c_information1
6394: and cpe.information2 = c_information2
6440: --
6441: l_update boolean := false ;
6442: l_datetrack_mode varchar2(80) := hr_api.g_update;
6443: l_process_date date;
6444: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6445: --
6446: --UPD END
6447: l_current_pk_id number := null ;
6448:
6859: select distinct cpe.information1,
6860: cpe.information2,
6861: cpe.information3,
6862: cpe.table_route_id
6863: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6864: pqh_table_route tr
6865: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6866: and cpe.table_route_id = tr.table_route_id
6867: -- and tr.where_clause = l_BEN_ELIGY_PRFL_RL_F
6875: c_information1 number) is
6876: select
6877: min(cpe.information2) min_esd,
6878: max(cpe.information3) min_eed
6879: from ben_copy_entity_results cpe
6880: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6881: and cpe.table_route_id = c_table_route_id
6882: and cpe.information1 = c_information1 ;
6883: --
6886: c_information2 date,
6887: c_information3 date ) is
6888: select
6889: cpe.*
6890: from ben_copy_entity_results cpe
6891: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6892: and cpe.table_route_id = c_table_route_id
6893: and cpe.information1 = c_information1
6894: and cpe.information2 = c_information2
6940: --
6941: l_update boolean := false ;
6942: l_datetrack_mode varchar2(80) := hr_api.g_update;
6943: l_process_date date;
6944: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6945: --
6946: --UPD END
6947: l_current_pk_id number := null ;
6948:
7359: select distinct cpe.information1,
7360: cpe.information2,
7361: cpe.information3,
7362: cpe.table_route_id
7363: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7364: pqh_table_route tr
7365: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7366: and cpe.table_route_id = tr.table_route_id
7367: -- and tr.where_clause = l_BEN_ELIG_HRS_WKD_PRTE_F
7375: c_information1 number) is
7376: select
7377: min(cpe.information2) min_esd,
7378: max(cpe.information3) min_eed
7379: from ben_copy_entity_results cpe
7380: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7381: and cpe.table_route_id = c_table_route_id
7382: and cpe.information1 = c_information1 ;
7383: --
7386: c_information2 date,
7387: c_information3 date ) is
7388: select
7389: cpe.*
7390: from ben_copy_entity_results cpe
7391: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7392: and cpe.table_route_id = c_table_route_id
7393: and cpe.information1 = c_information1
7394: and cpe.information2 = c_information2
7437: --
7438: l_update boolean := false ;
7439: l_datetrack_mode varchar2(80) := hr_api.g_update;
7440: l_process_date date;
7441: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7442: --
7443: --UPD END
7444: l_current_pk_id number := null ;
7445:
7853: select distinct cpe.information1,
7854: cpe.information2,
7855: cpe.information3,
7856: cpe.table_route_id
7857: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7858: pqh_table_route tr
7859: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7860: and cpe.table_route_id = tr.table_route_id
7861: -- and tr.where_clause = l_BEN_ELIG_JOB_PRTE_F
7869: c_information1 number) is
7870: select
7871: min(cpe.information2) min_esd,
7872: max(cpe.information3) min_eed
7873: from ben_copy_entity_results cpe
7874: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7875: and cpe.table_route_id = c_table_route_id
7876: and cpe.information1 = c_information1 ;
7877: --
7880: c_information2 date,
7881: c_information3 date ) is
7882: select
7883: cpe.*
7884: from ben_copy_entity_results cpe
7885: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7886: and cpe.table_route_id = c_table_route_id
7887: and cpe.information1 = c_information1
7888: and cpe.information2 = c_information2
7934: --
7935: l_update boolean := false ;
7936: l_datetrack_mode varchar2(80) := hr_api.g_update;
7937: l_process_date date;
7938: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7939: --
7940: --UPD END
7941: l_current_pk_id number := null ;
7942:
8370: select distinct cpe.information1,
8371: cpe.information2,
8372: cpe.information3,
8373: cpe.table_route_id
8374: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8375: pqh_table_route tr
8376: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8377: and cpe.table_route_id = tr.table_route_id
8378: -- and tr.where_clause = l_BEN_ELIG_LBR_MMBR_PRTE_F
8386: c_information1 number) is
8387: select
8388: min(cpe.information2) min_esd,
8389: max(cpe.information3) min_eed
8390: from ben_copy_entity_results cpe
8391: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8392: and cpe.table_route_id = c_table_route_id
8393: and cpe.information1 = c_information1 ;
8394: --
8397: c_information2 date,
8398: c_information3 date ) is
8399: select
8400: cpe.*
8401: from ben_copy_entity_results cpe
8402: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8403: and cpe.table_route_id = c_table_route_id
8404: and cpe.information1 = c_information1
8405: and cpe.information2 = c_information2
8448: --
8449: l_update boolean := false ;
8450: l_datetrack_mode varchar2(80) := hr_api.g_update;
8451: l_process_date date;
8452: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8453: --
8454: --UPD END
8455: l_current_pk_id number := null ;
8456:
8859: select distinct cpe.information1,
8860: cpe.information2,
8861: cpe.information3,
8862: cpe.table_route_id
8863: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
8864: pqh_table_route tr
8865: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8866: and cpe.table_route_id = tr.table_route_id
8867: -- and tr.where_clause = l_BEN_ELIG_LGL_ENTY_PRTE_F
8875: c_information1 number) is
8876: select
8877: min(cpe.information2) min_esd,
8878: max(cpe.information3) min_eed
8879: from ben_copy_entity_results cpe
8880: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8881: and cpe.table_route_id = c_table_route_id
8882: and cpe.information1 = c_information1 ;
8883: --
8886: c_information2 date,
8887: c_information3 date ) is
8888: select
8889: cpe.*
8890: from ben_copy_entity_results cpe
8891: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8892: and cpe.table_route_id = c_table_route_id
8893: and cpe.information1 = c_information1
8894: and cpe.information2 = c_information2
8937: --
8938: l_update boolean := false ;
8939: l_datetrack_mode varchar2(80) := hr_api.g_update;
8940: l_process_date date;
8941: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8942: --
8943: --UPD END
8944: l_current_pk_id number := null ;
8945:
9376: select distinct cpe.information1,
9377: cpe.information2,
9378: cpe.information3,
9379: cpe.table_route_id
9380: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9381: pqh_table_route tr
9382: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9383: and cpe.table_route_id = tr.table_route_id
9384: -- and tr.where_clause = l_BEN_ELIG_LOA_RSN_PRTE_F
9392: c_information1 number) is
9393: select
9394: min(cpe.information2) min_esd,
9395: max(cpe.information3) min_eed
9396: from ben_copy_entity_results cpe
9397: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9398: and cpe.table_route_id = c_table_route_id
9399: and cpe.information1 = c_information1 ;
9400: --
9403: c_information2 date,
9404: c_information3 date ) is
9405: select
9406: cpe.*
9407: from ben_copy_entity_results cpe
9408: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9409: and cpe.table_route_id = c_table_route_id
9410: and cpe.information1 = c_information1
9411: and cpe.information2 = c_information2
9457: --
9458: l_update boolean := false ;
9459: l_datetrack_mode varchar2(80) := hr_api.g_update;
9460: l_process_date date;
9461: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9462: --
9463: --UPD END
9464: l_current_pk_id number := null ;
9465:
9930: select distinct cpe.information1,
9931: cpe.information2,
9932: cpe.information3,
9933: cpe.table_route_id
9934: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
9935: pqh_table_route tr
9936: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9937: and cpe.table_route_id = tr.table_route_id
9938: -- and tr.where_clause = l_BEN_ELIG_LOS_PRTE_F
9946: c_information1 number) is
9947: select
9948: min(cpe.information2) min_esd,
9949: max(cpe.information3) min_eed
9950: from ben_copy_entity_results cpe
9951: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9952: and cpe.table_route_id = c_table_route_id
9953: and cpe.information1 = c_information1 ;
9954: --
9957: c_information2 date,
9958: c_information3 date ) is
9959: select
9960: cpe.*
9961: from ben_copy_entity_results cpe
9962: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9963: and cpe.table_route_id = c_table_route_id
9964: and cpe.information1 = c_information1
9965: and cpe.information2 = c_information2
10008: --
10009: l_update boolean := false ;
10010: l_datetrack_mode varchar2(80) := hr_api.g_update;
10011: l_process_date date;
10012: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10013: --
10014: --UPD END
10015: l_current_pk_id number := null ;
10016:
10424: select distinct cpe.information1,
10425: cpe.information2,
10426: cpe.information3,
10427: cpe.table_route_id
10428: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10429: pqh_table_route tr
10430: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10431: and cpe.table_route_id = tr.table_route_id
10432: -- and tr.where_clause = l_BEN_ELIG_LVG_RSN_PRTE_F
10440: c_information1 number) is
10441: select
10442: min(cpe.information2) min_esd,
10443: max(cpe.information3) min_eed
10444: from ben_copy_entity_results cpe
10445: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10446: and cpe.table_route_id = c_table_route_id
10447: and cpe.information1 = c_information1 ;
10448: --
10451: c_information2 date,
10452: c_information3 date ) is
10453: select
10454: cpe.*
10455: from ben_copy_entity_results cpe
10456: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10457: and cpe.table_route_id = c_table_route_id
10458: and cpe.information1 = c_information1
10459: and cpe.information2 = c_information2
10502: --
10503: l_update boolean := false ;
10504: l_datetrack_mode varchar2(80) := hr_api.g_update;
10505: l_process_date date;
10506: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10507: --
10508: --UPD END
10509: l_current_pk_id number := null ;
10510:
10920: select distinct cpe.information1,
10921: cpe.information2,
10922: cpe.information3,
10923: cpe.table_route_id
10924: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
10925: pqh_table_route tr
10926: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10927: and cpe.table_route_id = tr.table_route_id
10928: -- and tr.where_clause = l_BEN_ELIG_MRTL_STS_PRTE_F
10936: c_information1 number) is
10937: select
10938: min(cpe.information2) min_esd,
10939: max(cpe.information3) min_eed
10940: from ben_copy_entity_results cpe
10941: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10942: and cpe.table_route_id = c_table_route_id
10943: and cpe.information1 = c_information1 ;
10944: --
10947: c_information2 date,
10948: c_information3 date ) is
10949: select
10950: cpe.*
10951: from ben_copy_entity_results cpe
10952: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10953: and cpe.table_route_id = c_table_route_id
10954: and cpe.information1 = c_information1
10955: and cpe.information2 = c_information2
10998: --
10999: l_update boolean := false ;
11000: l_datetrack_mode varchar2(80) := hr_api.g_update;
11001: l_process_date date;
11002: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11003: --
11004: --UPD END
11005: l_current_pk_id number := null ;
11006:
11414: select distinct cpe.information1,
11415: cpe.information2,
11416: cpe.information3,
11417: cpe.table_route_id
11418: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
11419: pqh_table_route tr
11420: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11421: and cpe.table_route_id = tr.table_route_id
11422: -- and tr.where_clause = l_BEN_ELIG_NO_OTHR_CVG_PRTE_F
11430: c_information1 number) is
11431: select
11432: min(cpe.information2) min_esd,
11433: max(cpe.information3) min_eed
11434: from ben_copy_entity_results cpe
11435: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11436: and cpe.table_route_id = c_table_route_id
11437: and cpe.information1 = c_information1 ;
11438: --
11441: c_information2 date,
11442: c_information3 date ) is
11443: select
11444: cpe.*
11445: from ben_copy_entity_results cpe
11446: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11447: and cpe.table_route_id = c_table_route_id
11448: and cpe.information1 = c_information1
11449: and cpe.information2 = c_information2
11492: --
11493: l_update boolean := false ;
11494: l_datetrack_mode varchar2(80) := hr_api.g_update;
11495: l_process_date date;
11496: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11497: --
11498: --UPD END
11499: l_current_pk_id number := null ;
11500:
11899: select distinct cpe.information1,
11900: cpe.information2,
11901: cpe.information3,
11902: cpe.table_route_id
11903: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
11904: pqh_table_route tr
11905: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11906: and cpe.table_route_id = tr.table_route_id
11907: -- and tr.where_clause = l_BEN_ELIG_OPTD_MDCR_PRTE_F
11915: c_information1 number) is
11916: select
11917: min(cpe.information2) min_esd,
11918: max(cpe.information3) min_eed
11919: from ben_copy_entity_results cpe
11920: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11921: and cpe.table_route_id = c_table_route_id
11922: and cpe.information1 = c_information1 ;
11923: --
11926: c_information2 date,
11927: c_information3 date ) is
11928: select
11929: cpe.*
11930: from ben_copy_entity_results cpe
11931: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11932: and cpe.table_route_id = c_table_route_id
11933: and cpe.information1 = c_information1
11934: and cpe.information2 = c_information2
11977: --
11978: l_update boolean := false ;
11979: l_datetrack_mode varchar2(80) := hr_api.g_update;
11980: l_process_date date;
11981: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11982: --
11983: --UPD END
11984: l_current_pk_id number := null ;
11985:
12384: select distinct cpe.information1,
12385: cpe.information2,
12386: cpe.information3,
12387: cpe.table_route_id
12388: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12389: pqh_table_route tr
12390: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12391: and cpe.table_route_id = tr.table_route_id
12392: -- and tr.where_clause = l_BEN_ELIG_ORG_UNIT_PRTE_F
12400: c_information1 number) is
12401: select
12402: min(cpe.information2) min_esd,
12403: max(cpe.information3) min_eed
12404: from ben_copy_entity_results cpe
12405: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12406: and cpe.table_route_id = c_table_route_id
12407: and cpe.information1 = c_information1 ;
12408: --
12411: c_information2 date,
12412: c_information3 date ) is
12413: select
12414: cpe.*
12415: from ben_copy_entity_results cpe
12416: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12417: and cpe.table_route_id = c_table_route_id
12418: and cpe.information1 = c_information1
12419: and cpe.information2 = c_information2
12462: --
12463: l_update boolean := false ;
12464: l_datetrack_mode varchar2(80) := hr_api.g_update;
12465: l_process_date date;
12466: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12467: --
12468: --UPD END
12469: l_current_pk_id number := null ;
12470:
12904: select distinct cpe.information1,
12905: cpe.information2,
12906: cpe.information3,
12907: cpe.table_route_id
12908: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
12909: pqh_table_route tr
12910: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12911: and cpe.table_route_id = tr.table_route_id
12912: -- and tr.where_clause = l_BEN_ELIG_OTHR_PTIP_PRTE_F
12920: c_information1 number) is
12921: select
12922: min(cpe.information2) min_esd,
12923: max(cpe.information3) min_eed
12924: from ben_copy_entity_results cpe
12925: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12926: and cpe.table_route_id = c_table_route_id
12927: and cpe.information1 = c_information1 ;
12928: --
12931: c_information2 date,
12932: c_information3 date ) is
12933: select
12934: cpe.*
12935: from ben_copy_entity_results cpe
12936: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12937: and cpe.table_route_id = c_table_route_id
12938: and cpe.information1 = c_information1
12939: and cpe.information2 = c_information2
12982: --
12983: l_update boolean := false ;
12984: l_datetrack_mode varchar2(80) := hr_api.g_update;
12985: l_process_date date;
12986: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12987: --
12988: --UPD END
12989: l_current_pk_id number := null ;
12990:
13400: select distinct cpe.information1,
13401: cpe.information2,
13402: cpe.information3,
13403: cpe.table_route_id
13404: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13405: pqh_table_route tr
13406: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13407: and cpe.table_route_id = tr.table_route_id
13408: -- and tr.where_clause = l_BEN_ELIG_PCT_FL_TM_PRTE_F
13416: c_information1 number) is
13417: select
13418: min(cpe.information2) min_esd,
13419: max(cpe.information3) min_eed
13420: from ben_copy_entity_results cpe
13421: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13422: and cpe.table_route_id = c_table_route_id
13423: and cpe.information1 = c_information1 ;
13424: --
13427: c_information2 date,
13428: c_information3 date ) is
13429: select
13430: cpe.*
13431: from ben_copy_entity_results cpe
13432: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13433: and cpe.table_route_id = c_table_route_id
13434: and cpe.information1 = c_information1
13435: and cpe.information2 = c_information2
13481: --
13482: l_update boolean := false ;
13483: l_datetrack_mode varchar2(80) := hr_api.g_update;
13484: l_process_date date;
13485: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13486: --
13487: --UPD END
13488: l_current_pk_id number := null;
13489:
13897: select distinct cpe.information1,
13898: cpe.information2,
13899: cpe.information3,
13900: cpe.table_route_id
13901: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13902: pqh_table_route tr
13903: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13904: and cpe.table_route_id = tr.table_route_id
13905: -- and tr.where_clause = l_BEN_ELIG_PER_TYP_PRTE_F
13913: c_information1 number) is
13914: select
13915: min(cpe.information2) min_esd,
13916: max(cpe.information3) min_eed
13917: from ben_copy_entity_results cpe
13918: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13919: and cpe.table_route_id = c_table_route_id
13920: and cpe.information1 = c_information1 ;
13921: --
13924: c_information2 date,
13925: c_information3 date ) is
13926: select
13927: cpe.*
13928: from ben_copy_entity_results cpe
13929: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13930: and cpe.table_route_id = c_table_route_id
13931: and cpe.information1 = c_information1
13932: and cpe.information2 = c_information2
13978: --
13979: l_update boolean := false ;
13980: l_datetrack_mode varchar2(80) := hr_api.g_update;
13981: l_process_date date;
13982: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13983: --
13984: --UPD END
13985: l_current_pk_id number := null ;
13986:
14424: select distinct cpe.information1,
14425: cpe.information2,
14426: cpe.information3,
14427: cpe.table_route_id
14428: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14429: pqh_table_route tr
14430: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14431: and cpe.table_route_id = tr.table_route_id
14432: -- and tr.where_clause = l_BEN_ELIG_PPL_GRP_PRTE_F
14440: c_information1 number) is
14441: select
14442: min(cpe.information2) min_esd,
14443: max(cpe.information3) min_eed
14444: from ben_copy_entity_results cpe
14445: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14446: and cpe.table_route_id = c_table_route_id
14447: and cpe.information1 = c_information1 ;
14448: --
14451: c_information2 date,
14452: c_information3 date ) is
14453: select
14454: cpe.*
14455: from ben_copy_entity_results cpe
14456: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14457: and cpe.table_route_id = c_table_route_id
14458: and cpe.information1 = c_information1
14459: and cpe.information2 = c_information2
14504: --
14505: l_update boolean := false ;
14506: l_datetrack_mode varchar2(80) := hr_api.g_update;
14507: l_process_date date;
14508: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14509: --
14510: --UPD END
14511: l_current_pk_id number := null ;
14512:
14929: select distinct cpe.information1,
14930: cpe.information2,
14931: cpe.information3,
14932: cpe.table_route_id
14933: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14934: pqh_table_route tr
14935: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14936: and cpe.table_route_id = tr.table_route_id
14937: -- and tr.where_clause = l_BEN_ELIG_PY_BSS_PRTE_F
14945: c_information1 number) is
14946: select
14947: min(cpe.information2) min_esd,
14948: max(cpe.information3) min_eed
14949: from ben_copy_entity_results cpe
14950: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14951: and cpe.table_route_id = c_table_route_id
14952: and cpe.information1 = c_information1 ;
14953: --
14956: c_information2 date,
14957: c_information3 date ) is
14958: select
14959: cpe.*
14960: from ben_copy_entity_results cpe
14961: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14962: and cpe.table_route_id = c_table_route_id
14963: and cpe.information1 = c_information1
14964: and cpe.information2 = c_information2
15007: --
15008: l_update boolean := false ;
15009: l_datetrack_mode varchar2(80) := hr_api.g_update;
15010: l_process_date date;
15011: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15012: --
15013: --UPD END
15014: l_current_pk_id number := null ;
15015:
15444: select distinct cpe.information1,
15445: cpe.information2,
15446: cpe.information3,
15447: cpe.table_route_id
15448: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15449: pqh_table_route tr
15450: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15451: and cpe.table_route_id = tr.table_route_id
15452: -- and tr.where_clause = l_BEN_ELIG_PRBTN_PERD_PRTE_F
15460: c_information1 number) is
15461: select
15462: min(cpe.information2) min_esd,
15463: max(cpe.information3) min_eed
15464: from ben_copy_entity_results cpe
15465: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15466: and cpe.table_route_id = c_table_route_id
15467: and cpe.information1 = c_information1 ;
15468: --
15471: c_information2 date,
15472: c_information3 date ) is
15473: select
15474: cpe.*
15475: from ben_copy_entity_results cpe
15476: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15477: and cpe.table_route_id = c_table_route_id
15478: and cpe.information1 = c_information1
15479: and cpe.information2 = c_information2
15528: --
15529: l_update boolean := false ;
15530: l_datetrack_mode varchar2(80) := hr_api.g_update;
15531: l_process_date date;
15532: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15533: --
15534: --UPD END
15535: l_current_pk_id number := null ;
15536:
15949: select distinct cpe.information1,
15950: cpe.information2,
15951: cpe.information3,
15952: cpe.table_route_id
15953: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15954: pqh_table_route tr
15955: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15956: and cpe.table_route_id = tr.table_route_id
15957: -- and tr.where_clause = l_BEN_ELG_PRTT_ANTR_PL_PRTE_F
15965: c_information1 number) is
15966: select
15967: min(cpe.information2) min_esd,
15968: max(cpe.information3) min_eed
15969: from ben_copy_entity_results cpe
15970: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15971: and cpe.table_route_id = c_table_route_id
15972: and cpe.information1 = c_information1 ;
15973: --
15976: c_information2 date,
15977: c_information3 date ) is
15978: select
15979: cpe.*
15980: from ben_copy_entity_results cpe
15981: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15982: and cpe.table_route_id = c_table_route_id
15983: and cpe.information1 = c_information1
15984: and cpe.information2 = c_information2
16029: --
16030: l_update boolean := false ;
16031: l_datetrack_mode varchar2(80) := hr_api.g_update;
16032: l_process_date date;
16033: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16034: --
16035: --UPD END
16036: l_current_pk_id number := null ;
16037:
16441: select distinct cpe.information1,
16442: cpe.information2,
16443: cpe.information3,
16444: cpe.table_route_id
16445: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16446: pqh_table_route tr
16447: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16448: and cpe.table_route_id = tr.table_route_id
16449: -- and tr.where_clause = l_BEN_ELIG_PSTN_PRTE_F
16457: c_information1 number) is
16458: select
16459: min(cpe.information2) min_esd,
16460: max(cpe.information3) min_eed
16461: from ben_copy_entity_results cpe
16462: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16463: and cpe.table_route_id = c_table_route_id
16464: and cpe.information1 = c_information1 ;
16465: --
16468: c_information2 date,
16469: c_information3 date ) is
16470: select
16471: cpe.*
16472: from ben_copy_entity_results cpe
16473: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16474: and cpe.table_route_id = c_table_route_id
16475: and cpe.information1 = c_information1
16476: and cpe.information2 = c_information2
16519: --
16520: l_update boolean := false ;
16521: l_datetrack_mode varchar2(80) := hr_api.g_update;
16522: l_process_date date;
16523: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16524: --
16525: --UPD END
16526: l_current_pk_id number := null ;
16527:
16957: select distinct cpe.information1,
16958: cpe.information2,
16959: cpe.information3,
16960: cpe.table_route_id
16961: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
16962: pqh_table_route tr
16963: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16964: and cpe.table_route_id = tr.table_route_id
16965: -- and tr.where_clause = l_BEN_ELIG_PYRL_PRTE_F
16973: c_information1 number) is
16974: select
16975: min(cpe.information2) min_esd,
16976: max(cpe.information3) min_eed
16977: from ben_copy_entity_results cpe
16978: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16979: and cpe.table_route_id = c_table_route_id
16980: and cpe.information1 = c_information1 ;
16981: --
16984: c_information2 date,
16985: c_information3 date ) is
16986: select
16987: cpe.*
16988: from ben_copy_entity_results cpe
16989: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
16990: and cpe.table_route_id = c_table_route_id
16991: and cpe.information1 = c_information1
16992: and cpe.information2 = c_information2
17035: --
17036: l_update boolean := false ;
17037: l_datetrack_mode varchar2(80) := hr_api.g_update;
17038: l_process_date date;
17039: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17040: --
17041: --UPD END
17042: l_current_pk_id number := null ;
17043:
17470: select distinct cpe.information1,
17471: cpe.information2,
17472: cpe.information3,
17473: cpe.table_route_id
17474: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17475: pqh_table_route tr
17476: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17477: and cpe.table_route_id = tr.table_route_id
17478: -- and tr.where_clause = l_BEN_ELG_PSL_CD_R_RNG_PRTE_F
17486: c_information1 number) is
17487: select
17488: min(cpe.information2) min_esd,
17489: max(cpe.information3) min_eed
17490: from ben_copy_entity_results cpe
17491: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17492: and cpe.table_route_id = c_table_route_id
17493: and cpe.information1 = c_information1 ;
17494: --
17497: c_information2 date,
17498: c_information3 date ) is
17499: select
17500: cpe.*
17501: from ben_copy_entity_results cpe
17502: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17503: and cpe.table_route_id = c_table_route_id
17504: and cpe.information1 = c_information1
17505: and cpe.information2 = c_information2
17548: --
17549: l_update boolean := false ;
17550: l_datetrack_mode varchar2(80) := hr_api.g_update;
17551: l_process_date date;
17552: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
17553: --
17554: --UPD END
17555: l_current_pk_id number := null ;
17556:
17954: select distinct cpe.information1,
17955: cpe.information2,
17956: cpe.information3,
17957: cpe.table_route_id
17958: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
17959: pqh_table_route tr
17960: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17961: and cpe.table_route_id = tr.table_route_id
17962: -- and tr.where_clause = l_BEN_ELIG_QUAL_TITL_PRTE_F
17970: c_information1 number) is
17971: select
17972: min(cpe.information2) min_esd,
17973: max(cpe.information3) min_eed
17974: from ben_copy_entity_results cpe
17975: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17976: and cpe.table_route_id = c_table_route_id
17977: and cpe.information1 = c_information1 ;
17978: --
17981: c_information2 date,
17982: c_information3 date ) is
17983: select
17984: cpe.*
17985: from ben_copy_entity_results cpe
17986: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
17987: and cpe.table_route_id = c_table_route_id
17988: and cpe.information1 = c_information1
17989: and cpe.information2 = c_information2
18032: --
18033: l_update boolean := false ;
18034: l_datetrack_mode varchar2(80) := hr_api.g_update;
18035: l_process_date date;
18036: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18037: --
18038: --UPD END
18039: l_current_pk_id number := null ;
18040:
18471: select distinct cpe.information1,
18472: cpe.information2,
18473: cpe.information3,
18474: cpe.table_route_id
18475: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18476: pqh_table_route tr
18477: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18478: and cpe.table_route_id = tr.table_route_id
18479: -- and tr.where_clause = l_BEN_ELIG_SVC_AREA_PRTE_F
18487: c_information1 number) is
18488: select
18489: min(cpe.information2) min_esd,
18490: max(cpe.information3) min_eed
18491: from ben_copy_entity_results cpe
18492: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18493: and cpe.table_route_id = c_table_route_id
18494: and cpe.information1 = c_information1 ;
18495: --
18498: c_information2 date,
18499: c_information3 date ) is
18500: select
18501: cpe.*
18502: from ben_copy_entity_results cpe
18503: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18504: and cpe.table_route_id = c_table_route_id
18505: and cpe.information1 = c_information1
18506: and cpe.information2 = c_information2
18551: --
18552: l_update boolean := false ;
18553: l_datetrack_mode varchar2(80) := hr_api.g_update;
18554: l_process_date date;
18555: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
18556: --
18557: --UPD END
18558: l_current_pk_id number := null ;
18559:
18984: select distinct cpe.information1,
18985: cpe.information2,
18986: cpe.information3,
18987: cpe.table_route_id
18988: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
18989: pqh_table_route tr
18990: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
18991: and cpe.table_route_id = tr.table_route_id
18992: -- and tr.where_clause = l_BEN_ELIG_SCHEDD_HRS_PRTE_F
19000: c_information1 number) is
19001: select
19002: min(cpe.information2) min_esd,
19003: max(cpe.information3) min_eed
19004: from ben_copy_entity_results cpe
19005: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19006: and cpe.table_route_id = c_table_route_id
19007: and cpe.information1 = c_information1 ;
19008: --
19011: c_information2 date,
19012: c_information3 date ) is
19013: select
19014: cpe.*
19015: from ben_copy_entity_results cpe
19016: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19017: and cpe.table_route_id = c_table_route_id
19018: and cpe.information1 = c_information1
19019: and cpe.information2 = c_information2
19086: --
19087: l_update boolean := false ;
19088: l_datetrack_mode varchar2(80) := hr_api.g_update;
19089: l_process_date date;
19090: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19091: --
19092: --UPD END
19093: l_current_pk_id number := null ;
19094:
19531: select distinct cpe.information1,
19532: cpe.information2,
19533: cpe.information3,
19534: cpe.table_route_id
19535: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19536: pqh_table_route tr
19537: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19538: and cpe.table_route_id = tr.table_route_id
19539: -- and tr.where_clause = l_BEN_ELIG_SP_CLNG_PRG_PRTE_F
19547: c_information1 number) is
19548: select
19549: min(cpe.information2) min_esd,
19550: max(cpe.information3) min_eed
19551: from ben_copy_entity_results cpe
19552: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19553: and cpe.table_route_id = c_table_route_id
19554: and cpe.information1 = c_information1 ;
19555: --
19558: c_information2 date,
19559: c_information3 date ) is
19560: select
19561: cpe.*
19562: from ben_copy_entity_results cpe
19563: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19564: and cpe.table_route_id = c_table_route_id
19565: and cpe.information1 = c_information1
19566: and cpe.information2 = c_information2
19611: --
19612: l_update boolean := false ;
19613: l_datetrack_mode varchar2(80) := hr_api.g_update;
19614: l_process_date date;
19615: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
19616: --
19617: --UPD END
19618: l_current_pk_id number := null ;
19619:
20052: select distinct cpe.information1,
20053: cpe.information2,
20054: cpe.information3,
20055: cpe.table_route_id
20056: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20057: pqh_table_route tr
20058: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20059: and cpe.table_route_id = tr.table_route_id
20060: -- and tr.where_clause = l_BEN_ELIG_SUPPL_ROLE_PRTE_F
20068: c_information1 number) is
20069: select
20070: min(cpe.information2) min_esd,
20071: max(cpe.information3) min_eed
20072: from ben_copy_entity_results cpe
20073: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20074: and cpe.table_route_id = c_table_route_id
20075: and cpe.information1 = c_information1 ;
20076: --
20079: c_information2 date,
20080: c_information3 date ) is
20081: select
20082: cpe.*
20083: from ben_copy_entity_results cpe
20084: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20085: and cpe.table_route_id = c_table_route_id
20086: and cpe.information1 = c_information1
20087: and cpe.information2 = c_information2
20133: --
20134: l_update boolean := false ;
20135: l_datetrack_mode varchar2(80) := hr_api.g_update;
20136: l_process_date date;
20137: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20138: --
20139: --UPD END
20140: l_current_pk_id number := null ;
20141:
20576: select distinct cpe.information1,
20577: cpe.information2,
20578: cpe.information3,
20579: cpe.table_route_id
20580: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
20581: pqh_table_route tr
20582: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20583: and cpe.table_route_id = tr.table_route_id
20584: -- and tr.where_clause = l_BEN_ELIG_WK_LOC_PRTE_F
20592: c_information1 number) is
20593: select
20594: min(cpe.information2) min_esd,
20595: max(cpe.information3) min_eed
20596: from ben_copy_entity_results cpe
20597: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20598: and cpe.table_route_id = c_table_route_id
20599: and cpe.information1 = c_information1 ;
20600: --
20603: c_information2 date,
20604: c_information3 date ) is
20605: select
20606: cpe.*
20607: from ben_copy_entity_results cpe
20608: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
20609: and cpe.table_route_id = c_table_route_id
20610: and cpe.information1 = c_information1
20611: and cpe.information2 = c_information2
20654: --
20655: l_update boolean := false ;
20656: l_datetrack_mode varchar2(80) := hr_api.g_update;
20657: l_process_date date;
20658: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
20659: --
20660: --UPD END
20661: l_current_pk_id number := null ;
20662:
21093: select distinct cpe.information1,
21094: cpe.information2,
21095: cpe.information3,
21096: cpe.table_route_id
21097: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21098: pqh_table_route tr
21099: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21100: and cpe.table_route_id = tr.table_route_id
21101: -- and tr.where_clause = l_BEN_ELIG_DPNT_OTHR_PTIP_F
21109: c_information1 number) is
21110: select
21111: min(cpe.information2) min_esd,
21112: max(cpe.information3) min_eed
21113: from ben_copy_entity_results cpe
21114: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21115: and cpe.table_route_id = c_table_route_id
21116: and cpe.information1 = c_information1 ;
21117: --
21120: c_information2 date,
21121: c_information3 date ) is
21122: select
21123: cpe.*
21124: from ben_copy_entity_results cpe
21125: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21126: and cpe.table_route_id = c_table_route_id
21127: and cpe.information1 = c_information1
21128: and cpe.information2 = c_information2
21175: --
21176: l_update boolean := false ;
21177: l_datetrack_mode varchar2(80) := hr_api.g_update;
21178: l_process_date date;
21179: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21180: --
21181: --UPD END
21182: l_current_pk_id number := null ;
21183:
21598: select distinct cpe.information1,
21599: cpe.information2,
21600: cpe.information3,
21601: cpe.table_route_id
21602: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21603: pqh_table_route tr
21604: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21605: and cpe.table_route_id = tr.table_route_id
21606: -- and tr.where_clause = l_BEN_ELIG_DSBLTY_CTG_PRTE_F
21614: c_information1 number) is
21615: select
21616: min(cpe.information2) min_esd,
21617: max(cpe.information3) min_eed
21618: from ben_copy_entity_results cpe
21619: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21620: and cpe.table_route_id = c_table_route_id
21621: and cpe.information1 = c_information1 ;
21622: --
21625: c_information2 date,
21626: c_information3 date ) is
21627: select
21628: cpe.*
21629: from ben_copy_entity_results cpe
21630: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21631: and cpe.table_route_id = c_table_route_id
21632: and cpe.information1 = c_information1
21633: and cpe.information2 = c_information2
21683: --
21684: l_update boolean := false ;
21685: l_datetrack_mode varchar2(80) := hr_api.g_update;
21686: l_process_date date;
21687: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
21688: --
21689: --UPD END
21690: l_current_pk_id number := null ;
21691:
22102: select distinct cpe.information1,
22103: cpe.information2,
22104: cpe.information3,
22105: cpe.table_route_id
22106: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22107: pqh_table_route tr
22108: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22109: and cpe.table_route_id = tr.table_route_id
22110: -- and tr.where_clause = l_BEN_ELIG_DSBLTY_DGR_PRTE_F
22118: c_information1 number) is
22119: select
22120: min(cpe.information2) min_esd,
22121: max(cpe.information3) min_eed
22122: from ben_copy_entity_results cpe
22123: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22124: and cpe.table_route_id = c_table_route_id
22125: and cpe.information1 = c_information1 ;
22126: --
22129: c_information2 date,
22130: c_information3 date ) is
22131: select
22132: cpe.*
22133: from ben_copy_entity_results cpe
22134: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22135: and cpe.table_route_id = c_table_route_id
22136: and cpe.information1 = c_information1
22137: and cpe.information2 = c_information2
22189: --
22190: l_update boolean := false ;
22191: l_datetrack_mode varchar2(80) := hr_api.g_update;
22192: l_process_date date;
22193: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22194: --
22195: --UPD END
22196: l_current_pk_id number := null ;
22197:
22611: select distinct cpe.information1,
22612: cpe.information2,
22613: cpe.information3,
22614: cpe.table_route_id
22615: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
22616: pqh_table_route tr
22617: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22618: and cpe.table_route_id = tr.table_route_id
22619: -- and tr.where_clause = l_BEN_ELIG_DSBLTY_RSN_PRTE_F
22627: c_information1 number) is
22628: select
22629: min(cpe.information2) min_esd,
22630: max(cpe.information3) min_eed
22631: from ben_copy_entity_results cpe
22632: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22633: and cpe.table_route_id = c_table_route_id
22634: and cpe.information1 = c_information1 ;
22635: --
22638: c_information2 date,
22639: c_information3 date ) is
22640: select
22641: cpe.*
22642: from ben_copy_entity_results cpe
22643: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
22644: and cpe.table_route_id = c_table_route_id
22645: and cpe.information1 = c_information1
22646: and cpe.information2 = c_information2
22698: --
22699: l_update boolean := false ;
22700: l_datetrack_mode varchar2(80) := hr_api.g_update;
22701: l_process_date date;
22702: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
22703: --
22704: --UPD END
22705: l_current_pk_id number := null ;
22706:
23139: select distinct cpe.information1,
23140: cpe.information2,
23141: cpe.information3,
23142: cpe.table_route_id
23143: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23144: pqh_table_route tr
23145: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23146: and cpe.table_route_id = tr.table_route_id
23147: -- and tr.where_clause = l_BEN_ELIG_EE_STAT_PRTE_F
23155: c_information1 number) is
23156: select
23157: min(cpe.information2) min_esd,
23158: max(cpe.information3) min_eed
23159: from ben_copy_entity_results cpe
23160: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23161: and cpe.table_route_id = c_table_route_id
23162: and cpe.information1 = c_information1 ;
23163: --
23166: c_information2 date,
23167: c_information3 date ) is
23168: select
23169: cpe.*
23170: from ben_copy_entity_results cpe
23171: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23172: and cpe.table_route_id = c_table_route_id
23173: and cpe.information1 = c_information1
23174: and cpe.information2 = c_information2
23217: --
23218: l_update boolean := false ;
23219: l_datetrack_mode varchar2(80) := hr_api.g_update;
23220: l_process_date date;
23221: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23222: --
23223: --UPD END
23224: l_current_pk_id number := null ;
23225:
23653: select distinct cpe.information1,
23654: cpe.information2,
23655: cpe.information3,
23656: cpe.table_route_id
23657: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
23658: pqh_table_route tr
23659: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23660: and cpe.table_route_id = tr.table_route_id
23661: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_OIPL_F
23669: c_information1 number) is
23670: select
23671: min(cpe.information2) min_esd,
23672: max(cpe.information3) min_eed
23673: from ben_copy_entity_results cpe
23674: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23675: and cpe.table_route_id = c_table_route_id
23676: and cpe.information1 = c_information1 ;
23677: --
23680: c_information2 date,
23681: c_information3 date ) is
23682: select
23683: cpe.*
23684: from ben_copy_entity_results cpe
23685: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
23686: and cpe.table_route_id = c_table_route_id
23687: and cpe.information1 = c_information1
23688: and cpe.information2 = c_information2
23731: --
23732: l_update boolean := false ;
23733: l_datetrack_mode varchar2(80) := hr_api.g_update;
23734: l_process_date date;
23735: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
23736: --
23737: --UPD END
23738: l_current_pk_id number := null ;
23739:
24147: select distinct cpe.information1,
24148: cpe.information2,
24149: cpe.information3,
24150: cpe.table_route_id
24151: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24152: pqh_table_route tr
24153: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24154: and cpe.table_route_id = tr.table_route_id
24155: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PGM_F
24163: c_information1 number) is
24164: select
24165: min(cpe.information2) min_esd,
24166: max(cpe.information3) min_eed
24167: from ben_copy_entity_results cpe
24168: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24169: and cpe.table_route_id = c_table_route_id
24170: and cpe.information1 = c_information1 ;
24171: --
24174: c_information2 date,
24175: c_information3 date ) is
24176: select
24177: cpe.*
24178: from ben_copy_entity_results cpe
24179: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24180: and cpe.table_route_id = c_table_route_id
24181: and cpe.information1 = c_information1
24182: and cpe.information2 = c_information2
24225: --
24226: l_update boolean := false ;
24227: l_datetrack_mode varchar2(80) := hr_api.g_update;
24228: l_process_date date;
24229: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
24230: --
24231: --UPD END
24232: l_current_pk_id number := null ;
24233:
24641: select distinct cpe.information1,
24642: cpe.information2,
24643: cpe.information3,
24644: cpe.table_route_id
24645: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
24646: pqh_table_route tr
24647: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24648: and cpe.table_route_id = tr.table_route_id
24649: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PLIP_F
24657: c_information1 number) is
24658: select
24659: min(cpe.information2) min_esd,
24660: max(cpe.information3) min_eed
24661: from ben_copy_entity_results cpe
24662: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24663: and cpe.table_route_id = c_table_route_id
24664: and cpe.information1 = c_information1 ;
24665: --
24668: c_information2 date,
24669: c_information3 date ) is
24670: select
24671: cpe.*
24672: from ben_copy_entity_results cpe
24673: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
24674: and cpe.table_route_id = c_table_route_id
24675: and cpe.information1 = c_information1
24676: and cpe.information2 = c_information2
24719: --
24720: l_update boolean := false ;
24721: l_datetrack_mode varchar2(80) := hr_api.g_update;
24722: l_process_date date;
24723: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
24724: --
24725: --UPD END
24726: l_current_pk_id number := null ;
24727:
25134: select distinct cpe.information1,
25135: cpe.information2,
25136: cpe.information3,
25137: cpe.table_route_id
25138: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25139: pqh_table_route tr
25140: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25141: and cpe.table_route_id = tr.table_route_id
25142: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PL_F
25150: c_information1 number) is
25151: select
25152: min(cpe.information2) min_esd,
25153: max(cpe.information3) min_eed
25154: from ben_copy_entity_results cpe
25155: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25156: and cpe.table_route_id = c_table_route_id
25157: and cpe.information1 = c_information1 ;
25158: --
25161: c_information2 date,
25162: c_information3 date ) is
25163: select
25164: cpe.*
25165: from ben_copy_entity_results cpe
25166: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25167: and cpe.table_route_id = c_table_route_id
25168: and cpe.information1 = c_information1
25169: and cpe.information2 = c_information2
25212: --
25213: l_update boolean := false ;
25214: l_datetrack_mode varchar2(80) := hr_api.g_update;
25215: l_process_date date;
25216: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25217: --
25218: --UPD END
25219: l_current_pk_id number := null ;
25220:
25625: select distinct cpe.information1,
25626: cpe.information2,
25627: cpe.information3,
25628: cpe.table_route_id
25629: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
25630: pqh_table_route tr
25631: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25632: and cpe.table_route_id = tr.table_route_id
25633: -- and tr.where_clause = l_BEN_ELIG_ENRLD_ANTHR_PTIP_F
25641: c_information1 number) is
25642: select
25643: min(cpe.information2) min_esd,
25644: max(cpe.information3) min_eed
25645: from ben_copy_entity_results cpe
25646: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25647: and cpe.table_route_id = c_table_route_id
25648: and cpe.information1 = c_information1 ;
25649: --
25652: c_information2 date,
25653: c_information3 date ) is
25654: select
25655: cpe.*
25656: from ben_copy_entity_results cpe
25657: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
25658: and cpe.table_route_id = c_table_route_id
25659: and cpe.information1 = c_information1
25660: and cpe.information2 = c_information2
25703: --
25704: l_update boolean := false ;
25705: l_datetrack_mode varchar2(80) := hr_api.g_update;
25706: l_process_date date;
25707: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
25708: --
25709: --UPD END
25710: l_current_pk_id number := null ;
25711:
26125: select distinct cpe.information1,
26126: cpe.information2,
26127: cpe.information3,
26128: cpe.table_route_id
26129: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26130: pqh_table_route tr
26131: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26132: and cpe.table_route_id = tr.table_route_id
26133: -- and tr.where_clause = l_BEN_ELIG_FL_TM_PT_TM_PRTE_F
26141: c_information1 number) is
26142: select
26143: min(cpe.information2) min_esd,
26144: max(cpe.information3) min_eed
26145: from ben_copy_entity_results cpe
26146: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26147: and cpe.table_route_id = c_table_route_id
26148: and cpe.information1 = c_information1 ;
26149: --
26152: c_information2 date,
26153: c_information3 date ) is
26154: select
26155: cpe.*
26156: from ben_copy_entity_results cpe
26157: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26158: and cpe.table_route_id = c_table_route_id
26159: and cpe.information1 = c_information1
26160: and cpe.information2 = c_information2
26208: --
26209: l_update boolean := false ;
26210: l_datetrack_mode varchar2(80) := hr_api.g_update;
26211: l_process_date date;
26212: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26213: --
26214: --UPD END
26215: l_current_pk_id number := null ;
26216:
26627: select distinct cpe.information1,
26628: cpe.information2,
26629: cpe.information3,
26630: cpe.table_route_id
26631: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
26632: pqh_table_route tr
26633: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26634: and cpe.table_route_id = tr.table_route_id
26635: -- and tr.where_clause = l_BEN_ELIG_GRD_PRTE_F
26643: c_information1 number) is
26644: select
26645: min(cpe.information2) min_esd,
26646: max(cpe.information3) min_eed
26647: from ben_copy_entity_results cpe
26648: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26649: and cpe.table_route_id = c_table_route_id
26650: and cpe.information1 = c_information1 ;
26651: --
26654: c_information2 date,
26655: c_information3 date ) is
26656: select
26657: cpe.*
26658: from ben_copy_entity_results cpe
26659: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
26660: and cpe.table_route_id = c_table_route_id
26661: and cpe.information1 = c_information1
26662: and cpe.information2 = c_information2
26714: --
26715: l_update boolean := false ;
26716: l_datetrack_mode varchar2(80) := hr_api.g_update;
26717: l_process_date date;
26718: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
26719: --
26720: --UPD END
26721: l_current_pk_id number := null ;
26722:
27157: select distinct cpe.information1,
27158: cpe.information2,
27159: cpe.information3,
27160: cpe.table_route_id
27161: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
27162: pqh_table_route tr
27163: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
27164: and cpe.table_route_id = tr.table_route_id
27165: -- and tr.where_clause = l_BEN_ELIG_HRLY_SLRD_PRTE_F
27173: c_information1 number) is
27174: select
27175: min(cpe.information2) min_esd,
27176: max(cpe.information3) min_eed
27177: from ben_copy_entity_results cpe
27178: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
27179: and cpe.table_route_id = c_table_route_id
27180: and cpe.information1 = c_information1 ;
27181: --
27184: c_information2 date,
27185: c_information3 date ) is
27186: select
27187: cpe.*
27188: from ben_copy_entity_results cpe
27189: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
27190: and cpe.table_route_id = c_table_route_id
27191: and cpe.information1 = c_information1
27192: and cpe.information2 = c_information2
27240: --
27241: l_update boolean := false ;
27242: l_datetrack_mode varchar2(80) := hr_api.g_update;
27243: l_process_date date;
27244: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
27245: --
27246: --UPD END
27247: l_current_pk_id number := null ;
27248:
27659: select distinct cpe.information1,
27660: cpe.information2,
27661: cpe.information3,
27662: cpe.table_route_id
27663: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
27664: pqh_table_route tr
27665: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
27666: and cpe.table_route_id = tr.table_route_id
27667: -- and tr.where_clause = l_BEN_ELIG_PERF_RTNG_PRTE_F
27675: c_information1 number) is
27676: select
27677: min(cpe.information2) min_esd,
27678: max(cpe.information3) min_eed
27679: from ben_copy_entity_results cpe
27680: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
27681: and cpe.table_route_id = c_table_route_id
27682: and cpe.information1 = c_information1 ;
27683: --
27686: c_information2 date,
27687: c_information3 date ) is
27688: select
27689: cpe.*
27690: from ben_copy_entity_results cpe
27691: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
27692: and cpe.table_route_id = c_table_route_id
27693: and cpe.information1 = c_information1
27694: and cpe.information2 = c_information2
27743: --
27744: l_update boolean := false ;
27745: l_datetrack_mode varchar2(80) := hr_api.g_update;
27746: l_process_date date;
27747: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
27748: --
27749: --UPD END
27750: l_current_pk_id number := null ;
27751:
28163: select distinct cpe.information1,
28164: cpe.information2,
28165: cpe.information3,
28166: cpe.table_route_id
28167: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
28168: pqh_table_route tr
28169: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
28170: and cpe.table_route_id = tr.table_route_id
28171: -- and tr.where_clause = l_BEN_ELIG_QUA_IN_GR_PRTE_F
28179: c_information1 number) is
28180: select
28181: min(cpe.information2) min_esd,
28182: max(cpe.information3) min_eed
28183: from ben_copy_entity_results cpe
28184: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
28185: and cpe.table_route_id = c_table_route_id
28186: and cpe.information1 = c_information1 ;
28187: --
28190: c_information2 date,
28191: c_information3 date ) is
28192: select
28193: cpe.*
28194: from ben_copy_entity_results cpe
28195: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
28196: and cpe.table_route_id = c_table_route_id
28197: and cpe.information1 = c_information1
28198: and cpe.information2 = c_information2
28244: --
28245: l_update boolean := false ;
28246: l_datetrack_mode varchar2(80) := hr_api.g_update;
28247: l_process_date date;
28248: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
28249: --
28250: --UPD END
28251: l_current_pk_id number := null ;
28252:
28659: select distinct cpe.information1,
28660: cpe.information2,
28661: cpe.information3,
28662: cpe.table_route_id
28663: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
28664: pqh_table_route tr
28665: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
28666: and cpe.table_route_id = tr.table_route_id
28667: -- and tr.where_clause = l_BEN_ELIG_GNDR_PRTE_F
28675: c_information1 number) is
28676: select
28677: min(cpe.information2) min_esd,
28678: max(cpe.information3) min_eed
28679: from ben_copy_entity_results cpe
28680: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
28681: and cpe.table_route_id = c_table_route_id
28682: and cpe.information1 = c_information1 ;
28683: --
28686: c_information2 date,
28687: c_information3 date ) is
28688: select
28689: cpe.*
28690: from ben_copy_entity_results cpe
28691: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
28692: and cpe.table_route_id = c_table_route_id
28693: and cpe.information1 = c_information1
28694: and cpe.information2 = c_information2
28740: --
28741: l_update boolean := false ;
28742: l_datetrack_mode varchar2(80) := hr_api.g_update;
28743: l_process_date date;
28744: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
28745: --
28746: --UPD END
28747: l_current_pk_id number := null ;
28748:
29157: select distinct cpe.information1,
29158: cpe.information2,
29159: cpe.information3,
29160: cpe.table_route_id
29161: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
29162: pqh_table_route tr
29163: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
29164: and cpe.table_route_id = tr.table_route_id
29165: -- and tr.where_clause = l_BEN_ELIG_TBCO_USE_PRTE_F
29173: c_information1 number) is
29174: select
29175: min(cpe.information2) min_esd,
29176: max(cpe.information3) min_eed
29177: from ben_copy_entity_results cpe
29178: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
29179: and cpe.table_route_id = c_table_route_id
29180: and cpe.information1 = c_information1 ;
29181: --
29184: c_information2 date,
29185: c_information3 date ) is
29186: select
29187: cpe.*
29188: from ben_copy_entity_results cpe
29189: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
29190: and cpe.table_route_id = c_table_route_id
29191: and cpe.information1 = c_information1
29192: and cpe.information2 = c_information2
29235: --
29236: l_update boolean := false ;
29237: l_datetrack_mode varchar2(80) := hr_api.g_update;
29238: l_process_date date;
29239: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
29240: --
29241: --UPD END
29242: l_current_pk_id number := null ;
29243:
29648: select distinct cpe.information1,
29649: cpe.information2,
29650: cpe.information3,
29651: cpe.table_route_id
29652: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
29653: pqh_table_route tr
29654: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
29655: and cpe.table_route_id = tr.table_route_id
29656: -- and tr.where_clause = l_BEN_ELIG_DSBLD_PRTE_F
29664: c_information1 number) is
29665: select
29666: min(cpe.information2) min_esd,
29667: max(cpe.information3) min_eed
29668: from ben_copy_entity_results cpe
29669: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
29670: and cpe.table_route_id = c_table_route_id
29671: and cpe.information1 = c_information1 ;
29672: --
29675: c_information2 date,
29676: c_information3 date ) is
29677: select
29678: cpe.*
29679: from ben_copy_entity_results cpe
29680: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
29681: and cpe.table_route_id = c_table_route_id
29682: and cpe.information1 = c_information1
29683: and cpe.information2 = c_information2
29726: --
29727: l_update boolean := false ;
29728: l_datetrack_mode varchar2(80) := hr_api.g_update;
29729: l_process_date date;
29730: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
29731: --
29732: --UPD END
29733: l_current_pk_id number := null ;
29734:
30146: select distinct cpe.information1,
30147: cpe.information2,
30148: cpe.information3,
30149: cpe.table_route_id
30150: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
30151: pqh_table_route tr
30152: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
30153: and cpe.table_route_id = tr.table_route_id
30154: -- and tr.where_clause = l_BEN_ELIG_TTL_PRTT_PRTE_F
30161: c_information1 number) is
30162: select
30163: min(cpe.information2) min_esd,
30164: max(cpe.information3) min_eed
30165: from ben_copy_entity_results cpe
30166: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
30167: and cpe.table_route_id = c_table_route_id
30168: and cpe.information1 = c_information1 ;
30169: --
30172: c_information2 date,
30173: c_information3 date ) is
30174: select
30175: cpe.*
30176: from ben_copy_entity_results cpe
30177: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
30178: and cpe.table_route_id = c_table_route_id
30179: and cpe.information1 = c_information1
30180: and cpe.information2 = c_information2
30238: --
30239: l_update boolean := false ;
30240: l_datetrack_mode varchar2(80) := hr_api.g_update;
30241: l_process_date date;
30242: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
30243: --
30244: --UPD END
30245: l_current_pk_id number := null ;
30246:
30676: select distinct cpe.information1,
30677: cpe.information2,
30678: cpe.information3,
30679: cpe.table_route_id
30680: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
30681: pqh_table_route tr
30682: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
30683: and cpe.table_route_id = tr.table_route_id
30684: -- and tr.where_clause = l_BEN_ELIG_TTL_CVG_VOL_PRTE_F
30691: c_information1 number) is
30692: select
30693: min(cpe.information2) min_esd,
30694: max(cpe.information3) min_eed
30695: from ben_copy_entity_results cpe
30696: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
30697: and cpe.table_route_id = c_table_route_id
30698: and cpe.information1 = c_information1 ;
30699: --
30702: c_information2 date,
30703: c_information3 date ) is
30704: select
30705: cpe.*
30706: from ben_copy_entity_results cpe
30707: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
30708: and cpe.table_route_id = c_table_route_id
30709: and cpe.information1 = c_information1
30710: and cpe.information2 = c_information2
30768: --
30769: l_update boolean := false ;
30770: l_datetrack_mode varchar2(80) := hr_api.g_update;
30771: l_process_date date;
30772: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
30773: --
30774: --UPD END
30775: l_current_pk_id number := null ;
30776:
31200: select distinct cpe.information1,
31201: cpe.information2,
31202: cpe.information3,
31203: cpe.table_route_id
31204: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
31205: pqh_table_route tr
31206: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
31207: and cpe.table_route_id = tr.table_route_id
31208: -- and tr.where_clause = l_BEN_ELIG_HLTH_CVG_PRTE_F
31216: c_information1 number) is
31217: select
31218: min(cpe.information2) min_esd,
31219: max(cpe.information3) min_eed
31220: from ben_copy_entity_results cpe
31221: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
31222: and cpe.table_route_id = c_table_route_id
31223: and cpe.information1 = c_information1 ;
31224: --
31227: c_information2 date,
31228: c_information3 date ) is
31229: select
31230: cpe.*
31231: from ben_copy_entity_results cpe
31232: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
31233: and cpe.table_route_id = c_table_route_id
31234: and cpe.information1 = c_information1
31235: and cpe.information2 = c_information2
31281: --
31282: l_update boolean := false ;
31283: l_datetrack_mode varchar2(80) := hr_api.g_update;
31284: l_process_date date;
31285: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
31286: --
31287: --UPD END
31288: l_current_pk_id number := null ;
31289:
31697: select distinct cpe.information1,
31698: cpe.information2,
31699: cpe.information3,
31700: cpe.table_route_id
31701: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
31702: pqh_table_route tr
31703: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
31704: and cpe.table_route_id = tr.table_route_id
31705: -- and tr.where_clause = l_BEN_ELIG_ANTHR_PL_PRTE_F
31713: c_information1 number) is
31714: select
31715: min(cpe.information2) min_esd,
31716: max(cpe.information3) min_eed
31717: from ben_copy_entity_results cpe
31718: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
31719: and cpe.table_route_id = c_table_route_id
31720: and cpe.information1 = c_information1 ;
31721: --
31724: c_information2 date,
31725: c_information3 date ) is
31726: select
31727: cpe.*
31728: from ben_copy_entity_results cpe
31729: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
31730: and cpe.table_route_id = c_table_route_id
31731: and cpe.information1 = c_information1
31732: and cpe.information2 = c_information2
31775: --
31776: l_update boolean := false ;
31777: l_datetrack_mode varchar2(80) := hr_api.g_update;
31778: l_process_date date;
31779: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
31780: --
31781: --UPD END
31782: l_current_pk_id number := null ;
31783:
32400: IS
32401: SELECT DISTINCT cpe.information1, cpe.information2, cpe.information3,
32402: cpe.table_route_id, cpe.dml_operation,
32403: cpe.datetrack_mode, cpe.information263
32404: FROM ben_copy_entity_results cpe, pqh_table_route tr
32405: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
32406: AND cpe.table_route_id = tr.table_route_id
32407: AND tr.table_alias = cv_table_alias
32408: AND cpe.number_of_copies = 1
32417: --
32418: CURSOR c_ecv_min_max_dates (cv_table_route_id NUMBER, cv_information1 NUMBER)
32419: IS
32420: SELECT MIN (cpe.information2) min_esd, MAX (cpe.information3) min_eed
32421: FROM ben_copy_entity_results cpe
32422: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
32423: AND cpe.table_route_id = cv_table_route_id
32424: AND cpe.information1 = cv_information1;
32425: --
32430: cv_information3 DATE
32431: )
32432: IS
32433: SELECT cpe.*
32434: FROM ben_copy_entity_results cpe
32435: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
32436: AND cpe.table_route_id = cv_table_route_id
32437: AND cpe.information1 = cv_information1
32438: AND cpe.information2 = cv_information2
32457: --
32458: CURSOR c_unique_ecv_id (cv_table_alias VARCHAR2)
32459: IS
32460: SELECT DISTINCT cpe.information1, cpe.information5, cpe.information263
32461: FROM ben_copy_entity_results cpe, pqh_table_route tr
32462: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
32463: AND cpe.table_route_id = tr.table_route_id
32464: AND tr.table_alias = cv_table_alias
32465: AND cpe.number_of_copies = 1
32486: p_table_route_id NUMBER
32487: )
32488: IS
32489: SELECT information5
32490: FROM ben_copy_entity_results
32491: WHERE table_route_id = p_table_route_id
32492: AND copy_entity_txn_id = p_copy_entity_txn_id
32493: AND information1 = p_parent_pk_id;
32494: --
32495: l_dt_rec_found BOOLEAN;
32496: l_update BOOLEAN := FALSE;
32497: l_datetrack_mode VARCHAR2 (80) := hr_api.g_update;
32498: l_process_date DATE;
32499: l_dml_operation ben_copy_entity_results.dml_operation%TYPE;
32500: l_current_pk_id NUMBER := NULL;
32501: l_prev_pk_id NUMBER := NULL;
32502: l_first_rec BOOLEAN := TRUE;
32503: r_ecv c_ecv%ROWTYPE;