eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on BEN_COPY_ENTITY_RESULTS

Line 32: FROM BEN_COPY_ENTITY_RESULTS cer

28: from BEN_PL_TYP_F ptp
29: where ptp.pl_typ_id = p_pl_typ_id
30: -- and p_effective_date between effective_start_date and effective_end_date
31: and NOT EXISTS (SELECT information1
32: FROM BEN_COPY_ENTITY_RESULTS cer
33: WHERE copy_entity_txn_id = p_copy_entity_txn_id
34: AND table_alias = 'PTP'
35: AND information1 = p_pl_typ_id
36: AND dml_operation = 'REUSE');

Line 68: ben_copy_entity_results_api.create_copy_entity_results(

64: -- fetch c_ptp into l_ptp_rec;
65: for l_ptp_rec in c_ptp
66: loop
67: --IF C_PTP%FOUND THEN
68: ben_copy_entity_results_api.create_copy_entity_results(
69: p_copy_entity_result_id => l_copy_entity_result_id,
70: p_copy_entity_txn_id => p_copy_entity_txn_id,
71: p_result_type_cd => l_result_type_cd,
72: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 230: ben_copy_entity_results

226: information185,
227: information228, -- pl_typ_opt_typ_id
228: information258 -- oipl id
229: from
230: ben_copy_entity_results
231: where
232: copy_entity_txn_id = p_copy_entity_txn_id
233: and parent_entity_result_id = p_parent_entity_result_id
234: -- Inorder to populate mappings for rows outside effective date removing date track where clause

Line 240: l_name ben_copy_entity_results.information5%TYPE;

236: and information170 is null
237: for update of
238: information170, information185;
239:
240: l_name ben_copy_entity_results.information5%TYPE;
241: l_information185 ben_copy_entity_results.information170%TYPE;
242: l_parent_entity_result_id Number;
243: l_overview_name ben_copy_entity_results.information5%TYPE;
244: l_position Number;

Line 241: l_information185 ben_copy_entity_results.information170%TYPE;

237: for update of
238: information170, information185;
239:
240: l_name ben_copy_entity_results.information5%TYPE;
241: l_information185 ben_copy_entity_results.information170%TYPE;
242: l_parent_entity_result_id Number;
243: l_overview_name ben_copy_entity_results.information5%TYPE;
244: l_position Number;
245: l_business_group_id Number;

Line 243: l_overview_name ben_copy_entity_results.information5%TYPE;

239:
240: l_name ben_copy_entity_results.information5%TYPE;
241: l_information185 ben_copy_entity_results.information170%TYPE;
242: l_parent_entity_result_id Number;
243: l_overview_name ben_copy_entity_results.information5%TYPE;
244: l_position Number;
245: l_business_group_id Number;
246:
247: begin

Line 259: ben_copy_entity_results

255:
256: select
257: copy_entity_result_id into l_parent_entity_result_id
258: from
259: ben_copy_entity_results
260: where
261: table_alias = 'ELP'
262: and copy_entity_txn_id = p_copy_entity_txn_id
263: and information1 = p_elig_prfl_id

Line 306: ben_copy_entity_results

302: l_information185 := null;
303: end;
304:
305: update
306: ben_copy_entity_results
307: set
308: information170 = l_name,
309: information185 = l_information185
310: where current of c_crit;

Line 337: ben_copy_entity_results

333: l_information185 := null;
334: end;
335:
336: update
337: ben_copy_entity_results
338: set
339: information170 = l_name,
340: information185 = l_information185
341: where current of c_crit;

Line 379: ben_copy_entity_results

375: and oipl.business_group_id = pln.business_group_id
376: and p_effective_date between pln.effective_start_date and pln.effective_end_date;
377:
378: update
379: ben_copy_entity_results
380: set
381: information185 = l_information185
382: where current of c_crit;
383: -- if Criteria is any of tbe below listed, we should not copy mappings since mappings could be more than 240 characters ( UTF - 8)

Line 391: ben_copy_entity_results

387: or l_crit.table_alias='EEI' or l_crit.table_alias='EEP' or l_crit.table_alias='EET'
388: or l_crit.table_alias='EAI' or l_crit.table_alias='EEG' or l_crit.table_alias='ECQ' ) then
389:
390: update
391: ben_copy_entity_results
392: set
393: information170 = l_name
394: where current of c_crit;
395: end if;

Line 414: ben_copy_entity_results

410: is
411: select
412: information1 elig_prfl_id
413: from
414: ben_copy_entity_results
415: where
416: table_alias = 'ELP'
417: and copy_entity_txn_id = p_copy_entity_txn_id
418: and p_effective_date between information2 and information3 ;

Line 450: Ben_copy_entity_results ptp,

446: -- Update Information11 with extra mapping
447: Select
448: ptp.Information18 into l_opt_Typ_Cd
449: From
450: Ben_copy_entity_results ptp,
451: Ben_copy_entity_results pln
452: Where
453: ptp.copy_entity_txn_id = p_copy_entity_txn_id
454: And pln.copy_entity_txn_id = ptp.copy_entity_txn_id

Line 451: Ben_copy_entity_results pln

447: Select
448: ptp.Information18 into l_opt_Typ_Cd
449: From
450: Ben_copy_entity_results ptp,
451: Ben_copy_entity_results pln
452: Where
453: ptp.copy_entity_txn_id = p_copy_entity_txn_id
454: And pln.copy_entity_txn_id = ptp.copy_entity_txn_id
455: And p_effective_date between ptp.information2 and ptp.information3

Line 465: Ben_copy_entity_results pln

461: And ptp.status <>'DELETE'
462: And pln.copy_entity_result_id = p_copy_entity_result_id;
463:
464: Update
465: Ben_copy_entity_results pln
466: Set
467: Information11 = l_opt_Typ_Cd
468: Where
469: copy_entity_result_id = p_copy_entity_result_id;

Line 495: BEN_COPY_ENTITY_RESULTS cpy

491: cursor c_CPY(c_table_alias varchar2) is
492: select
493: cpy.*
494: from
495: BEN_COPY_ENTITY_RESULTS cpy
496: where
497: cpy.information4 = p_business_group_id
498: And cpy.copy_entity_txn_id = p_copy_entity_txn_id
499: And cpy.table_alias='CPY'

Line 521: Ben_copy_entity_results yrp

517: Information308 ,
518: Information12
519: into l_start_dt , l_end_dt , l_type
520: From
521: Ben_copy_entity_results yrp
522: Where
523: yrp.copy_entity_txn_id = p_copy_entity_txn_id
524: And yrp.table_alias='YRP'
525: And yrp.information1 = l_cpy_rec.Information240 ;

Line 529: Ben_copy_entity_results cpy

525: And yrp.information1 = l_cpy_rec.Information240 ;
526:
527: -- Update the Plan Year Periods Extra Mappings
528: Update
529: Ben_copy_entity_results cpy
530: set
531: information311 = l_start_dt,
532: information310 = l_end_dt,
533: information12 = l_type

Line 558: from ben_copy_entity_results EPA

554: EPA.information259 CTP,
555: EPA.information256 CPP,
556: EPA.information261 PLN,
557: EPA.information258 COP
558: from ben_copy_entity_results EPA
559: where copy_entity_txn_id = c_copy_entity_txn_id
560: and table_alias = 'EPA'
561: and c_effective_date between information2 and information3
562: for update of information20, information272;

Line 566: from ben_copy_entity_results CEP

562: for update of information20, information272;
563:
564: cursor c_cep (c_copy_entity_txn_id Number, c_effective_date Date, c_prtn_elig_id Number) is
565: select CEP.copy_entity_result_id
566: from ben_copy_entity_results CEP
567: where copy_entity_txn_id = c_copy_entity_txn_id
568: and table_alias = 'CEP'
569: and c_effective_date between information2 and information3
570: and information229 = c_prtn_elig_id

Line 606: ben_copy_entity_results

602: dbms_output.put_line('COMP_ID: '||l_prtn_elig_id);
603: dbms_output.put_line('COMP_ID: '||l_epa.copy_entity_result_id);*/
604:
605: update
606: ben_copy_entity_results
607: set
608: information20 = l_compobj_type,
609: information272 = l_compobj_id
610: Where Current Of c_epa ;

Line 617: ben_copy_entity_results

613: FOR l_cep in c_cep(p_copy_entity_txn_id, p_effective_date, l_prtn_elig_id)
614: LOOP
615:
616: update
617: ben_copy_entity_results
618: set
619: information20 = l_compobj_type,
620: information272 = l_compobj_id
621: where current of c_cep;

Line 644: ben_copy_entity_results

640: information266,
641: information186,
642: information2 effective_date
643: from
644: ben_copy_entity_results
645: where
646: table_alias = 'VPF'
647: and copy_entity_txn_id = p_copy_entity_txn_id
648: -- Inorder to populate mappings for rows outside effective date removing date track where clause

Line 654: l_elig_prfl_name ben_copy_entity_results.information170%type;

650: and (information186 is null or information266 is null)
651: for update of information266, information186;
652:
653: l_elig_prfl_id Number;
654: l_elig_prfl_name ben_copy_entity_results.information170%type;
655:
656: begin
657: hr_utility.set_location('Entering: '||l_proc,10);
658: -- dbms_output.put_line('Before Cursor');

Line 667: ben_copy_entity_Results elp,

663: select
664: elp.information1 , elp.information170
665: into l_elig_prfl_id, l_elig_prfl_name
666: from
667: ben_copy_entity_Results elp,
668: ben_copy_entity_results vep
669: where
670: elp.table_alias = 'ELP'
671: and elp.copy_entity_txn_id = p_copy_entity_Txn_id

Line 668: ben_copy_entity_results vep

664: elp.information1 , elp.information170
665: into l_elig_prfl_id, l_elig_prfl_name
666: from
667: ben_copy_entity_Results elp,
668: ben_copy_entity_results vep
669: where
670: elp.table_alias = 'ELP'
671: and elp.copy_entity_txn_id = p_copy_entity_Txn_id
672: and l_vpf.effective_date between elp.information2 and elp.information3

Line 681: ben_copy_entity_results

677: and vep.information262 = l_vpf.vrbl_rt_prfl_id;
678:
679:
680: update
681: ben_copy_entity_results
682: set
683: information266 = l_elig_prfl_id,
684: information186 = l_elig_prfl_name
685: where current of c_vpf;

Line 704: Ben_copy_entity_results len1

700: l_proc varchar2(72) := g_package||'.populate_extra_Mapping_LEN';
701: Begin
702: hr_utility.set_location('Entering: '||l_proc,10);
703: Update
704: Ben_copy_entity_results len1
705: Set
706: Information170 = (
707: Select
708: ler.information170 Name

Line 710: Ben_copy_entity_results len,

706: Information170 = (
707: Select
708: ler.information170 Name
709: From
710: Ben_copy_entity_results len,
711: Ben_copy_entity_results ler
712: Where
713: len.copy_entity_result_id = p_copy_entity_result_id
714: And ler.copy_entity_txn_id = len.copy_entity_txn_id

Line 711: Ben_copy_entity_results ler

707: Select
708: ler.information170 Name
709: From
710: Ben_copy_entity_results len,
711: Ben_copy_entity_results ler
712: Where
713: len.copy_entity_result_id = p_copy_entity_result_id
714: And ler.copy_entity_txn_id = len.copy_entity_txn_id
715: And p_effective_date between len.information2 and len.information3

Line 738: Ben_copy_entity_results len,

734: Cursor C_LEN is
735: Select
736: len.copy_entity_result_id
737: From
738: Ben_copy_entity_results len,
739: Ben_copy_entity_results pet
740: Where
741: len.copy_entity_txn_id = p_copy_entity_txn_id
742: And len.copy_entity_txn_id = pet.copy_entity_txn_id

Line 739: Ben_copy_entity_results pet

735: Select
736: len.copy_entity_result_id
737: From
738: Ben_copy_entity_results len,
739: Ben_copy_entity_results pet
740: Where
741: len.copy_entity_txn_id = p_copy_entity_txn_id
742: And len.copy_entity_txn_id = pet.copy_entity_txn_id
743: And p_effective_date between len.information2 and len.information3

Line 833: Ben_copy_entity_results LPR

829: LPR.information256,
830: LPR.information257 ler_id,
831: LPR.information2 effective_date
832: From
833: Ben_copy_entity_results LPR
834: Where
835: LPR.copy_entity_txn_id = p_copy_entity_txn_id
836: And LPR.copy_entity_txn_id = LPR.copy_entity_txn_id
837: --And p_effective_date between LPR.information2 and LPR.information3

Line 854: ben_copy_entity_results

850: information16 ENRT_CD,
851: information101 NEW_ENRT_CD,
852: information102 CUR_ENRT_CD
853: from
854: ben_copy_entity_results
855: where
856: copy_entity_txn_id = p_copy_entity_txn_id
857: and table_alias = 'LPR1'
858: and information16 is not null

Line 863: l_new_enrt_cd ben_copy_entity_results.information101%type;

859: -- and p_effective_date between information2 and information3
860: and dml_operation <> 'DELETE'
861: for update of information101, information102;
862:
863: l_new_enrt_cd ben_copy_entity_results.information101%type;
864: l_cur_enrt_cd ben_copy_entity_results.information102%type;
865:
866: plipCopyEntityResultId ben_copy_entity_results.copy_entity_result_id%type;
867: l_pl_id ben_pl_f.pl_id%type ;

Line 864: l_cur_enrt_cd ben_copy_entity_results.information102%type;

860: and dml_operation <> 'DELETE'
861: for update of information101, information102;
862:
863: l_new_enrt_cd ben_copy_entity_results.information101%type;
864: l_cur_enrt_cd ben_copy_entity_results.information102%type;
865:
866: plipCopyEntityResultId ben_copy_entity_results.copy_entity_result_id%type;
867: l_pl_id ben_pl_f.pl_id%type ;
868:

Line 866: plipCopyEntityResultId ben_copy_entity_results.copy_entity_result_id%type;

862:
863: l_new_enrt_cd ben_copy_entity_results.information101%type;
864: l_cur_enrt_cd ben_copy_entity_results.information102%type;
865:
866: plipCopyEntityResultId ben_copy_entity_results.copy_entity_result_id%type;
867: l_pl_id ben_pl_f.pl_id%type ;
868:
869: l_new_dflt_enrt_cd varchar2(15);
870: l_old_dflt_enrt_cd varchar2(15);

Line 888: ben_copy_entity_results

884: -- Populate information162 with level copy result id
885: Select
886: copy_entity_result_id ,information261 into plipCopyEntityResultId,l_pl_id
887: From
888: ben_copy_entity_results
889: where
890: copy_entity_txn_id = p_copy_entity_txn_id
891: and l_LPR.effective_date between information2 and information3
892: and table_alias='CPP'

Line 905: Ben_copy_entity_results lop,

901: --
902: Select
903: cop.copy_entity_result_id into l_default_object_id
904: From
905: Ben_copy_entity_results lop,
906: Ben_copy_entity_results cop
907: Where
908: lop.copy_entity_txn_id = p_copy_entity_txn_id
909: And lop.copy_entity_txn_id = cop.copy_entity_txn_id

Line 906: Ben_copy_entity_results cop

902: Select
903: cop.copy_entity_result_id into l_default_object_id
904: From
905: Ben_copy_entity_results lop,
906: Ben_copy_entity_results cop
907: Where
908: lop.copy_entity_txn_id = p_copy_entity_txn_id
909: And lop.copy_entity_txn_id = cop.copy_entity_txn_id
910: And l_LPR.effective_date between lop.information2 and lop.information3

Line 942: Ben_copy_entity_results LPR1

938: --dbms_output.put_line(' here '|| l_new_dflt_enrt_cd);
939:
940: -- Update the New and Old Default enrollment Logic by parsing the combined dflt enrt logic
941: Update
942: Ben_copy_entity_results LPR1
943: Set
944: LPR1.information103 =l_new_dflt_enrt_cd,
945: LPR1.information104 =l_old_dflt_enrt_cd,
946: LPR1.information160 = l_default_object_id,

Line 958: ben_copy_entity_results

954: loop
955: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(l_lpr1.ENRT_CD);
956: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(l_lpr1.ENRT_CD);
957: update
958: ben_copy_entity_results
959: set
960: information101 = l_new_enrt_cd,
961: information102 = l_cur_enrt_cd
962: where current of c_lpr1;

Line 985: Ben_copy_entity_results LOP

981: LOP.information16,
982: LOP.information258,
983: LOP.information2 effective_date
984: From
985: Ben_copy_entity_results LOP
986: Where
987: LOP.copy_entity_txn_id = p_copy_entity_txn_id
988: And LOP.copy_entity_txn_id = LOP.copy_entity_txn_id
989: --And p_effective_date between LOP.information2 and LOP.information3

Line 1014: ben_copy_entity_results

1010:
1011: Select
1012: copy_entity_result_id into oiplCopyEntityResultId
1013: From
1014: ben_copy_entity_results
1015: where
1016: copy_entity_txn_id = p_copy_entity_txn_id
1017: and l_LOP.effective_date between information2 and information3
1018: and table_alias='COP'

Line 1024: Ben_copy_entity_results LOP1

1020: --
1021:
1022: -- Update the New and Old Default enrollment Logic by parsing the combined dflt enrt logic
1023: Update
1024: Ben_copy_entity_results LOP1
1025: Set
1026: LOP1.information103 =l_new_dflt_enrt_cd,
1027: LOP1.information104 =l_old_dflt_enrt_cd,
1028: -- If OIpl has the defaults flag set then make this the default object for this level

Line 1055: Ben_copy_entity_results COP

1051: Select
1052: COP.copy_entity_result_id,
1053: COP.information26
1054: From
1055: Ben_copy_entity_results COP
1056: Where
1057: COP.copy_entity_txn_id = p_copy_entity_txn_id
1058: And COP.copy_entity_txn_id = COP.copy_entity_txn_id
1059: --And p_effective_date between COP.information2 and COP.information3

Line 1079: Ben_copy_entity_results COP1

1075: l_old_dflt_enrt_cd := get_Dflt_Old_Enrt_cd(l_COP.information26);
1076:
1077: -- Update the New and Old Default enrollment Logic by parsing the combined dflt enrt logic
1078: Update
1079: Ben_copy_entity_results COP1
1080: Set
1081: COP1.information106 =l_new_dflt_enrt_cd,
1082: COP1.information107 =l_old_dflt_enrt_cd,
1083: -- If OIpl has the defaults flag set then make this the default object for this level

Line 1105: FROM ben_copy_entity_results cpp

1101: l_proc varchar2(72) := g_package||'.copy_pln_record_pcp';
1102:
1103: CURSOR cur_new_ctp IS
1104: SELECT cpp.information261 pl_id
1105: FROM ben_copy_entity_results cpp
1106: WHERE cpp.copy_entity_txn_id = p_copy_entity_txn_id
1107: AND cpp.table_alias = TABLE_ALIAS_CPP
1108: AND cpp.information261 NOT IN
1109: (SELECT pln.information1

Line 1110: FROM ben_copy_entity_results pln

1106: WHERE cpp.copy_entity_txn_id = p_copy_entity_txn_id
1107: AND cpp.table_alias = TABLE_ALIAS_CPP
1108: AND cpp.information261 NOT IN
1109: (SELECT pln.information1
1110: FROM ben_copy_entity_results pln
1111: WHERE pln.copy_entity_txn_id = p_copy_entity_txn_id
1112: AND pln.table_alias = TABLE_ALIAS_PLN );
1113: BEGIN
1114: hr_utility.set_location('Entering: '||l_proc,10);

Line 1151: DELETE FROM ben_copy_entity_results

1147: p_copy_entity_txn_id
1148: ,l_business_group_id
1149: ,l_effective_date
1150: );
1151: DELETE FROM ben_copy_entity_results
1152: WHERE copy_entity_txn_id = p_copy_entity_txn_id
1153: AND copy_entity_result_id NOT IN
1154: ( SELECT MIN(copy_entity_result_id)
1155: FROM ben_copy_entity_results

Line 1155: FROM ben_copy_entity_results

1151: DELETE FROM ben_copy_entity_results
1152: WHERE copy_entity_txn_id = p_copy_entity_txn_id
1153: AND copy_entity_result_id NOT IN
1154: ( SELECT MIN(copy_entity_result_id)
1155: FROM ben_copy_entity_results
1156: WHERE copy_entity_txn_id = p_copy_entity_txn_id
1157: AND NVL(dml_operation, DML_OPER_REUSE) = DML_OPER_REUSE
1158: AND ( result_type_cd='DISPLAY' or
1159: l_effective_date between information2 and information3

Line 1275: FROM ben_copy_entity_results

1271:
1272: hr_utility.set_location('Deleting CPP rows: '||p_id,20);
1273:
1274: DELETE
1275: FROM ben_copy_entity_results
1276: WHERE copy_entity_txn_id = p_copy_entity_txn_id
1277: AND information256 = p_id
1278: AND table_alias in (TABLE_ALIAS_LPR);
1279: END IF;

Line 1299: FROM BEN_COPY_ENTITY_RESULTS cer

1295: from BEN_PL_F pln
1296: where pln.pl_id = p_pl_id
1297: and p_effective_date between effective_start_date and effective_end_date
1298: and NOT EXISTS (SELECT information1
1299: FROM BEN_COPY_ENTITY_RESULTS cer
1300: WHERE copy_entity_txn_id = p_copy_entity_txn_id
1301: AND table_alias = 'PLN'
1302: AND information1 = p_pl_id
1303: AND dml_operation = 'REUSE');

Line 1328: ben_copy_entity_results_api.create_copy_entity_results(

1324:
1325: open c_pln;
1326: fetch c_pln into l_pln_rec;
1327: IF c_pln%FOUND THEN
1328: ben_copy_entity_results_api.create_copy_entity_results(
1329: p_copy_entity_result_id => l_copy_entity_result_id,
1330: p_copy_entity_txn_id => p_copy_entity_txn_id,
1331: p_result_type_cd => l_result_type_cd,
1332: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,

Line 1673: from ben_copy_entity_results

1669: ,c_copy_entity_txn_id NUMBER
1670: )
1671: IS
1672: Select information170 name
1673: from ben_copy_entity_results
1674: where table_alias='ELP'
1675: and copy_entity_txn_id=c_copy_entity_txn_id
1676: and information1=c_eligy_prfl_id;
1677: l_rec csr_txn_prfl_name%ROWTYPE;

Line 1701: From ben_copy_entity_results cep

1697: Cursor csr_txn_prfl(c_prtn_elig_id NUMBER) IS
1698: Select cep.information263 ELIGY_PRFL_ID,
1699: cep.information12 mndtry_flag ,
1700: cep.copy_entity_result_id
1701: From ben_copy_entity_results cep
1702: Where cep.copy_entity_txn_id=p_copy_entity_txn_id
1703: and cep.table_alias='CEP'
1704: and cep.INFORMATION229=c_prtn_elig_id;
1705:

Line 1710: From ben_copy_entity_results

1706: --
1707: Cursor csr_chk_elp_exist (c_eligy_prfl_id NUMBER
1708: ,c_copy_txn_id NUMBER ) IS
1709: Select 1
1710: From ben_copy_entity_results
1711: Where table_alias='ELP'
1712: and copy_entity_txn_id=c_copy_txn_id
1713: and information1=c_eligy_prfl_id;
1714:

Line 1788: from ben_copy_entity_results

1784: where business_group_id =l_business_group_id
1785: and l_effective_date between effective_start_date and effective_end_date
1786: and stat_cd='A' and BNFT_CAGR_PRTN_CD='BNFT'
1787: and eligy_prfl_id not in (select information1
1788: from ben_copy_entity_results
1789: where copy_entity_txn_id=p_copy_entity_txn_id
1790: and table_alias='ELP'
1791: );
1792:

Line 1837: From ben_copy_entity_results xyz

1833:
1834: Cursor csr_txn_prfl IS
1835: Select xyz.information262 VRBL_RT_PRFL_ID,
1836: xyz.copy_entity_result_id
1837: From ben_copy_entity_results xyz
1838: Where xyz.copy_entity_txn_id=p_copy_entity_txn_id
1839: and xyz.table_alias=decode(p_vrbl_usg_code,'CVG','BVR1','AVR')
1840: and decode(table_alias,'BVR1',information238,information253)=p_vrbl_cvg_rt_id
1841: and dml_operation <> 'DELETE';

Line 1848: from ben_copy_entity_results abr

1844: select dml_operation,
1845: datetrack_mode,
1846: information32 uses_vrbl_rt_flag,
1847: future_data_exists
1848: from ben_copy_entity_results abr
1849: where abr.copy_entity_txn_id = p_copy_entity_txn_id
1850: and table_alias = 'ABR'
1851: and information1 = p_vrbl_cvg_rt_id
1852: and l_effective_date between information2 and information3

Line 1897: ben_copy_entity_results

1893: Begin
1894: select
1895: information83 into l_RT_ELIG_PRFL_FLAG
1896: from
1897: ben_copy_entity_results
1898: where
1899: table_alias = 'VPF'
1900: and copy_entity_txn_id = p_copy_entity_txn_id
1901: and information1 = l_rec.VRBL_RT_PRFL_ID

Line 1910: ben_copy_entity_results vpf,

1906: select
1907: elp.information1,
1908: elp.information170 into l_elig_prfl_id, l_elp_name
1909: from
1910: ben_copy_entity_results vpf,
1911: ben_copy_entity_results vep,
1912: ben_copy_entity_results elp
1913: where
1914: vpf.copy_entity_txn_id = elp.copy_entity_txn_id

Line 1911: ben_copy_entity_results vep,

1907: elp.information1,
1908: elp.information170 into l_elig_prfl_id, l_elp_name
1909: from
1910: ben_copy_entity_results vpf,
1911: ben_copy_entity_results vep,
1912: ben_copy_entity_results elp
1913: where
1914: vpf.copy_entity_txn_id = elp.copy_entity_txn_id
1915: and vpf.copy_entity_txn_id = vep.copy_entity_txn_id

Line 1912: ben_copy_entity_results elp

1908: elp.information170 into l_elig_prfl_id, l_elp_name
1909: from
1910: ben_copy_entity_results vpf,
1911: ben_copy_entity_results vep,
1912: ben_copy_entity_results elp
1913: where
1914: vpf.copy_entity_txn_id = elp.copy_entity_txn_id
1915: and vpf.copy_entity_txn_id = vep.copy_entity_txn_id
1916: and vpf.copy_entity_txn_id = p_copy_entity_txn_id

Line 1928: ben_copy_entity_results

1924: and l_effective_date between vep.information2 and vep.information3
1925: and l_effective_date between elp.information2 and elp.information3;
1926:
1927: update
1928: ben_copy_entity_results
1929: set
1930: INFORMATION266 = l_elig_prfl_id,
1931: INFORMATION186 = l_elp_name
1932: where

Line 1967: Update ben_copy_entity_results

1963: elsif (l_rate_row.dml_operation = 'REUSE' or l_rate_row.dml_operation = 'UPDATE') and l_rate_row.uses_vrbl_rt_flag <> l_rate_vpf_exits then
1964: -- there can be two cases when future date may or may not exists
1965: -- if the future data exists we need to set datetrack mode to correction because we are not asking the question on page.
1966: if l_rate_row.future_data_exists = 'Y' then
1967: Update ben_copy_entity_results
1968: set INFORMATION32=l_rate_vpf_exits,
1969: dml_operation = 'UPDATE',
1970: datetrack_mode = 'CORRECTION'
1971: where copy_entity_txn_id=p_copy_entity_txn_id

Line 1976: Update ben_copy_entity_results

1972: and table_alias='ABR'
1973: and information1= p_vrbl_cvg_rt_id
1974: and l_effective_date between information2 and information3;
1975: else
1976: Update ben_copy_entity_results
1977: set INFORMATION32=l_rate_vpf_exits,
1978: dml_operation = 'UPDATE',
1979: datetrack_mode = 'UPDATE'
1980: where copy_entity_txn_id=p_copy_entity_txn_id

Line 1988: Update ben_copy_entity_results

1984: end if;
1985: else
1986: -- for create cases we just need to set the uses variable rate flag.
1987:
1988: Update ben_copy_entity_results
1989: set INFORMATION32=l_rate_vpf_exits
1990: where copy_entity_txn_id=p_copy_entity_txn_id and table_alias='ABR'
1991: and information1= p_vrbl_cvg_rt_id
1992: and l_effective_date between information2 and information3;

Line 2023: ben_copy_entity_results

2019: information186,
2020: information266,
2021: copy_entity_result_id
2022: from
2023: ben_copy_entity_results
2024: where
2025: table_alias = 'VPF'
2026: and copy_entity_txn_id = p_copy_entity_txn_id
2027: and information1 = p_vrbl_rt_prfl_id

Line 2036: l_elpro_name ben_copy_entity_results.information170%type;

2032: for update of information266, information186;
2033:
2034: l_ovn_number Number;
2035: l_elig_prfl_id Number;
2036: l_elpro_name ben_copy_entity_results.information170%type;
2037: copy_extra_mappings varchar2(1);
2038:
2039: begin
2040: hr_utility.set_location('Entering: '||l_proc,10);

Line 2066: ben_copy_entity_results vpf,

2062: select
2063: elp.information1,
2064: elp.information170 into l_elig_prfl_id, l_elpro_name
2065: from
2066: ben_copy_entity_results vpf,
2067: ben_copy_entity_results vep,
2068: ben_copy_entity_results elp
2069: where
2070: vpf.copy_entity_txn_id = elp.copy_entity_txn_id

Line 2067: ben_copy_entity_results vep,

2063: elp.information1,
2064: elp.information170 into l_elig_prfl_id, l_elpro_name
2065: from
2066: ben_copy_entity_results vpf,
2067: ben_copy_entity_results vep,
2068: ben_copy_entity_results elp
2069: where
2070: vpf.copy_entity_txn_id = elp.copy_entity_txn_id
2071: and vpf.copy_entity_txn_id = vep.copy_entity_txn_id

Line 2068: ben_copy_entity_results elp

2064: elp.information170 into l_elig_prfl_id, l_elpro_name
2065: from
2066: ben_copy_entity_results vpf,
2067: ben_copy_entity_results vep,
2068: ben_copy_entity_results elp
2069: where
2070: vpf.copy_entity_txn_id = elp.copy_entity_txn_id
2071: and vpf.copy_entity_txn_id = vep.copy_entity_txn_id
2072: and vpf.copy_entity_txn_id = p_copy_entity_txn_id

Line 2087: ben_copy_entity_results

2083: and p_effective_date between elp.information2 and elp.information3
2084: and elp.dml_operation <> 'DELETE' and elp.status='VALID';
2085:
2086: update
2087: ben_copy_entity_results
2088: set
2089: information266 = l_elig_prfl_id,
2090: information186 = l_elpro_name
2091: where

Line 2125: from ben_copy_entity_results

2121: ,c_copy_entity_txn_id NUMBER
2122: )
2123: IS
2124: Select information170 name
2125: from ben_copy_entity_results
2126: where table_alias='DCE'
2127: and copy_entity_txn_id=c_copy_entity_txn_id
2128: and information1=c_eligy_prfl_id;
2129: l_rec csr_txn_prfl_name%ROWTYPE;

Line 2150: From ben_copy_entity_results ade

2146: Cursor csr_txn_prfl(c_dpnt_dsgn_object_id number ,c_dpnt_dsgn_level_code varchar2) IS
2147: Select ade.information255 ELIGY_PRFL_ID,
2148: ade.information11 mndtry_flag ,
2149: ade.copy_entity_result_id
2150: From ben_copy_entity_results ade
2151: Where ade.copy_entity_txn_id=p_copy_entity_txn_id
2152: and ade.table_alias='ADE'
2153: and decode(c_dpnt_dsgn_level_code,'PL',ade.information261,'PTIP',ade.information259)=c_dpnt_dsgn_object_id;
2154: --

Line 2158: From ben_copy_entity_results

2154: --
2155: Cursor csr_chk_dce_exist (c_eligy_prfl_id NUMBER
2156: ,c_copy_txn_id NUMBER ) IS
2157: Select 1
2158: From ben_copy_entity_results
2159: Where table_alias='DCE'
2160: and copy_entity_txn_id=c_copy_txn_id
2161: and information1=c_eligy_prfl_id;
2162:

Line 2225: From ben_copy_entity_results

2221: l_proc varchar2(72) := g_package||'.create_dep_elig_crtr_results';
2222:
2223: Cursor csr_dep_elig_criteria (c_parent_id NUMBER) IS
2224: Select table_alias,INFORMATION261, INFORMATION246
2225: From ben_copy_entity_results
2226: Where parent_entity_result_id=c_parent_id;
2227:
2228: l_ovn_number NUMBER;
2229: l_effective_date DATE;

Line 2281: From BEN_COPY_ENTITY_RESULTS

2277: RETURN boolean IS
2278:
2279: CURSOR csr_rec_exists IS
2280: Select 'Y'
2281: From BEN_COPY_ENTITY_RESULTS
2282: Where copy_entity_txn_id=p_copy_entity_txn_id
2283: AND table_alias=p_table_alias
2284: AND information1=p_information1
2285: AND result_type_cd='DISPLAY';

Line 2306: From ben_copy_entity_results

2302: l_proc varchar2(72) := g_package||'.create_elig_crtr_results';
2303: --
2304: Cursor csr_elig_epg_criteria (c_parent_id NUMBER) IS
2305: Select table_alias,INFORMATION261,copy_entity_result_id,information5,information11
2306: From ben_copy_entity_results
2307: Where parent_entity_result_id=c_parent_id and TABLE_ALIAS='EPG';
2308: --
2309: Cursor csr_elig_criteria (c_parent_id NUMBER) IS
2310: Select table_alias, INFORMATION222,INFORMATION223,INFORMATION224,INFORMATION233,INFORMATION241,INFORMATION243,INFORMATION245,

Line 2312: From ben_copy_entity_results

2308: --
2309: Cursor csr_elig_criteria (c_parent_id NUMBER) IS
2310: Select table_alias, INFORMATION222,INFORMATION223,INFORMATION224,INFORMATION233,INFORMATION241,INFORMATION243,INFORMATION245,
2311: INFORMATION246,INFORMATION254,INFORMATION272
2312: From ben_copy_entity_results
2313: Where parent_entity_result_id=c_parent_id
2314: and TABLE_ALIAS in ('EAP','ECL','ECP','EHW','ELS','EPF','EBN','EPZ','ESA','ECV');
2315: --
2316:

Line 2359: UPDATE ben_copy_entity_results set INFORMATION5= l_ppl_flx where copy_entity_result_id=l_rec.copy_entity_result_id;

2355: );
2356: IF l_rec.information11='Y' THEN
2357: l_ppl_flx :=l_ppl_flx|| fnd_message.get_string('BEN','BEN_93294_PDC_EXCLUDE_FLAG');
2358: END IF;
2359: UPDATE ben_copy_entity_results set INFORMATION5= l_ppl_flx where copy_entity_result_id=l_rec.copy_entity_result_id;
2360: END IF;
2361: END LOOP;
2362: /*
2363: * For 6 drvd Factors + service Area + Bnft Group + Postal Codes we have to copy them to stage if they are used

Line 2470: l_overview_name ben_copy_entity_results.information5%type;

2466: RETURN VARCHAR2 is
2467:
2468: l_effective_date Date;
2469: l_business_group_id Number;
2470: l_overview_name ben_copy_entity_results.information5%type;
2471:
2472: begin
2473: get_txn_details(p_copy_entity_txn_id,l_business_group_id,l_effective_date);
2474: l_overview_name := null;

Line 2480: ben_copy_entity_results

2476: begin
2477: select -- if PGM is copied to staging, return the Pgm Name in Staging
2478: information170 into l_overview_name
2479: from
2480: ben_copy_entity_results
2481: where
2482: copy_entity_txn_id = p_copy_entity_txn_id
2483: and information1 = p_pgm_id
2484: and table_alias = 'PGM'

Line 2506: ben_copy_entity_results pgm,

2502: begin
2503: select -- if Pgm and Plan Type is copied to staging, then return their names in staging
2504: pgm.information170 || ' - ' || ptp.information170 into l_overview_name
2505: from
2506: ben_copy_entity_results pgm,
2507: ben_copy_entity_results ctp,
2508: ben_copy_entity_results ptp
2509: where
2510: ctp.copy_entity_txn_id = p_copy_entity_txn_id

Line 2507: ben_copy_entity_results ctp,

2503: select -- if Pgm and Plan Type is copied to staging, then return their names in staging
2504: pgm.information170 || ' - ' || ptp.information170 into l_overview_name
2505: from
2506: ben_copy_entity_results pgm,
2507: ben_copy_entity_results ctp,
2508: ben_copy_entity_results ptp
2509: where
2510: ctp.copy_entity_txn_id = p_copy_entity_txn_id
2511: and ctp.table_alias = 'CTP'

Line 2508: ben_copy_entity_results ptp

2504: pgm.information170 || ' - ' || ptp.information170 into l_overview_name
2505: from
2506: ben_copy_entity_results pgm,
2507: ben_copy_entity_results ctp,
2508: ben_copy_entity_results ptp
2509: where
2510: ctp.copy_entity_txn_id = p_copy_entity_txn_id
2511: and ctp.table_alias = 'CTP'
2512: and ptp.copy_entity_txn_id = ctp.copy_entity_txn_id

Line 2573: Ben_copy_entity_results cpe

2569: l_proc varchar2(72) := g_package||'.create_Plan_Yr_Periods';
2570: --
2571: Cursor C_PLN(p_copy_entity_txn_id number ,p_effective_date Date) is
2572: Select cpe.* from
2573: Ben_copy_entity_results cpe
2574: Where
2575: cpe.copy_Entity_txn_Id = p_copy_entity_txn_id
2576: And cpe.Table_Alias='PLN'
2577: --And cpe.Dml_operation='INSERT'

Line 2583: Ben_copy_entity_results cpe

2579: And p_effective_date between cpe.Information2 And cpe.Information3 ;
2580:
2581: Cursor C_CPY(p_copy_entity_txn_id number) is
2582: Select cpe.* from
2583: Ben_copy_entity_results cpe
2584: Where
2585: cpe.copy_Entity_txn_Id = p_copy_entity_txn_id
2586: And cpe.Table_Alias='CPY'
2587: --And cpe.Dml_operation='INSERT'

Line 2609: delete from ben_copy_entity_results

2605: l_RESULT_TYPE_CD :='DISPLAY' ;
2606:
2607: /*
2608: -- Delete any existing CPY rows for PLN
2609: delete from ben_copy_entity_results
2610: where
2611: copy_entity_txn_id =p_copy_entity_txn_id
2612: And table_Alias='CPY'
2613: And information261 is not null ;

Line 2623: Update Ben_Copy_Entity_Results

2619: --
2620: -- Sync the Sequence Numbers of PGM Yr Period so that they are in order
2621: -- --dbms_output.put_line(' pgm sequence '||l_pgm_Yr_Perd_Sequence_Number || ' for '||l_CPY.information311 ||'-'||l_CPY.information310);
2622:
2623: Update Ben_Copy_Entity_Results
2624:
2625: Set Information262 = l_pgm_Yr_Perd_Sequence_Number
2626:
2627: Where Current Of c_CPY ;

Line 2691: Ben_copy_entity_results cpy

2687: 8 into l_pkId
2688:
2689: From
2690:
2691: Ben_copy_entity_results cpy
2692:
2693: Where
2694: cpy.copy_entity_txn_id = p_copy_entity_txn_id
2695: And p_effective_date between cpy.information2 and cpy.information3

Line 2710: ben_copy_entity_results_api.create_copy_entity_results

2706:
2707: Select BEN_POPL_YR_PERD_S.nextval into l_pkId
2708: From dual ;
2709: -- dbms_output.put_line(' yrp id '||to_char(l_CPY.information1));
2710: ben_copy_entity_results_api.create_copy_entity_results
2711: (
2712: p_copy_entity_result_id => l_copy_entity_result_id,
2713: p_copy_entity_txn_id => p_copy_entity_txn_id,
2714: p_result_type_cd => l_result_type_cd,

Line 2926: Ben_copy_entity_Results cpe,

2922: -- All PSL in Txn which have a LPL attached to it
2923: Cursor c_CPE is
2924: Select cpe.*
2925: from
2926: Ben_copy_entity_Results cpe,
2927: Ben_copy_entity_Results lpl
2928: Where
2929: cpe.copy_entity_txn_id=0
2930: And cpe.Table_Alias ='PSL'

Line 2927: Ben_copy_entity_Results lpl

2923: Cursor c_CPE is
2924: Select cpe.*
2925: from
2926: Ben_copy_entity_Results cpe,
2927: Ben_copy_entity_Results lpl
2928: Where
2929: cpe.copy_entity_txn_id=0
2930: And cpe.Table_Alias ='PSL'
2931: And lpl.copy_entity_txn_id=p_copy_entity_txn_id

Line 2975: ben_copy_entity_results_api.create_copy_entity_results(

2971: /** Manual Change - Replace this with Plan Copy
2972: Copy PSL Row to Staging
2973: */
2974:
2975: ben_copy_entity_results_api.create_copy_entity_results(
2976: p_copy_entity_result_id => l_copy_entity_result_id,
2977: p_copy_entity_txn_id => p_copy_entity_txn_id,
2978: p_result_type_cd => 'DISPLAY',
2979: p_number_of_copies => 1,

Line 3061: ben_copy_entity_results_api.create_copy_entity_results

3057: l_name := chkName(p_effective_date,l_CPE.Information15,p_business_group_id);
3058:
3059:
3060: -- Create the Life event Triggers in Staging
3061: ben_copy_entity_results_api.create_copy_entity_results
3062: (
3063: p_copy_entity_result_id => l_copy_entity_result_id,
3064: p_copy_entity_txn_id => p_copy_entity_txn_id,
3065: p_result_type_cd => l_result_type_cd,

Line 3096: Update Ben_Copy_Entity_Results

3092:
3093:
3094: -- Update the Foreign Key to PSL Table in LPL with appropriate Foreign Key Id
3095:
3096: Update Ben_Copy_Entity_Results
3097: Set
3098: INFORMATION258 = l_per_info_chg_cs_ler_id -- PER_INFO_CHG_CS_LER_ID
3099: Where
3100: Copy_Entity_Txn_Id= p_copy_entity_txn_id

Line 3597: from ben_copy_entity_results cpe,

3593:
3594: yrp.business_group_id = p_business_group_id
3595: and not exists (
3596: select null
3597: from ben_copy_entity_results cpe,
3598: pqh_table_route trt
3599: where copy_entity_txn_id = p_copy_entity_txn_id
3600: and trt.table_route_id = cpe.table_route_id
3601:

Line 3721: ben_copy_entity_results

3717: cursor c_cpp_sequence is
3718: select
3719: information263 ordr_num
3720: from
3721: ben_copy_entity_results
3722: where
3723: copy_entity_txn_id = p_copy_entity_txn_id
3724: and table_alias = 'CPP'
3725: and p_effective_date between information2 and information3

Line 3733: ben_copy_entity_results

3729: cursor c_ctp_sequence is
3730: select
3731: information268 ordr_num
3732: from
3733: ben_copy_entity_results
3734: where
3735: copy_entity_txn_id = p_copy_entity_txn_id
3736: and table_alias = 'CTP'
3737: and p_effective_date between information2 and information3

Line 3777: ben_copy_entity_results

3773: l_max_sequence);
3774: l_sequence := (round((l_max_sequence/10),0)+1)*10;
3775: for p_cpp in c_cpp_sequence loop
3776: update
3777: ben_copy_entity_results
3778: set
3779: information263 = l_sequence
3780: where current of c_cpp_sequence;
3781: l_sequence := l_sequence + 10;

Line 3793: ben_copy_entity_results

3789: l_max_sequence);
3790: l_sequence := (round((l_max_sequence/10),0)+1)*10;
3791: for p_ctp in c_ctp_sequence loop
3792: update
3793: ben_copy_entity_results
3794: set
3795: information268 = l_sequence
3796: where current of c_ctp_sequence;
3797: l_sequence := l_sequence + 10;

Line 3839: from ben_copy_entity_results where

3835: and bnfts_bal_id =c_balance_id;
3836:
3837: Cursor csr_new_bnft_balance(c_balance_id NUMBER,c_txn_id NUMBER,c_effective_date DATE) IS
3838: select information170
3839: from ben_copy_entity_results where
3840: table_alias='BNB' and copy_entity_txn_id=c_txn_id
3841: and information1=c_balance_id and
3842: c_effective_date between information2 and information3;
3843:

Line 3894: From ben_copy_entity_results

3890: p_effective_date Date
3891: )
3892: IS
3893: Select information170
3894: From ben_copy_entity_results
3895: Where copy_entity_txn_id=p_copy_entity_txn_id
3896: and table_alias=p_table_alias
3897: and information1=p_information1
3898: and p_effective_date between nvl(information2,p_effective_date) and nvl(information3,p_effective_date);

Line 3900: l_name ben_copy_entity_results.information170%TYPE;

3896: and table_alias=p_table_alias
3897: and information1=p_information1
3898: and p_effective_date between nvl(information2,p_effective_date) and nvl(information3,p_effective_date);
3899:
3900: l_name ben_copy_entity_results.information170%TYPE;
3901: l_table_name pqh_table_route.where_clause%TYPE;
3902: l_effective_date pqh_copy_entity_txns.SRC_EFFECTIVE_DATE%TYPE;
3903: l_bg_id pqh_copy_entity_txns.CONTEXT_BUSINESS_GROUP_ID%TYPE;
3904: Begin

Line 3915: from ben_copy_entity_results

3911: if p_table_alias='PFF'
3912: then
3913: begin
3914: select information218 into l_name
3915: from ben_copy_entity_results
3916: where copy_entity_txn_id=p_copy_entity_txn_id
3917: and table_alias=p_table_alias
3918: and information1=p_information1;
3919: Exception when no_data_found then

Line 3927: from ben_copy_entity_results

3923: elsif p_table_alias='RZR'
3924: then
3925: begin
3926: select information142||' - '|| information141 into l_name
3927: from ben_copy_entity_results
3928: where copy_entity_txn_id=p_copy_entity_txn_id
3929: and table_alias=p_table_alias
3930: and information1=p_information1
3931: and rownum=1;

Line 3974: From BEN_COPY_ENTITY_RESULTS

3970: l_proc varchar2(72) := g_package||'.copy_drvd_factor';
3971:
3972: Cursor csr_rec_exists is
3973: Select 'Y'
3974: From BEN_COPY_ENTITY_RESULTS
3975: Where copy_entity_txn_id=p_copy_entity_txn_id
3976: And table_alias=p_table_alias
3977: And information1=p_information1
3978: And result_type_cd='DISPLAY';

Line 4107: from ben_copy_entity_results

4103: p_max_sequence OUT NOCOPY Number) is
4104: l_proc varchar2(72) := g_package||'.max_sequence';
4105: cursor max_cpp_sequence(c_copy_entity_txn_id Number, c_effective_date Date) is
4106: select max(information263)
4107: from ben_copy_entity_results
4108: where table_alias = 'CPP'
4109: and copy_entity_txn_id = c_copy_entity_txn_id;
4110: -- and c_effective_date between information2 and information3;
4111:

Line 4114: from ben_copy_entity_results

4110: -- and c_effective_date between information2 and information3;
4111:
4112: cursor max_ctp_sequence(c_copy_entity_txn_id Number, c_effective_date Date) is
4113: select max(information268)
4114: from ben_copy_entity_results
4115: where table_alias = 'CTP'
4116: and copy_entity_txn_id = c_copy_entity_txn_id;
4117: -- and c_effective_date between information2 and information3;
4118:

Line 4122: from ben_copy_entity_results

4118:
4119:
4120: cursor max_cop_sequence(c_copy_entity_txn_id Number, c_effective_date Date, c_plan_id Number) is
4121: select max(information263)
4122: from ben_copy_entity_results
4123: where table_alias = 'COP'
4124: and copy_entity_txn_id = c_copy_entity_txn_id
4125: and information261 = c_plan_id;
4126: -- and c_effective_date between information2 and information3;

Line 4153: Select COPY_ENTITY_RESULT_ID From BEN_COPY_ENTITY_RESULTS

4149: ,p_information1 IN NUMBER
4150: )
4151: RETURN NUMBER IS
4152: Cursor csr_drvd_result IS
4153: Select COPY_ENTITY_RESULT_ID From BEN_COPY_ENTITY_RESULTS
4154: Where copy_entity_txn_id=p_copy_entity_txn_id
4155: And table_alias=p_table_alias
4156: And information1=p_information1
4157: And result_type_cd='DISPLAY';

Line 4178: l_enp_name ben_copy_entity_results.information5%type;

4174: Is
4175: --
4176: l_Strt_Dt Date ;
4177: l_End_Dt Date ;
4178: l_enp_name ben_copy_entity_results.information5%type;
4179: l_proc varchar2(72) := g_package||'.populate_extra_Mapping_ENP';
4180:
4181: Cursor c_ENP is
4182: Select

Line 4186: Ben_copy_entity_results yrp,

4182: Select
4183: yrp.information309 strt_dt,
4184: yrp.information308 end_dt
4185: From
4186: Ben_copy_entity_results yrp,
4187: Ben_copy_entity_results enp
4188: Where
4189: ENP.copy_entity_result_id = p_copy_entity_result_id
4190: And yrp.copy_entity_txn_id = ENP.copy_entity_txn_id

Line 4187: Ben_copy_entity_results enp

4183: yrp.information309 strt_dt,
4184: yrp.information308 end_dt
4185: From
4186: Ben_copy_entity_results yrp,
4187: Ben_copy_entity_results enp
4188: Where
4189: ENP.copy_entity_result_id = p_copy_entity_result_id
4190: And yrp.copy_entity_txn_id = ENP.copy_entity_txn_id
4191: and yrp.table_alias='YRP'

Line 4207: ben_copy_entity_results enp,

4203: select
4204: meaning||' '||to_char(enp.information318,'yyyy-mm-dd')||' '||to_char(enp.information317,'yyyy-mm-dd') into l_enp_name
4205: from
4206: hr_lookups,
4207: ben_copy_entity_results enp,
4208: ben_copy_entity_results pet
4209: where
4210: lookup_type = 'BEN_ENRT_TYP_CYCL'
4211: and enp.copy_entity_result_id = p_copy_entity_result_id

Line 4208: ben_copy_entity_results pet

4204: meaning||' '||to_char(enp.information318,'yyyy-mm-dd')||' '||to_char(enp.information317,'yyyy-mm-dd') into l_enp_name
4205: from
4206: hr_lookups,
4207: ben_copy_entity_results enp,
4208: ben_copy_entity_results pet
4209: where
4210: lookup_type = 'BEN_ENRT_TYP_CYCL'
4211: and enp.copy_entity_result_id = p_copy_entity_result_id
4212: and pet.copy_entity_txn_id = enp.copy_entity_txn_id

Line 4220: Ben_copy_entity_results ENP1

4216: and p_effective_date between pet.information2 and pet.information3;
4217:
4218:
4219: Update
4220: Ben_copy_entity_results ENP1
4221: Set
4222: ENP1.Information310 = l_ENP.strt_dt,
4223: ENP1.Information311 = l_ENP.end_dt,
4224: ENP1.Information5 = l_enp_name

Line 4250: Ben_copy_entity_results ENP,

4246: Cursor C_ENP is
4247: Select
4248: ENP.copy_entity_result_id
4249: From
4250: Ben_copy_entity_results ENP,
4251: Ben_copy_entity_results pet
4252: Where
4253: ENP.copy_entity_txn_id = p_copy_entity_txn_id
4254: And ENP.copy_entity_txn_id = pet.copy_entity_txn_id

Line 4251: Ben_copy_entity_results pet

4247: Select
4248: ENP.copy_entity_result_id
4249: From
4250: Ben_copy_entity_results ENP,
4251: Ben_copy_entity_results pet
4252: Where
4253: ENP.copy_entity_txn_id = p_copy_entity_txn_id
4254: And ENP.copy_entity_txn_id = pet.copy_entity_txn_id
4255: And p_effective_date between pet.information2 and pet.information3

Line 4290: Ben_copy_entity_results ctp

4286: ctp.information45,
4287: ctp.information248,
4288: ctp.information2 effective_date -- Add effective Date for populating mappings
4289: From
4290: Ben_copy_entity_results ctp
4291: Where
4292: ctp.copy_entity_txn_id = p_copy_entity_txn_id
4293: And ctp.copy_entity_txn_id = ctp.copy_entity_txn_id
4294: --And p_effective_date between ctp.information2 and ctp.information3

Line 4309: ben_copy_entity_results

4305: information44 ENRT_CD,
4306: information101 NEW_ENRT_CD,
4307: information102 CUR_ENRT_CD
4308: from
4309: ben_copy_entity_results
4310: where
4311: copy_entity_txn_id = p_copy_entity_txn_id
4312: and table_alias = 'CTP'
4313: and information44 is not null

Line 4320: l_new_enrt_cd ben_copy_entity_results.information101%type;

4316: for update of information101, information102;
4317:
4318: l_new_dflt_enrt_cd varchar2(15);
4319: l_old_dflt_enrt_cd varchar2(15);
4320: l_new_enrt_cd ben_copy_entity_results.information101%type;
4321: l_cur_enrt_cd ben_copy_entity_results.information102%type;
4322: l_default_object_id Number;
4323: --
4324: Begin

Line 4321: l_cur_enrt_cd ben_copy_entity_results.information102%type;

4317:
4318: l_new_dflt_enrt_cd varchar2(15);
4319: l_old_dflt_enrt_cd varchar2(15);
4320: l_new_enrt_cd ben_copy_entity_results.information101%type;
4321: l_cur_enrt_cd ben_copy_entity_results.information102%type;
4322: l_default_object_id Number;
4323: --
4324: Begin
4325: hr_utility.set_location('Entering: '||l_proc,10);

Line 4339: ben_copy_entity_results cpp

4335: --
4336: Select
4337: cpp.copy_entity_result_id into l_default_object_id
4338: From
4339: ben_copy_entity_results cpp
4340: ,ben_copy_entity_results pln
4341: Where
4342: cpp.copy_entity_txn_id = p_copy_entity_txn_id
4343: -- Take Effective Date from the cursor above

Line 4340: ,ben_copy_entity_results pln

4336: Select
4337: cpp.copy_entity_result_id into l_default_object_id
4338: From
4339: ben_copy_entity_results cpp
4340: ,ben_copy_entity_results pln
4341: Where
4342: cpp.copy_entity_txn_id = p_copy_entity_txn_id
4343: -- Take Effective Date from the cursor above
4344: And l_CTP.effective_date between cpp.information2 and cpp.information3

Line 4368: ben_copy_entity_results pln

4364: Begin
4365: Select
4366: cop.copy_entity_result_id into l_default_object_id
4367: From
4368: ben_copy_entity_results pln
4369: ,ben_copy_entity_results cop
4370: Where
4371: pln.copy_entity_txn_id = p_copy_entity_txn_id
4372: And l_CTP.effective_date between pln.information2 and pln.information3

Line 4369: ,ben_copy_entity_results cop

4365: Select
4366: cop.copy_entity_result_id into l_default_object_id
4367: From
4368: ben_copy_entity_results pln
4369: ,ben_copy_entity_results cop
4370: Where
4371: pln.copy_entity_txn_id = p_copy_entity_txn_id
4372: And l_CTP.effective_date between pln.information2 and pln.information3
4373: And cop.copy_entity_txn_id=pln.copy_entity_txn_id

Line 4392: Ben_copy_entity_results ctp1

4388: End If;
4389:
4390:
4391: Update
4392: Ben_copy_entity_results ctp1
4393: Set
4394: ctp1.information106 =l_new_dflt_enrt_cd ,
4395: ctp1.information107 =l_old_dflt_enrt_cd ,
4396: ctp1.information160 = l_default_object_Id

Line 4408: ben_copy_entity_results

4404: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(L_Enrt_Ctp.ENRT_CD);
4405: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(L_Enrt_Ctp.ENRT_CD);
4406:
4407: update
4408: ben_copy_entity_results
4409: set
4410: information101 = l_new_enrt_cd,
4411: information102 = l_cur_enrt_cd
4412: where current of C_Enrt_Ctp;

Line 4437: Ben_copy_entity_results ctp

4433: ctp.information259,
4434: ctp.information257 ler_id,
4435: ctp.information2 effective_date
4436: From
4437: Ben_copy_entity_results ctp
4438: Where
4439:
4440: ctp.copy_entity_txn_id = p_copy_entity_txn_id
4441: And ctp.copy_entity_txn_id = ctp.copy_entity_txn_id

Line 4458: ben_copy_entity_results

4454: information14 ENRT_CD,
4455: information101 NEW_ENRT_CD,
4456: information102 CUR_ENRT_CD
4457: from
4458: ben_copy_entity_results
4459: where
4460: copy_entity_txn_id = p_copy_entity_txn_id
4461: and table_alias = 'LCT'
4462: and information14 is not null

Line 4467: l_new_enrt_cd ben_copy_entity_results.information101%type;

4463: -- and p_effective_date between information2 and information3
4464: and dml_operation <> 'DELETE'
4465: for update of information101, information102;
4466:
4467: l_new_enrt_cd ben_copy_entity_results.information101%type;
4468: l_cur_enrt_cd ben_copy_entity_results.information102%type;
4469: ptipCopyEntityResultId ben_copy_entity_results.copy_entity_result_id%type;
4470: l_ptp_id ben_pl_typ_f.pl_typ_id%type;
4471: l_new_dflt_enrt_cd varchar2(15);

Line 4468: l_cur_enrt_cd ben_copy_entity_results.information102%type;

4464: and dml_operation <> 'DELETE'
4465: for update of information101, information102;
4466:
4467: l_new_enrt_cd ben_copy_entity_results.information101%type;
4468: l_cur_enrt_cd ben_copy_entity_results.information102%type;
4469: ptipCopyEntityResultId ben_copy_entity_results.copy_entity_result_id%type;
4470: l_ptp_id ben_pl_typ_f.pl_typ_id%type;
4471: l_new_dflt_enrt_cd varchar2(15);
4472: l_old_dflt_enrt_cd varchar2(15);

Line 4469: ptipCopyEntityResultId ben_copy_entity_results.copy_entity_result_id%type;

4465: for update of information101, information102;
4466:
4467: l_new_enrt_cd ben_copy_entity_results.information101%type;
4468: l_cur_enrt_cd ben_copy_entity_results.information102%type;
4469: ptipCopyEntityResultId ben_copy_entity_results.copy_entity_result_id%type;
4470: l_ptp_id ben_pl_typ_f.pl_typ_id%type;
4471: l_new_dflt_enrt_cd varchar2(15);
4472: l_old_dflt_enrt_cd varchar2(15);
4473: l_default_object_id Number;

Line 4486: ben_copy_entity_results

4482:
4483: Select
4484: copy_entity_result_id,information248 into ptipCopyEntityResultId,l_ptp_id
4485: From
4486: ben_copy_entity_results
4487: where
4488: copy_entity_txn_id = p_copy_entity_txn_id
4489: and l_LCT.effective_date between information2 and information3
4490: and table_alias='CTP'

Line 4502: ben_copy_entity_results lpr1

4498: --
4499: Select
4500: cpp.copy_entity_result_id into l_default_object_id
4501: From
4502: ben_copy_entity_results lpr1
4503: ,ben_copy_entity_results cpp
4504: ,ben_copy_entity_results pln
4505: ,ben_copy_entity_results ctp
4506: Where

Line 4503: ,ben_copy_entity_results cpp

4499: Select
4500: cpp.copy_entity_result_id into l_default_object_id
4501: From
4502: ben_copy_entity_results lpr1
4503: ,ben_copy_entity_results cpp
4504: ,ben_copy_entity_results pln
4505: ,ben_copy_entity_results ctp
4506: Where
4507: lpr1.copy_entity_txn_id = p_copy_entity_txn_id

Line 4504: ,ben_copy_entity_results pln

4500: cpp.copy_entity_result_id into l_default_object_id
4501: From
4502: ben_copy_entity_results lpr1
4503: ,ben_copy_entity_results cpp
4504: ,ben_copy_entity_results pln
4505: ,ben_copy_entity_results ctp
4506: Where
4507: lpr1.copy_entity_txn_id = p_copy_entity_txn_id
4508: And ctp.copy_entity_txn_id = lpr1.copy_entity_txn_id

Line 4505: ,ben_copy_entity_results ctp

4501: From
4502: ben_copy_entity_results lpr1
4503: ,ben_copy_entity_results cpp
4504: ,ben_copy_entity_results pln
4505: ,ben_copy_entity_results ctp
4506: Where
4507: lpr1.copy_entity_txn_id = p_copy_entity_txn_id
4508: And ctp.copy_entity_txn_id = lpr1.copy_entity_txn_id
4509: And cpp.copy_entity_txn_id = lpr1.copy_entity_txn_id

Line 4549: ben_copy_entity_results lop

4545: --
4546: Select
4547: cop.copy_entity_result_id into l_default_object_id
4548: From
4549: ben_copy_entity_results lop
4550: ,ben_copy_entity_results cop
4551: ,ben_copy_entity_results cpp
4552: ,ben_copy_entity_results pln
4553: ,ben_copy_entity_results ctp

Line 4550: ,ben_copy_entity_results cop

4546: Select
4547: cop.copy_entity_result_id into l_default_object_id
4548: From
4549: ben_copy_entity_results lop
4550: ,ben_copy_entity_results cop
4551: ,ben_copy_entity_results cpp
4552: ,ben_copy_entity_results pln
4553: ,ben_copy_entity_results ctp
4554: Where

Line 4551: ,ben_copy_entity_results cpp

4547: cop.copy_entity_result_id into l_default_object_id
4548: From
4549: ben_copy_entity_results lop
4550: ,ben_copy_entity_results cop
4551: ,ben_copy_entity_results cpp
4552: ,ben_copy_entity_results pln
4553: ,ben_copy_entity_results ctp
4554: Where
4555: lop.copy_entity_txn_id = p_copy_entity_txn_id

Line 4552: ,ben_copy_entity_results pln

4548: From
4549: ben_copy_entity_results lop
4550: ,ben_copy_entity_results cop
4551: ,ben_copy_entity_results cpp
4552: ,ben_copy_entity_results pln
4553: ,ben_copy_entity_results ctp
4554: Where
4555: lop.copy_entity_txn_id = p_copy_entity_txn_id
4556: And ctp.copy_entity_txn_id = lop.copy_entity_txn_id

Line 4553: ,ben_copy_entity_results ctp

4549: ben_copy_entity_results lop
4550: ,ben_copy_entity_results cop
4551: ,ben_copy_entity_results cpp
4552: ,ben_copy_entity_results pln
4553: ,ben_copy_entity_results ctp
4554: Where
4555: lop.copy_entity_txn_id = p_copy_entity_txn_id
4556: And ctp.copy_entity_txn_id = lop.copy_entity_txn_id
4557: And cpp.copy_entity_txn_id = lop.copy_entity_txn_id

Line 4609: Ben_copy_entity_results ctp1

4605: -- also populate the composite id to that of the row copy entity result id
4606: -- so copied lct records will not show any groupings but wil be simply one to one
4607: -- grouping will hamper performance
4608: Update
4609: Ben_copy_entity_results ctp1
4610: Set
4611: ctp1.information103 =l_new_dflt_enrt_cd,
4612: ctp1.information104 =l_old_dflt_enrt_cd,
4613: ctp1.information160 = l_default_object_id,

Line 4625: ben_copy_entity_results

4621: loop
4622: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(l_lct.ENRT_CD);
4623: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(l_lct.ENRT_CD);
4624: update
4625: ben_copy_entity_results
4626: set
4627: information101 = l_new_enrt_cd,
4628: information102 = l_cur_enrt_cd
4629: where current of c_enrt_lct;

Line 4652: Ben_copy_entity_results CPP

4648: CPP.information13,
4649: CPP.information261,
4650: CPP.information2 effective_date
4651: From
4652: Ben_copy_entity_results CPP
4653: Where
4654: CPP.copy_entity_txn_id = p_copy_entity_txn_id
4655: And CPP.copy_entity_txn_id = CPP.copy_entity_txn_id
4656: --And p_effective_date between CPP.information2 and CPP.information3

Line 4671: ben_copy_entity_results

4667: information22 ENRT_CD,
4668: information101 NEW_ENRT_CD,
4669: information102 CUR_ENRT_CD
4670: from
4671: ben_copy_entity_results
4672: where
4673: copy_entity_Txn_id = p_copy_entity_txn_id
4674: and table_alias = 'CPP'
4675: -- and p_effective_date between information2 and information3

Line 4679: l_new_enrt_cd ben_copy_entity_results.information101%type;

4675: -- and p_effective_date between information2 and information3
4676: and dml_operation <> 'DELETE'
4677: for update of information101, information102;
4678:
4679: l_new_enrt_cd ben_copy_entity_results.information101%type;
4680: l_cur_enrt_cd ben_copy_entity_results.information102%type;
4681: l_new_dflt_enrt_cd varchar2(15);
4682: l_old_dflt_enrt_cd varchar2(15);
4683: l_default_object_id Number;

Line 4680: l_cur_enrt_cd ben_copy_entity_results.information102%type;

4676: and dml_operation <> 'DELETE'
4677: for update of information101, information102;
4678:
4679: l_new_enrt_cd ben_copy_entity_results.information101%type;
4680: l_cur_enrt_cd ben_copy_entity_results.information102%type;
4681: l_new_dflt_enrt_cd varchar2(15);
4682: l_old_dflt_enrt_cd varchar2(15);
4683: l_default_object_id Number;
4684: --

Line 4704: Ben_copy_entity_results cop

4700: --
4701: Select
4702: cop.copy_entity_result_id into l_default_object_id
4703: From
4704: Ben_copy_entity_results cop
4705: Where
4706: cop.copy_entity_txn_id = p_copy_entity_txn_id
4707: And l_CPP.effective_date between cop.information2 and cop.information3
4708: And cop.table_alias = 'COP'

Line 4723: Ben_copy_entity_results CPP1

4719: End If ;
4720:
4721: -- Update the New and Old Default enrollment Logic by parsing the combined dflt enrt logic
4722: Update
4723: Ben_copy_entity_results CPP1
4724: Set
4725: CPP1.information106 =l_new_dflt_enrt_cd,
4726: CPP1.information107 =l_old_dflt_enrt_cd,
4727: CPP1.information160 = l_default_object_id

Line 4739: ben_copy_entity_results

4735: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(L_Cpp.ENRT_CD);
4736: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(L_Cpp.ENRT_CD);
4737:
4738: update
4739: ben_copy_entity_results
4740: set
4741: information101 = l_new_enrt_cd,
4742: information102 = l_cur_enrt_cd
4743: where current of C_Enrt_Cpp;

Line 4761: Ben_copy_entity_results pgm

4757: --
4758: cursor c_PGM is
4759: Select pgm.*
4760: from
4761: Ben_copy_entity_results pgm
4762: Where
4763: pgm.copy_entity_txn_id = p_copy_entity_txn_id
4764: And pgm.table_alias='PGM'
4765: for update of pgm.information101,pgm.information102;

Line 4779: Ben_copy_entity_results pgm1

4775: l_new_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_new_enrt_cd(l_PGM.information51) ;
4776: l_cur_enrt_cd := BEN_PDW_COPY_BEN_TO_STG.get_cur_enrt_cd(l_PGM.information51) ;
4777:
4778: Update
4779: Ben_copy_entity_results pgm1
4780: Set
4781: information101= l_new_enrt_cd,
4782: information102= l_cur_enrt_cd
4783: Where current of c_PGM ;

Line 4808: Ben_copy_entity_results cpp,

4804: Cursor C_CPP is
4805: Select
4806: pln.copy_entity_result_id
4807: From
4808: Ben_copy_entity_results cpp,
4809: Ben_copy_entity_results pln
4810: Where
4811: cpp.copy_entity_txn_id = p_copy_entity_txn_id
4812: And pln.copy_entity_txn_id = cpp.copy_entity_txn_id

Line 4809: Ben_copy_entity_results pln

4805: Select
4806: pln.copy_entity_result_id
4807: From
4808: Ben_copy_entity_results cpp,
4809: Ben_copy_entity_results pln
4810: Where
4811: cpp.copy_entity_txn_id = p_copy_entity_txn_id
4812: And pln.copy_entity_txn_id = cpp.copy_entity_txn_id
4813: And p_effective_date between cpp.information2 and cpp.information3

Line 4826: Ben_copy_entity_results cpp,

4822: Cursor C_CPP is
4823: Select
4824: pln.copy_entity_result_id
4825: From
4826: Ben_copy_entity_results cpp,
4827: Ben_copy_entity_results pln
4828: Where
4829: cpp.copy_entity_txn_id = 229
4830: And pln.copy_entity_txn_id = cpp.copy_entity_txn_id

Line 4827: Ben_copy_entity_results pln

4823: Select
4824: pln.copy_entity_result_id
4825: From
4826: Ben_copy_entity_results cpp,
4827: Ben_copy_entity_results pln
4828: Where
4829: cpp.copy_entity_txn_id = 229
4830: And pln.copy_entity_txn_id = cpp.copy_entity_txn_id
4831: And sysdate between cpp.information2 and cpp.information3

Line 5012: delete from ben_copy_entity_results

5008: -- For now, GSP will mark the column FUTURE_DATA_EXISTS with Y
5009: if ( l_context <> 'GSP')
5010: then
5011: -- first delete the duplicate rows
5012: delete from ben_copy_entity_results
5013: where rowid in ( select min(rowid)
5014: from ben_copy_entity_results
5015: where copy_entity_txn_id = p_copy_entity_txn_id
5016: and information1 is not null

Line 5014: from ben_copy_entity_results

5010: then
5011: -- first delete the duplicate rows
5012: delete from ben_copy_entity_results
5013: where rowid in ( select min(rowid)
5014: from ben_copy_entity_results
5015: where copy_entity_txn_id = p_copy_entity_txn_id
5016: and information1 is not null
5017: group by table_alias,information1, information2, information3
5018: having count( table_alias) > 1 );

Line 5022: update ben_copy_entity_results a

5018: having count( table_alias) > 1 );
5019:
5020: -- update the selected one to Y
5021:
5022: update ben_copy_entity_results a
5023: set future_data_exists ='Y'
5024: where a.copy_entity_txn_id = p_copy_entity_txn_id
5025: and a.future_data_exists is null
5026: and a.information3 < to_date('4712/12/31','YYYY/MM/DD')

Line 5028: ( select 'Y' from ben_copy_entity_results b

5024: where a.copy_entity_txn_id = p_copy_entity_txn_id
5025: and a.future_data_exists is null
5026: and a.information3 < to_date('4712/12/31','YYYY/MM/DD')
5027: and exists
5028: ( select 'Y' from ben_copy_entity_results b
5029: where b.copy_entity_txn_id = a.copy_entity_txn_id
5030: and b.table_alias = a.table_alias
5031: and b.information1 = a.information1
5032: and b.information2 = a.information3+1);

Line 5035: update ben_copy_entity_results

5031: and b.information1 = a.information1
5032: and b.information2 = a.information3+1);
5033: -- update all others to N
5034:
5035: update ben_copy_entity_results
5036: set future_data_exists = nvl(future_Data_exists,'N'),
5037: result_type_cd = 'DISPLAY'
5038: where copy_entity_txn_id = p_copy_entity_txn_id;
5039: end if;

Line 5091: l_rule_name ben_copy_entity_results.information170%type;

5087: ,p_table_alias IN VARCHAR2)
5088: RETURN VARCHAR2 IS
5089: l_business_group_id Number;
5090: l_effective_date Date;
5091: l_rule_name ben_copy_entity_results.information170%type;
5092: BEGIN
5093: get_txn_details (p_copy_entity_txn_id ,l_business_group_id,l_effective_date);
5094: if (p_id is not null) THEN
5095: begin

Line 5097: from ben_copy_entity_results fff,

5093: get_txn_details (p_copy_entity_txn_id ,l_business_group_id,l_effective_date);
5094: if (p_id is not null) THEN
5095: begin
5096: Select fff.information112 into l_rule_name
5097: from ben_copy_entity_results fff,
5098: ben_copy_entity_results ben
5099: where fff.table_alias='FFF'
5100: and fff.copy_entity_txn_id=p_copy_entity_txn_id
5101: and ben.copy_entity_txn_id=p_copy_entity_txn_id

Line 5098: ben_copy_entity_results ben

5094: if (p_id is not null) THEN
5095: begin
5096: Select fff.information112 into l_rule_name
5097: from ben_copy_entity_results fff,
5098: ben_copy_entity_results ben
5099: where fff.table_alias='FFF'
5100: and fff.copy_entity_txn_id=p_copy_entity_txn_id
5101: and ben.copy_entity_txn_id=p_copy_entity_txn_id
5102: and fff.information1=decode(p_table_alias,'CTP',ben.INFORMATION277,'CPP',ben.INFORMATION264,'COP',ben.INFORMATION266,'PLN',ben.information272,'LPR1',ben.INFORMATION263,'LOP',ben.INFORMATION264,'LCT',ben.INFORMATION13,'CCM',ben.INFORMATION266)

Line 5116: from ben_copy_entity_results

5112:
5113: procedure update_task_list_row(p_copy_entity_txn_id Number,p_effective_date Date)
5114: is
5115: cursor c_pgm is select information1 pgm_id, information170 name, information36 Alws_Unrstrctd_Enrt_Flag,information50 pgm_uom
5116: from ben_copy_entity_results
5117: where copy_entity_txn_id = p_copy_entity_txn_id
5118: and table_alias = 'PGM'
5119: and p_effective_date between information2 and information3;
5120:

Line 5129: update ben_copy_entity_results

5125: open c_pgm;
5126: fetch c_pgm into l_pgmrow;
5127: close c_pgm;
5128: if(l_pgmrow.pgm_id is not null) then
5129: update ben_copy_entity_results
5130: set INFORMATION260 = l_pgmrow.pgm_id /*SAVED_TASK_PGMID*/
5131: ,INFORMATION185 = l_pgmrow.name /* SAVED_PROGRAM_NAME*/
5132: ,INFORMATION14 = l_pgmrow.Alws_Unrstrctd_Enrt_Flag /* PGM_ALWS_UNRSTRCTD*/
5133: ,INFORMATION15 = l_pgmrow.pgm_uom /*PGM_UOM */