[Home] [Help]
132: cursor c_table_data_in_cer is
133: select tr.table_alias, tr.table_route_id
134: from pqh_table_route tr
135: where tr.table_route_id in(
136: select table_route_id from ben_copy_entity_results cpe
137: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
138: and cpe.number_of_copies = 1);
139: --
140: begin
218: --
219: procedure update_cer_with_target(c_pk_rec g_pk_rec_type, p_copy_entity_txn_id in number) is
220: begin
221: hr_utility.set_location('Inside update_cer_with_target ',233);
222: update ben_copy_entity_results
223: set information9 = c_pk_rec.copy_reuse_type||'-'||c_pk_rec.new_value
224: where copy_entity_txn_id = p_copy_entity_txn_id
225: and table_route_id = c_pk_rec.table_route_id
226: and information1 = c_pk_rec.old_value ;
1156: cpe.information112 NAME, -- 5250824, 5253679 (FF Case Sensitive)
1157: cpe.table_route_id,
1158: cpe.dml_operation, cpe.datetrack_mode
1159: --RKG Modfied for PDW FF Enhancements
1160: FROM ben_copy_entity_results cpe, pqh_table_route tr
1161: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
1162: AND cpe.table_route_id = tr.table_route_id
1163: AND tr.table_alias = l_table_alias
1164: AND cpe.number_of_copies = 1 --ADDITION
1174: --
1175: CURSOR c_fff_min_max_dates (c_table_route_id NUMBER, c_information1 NUMBER)
1176: IS
1177: SELECT MIN (cpe.information2) min_esd, MAX (cpe.information3) min_eed
1178: FROM ben_copy_entity_results cpe
1179: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
1180: AND cpe.table_route_id = c_table_route_id
1181: AND cpe.information1 = c_information1;
1182:
1188: c_information3 DATE
1189: )
1190: IS
1191: SELECT cpe.*
1192: FROM ben_copy_entity_results cpe
1193: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
1194: AND cpe.table_route_id = c_table_route_id
1195: AND cpe.information1 = c_information1
1196: AND cpe.information2 = c_information2
1230: --
1231: l_update BOOLEAN := FALSE;
1232: l_datetrack_mode VARCHAR2 (80) := hr_api.g_update;
1233: l_process_date DATE;
1234: l_dml_operation ben_copy_entity_results.dml_operation%TYPE;
1235: --
1236: --UPD END
1237: --TEMPIK
1238: l_dt_rec_found BOOLEAN;
1682: cpe.information2,
1683: cpe.information3,
1684: cpe.information170 name,
1685: cpe.table_route_id
1686: from ben_copy_entity_results cpe,
1687: pqh_table_route tr
1688: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1689: and cpe.table_route_id = tr.table_route_id
1690: -- and tr.where_clause = l_BEN_ACTN_TYP
1698: c_information1 number) is
1699: select
1700: min(cpe.information2) min_esd,
1701: max(cpe.information3) min_eed
1702: from ben_copy_entity_results cpe
1703: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1704: and cpe.table_route_id = c_table_route_id
1705: and cpe.information1 = c_information1 ;
1706: --
1709: c_information2 date,
1710: c_information3 date ) is
1711: select
1712: cpe.*
1713: from ben_copy_entity_results cpe
1714: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1715: and cpe.table_route_id = c_table_route_id
1716: and cpe.information1 = c_information1
1717: and rownum = 1 ;
1735: --
1736: l_update boolean := false ;
1737: l_datetrack_mode varchar2(80) := hr_api.g_update;
1738: l_process_date date;
1739: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
1740: --
1741: --UPD END
1742: l_prev_pk_id number := null ;
1743: l_first_rec boolean := true ;
1937: cpe.INFORMATION170 name,
1938: cpe.table_route_id,
1939: cpe.dml_operation,
1940: cpe.datetrack_mode
1941: from ben_copy_entity_results cpe,
1942: pqh_table_route tr
1943: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1944: and cpe.table_route_id = tr.table_route_id
1945: -- and tr.where_clause = l_BEN_CMBN_PLIP_F
1953: c_information1 number) is
1954: select
1955: min(cpe.information2) min_esd,
1956: max(cpe.information3) min_eed
1957: from ben_copy_entity_results cpe
1958: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1959: and cpe.table_route_id = c_table_route_id
1960: and cpe.information1 = c_information1 ;
1961: --
1964: c_information2 date,
1965: c_information3 date ) is
1966: select
1967: cpe.*
1968: from ben_copy_entity_results cpe
1969: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
1970: and cpe.table_route_id = c_table_route_id
1971: and cpe.information1 = c_information1
1972: and cpe.information2 = c_information2
2038: --
2039: l_update boolean := false ;
2040: l_datetrack_mode varchar2(80) := hr_api.g_update;
2041: l_process_date date;
2042: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2043: --
2044: --UPD END
2045: l_prev_pk_id number := null ;
2046: l_first_rec boolean := true ;
2457: cpe.information2,
2458: cpe.information3,
2459: cpe.INFORMATION170 name,
2460: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
2461: from ben_copy_entity_results cpe,
2462: pqh_table_route tr
2463: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2464: and cpe.table_route_id = tr.table_route_id
2465: -- and tr.where_clause = l_BEN_CMBN_PTIP_F
2473: c_information1 number) is
2474: select
2475: min(cpe.information2) min_esd,
2476: max(cpe.information3) min_eed
2477: from ben_copy_entity_results cpe
2478: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2479: and cpe.table_route_id = c_table_route_id
2480: and cpe.information1 = c_information1 ;
2481: --
2484: c_information2 date,
2485: c_information3 date ) is
2486: select
2487: cpe.*
2488: from ben_copy_entity_results cpe
2489: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2490: and cpe.table_route_id = c_table_route_id
2491: and cpe.information1 = c_information1
2492: and cpe.information2 = c_information2
2555: --
2556: l_update boolean := false ;
2557: l_datetrack_mode varchar2(80) := hr_api.g_update;
2558: l_process_date date;
2559: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
2560: --
2561: --UPD END
2562: l_prev_pk_id number := null ;
2563: l_first_rec boolean := true ;
2935: cpe.information3,
2936: cpe.INFORMATION170 name,
2937: cpe.table_route_id,
2938: cpe.dml_operation,cpe.datetrack_mode
2939: from ben_copy_entity_results cpe,
2940: pqh_table_route tr
2941: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2942: and cpe.table_route_id = tr.table_route_id
2943: -- and tr.where_clause = l_BEN_CMBN_PTIP_OPT_F
2951: c_information1 number) is
2952: select
2953: min(cpe.information2) min_esd,
2954: max(cpe.information3) min_eed
2955: from ben_copy_entity_results cpe
2956: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2957: and cpe.table_route_id = c_table_route_id
2958: and cpe.information1 = c_information1 ;
2959: --
2962: c_information2 date,
2963: c_information3 date ) is
2964: select
2965: cpe.*
2966: from ben_copy_entity_results cpe
2967: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2968: and cpe.table_route_id = c_table_route_id
2969: and cpe.information1 = c_information1
2970: and cpe.information2 = c_information2
3036: --
3037: l_update boolean := false ;
3038: l_datetrack_mode varchar2(80) := hr_api.g_update;
3039: l_process_date date;
3040: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3041: --
3042: --UPD END
3043: l_prev_pk_id number := null ;
3044: l_first_rec boolean := true ;
3444: cpe.information3,
3445: cpe.INFORMATION170 name,
3446: cpe.table_route_id,
3447: cpe.dml_operation,cpe.datetrack_mode
3448: from ben_copy_entity_results cpe,
3449: pqh_table_route tr
3450: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3451: and cpe.table_route_id = tr.table_route_id
3452: -- and tr.where_clause = l_BEN_BNFTS_BAL_F
3462: cpe.INFORMATION170 name,
3463: cpe.table_route_id,
3464: cpe.dml_operation,
3465: cpe.datetrack_mode
3466: from ben_copy_entity_results cpe
3467: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3468: and cpe.table_alias = l_table_alias
3469: and cpe.number_of_copies = 1 --ADDITION
3470: group by cpe.information1,
3481: c_information1 number) is
3482: select
3483: min(cpe.information2) min_esd,
3484: max(cpe.information3) min_eed
3485: from ben_copy_entity_results cpe
3486: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3487: and cpe.table_route_id = c_table_route_id
3488: and cpe.information1 = c_information1 ;
3489: --
3492: c_information2 date,
3493: c_information3 date ) is
3494: select
3495: cpe.*
3496: from ben_copy_entity_results cpe
3497: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3498: and cpe.table_route_id = c_table_route_id
3499: and cpe.information1 = c_information1
3500: and cpe.information2 = c_information2
3536: --
3537: l_update boolean := false ;
3538: l_datetrack_mode varchar2(80) := hr_api.g_update;
3539: l_process_date date;
3540: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3541: --
3542: --UPD END
3543: --
3544: l_current_pk_id number := null ;
3936: cpe.information3,
3937: cpe.INFORMATION170 name,
3938: cpe.table_route_id,
3939: cpe.dml_operation --UPD
3940: from ben_copy_entity_results cpe
3941: -- pqh_table_route tr UPD
3942: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3943: -- and cpe.table_route_id = tr.table_route_id UPD
3944: -- and tr.where_clause = l_BEN_COMP_LVL_FCTR
3953: c_information1 number) is
3954: select
3955: min(cpe.information2) min_esd,
3956: max(cpe.information3) min_eed
3957: from ben_copy_entity_results cpe
3958: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3959: and cpe.table_route_id = c_table_route_id
3960: and cpe.information1 = c_information1 ;
3961: --
3964: c_information2 date,
3965: c_information3 date ) is
3966: select
3967: cpe.*
3968: from ben_copy_entity_results cpe
3969: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3970: and cpe.table_route_id = c_table_route_id
3971: and cpe.information1 = c_information1
3972: and rownum = 1 ;
3988: --
3989: l_update boolean := false ;
3990: l_datetrack_mode varchar2(80) := hr_api.g_update;
3991: l_process_date date;
3992: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
3993: --
3994: --UPD END
3995: l_prev_pk_id number := null ;
3996: l_first_rec boolean := true ;
4372: cpe.information2,
4373: cpe.information3,
4374: cpe.INFORMATION170 name,
4375: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
4376: from ben_copy_entity_results cpe,
4377: pqh_table_route tr
4378: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4379: and cpe.table_route_id = tr.table_route_id
4380: -- and tr.where_clause = l_BEN_HRS_WKD_IN_PERD_FCTR
4388: c_information1 number) is
4389: select
4390: min(cpe.information2) min_esd,
4391: max(cpe.information3) min_eed
4392: from ben_copy_entity_results cpe
4393: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4394: and cpe.table_route_id = c_table_route_id
4395: and cpe.information1 = c_information1 ;
4396: --
4399: c_information2 date,
4400: c_information3 date ) is
4401: select
4402: cpe.*
4403: from ben_copy_entity_results cpe
4404: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4405: and cpe.table_route_id = c_table_route_id
4406: and cpe.information1 = c_information1
4407: and rownum = 1 ;
4424: --
4425: l_update boolean := false ;
4426: l_datetrack_mode varchar2(80) := hr_api.g_update;
4427: l_process_date date;
4428: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4429: --
4430: --UPD END
4431: l_prev_pk_id number := null ;
4432: l_first_rec boolean := true ;
4789: cpe.information2,
4790: cpe.information3,
4791: cpe.INFORMATION170 name,
4792: cpe.table_route_id,dml_operation,cpe.datetrack_mode
4793: from ben_copy_entity_results cpe,
4794: pqh_table_route tr
4795: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4796: and cpe.table_route_id = tr.table_route_id
4797: -- and tr.where_clause = l_BEN_AGE_FCTR
4805: c_information1 number) is
4806: select
4807: min(cpe.information2) min_esd,
4808: max(cpe.information3) min_eed
4809: from ben_copy_entity_results cpe
4810: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4811: and cpe.table_route_id = c_table_route_id
4812: and cpe.information1 = c_information1 ;
4813: --
4816: c_information2 date,
4817: c_information3 date ) is
4818: select
4819: cpe.*
4820: from ben_copy_entity_results cpe
4821: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
4822: and cpe.table_route_id = c_table_route_id
4823: and cpe.information1 = c_information1
4824: and rownum = 1 ;
4841: --
4842: l_update boolean := false ;
4843: l_datetrack_mode varchar2(80) := hr_api.g_update;
4844: l_process_date date;
4845: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
4846: --
4847: --UPD END
4848: l_prev_pk_id number := null ;
4849: l_first_rec boolean := true ;
5155: cpe.information2,
5156: cpe.information3,
5157: cpe.INFORMATION170 name,
5158: cpe.table_route_id,dml_operation,cpe.datetrack_mode
5159: from ben_copy_entity_results cpe,
5160: pqh_table_route tr
5161: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5162: and cpe.table_route_id = tr.table_route_id
5163: -- and tr.where_clause = l_BEN_LOS_FCTR
5171: c_information1 number) is
5172: select
5173: min(cpe.information2) min_esd,
5174: max(cpe.information3) min_eed
5175: from ben_copy_entity_results cpe
5176: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5177: and cpe.table_route_id = c_table_route_id
5178: and cpe.information1 = c_information1 ;
5179: --
5182: c_information2 date,
5183: c_information3 date ) is
5184: select
5185: cpe.*
5186: from ben_copy_entity_results cpe
5187: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5188: and cpe.table_route_id = c_table_route_id
5189: and cpe.information1 = c_information1
5190: and rownum = 1 ;
5207: --
5208: l_update boolean := false ;
5209: l_datetrack_mode varchar2(80) := hr_api.g_update;
5210: l_process_date date;
5211: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5212: --
5213: --UPD END
5214: l_prev_pk_id number := null ;
5215: l_first_rec boolean := true ;
5519: cpe.information2,
5520: cpe.information3,
5521: cpe.INFORMATION218 name,
5522: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
5523: from ben_copy_entity_results cpe,
5524: pqh_table_route tr
5525: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5526: and cpe.table_route_id = tr.table_route_id
5527: -- and tr.where_clause = l_BEN_PCT_FL_TM_FCTR
5535: c_information1 number) is
5536: select
5537: min(cpe.information2) min_esd,
5538: max(cpe.information3) min_eed
5539: from ben_copy_entity_results cpe
5540: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5541: and cpe.table_route_id = c_table_route_id
5542: and cpe.information1 = c_information1 ;
5543: --
5546: c_information2 date,
5547: c_information3 date ) is
5548: select
5549: cpe.*
5550: from ben_copy_entity_results cpe
5551: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5552: and cpe.table_route_id = c_table_route_id
5553: and cpe.information1 = c_information1
5554: and rownum = 1 ;
5571: --
5572: l_update boolean := false ;
5573: l_datetrack_mode varchar2(80) := hr_api.g_update;
5574: l_process_date date;
5575: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5576: --
5577: --UPD END
5578: l_prev_pk_id number := null ;
5579: l_first_rec boolean := true ;
5863: cpe.information2,
5864: cpe.information3,
5865: cpe.INFORMATION170 name,
5866: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
5867: from ben_copy_entity_results cpe,
5868: pqh_table_route tr
5869: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5870: and cpe.table_route_id = tr.table_route_id
5871: -- and tr.where_clause = l_BEN_CMBN_AGE_LOS_FCTR
5879: c_information1 number) is
5880: select
5881: min(cpe.information2) min_esd,
5882: max(cpe.information3) min_eed
5883: from ben_copy_entity_results cpe
5884: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5885: and cpe.table_route_id = c_table_route_id
5886: and cpe.information1 = c_information1 ;
5887: --
5890: c_information2 date,
5891: c_information3 date ) is
5892: select
5893: cpe.*
5894: from ben_copy_entity_results cpe
5895: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5896: and cpe.table_route_id = c_table_route_id
5897: and cpe.information1 = c_information1
5898: and rownum = 1 ;
5915: --
5916: l_update boolean := false ;
5917: l_datetrack_mode varchar2(80) := hr_api.g_update;
5918: l_process_date date;
5919: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
5920: --
5921: --UPD END
5922: l_prev_pk_id number := null ;
5923: l_first_rec boolean := true ;
6209: cpe.information2,
6210: cpe.information3,
6211: cpe.INFORMATION170 name,
6212: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
6213: from ben_copy_entity_results cpe,
6214: pqh_table_route tr
6215: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6216: and cpe.table_route_id = tr.table_route_id
6217: -- and tr.where_clause = l_BEN_PL_TYP_F
6225: c_information1 number) is
6226: select
6227: min(cpe.information2) min_esd,
6228: max(cpe.information3) min_eed
6229: from ben_copy_entity_results cpe
6230: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6231: and cpe.table_route_id = c_table_route_id
6232: and cpe.information1 = c_information1 ;
6233: --
6236: c_information2 date,
6237: c_information3 date ) is
6238: select
6239: cpe.*
6240: from ben_copy_entity_results cpe
6241: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6242: and cpe.table_route_id = c_table_route_id
6243: and cpe.information1 = c_information1
6244: and cpe.information2 = c_information2
6282: --
6283: l_update boolean := false ;
6284: l_datetrack_mode varchar2(80) := hr_api.g_update;
6285: l_process_date date;
6286: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6287: --
6288: --UPD END
6289: l_prev_pk_id number := null ;
6290: l_first_rec boolean := true ;
6685: cpe.information2,
6686: cpe.information3,
6687: cpe.INFORMATION170 name,
6688: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
6689: from ben_copy_entity_results cpe,
6690: pqh_table_route tr
6691: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6692: and cpe.table_route_id = tr.table_route_id
6693: -- and tr.where_clause = l_BEN_PGM_F
6701: c_information1 number) is
6702: select
6703: min(cpe.information2) min_esd,
6704: max(cpe.information3) min_eed
6705: from ben_copy_entity_results cpe
6706: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6707: and cpe.table_route_id = c_table_route_id
6708: and cpe.information1 = c_information1 ;
6709: --
6712: c_information2 date,
6713: c_information3 date ) is
6714: select
6715: cpe.*
6716: from ben_copy_entity_results cpe
6717: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6718: and cpe.table_route_id = c_table_route_id
6719: and cpe.information1 = c_information1
6720: and cpe.information2 = c_information2
6758: --
6759: l_update boolean := false ;
6760: l_datetrack_mode varchar2(80) := hr_api.g_update;
6761: l_process_date date;
6762: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
6763: --
6764: --UPD END
6765: l_prev_pk_id number := null ;
6766: l_first_rec boolean := true ;
7348: cpe.information2,
7349: cpe.information3,
7350: cpe.INFORMATION170 name,
7351: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
7352: from ben_copy_entity_results cpe,
7353: pqh_table_route tr
7354: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7355: and cpe.table_route_id = tr.table_route_id
7356: -- and tr.where_clause = l_BEN_REGN_F
7364: c_information1 number) is
7365: select
7366: min(cpe.information2) min_esd,
7367: max(cpe.information3) min_eed
7368: from ben_copy_entity_results cpe
7369: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7370: and cpe.table_route_id = c_table_route_id
7371: and cpe.information1 = c_information1 ;
7372: --
7375: c_information2 date,
7376: c_information3 date ) is
7377: select
7378: cpe.*
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: and cpe.information2 = c_information2
7421: --
7422: l_update boolean := false ;
7423: l_datetrack_mode varchar2(80) := hr_api.g_update;
7424: l_process_date date;
7425: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7426: --
7427: --UPD END
7428: l_prev_pk_id number := null ;
7429: l_first_rec boolean := true ;
7742: select distinct cpe.information1,
7743: cpe.information2,
7744: cpe.information3,
7745: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
7746: from ben_copy_entity_results cpe,
7747: pqh_table_route tr
7748: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7749: and cpe.table_route_id = tr.table_route_id
7750: -- and tr.where_clause = l_BEN_PSTL_ZIP_RNG_F
7758: c_information1 number) is
7759: select
7760: min(cpe.information2) min_esd,
7761: max(cpe.information3) min_eed
7762: from ben_copy_entity_results cpe
7763: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7764: and cpe.table_route_id = c_table_route_id
7765: and cpe.information1 = c_information1 ;
7766: --
7769: c_information2 date,
7770: c_information3 date ) is
7771: select
7772: cpe.*
7773: from ben_copy_entity_results cpe
7774: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7775: and cpe.table_route_id = c_table_route_id
7776: and cpe.information1 = c_information1
7777: and cpe.information2 = c_information2
7819: --
7820: l_update boolean := false ;
7821: l_datetrack_mode varchar2(80) := hr_api.g_update;
7822: l_process_date date;
7823: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
7824: --
7825: --UPD END
7826: l_prev_pk_id number := null ;
7827: l_first_rec boolean := true ;
8200: cpe.information2,
8201: cpe.information3,
8202: cpe.INFORMATION170 name,
8203: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
8204: from ben_copy_entity_results cpe,
8205: pqh_table_route tr
8206: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8207: and cpe.table_route_id = tr.table_route_id
8208: -- and tr.where_clause = l_BEN_RPTG_GRP
8216: c_information1 number) is
8217: select
8218: min(cpe.information2) min_esd,
8219: max(cpe.information3) min_eed
8220: from ben_copy_entity_results cpe
8221: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8222: and cpe.table_route_id = c_table_route_id
8223: and cpe.information1 = c_information1 ;
8224: --
8227: c_information2 date,
8228: c_information3 date ) is
8229: select
8230: cpe.*
8231: from ben_copy_entity_results cpe
8232: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8233: and cpe.table_route_id = c_table_route_id
8234: and cpe.information1 = c_information1
8235: and rownum = 1 ;
8253: --
8254: l_update boolean := false ;
8255: l_datetrack_mode varchar2(80) := hr_api.g_update;
8256: l_process_date date;
8257: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8258: --
8259: --UPD END
8260: l_prev_pk_id number := null ;
8261: l_first_rec boolean := true ;
8541: cpe.information2,
8542: cpe.information3,
8543: cpe.INFORMATION218 name,
8544: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
8545: from ben_copy_entity_results cpe,
8546: pqh_table_route tr
8547: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8548: and cpe.table_route_id = tr.table_route_id
8549: -- and tr.where_clause = l_BEN_RLTD_PER_CHG_CS_LER_F
8557: c_information1 number) is
8558: select
8559: min(cpe.information2) min_esd,
8560: max(cpe.information3) min_eed
8561: from ben_copy_entity_results cpe
8562: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8563: and cpe.table_route_id = c_table_route_id
8564: and cpe.information1 = c_information1 ;
8565: --
8568: c_information2 date,
8569: c_information3 date ) is
8570: select
8571: cpe.*
8572: from ben_copy_entity_results cpe
8573: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
8574: and cpe.table_route_id = c_table_route_id
8575: and cpe.information1 = c_information1
8576: and cpe.information2 = c_information2
8614: --
8615: l_update boolean := false ;
8616: l_datetrack_mode varchar2(80) := hr_api.g_update;
8617: l_process_date date;
8618: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
8619: --
8620: --UPD END
8621: l_prev_pk_id number := null ;
8622: l_first_rec boolean := true ;
8999: cpe.information2,
9000: cpe.information3,
9001: cpe.INFORMATION170 name,
9002: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
9003: from ben_copy_entity_results cpe,
9004: pqh_table_route tr
9005: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9006: and cpe.table_route_id = tr.table_route_id
9007: -- and tr.where_clause = l_BEN_OPT_F
9022: c_information1 number) is
9023: select
9024: min(cpe.information2) min_esd,
9025: max(cpe.information3) min_eed
9026: from ben_copy_entity_results cpe
9027: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9028: and cpe.table_route_id = c_table_route_id
9029: and cpe.information1 = c_information1 ;
9030: --
9033: c_information2 date,
9034: c_information3 date ) is
9035: select
9036: cpe.*
9037: from ben_copy_entity_results cpe
9038: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9039: and cpe.table_route_id = c_table_route_id
9040: and cpe.information1 = c_information1
9041: and cpe.information2 = c_information2
9092: --
9093: l_update boolean := false ;
9094: l_datetrack_mode varchar2(80) := hr_api.g_update;
9095: l_process_date date;
9096: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9097: --
9098: --UPD END
9099: l_prev_pk_id number := null ;
9100: l_first_rec boolean := true ;
9543: cpe.INFORMATION170 name,
9544: cpe.information16 typ_cd, -- Required for Absences
9545: cpe.information13 lf_evt_oper_cd, -- Required for Absences
9546: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
9547: from ben_copy_entity_results cpe,
9548: pqh_table_route tr
9549: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9550: and cpe.table_route_id = tr.table_route_id
9551: -- and tr.where_clause = l_BEN_LER_F
9560: c_information1 number) is
9561: select
9562: min(cpe.information2) min_esd,
9563: max(cpe.information3) min_eed
9564: from ben_copy_entity_results cpe
9565: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9566: and cpe.table_route_id = c_table_route_id
9567: and cpe.information1 = c_information1 ;
9568: --
9571: c_information2 date,
9572: c_information3 date ) is
9573: select
9574: cpe.*
9575: from ben_copy_entity_results cpe
9576: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
9577: and cpe.table_route_id = c_table_route_id
9578: and cpe.information1 = c_information1
9579: and cpe.information2 = c_information2
9679: --
9680: l_update boolean := false ;
9681: l_datetrack_mode varchar2(80) := hr_api.g_update;
9682: l_process_date date;
9683: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
9684: --
9685: --UPD END
9686: l_prev_pk_id number := null ;
9687: l_first_rec boolean := true ;
10187: select distinct cer.information1,
10188: cer.information2,
10189: cer.information3,
10190: cer.table_route_id,cer.dml_operation,cer.datetrack_mode
10191: from ben_copy_entity_results cer,
10192: pqh_table_route tr
10193: where cer.copy_entity_txn_id = p_copy_entity_txn_id
10194: and cer.table_route_id = tr.table_route_id
10195: and tr.table_alias = l_table_alias
10202: c_information1 number) is
10203: select
10204: min(cer.information2) min_esd,
10205: max(cer.information3) min_eed
10206: from ben_copy_entity_results cer
10207: where cer.copy_entity_txn_id = p_copy_entity_txn_id
10208: and cer.table_route_id = c_table_route_id
10209: and cer.information1 = c_information1 ;
10210: --
10213: c_information2 date,
10214: c_information3 date ) is
10215: select
10216: cer.*
10217: from ben_copy_entity_results cer
10218: where cer.copy_entity_txn_id = p_copy_entity_txn_id
10219: and cer.table_route_id = c_table_route_id
10220: and cer.information1 = c_information1
10221: and cer.information2 = c_information2
10265: --
10266: l_update boolean := false ;
10267: l_datetrack_mode varchar2(80) := hr_api.g_update;
10268: l_process_date date;
10269: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10270: --
10271: --UPD END
10272: l_prev_pk_id number := null ;
10273: l_first_rec boolean := true ;
10653: cpe.information2,
10654: cpe.information3,
10655: cpe.INFORMATION170 name,
10656: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
10657: from ben_copy_entity_results cpe,
10658: pqh_table_route tr
10659: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10660: and cpe.table_route_id = tr.table_route_id
10661: -- and tr.where_clause = l_BEN_ELIGY_PRFL_F
10670: c_information1 number) is
10671: select
10672: min(cpe.information2) min_esd,
10673: max(cpe.information3) min_eed
10674: from ben_copy_entity_results cpe
10675: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10676: and cpe.table_route_id = c_table_route_id
10677: and cpe.information1 = c_information1 ;
10678: --
10681: c_information2 date,
10682: c_information3 date ) is
10683: select
10684: cpe.*
10685: from ben_copy_entity_results cpe
10686: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
10687: and cpe.table_route_id = c_table_route_id
10688: and cpe.information1 = c_information1
10689: and cpe.information2 = c_information2
10727: --
10728: l_update boolean := false ;
10729: l_datetrack_mode varchar2(80) := hr_api.g_update;
10730: l_process_date date;
10731: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
10732: --
10733: --UPD END
10734: l_prev_pk_id number := null ;
10735: l_first_rec boolean := true ;
11240: cpe.information2,
11241: cpe.information3,
11242: cpe.INFORMATION170 name,
11243: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
11244: from ben_copy_entity_results cpe,
11245: pqh_table_route tr
11246: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11247: and cpe.table_route_id = tr.table_route_id
11248: -- and tr.where_clause = l_BEN_DPNT_CVG_ELIGY_PRFL_F
11256: c_information1 number) is
11257: select
11258: min(cpe.information2) min_esd,
11259: max(cpe.information3) min_eed
11260: from ben_copy_entity_results cpe
11261: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11262: and cpe.table_route_id = c_table_route_id
11263: and cpe.information1 = c_information1 ;
11264: --
11267: c_information2 date,
11268: c_information3 date ) is
11269: select
11270: cpe.*
11271: from ben_copy_entity_results cpe
11272: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11273: and cpe.table_route_id = c_table_route_id
11274: and cpe.information1 = c_information1
11275: and cpe.information2 = c_information2
11313: --
11314: l_update boolean := false ;
11315: l_datetrack_mode varchar2(80) := hr_api.g_update;
11316: l_process_date date;
11317: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11318: --
11319: --UPD END
11320: l_prev_pk_id number := null ;
11321: l_first_rec boolean := true ;
11719: cpe.information2,
11720: cpe.information3,
11721: cpe.INFORMATION170 name,
11722: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
11723: from ben_copy_entity_results cpe,
11724: pqh_table_route tr
11725: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11726: and cpe.table_route_id = tr.table_route_id
11727: -- and tr.where_clause = l_BEN_GD_OR_SVC_TYP
11736: c_information1 number) is
11737: select
11738: min(cpe.information2) min_esd,
11739: max(cpe.information3) min_eed
11740: from ben_copy_entity_results cpe
11741: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11742: and cpe.table_route_id = c_table_route_id
11743: and cpe.information1 = c_information1 ;
11744: --
11747: c_information2 date,
11748: c_information3 date ) is
11749: select
11750: cpe.*
11751: from ben_copy_entity_results cpe
11752: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11753: and cpe.table_route_id = c_table_route_id
11754: and cpe.information1 = c_information1
11755: and rownum = 1 ;
11772: --
11773: l_update boolean := false ;
11774: l_datetrack_mode varchar2(80) := hr_api.g_update;
11775: l_process_date date;
11776: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
11777: --
11778: --UPD END
11779: l_prev_pk_id number := null ;
11780: l_first_rec boolean := true ;
12048: cpe.information2,
12049: cpe.information3,
12050: cpe.INFORMATION170 name,
12051: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12052: from ben_copy_entity_results cpe,
12053: pqh_table_route tr
12054: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12055: and cpe.table_route_id = tr.table_route_id
12056: -- and tr.where_clause = l_BEN_BENFTS_GRP
12065: c_information1 number) is
12066: select
12067: min(cpe.information2) min_esd,
12068: max(cpe.information3) min_eed
12069: from ben_copy_entity_results cpe
12070: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12071: and cpe.table_route_id = c_table_route_id
12072: and cpe.information1 = c_information1 ;
12073: --
12076: c_information2 date,
12077: c_information3 date ) is
12078: select
12079: cpe.*
12080: from ben_copy_entity_results cpe
12081: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12082: and cpe.table_route_id = c_table_route_id
12083: and cpe.information1 = c_information1
12084: and rownum = 1 ;
12101: --
12102: l_update boolean := false ;
12103: l_datetrack_mode varchar2(80) := hr_api.g_update;
12104: l_process_date date;
12105: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12106: --
12107: --UPD END
12108: l_prev_pk_id number := null ;
12109: l_first_rec boolean := true ;
12378: cpe.information2,
12379: cpe.information3,
12380: cpe.INFORMATION218 name,
12381: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12382: from ben_copy_entity_results cpe,
12383: pqh_table_route tr
12384: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12385: and cpe.table_route_id = tr.table_route_id
12386: -- and tr.where_clause = l_BEN_PER_INFO_CHG_CS_LER_F
12394: c_information1 number) is
12395: select
12396: min(cpe.information2) min_esd,
12397: max(cpe.information3) min_eed
12398: from ben_copy_entity_results cpe
12399: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12400: and cpe.table_route_id = c_table_route_id
12401: and cpe.information1 = c_information1 ;
12402: --
12405: c_information2 date,
12406: c_information3 date ) is
12407: select
12408: cpe.*
12409: from ben_copy_entity_results cpe
12410: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12411: and cpe.table_route_id = c_table_route_id
12412: and cpe.information1 = c_information1
12413: and cpe.information2 = c_information2
12486: --
12487: l_update boolean := false ;
12488: l_datetrack_mode varchar2(80) := hr_api.g_update;
12489: l_process_date date;
12490: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
12491: --
12492: --UPD END
12493: l_prev_pk_id number := null ;
12494: l_first_rec boolean := true ;
12930: cpe.information2,
12931: cpe.information3,
12932: cpe.INFORMATION170 name,
12933: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
12934: from ben_copy_entity_results cpe,
12935: pqh_table_route tr
12936: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12937: and cpe.table_route_id = tr.table_route_id
12938: -- and tr.where_clause = l_BEN_CM_TYP_F
12946: c_information1 number) is
12947: select
12948: min(cpe.information2) min_esd,
12949: max(cpe.information3) min_eed
12950: from ben_copy_entity_results cpe
12951: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12952: and cpe.table_route_id = c_table_route_id
12953: and cpe.information1 = c_information1 ;
12954: --
12957: c_information2 date,
12958: c_information3 date ) is
12959: select
12960: cpe.*
12961: from ben_copy_entity_results cpe
12962: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
12963: and cpe.table_route_id = c_table_route_id
12964: and cpe.information1 = c_information1
12965: and cpe.information2 = c_information2
13003: --
13004: l_update boolean := false ;
13005: l_datetrack_mode varchar2(80) := hr_api.g_update;
13006: l_process_date date;
13007: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13008: --
13009: --UPD END
13010: l_prev_pk_id number := null ;
13011: l_first_rec boolean := true ;
13409: cpe.information2,
13410: cpe.information3,
13411: cpe.INFORMATION170 name,
13412: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
13413: from ben_copy_entity_results cpe,
13414: pqh_table_route tr
13415: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13416: and cpe.table_route_id = tr.table_route_id
13417: -- and tr.where_clause = l_BEN_PTD_LMT_F
13425: c_information1 number) is
13426: select
13427: min(cpe.information2) min_esd,
13428: max(cpe.information3) min_eed
13429: from ben_copy_entity_results cpe
13430: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13431: and cpe.table_route_id = c_table_route_id
13432: and cpe.information1 = c_information1 ;
13433: --
13436: c_information2 date,
13437: c_information3 date ) is
13438: select
13439: cpe.*
13440: from ben_copy_entity_results cpe
13441: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13442: and cpe.table_route_id = c_table_route_id
13443: and cpe.information1 = c_information1
13444: and cpe.information2 = c_information2
13482: --
13483: l_update boolean := false ;
13484: l_datetrack_mode varchar2(80) := hr_api.g_update;
13485: l_process_date date;
13486: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13487: --
13488: --UPD END
13489: l_prev_pk_id number := null ;
13490: l_first_rec boolean := true ;
13877: select distinct cpe.information1,
13878: cpe.information2,
13879: cpe.information3,
13880: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
13881: from ben_copy_entity_results cpe,
13882: pqh_table_route tr
13883: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13884: and cpe.table_route_id = tr.table_route_id
13885: -- and tr.where_clause = l_BEN_YR_PERD
13893: c_information1 number) is
13894: select
13895: min(cpe.information2) min_esd,
13896: max(cpe.information3) min_eed
13897: from ben_copy_entity_results cpe
13898: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13899: and cpe.table_route_id = c_table_route_id
13900: and cpe.information1 = c_information1 ;
13901: --
13904: c_information2 date,
13905: c_information3 date ) is
13906: select
13907: cpe.*
13908: from ben_copy_entity_results cpe
13909: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13910: and cpe.table_route_id = c_table_route_id
13911: and cpe.information1 = c_information1
13912: and rownum = 1 ;
13930: --
13931: l_update boolean := false ;
13932: l_datetrack_mode varchar2(80) := hr_api.g_update;
13933: l_process_date date;
13934: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
13935: --
13936: --UPD END
13937: l_prev_pk_id number := null ;
13938: l_first_rec boolean := true ;
14217: select distinct cpe.information1,
14218: cpe.information2,
14219: cpe.information3,
14220: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
14221: from ben_copy_entity_results cpe,
14222: pqh_table_route tr
14223: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14224: and cpe.table_route_id = tr.table_route_id
14225: -- and tr.where_clause = l_BEN_WTHN_YR_PERD
14233: c_information1 number) is
14234: select
14235: min(cpe.information2) min_esd,
14236: max(cpe.information3) min_eed
14237: from ben_copy_entity_results cpe
14238: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14239: and cpe.table_route_id = c_table_route_id
14240: and cpe.information1 = c_information1 ;
14241: --
14244: c_information2 date,
14245: c_information3 date ) is
14246: select
14247: cpe.*
14248: from ben_copy_entity_results cpe
14249: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14250: and cpe.table_route_id = c_table_route_id
14251: and cpe.information1 = c_information1
14252: and rownum = 1 ;
14275: --
14276: l_update boolean := false ;
14277: l_datetrack_mode varchar2(80) := hr_api.g_update;
14278: l_process_date date;
14279: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14280: --
14281: --UPD END
14282: l_prev_pk_id number := null ;
14283: l_first_rec boolean := true ;
14556: cpe.information3,
14557: cpe.INFORMATION170 name,
14558: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode,
14559: cpe.information8
14560: from ben_copy_entity_results cpe,
14561: pqh_table_route tr
14562: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14563: and cpe.table_route_id = tr.table_route_id
14564: -- and tr.where_clause = l_BEN_PL_F
14573: c_information1 number) is
14574: select
14575: min(cpe.information2) min_esd,
14576: max(cpe.information3) min_eed
14577: from ben_copy_entity_results cpe
14578: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14579: and cpe.table_route_id = c_table_route_id
14580: and cpe.information1 = c_information1 ;
14581: --
14584: c_information2 date,
14585: c_information3 date ) is
14586: select
14587: cpe.*
14588: from ben_copy_entity_results cpe
14589: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14590: and cpe.table_route_id = c_table_route_id
14591: and cpe.information1 = c_information1
14592: and cpe.information2 = c_information2
14648: --
14649: l_update boolean := false ;
14650: l_datetrack_mode varchar2(80) := hr_api.g_update;
14651: l_process_date date;
14652: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
14653: --
14654: --UPD END
14655: l_prev_pk_id number := null ;
14656: l_first_rec boolean := true ;
15508: cpe.information2,
15509: cpe.information3,
15510: cpe.information170 name,
15511: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
15512: from ben_copy_entity_results cpe,
15513: pqh_table_route tr
15514: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15515: and cpe.table_route_id = tr.table_route_id
15516: -- and tr.where_clause = l_BEN_SVC_AREA_F
15524: c_information1 number) is
15525: select
15526: min(cpe.information2) min_esd,
15527: max(cpe.information3) min_eed
15528: from ben_copy_entity_results cpe
15529: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15530: and cpe.table_route_id = c_table_route_id
15531: and cpe.information1 = c_information1 ;
15532: --
15535: c_information2 date,
15536: c_information3 date ) is
15537: select
15538: cpe.*
15539: from ben_copy_entity_results cpe
15540: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15541: and cpe.table_route_id = c_table_route_id
15542: and cpe.information1 = c_information1
15543: and cpe.information2 = c_information2
15581: --
15582: l_update boolean := false ;
15583: l_datetrack_mode varchar2(80) := hr_api.g_update;
15584: l_process_date date;
15585: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
15586: --
15587: --UPD END
15588: l_prev_pk_id number := null ;
15589: l_first_rec boolean := true ;
15960: select distinct cpe.information1,
15961: cpe.information2,
15962: cpe.information3,
15963: cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
15964: from ben_copy_entity_results cpe,
15965: pqh_table_route tr
15966: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15967: and cpe.table_route_id = tr.table_route_id
15968: -- and tr.where_clause = l_BEN_PL_TYP_OPT_TYP_F
15976: c_information1 number) is
15977: select
15978: min(cpe.information2) min_esd,
15979: max(cpe.information3) min_eed
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: --
15987: c_information2 date,
15988: c_information3 date ) is
15989: select
15990: cpe.*
15991: from ben_copy_entity_results cpe
15992: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15993: and cpe.table_route_id = c_table_route_id
15994: and cpe.information1 = c_information1
15995: and cpe.information2 = c_information2
16039: --
16040: l_update boolean := false ;
16041: l_datetrack_mode varchar2(80) := hr_api.g_update;
16042: l_process_date date;
16043: l_dml_operation ben_copy_entity_results.dml_operation%TYPE ;
16044: --
16045: --UPD END
16046: l_prev_pk_id number := null ;
16047: l_first_rec boolean := true ;
16550: IS
16551: SELECT DISTINCT cpe.information1, cpe.information2, cpe.information3,
16552: cpe.information170 NAME, cpe.table_route_id,
16553: cpe.dml_operation, cpe.datetrack_mode
16554: FROM ben_copy_entity_results cpe, pqh_table_route tr
16555: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
16556: AND cpe.table_route_id = tr.table_route_id
16557: AND tr.table_alias = l_table_alias
16558: AND cpe.number_of_copies = 1
16568: --
16569: CURSOR c_egl_min_max_dates (c_table_route_id NUMBER, c_information1 NUMBER)
16570: IS
16571: SELECT MIN (cpe.information2) min_esd, MAX (cpe.information3) min_eed
16572: FROM ben_copy_entity_results cpe
16573: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
16574: AND cpe.table_route_id = c_table_route_id
16575: AND cpe.information1 = c_information1;
16576: --
16579: c_information1 NUMBER
16580: )
16581: IS
16582: SELECT cpe.*
16583: FROM ben_copy_entity_results cpe
16584: WHERE cpe.copy_entity_txn_id = p_copy_entity_txn_id
16585: AND cpe.table_route_id = c_table_route_id
16586: AND cpe.information1 = c_information1
16587: AND ROWNUM = 1;
16608: l_current_pk_id NUMBER := NULL;
16609: l_update BOOLEAN := FALSE;
16610: l_datetrack_mode VARCHAR2 (80) := hr_api.g_update;
16611: l_process_date DATE;
16612: l_dml_operation ben_copy_entity_results.dml_operation%TYPE;
16613: l_prev_pk_id NUMBER := NULL;
16614: l_first_rec BOOLEAN := TRUE;
16615: r_egl c_egl%ROWTYPE;
16616: l_eligy_criteria_id NUMBER;