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_CWB_SUMMARY_PKG dependencies on BEN_CWB_SUMMARY

Line 1: package body BEN_CWB_SUMMARY_PKG as

1: package body BEN_CWB_SUMMARY_PKG as
2: /* $Header: bencwbsm.pkb 120.15.12010000.2 2008/09/08 06:15:58 cakunuru ship $ */
3: --
4: -- --------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33):=' ben_cwb_summary_pkg.'; --Global package name

4: -- --------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- --------------------------------------------------------------------------
7: --
8: g_package varchar2(33):=' ben_cwb_summary_pkg.'; --Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: type g_summary_type is table of ben_cwb_summary%rowtype
12: index by binary_integer;

Line 11: type g_summary_type is table of ben_cwb_summary%rowtype

7: --
8: g_package varchar2(33):=' ben_cwb_summary_pkg.'; --Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: type g_summary_type is table of ben_cwb_summary%rowtype
12: index by binary_integer;
13: g_summary_rec g_summary_type;
14: --
15: -- Get the rate information for this person.

Line 73: from ben_cwb_summary

69: ,sum(rec_mx_val_all) rec_mx_val
70: ,sum(misc1_val_all) misc1_val
71: ,sum(misc2_val_all) misc2_val
72: ,sum(misc3_val_all) misc3_val
73: from ben_cwb_summary
74: where group_per_in_ler_id = v_per_in_ler_id
75: group by group_pl_id, group_oipl_id
76: order by group_pl_id, group_oipl_id;
77:

Line 109: from ben_cwb_summary

105: ,p_lf_evt_ocrd_dt in date
106: ,p_called_from_batch in varchar2 default 'N') is
107: cursor c_refresh is
108: select 'Y'
109: from ben_cwb_summary
110: where group_per_in_ler_id = -1
111: and group_pl_id = p_group_pl_id
112: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
113: and status = 'R'

Line 138: insert into ben_cwb_summary

134: ,p_lf_evt_ocrd_dt in date) is
135: pragma autonomous_transaction;
136: begin
137: --
138: insert into ben_cwb_summary
139: (summary_id
140: ,group_per_in_ler_id
141: ,group_pl_id
142: ,lf_evt_ocrd_dt

Line 146: (ben_cwb_summary_s.nextval

142: ,lf_evt_ocrd_dt
143: ,status
144: ,person_id)
145: values
146: (ben_cwb_summary_s.nextval
147: ,-1
148: ,p_group_pl_id
149: ,p_lf_evt_ocrd_dt
150: ,'R'

Line 162: delete ben_cwb_summary

158: ,p_lf_evt_ocrd_dt in date) is
159: pragma autonomous_transaction;
160: begin
161: --
162: delete ben_cwb_summary
163: where group_per_in_ler_id = -1
164: and group_pl_id = p_group_pl_id
165: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
166: and status = 'R'

Line 177: procedure update_or_insert (p_sum_rec in ben_cwb_summary%rowtype) is

173: -- --------------------------------------------------------------------------
174: -- |--------------------------< update_or_insert >---------------------------|
175: -- --------------------------------------------------------------------------
176: --
177: procedure update_or_insert (p_sum_rec in ben_cwb_summary%rowtype) is
178:
179: -- select all the summary ids for this combination
180: cursor csr_summary_id is
181: select summary_id

Line 182: from ben_cwb_summary

178:
179: -- select all the summary ids for this combination
180: cursor csr_summary_id is
181: select summary_id
182: from ben_cwb_summary
183: where group_per_in_ler_id = p_sum_rec.group_per_in_ler_id
184: and group_pl_id = p_sum_rec.group_pl_id
185: and group_oipl_id = p_sum_rec.group_oipl_id;
186: --

Line 249: from ben_cwb_summary

245: -- try to get summary Id of one unlocked record
246: loop
247: begin
248: select null into l_dummy
249: from ben_cwb_summary
250: where summary_id = l_summary_id
251: for update nowait;
252:
253: -- Found one unlocked record. So set the flag and exit from the loop

Line 280: update ben_cwb_summary summ

276: hr_utility.set_location(l_proc, 40);
277: end if;
278: --
279: -- Found one unlocked record. So update the summary.
280: update ben_cwb_summary summ
281: set elig_count_direct = nvl2(summ.elig_count_direct,
282: summ.elig_count_direct+
283: nvl(p_sum_rec.elig_count_direct,0),
284: p_sum_rec.elig_count_direct)

Line 424: insert into ben_cwb_summary (

420: -- No records are found. So this will be the first record.
421: l_status := null;
422: end if;
423:
424: insert into ben_cwb_summary (
425: summary_id
426: ,group_per_in_ler_id
427: ,group_pl_id
428: ,group_oipl_id

Line 465: ben_cwb_summary_s.nextval

461: ,misc3_val_all
462: ,person_id
463: ,lf_evt_ocrd_dt)
464: values (
465: ben_cwb_summary_s.nextval
466: ,p_sum_rec.group_per_in_ler_id
467: ,p_sum_rec.group_pl_id
468: ,p_sum_rec.group_oipl_id
469: ,l_status

Line 521: from ben_cwb_summary summ

517:
518: -- get the records with status P
519: cursor csr_pending_recs(p_person_id number) is
520: select summ.*
521: from ben_cwb_summary summ
522: where summ.person_id = p_person_id
523: and summ.status = 'P'
524: order by summ.group_per_in_ler_id, summ.group_pl_id, summ.group_oipl_id;
525: --

Line 526: l_sum_rec ben_cwb_summary%rowtype;

522: where summ.person_id = p_person_id
523: and summ.status = 'P'
524: order by summ.group_per_in_ler_id, summ.group_pl_id, summ.group_oipl_id;
525: --
526: l_sum_rec ben_cwb_summary%rowtype;
527: --
528: l_proc varchar2(72) := g_package||'consolidate_summary_rec';
529: --
530: begin

Line 682: -- Now delete the record from ben_cwb_summary as it is already

678: (l_sum_rec.misc3_val_direct,pending_rec.misc3_val_direct);
679: l_sum_rec.misc3_val_all :=ben_cwb_utils.add_number_with_null_check
680: (l_sum_rec.misc3_val_all,pending_rec.misc3_val_all);
681:
682: -- Now delete the record from ben_cwb_summary as it is already
683: -- consolidated
684: delete from ben_cwb_summary
685: where summary_id = pending_rec.summary_id;
686: end loop; -- of get_pening_recs

Line 684: delete from ben_cwb_summary

680: (l_sum_rec.misc3_val_all,pending_rec.misc3_val_all);
681:
682: -- Now delete the record from ben_cwb_summary as it is already
683: -- consolidated
684: delete from ben_cwb_summary
685: where summary_id = pending_rec.summary_id;
686: end loop; -- of get_pening_recs
687: --
688: if g_debug then

Line 693: -- values will not get updated in ben_cwb_summary. So call

689: hr_utility.set_location(l_proc, 60);
690: end if;
691: --
692: -- if the for loop fetches atleast one record then the last summary record
693: -- values will not get updated in ben_cwb_summary. So call
694: -- update_or_insert again to update the values
695:
696: if (l_sum_rec.group_per_in_ler_id is not null) then
697: --

Line 721: from ben_cwb_summary

717: -- cursor to get the person ids who have split rows in
718: -- summary table
719: cursor csr_get_person_ids is
720: select distinct(person_id) person_id
721: from ben_cwb_summary
722: where status = 'P';
723: --
724: l_proc varchar2(72) := g_package||'consolidate_summary_rec_all';
725: --

Line 852: ,ben_cwb_summary summ

848: ws_bdgt_iss_val_direct
849: from ben_cwb_group_hrchy hrchy
850: ,ben_cwb_person_groups grp
851: ,ben_cwb_person_info info
852: ,ben_cwb_summary summ
853: where info.group_pl_id = p_group_pl_id
854: and info.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
855: and info.group_per_in_ler_id = hrchy.emp_per_in_ler_id
856: and hrchy.lvl_num = 1

Line 906: ,ben_cwb_summary summ

902: ,sum(misc1_val_direct) misc1_val_all
903: ,sum(misc2_val_direct) misc2_val_all
904: ,sum(misc3_val_direct) misc3_val_all
905: from ben_cwb_group_hrchy hrchy
906: ,ben_cwb_summary summ
907: ,ben_cwb_person_info info
908: where info.group_pl_id = p_group_pl_id
909: and info.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
910: and info.group_per_in_ler_id = hrchy.emp_per_in_ler_id

Line 931: ,ben_cwb_summary summ

927: summ.elig_sal_val_direct,summ.elig_sal_val_all) /100)
928: bdgt_iss_val_direct
929: from ben_cwb_group_hrchy hrchy
930: ,ben_cwb_person_groups grp
931: ,ben_cwb_summary summ
932: ,ben_cwb_person_info info
933: where info.group_pl_id = p_group_pl_id
934: and info.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
935: and info.group_per_in_ler_id = hrchy.emp_per_in_ler_id

Line 945: ben_cwb_summary.group_per_in_ler_id%type;

941: group by hrchy.mgr_per_in_ler_id, grp.group_pl_id, grp.group_oipl_id;
942:
943: -- Type delcarations for pl/sql tables
944: type group_per_in_ler_id_type is table of
945: ben_cwb_summary.group_per_in_ler_id%type;
946: type group_pl_id_type is table of
947: ben_cwb_summary.group_pl_id%type;
948: type group_oipl_id_type is table of
949: ben_cwb_summary.group_oipl_id%type;

Line 947: ben_cwb_summary.group_pl_id%type;

943: -- Type delcarations for pl/sql tables
944: type group_per_in_ler_id_type is table of
945: ben_cwb_summary.group_per_in_ler_id%type;
946: type group_pl_id_type is table of
947: ben_cwb_summary.group_pl_id%type;
948: type group_oipl_id_type is table of
949: ben_cwb_summary.group_oipl_id%type;
950: type elig_count_all_type is table of
951: ben_cwb_summary.elig_count_all%type;

Line 949: ben_cwb_summary.group_oipl_id%type;

945: ben_cwb_summary.group_per_in_ler_id%type;
946: type group_pl_id_type is table of
947: ben_cwb_summary.group_pl_id%type;
948: type group_oipl_id_type is table of
949: ben_cwb_summary.group_oipl_id%type;
950: type elig_count_all_type is table of
951: ben_cwb_summary.elig_count_all%type;
952: type emp_recv_count_all_type is table of
953: ben_cwb_summary. emp_recv_count_all%type;

Line 951: ben_cwb_summary.elig_count_all%type;

947: ben_cwb_summary.group_pl_id%type;
948: type group_oipl_id_type is table of
949: ben_cwb_summary.group_oipl_id%type;
950: type elig_count_all_type is table of
951: ben_cwb_summary.elig_count_all%type;
952: type emp_recv_count_all_type is table of
953: ben_cwb_summary. emp_recv_count_all%type;
954: type elig_sal_val_all_type is table of
955: ben_cwb_summary.elig_sal_val_all%type;

Line 953: ben_cwb_summary. emp_recv_count_all%type;

949: ben_cwb_summary.group_oipl_id%type;
950: type elig_count_all_type is table of
951: ben_cwb_summary.elig_count_all%type;
952: type emp_recv_count_all_type is table of
953: ben_cwb_summary. emp_recv_count_all%type;
954: type elig_sal_val_all_type is table of
955: ben_cwb_summary.elig_sal_val_all%type;
956: type ws_val_all_type is table of
957: ben_cwb_summary.ws_val_all%type;

Line 955: ben_cwb_summary.elig_sal_val_all%type;

951: ben_cwb_summary.elig_count_all%type;
952: type emp_recv_count_all_type is table of
953: ben_cwb_summary. emp_recv_count_all%type;
954: type elig_sal_val_all_type is table of
955: ben_cwb_summary.elig_sal_val_all%type;
956: type ws_val_all_type is table of
957: ben_cwb_summary.ws_val_all%type;
958: type ws_bdgt_val_direct_type is table of
959: ben_cwb_summary.ws_bdgt_val_direct%type;

Line 957: ben_cwb_summary.ws_val_all%type;

953: ben_cwb_summary. emp_recv_count_all%type;
954: type elig_sal_val_all_type is table of
955: ben_cwb_summary.elig_sal_val_all%type;
956: type ws_val_all_type is table of
957: ben_cwb_summary.ws_val_all%type;
958: type ws_bdgt_val_direct_type is table of
959: ben_cwb_summary.ws_bdgt_val_direct%type;
960: type ws_bdgt_val_all_type is table of
961: ben_cwb_summary.ws_bdgt_val_all%type;

Line 959: ben_cwb_summary.ws_bdgt_val_direct%type;

955: ben_cwb_summary.elig_sal_val_all%type;
956: type ws_val_all_type is table of
957: ben_cwb_summary.ws_val_all%type;
958: type ws_bdgt_val_direct_type is table of
959: ben_cwb_summary.ws_bdgt_val_direct%type;
960: type ws_bdgt_val_all_type is table of
961: ben_cwb_summary.ws_bdgt_val_all%type;
962: type ws_bdgt_iss_val_direct_type is table of
963: ben_cwb_summary.ws_bdgt_iss_val_direct%type;

Line 961: ben_cwb_summary.ws_bdgt_val_all%type;

957: ben_cwb_summary.ws_val_all%type;
958: type ws_bdgt_val_direct_type is table of
959: ben_cwb_summary.ws_bdgt_val_direct%type;
960: type ws_bdgt_val_all_type is table of
961: ben_cwb_summary.ws_bdgt_val_all%type;
962: type ws_bdgt_iss_val_direct_type is table of
963: ben_cwb_summary.ws_bdgt_iss_val_direct%type;
964: type ws_bdgt_iss_val_all_type is table of
965: ben_cwb_summary.ws_bdgt_iss_val_all%type;

Line 963: ben_cwb_summary.ws_bdgt_iss_val_direct%type;

959: ben_cwb_summary.ws_bdgt_val_direct%type;
960: type ws_bdgt_val_all_type is table of
961: ben_cwb_summary.ws_bdgt_val_all%type;
962: type ws_bdgt_iss_val_direct_type is table of
963: ben_cwb_summary.ws_bdgt_iss_val_direct%type;
964: type ws_bdgt_iss_val_all_type is table of
965: ben_cwb_summary.ws_bdgt_iss_val_all%type;
966: type bdgt_val_direct_type is table of
967: ben_cwb_summary.bdgt_val_direct%type;

Line 965: ben_cwb_summary.ws_bdgt_iss_val_all%type;

961: ben_cwb_summary.ws_bdgt_val_all%type;
962: type ws_bdgt_iss_val_direct_type is table of
963: ben_cwb_summary.ws_bdgt_iss_val_direct%type;
964: type ws_bdgt_iss_val_all_type is table of
965: ben_cwb_summary.ws_bdgt_iss_val_all%type;
966: type bdgt_val_direct_type is table of
967: ben_cwb_summary.bdgt_val_direct%type;
968: type bdgt_iss_val_direct_type is table of
969: ben_cwb_summary.bdgt_iss_val_direct%type;

Line 967: ben_cwb_summary.bdgt_val_direct%type;

963: ben_cwb_summary.ws_bdgt_iss_val_direct%type;
964: type ws_bdgt_iss_val_all_type is table of
965: ben_cwb_summary.ws_bdgt_iss_val_all%type;
966: type bdgt_val_direct_type is table of
967: ben_cwb_summary.bdgt_val_direct%type;
968: type bdgt_iss_val_direct_type is table of
969: ben_cwb_summary.bdgt_iss_val_direct%type;
970: type stat_sal_val_all_type is table of
971: ben_cwb_summary.stat_sal_val_all%type;

Line 969: ben_cwb_summary.bdgt_iss_val_direct%type;

965: ben_cwb_summary.ws_bdgt_iss_val_all%type;
966: type bdgt_val_direct_type is table of
967: ben_cwb_summary.bdgt_val_direct%type;
968: type bdgt_iss_val_direct_type is table of
969: ben_cwb_summary.bdgt_iss_val_direct%type;
970: type stat_sal_val_all_type is table of
971: ben_cwb_summary.stat_sal_val_all%type;
972: type oth_comp_val_all_type is table of
973: ben_cwb_summary.oth_comp_val_all%type;

Line 971: ben_cwb_summary.stat_sal_val_all%type;

967: ben_cwb_summary.bdgt_val_direct%type;
968: type bdgt_iss_val_direct_type is table of
969: ben_cwb_summary.bdgt_iss_val_direct%type;
970: type stat_sal_val_all_type is table of
971: ben_cwb_summary.stat_sal_val_all%type;
972: type oth_comp_val_all_type is table of
973: ben_cwb_summary.oth_comp_val_all%type;
974: type tot_comp_val_all_type is table of
975: ben_cwb_summary.tot_comp_val_all%type;

Line 973: ben_cwb_summary.oth_comp_val_all%type;

969: ben_cwb_summary.bdgt_iss_val_direct%type;
970: type stat_sal_val_all_type is table of
971: ben_cwb_summary.stat_sal_val_all%type;
972: type oth_comp_val_all_type is table of
973: ben_cwb_summary.oth_comp_val_all%type;
974: type tot_comp_val_all_type is table of
975: ben_cwb_summary.tot_comp_val_all%type;
976: type rec_val_all_type is table of
977: ben_cwb_summary.rec_val_all%type;

Line 975: ben_cwb_summary.tot_comp_val_all%type;

971: ben_cwb_summary.stat_sal_val_all%type;
972: type oth_comp_val_all_type is table of
973: ben_cwb_summary.oth_comp_val_all%type;
974: type tot_comp_val_all_type is table of
975: ben_cwb_summary.tot_comp_val_all%type;
976: type rec_val_all_type is table of
977: ben_cwb_summary.rec_val_all%type;
978: type rec_mn_val_all_type is table of
979: ben_cwb_summary.rec_mn_val_all%type;

Line 977: ben_cwb_summary.rec_val_all%type;

973: ben_cwb_summary.oth_comp_val_all%type;
974: type tot_comp_val_all_type is table of
975: ben_cwb_summary.tot_comp_val_all%type;
976: type rec_val_all_type is table of
977: ben_cwb_summary.rec_val_all%type;
978: type rec_mn_val_all_type is table of
979: ben_cwb_summary.rec_mn_val_all%type;
980: type rec_mx_val_all_type is table of
981: ben_cwb_summary.rec_mx_val_all%type;

Line 979: ben_cwb_summary.rec_mn_val_all%type;

975: ben_cwb_summary.tot_comp_val_all%type;
976: type rec_val_all_type is table of
977: ben_cwb_summary.rec_val_all%type;
978: type rec_mn_val_all_type is table of
979: ben_cwb_summary.rec_mn_val_all%type;
980: type rec_mx_val_all_type is table of
981: ben_cwb_summary.rec_mx_val_all%type;
982: type misc1_val_all_type is table of
983: ben_cwb_summary.misc1_val_all%type;

Line 981: ben_cwb_summary.rec_mx_val_all%type;

977: ben_cwb_summary.rec_val_all%type;
978: type rec_mn_val_all_type is table of
979: ben_cwb_summary.rec_mn_val_all%type;
980: type rec_mx_val_all_type is table of
981: ben_cwb_summary.rec_mx_val_all%type;
982: type misc1_val_all_type is table of
983: ben_cwb_summary.misc1_val_all%type;
984: type misc2_val_all_type is table of
985: ben_cwb_summary.misc2_val_all%type;

Line 983: ben_cwb_summary.misc1_val_all%type;

979: ben_cwb_summary.rec_mn_val_all%type;
980: type rec_mx_val_all_type is table of
981: ben_cwb_summary.rec_mx_val_all%type;
982: type misc1_val_all_type is table of
983: ben_cwb_summary.misc1_val_all%type;
984: type misc2_val_all_type is table of
985: ben_cwb_summary.misc2_val_all%type;
986: type misc3_val_all_type is table of
987: ben_cwb_summary.misc3_val_all%type;

Line 985: ben_cwb_summary.misc2_val_all%type;

981: ben_cwb_summary.rec_mx_val_all%type;
982: type misc1_val_all_type is table of
983: ben_cwb_summary.misc1_val_all%type;
984: type misc2_val_all_type is table of
985: ben_cwb_summary.misc2_val_all%type;
986: type misc3_val_all_type is table of
987: ben_cwb_summary.misc3_val_all%type;
988: type person_id_type is table of
989: ben_cwb_person_info.person_id%type;

Line 987: ben_cwb_summary.misc3_val_all%type;

983: ben_cwb_summary.misc1_val_all%type;
984: type misc2_val_all_type is table of
985: ben_cwb_summary.misc2_val_all%type;
986: type misc3_val_all_type is table of
987: ben_cwb_summary.misc3_val_all%type;
988: type person_id_type is table of
989: ben_cwb_person_info.person_id%type;
990: --
991: -- declare pl/sql tables

Line 1068: update ben_cwb_summary

1064: if nvl(l_group_per_in_ler_id_tab.count,0) > 0 then
1065: -- bulk update the table
1066: forall i in l_group_per_in_ler_id_tab.first..
1067: l_group_per_in_ler_id_tab.last
1068: update ben_cwb_summary
1069: set ws_bdgt_val_direct = l_ws_bdgt_val_direct_tab(i)
1070: ,ws_bdgt_iss_val_direct = l_ws_bdgt_iss_val_direct_tab(i)
1071: where group_per_in_ler_id = l_group_per_in_ler_id_tab(i)
1072: and group_pl_id = l_group_pl_id_tab(i)

Line 1113: update ben_cwb_summary

1109: if nvl(l_group_per_in_ler_id_tab.count,0) > 0 then
1110: -- bulk update the table
1111: forall i in l_group_per_in_ler_id_tab.first..
1112: l_group_per_in_ler_id_tab.last
1113: update ben_cwb_summary
1114: set ws_bdgt_val_direct = l_ws_bdgt_val_direct_tab(i)
1115: ,ws_bdgt_iss_val_direct = l_ws_bdgt_iss_val_direct_tab(i)
1116: ,bdgt_val_direct = l_bdgt_val_direct_tab(i)
1117: ,bdgt_iss_val_direct = l_bdgt_iss_val_direct_tab(i)

Line 1169: -- bulk update the data into ben_cwb_summary

1165: hr_utility.set_location(l_proc, 100);
1166: end if;
1167: --
1168: if nvl(l_group_per_in_ler_id_tab.count,0) > 0 then
1169: -- bulk update the data into ben_cwb_summary
1170: forall i in l_group_per_in_ler_id_tab.first..
1171: l_group_per_in_ler_id_tab.last
1172: update ben_cwb_summary
1173: set elig_count_all = l_elig_count_all_tab(i)

Line 1172: update ben_cwb_summary

1168: if nvl(l_group_per_in_ler_id_tab.count,0) > 0 then
1169: -- bulk update the data into ben_cwb_summary
1170: forall i in l_group_per_in_ler_id_tab.first..
1171: l_group_per_in_ler_id_tab.last
1172: update ben_cwb_summary
1173: set elig_count_all = l_elig_count_all_tab(i)
1174: ,emp_recv_count_all = l_emp_recv_count_all_tab(i)
1175: ,elig_sal_val_all = l_elig_sal_val_all_tab(i)
1176: ,ws_val_all = l_ws_val_all_tab(i)

Line 1247: update ben_cwb_summary

1243: -- bulk update the table
1244: if nvl(l_group_per_in_ler_id_tab.count,0) > 0 then
1245: forall i in l_group_per_in_ler_id_tab.first..
1246: l_group_per_in_ler_id_tab.last
1247: update ben_cwb_summary
1248: set bdgt_val_direct = l_bdgt_val_direct_tab(i)
1249: ,bdgt_iss_val_direct = l_bdgt_iss_val_direct_tab(i)
1250: where group_per_in_ler_id = l_group_per_in_ler_id_tab(i)
1251: and group_pl_id = l_group_pl_id_tab(i)

Line 1330: ben_cwb_summary.group_per_in_ler_id%type;

1326: and xchg.currency = rt.currency
1327: group by hrchy.mgr_per_in_ler_id,rt.group_pl_id, rt.group_oipl_id;
1328: --
1329: type group_per_in_ler_id_type is table of
1330: ben_cwb_summary.group_per_in_ler_id%type;
1331: type group_pl_id_type is table of ben_cwb_summary.group_pl_id%type;
1332: type group_oipl_id_type is table of ben_cwb_summary.group_oipl_id%type;
1333: type elig_count_direct_type is table of
1334: ben_cwb_summary.elig_count_direct%type;

Line 1331: type group_pl_id_type is table of ben_cwb_summary.group_pl_id%type;

1327: group by hrchy.mgr_per_in_ler_id,rt.group_pl_id, rt.group_oipl_id;
1328: --
1329: type group_per_in_ler_id_type is table of
1330: ben_cwb_summary.group_per_in_ler_id%type;
1331: type group_pl_id_type is table of ben_cwb_summary.group_pl_id%type;
1332: type group_oipl_id_type is table of ben_cwb_summary.group_oipl_id%type;
1333: type elig_count_direct_type is table of
1334: ben_cwb_summary.elig_count_direct%type;
1335: type emp_recv_count_direct_type is table of

Line 1332: type group_oipl_id_type is table of ben_cwb_summary.group_oipl_id%type;

1328: --
1329: type group_per_in_ler_id_type is table of
1330: ben_cwb_summary.group_per_in_ler_id%type;
1331: type group_pl_id_type is table of ben_cwb_summary.group_pl_id%type;
1332: type group_oipl_id_type is table of ben_cwb_summary.group_oipl_id%type;
1333: type elig_count_direct_type is table of
1334: ben_cwb_summary.elig_count_direct%type;
1335: type emp_recv_count_direct_type is table of
1336: ben_cwb_summary.emp_recv_count_direct%type;

Line 1334: ben_cwb_summary.elig_count_direct%type;

1330: ben_cwb_summary.group_per_in_ler_id%type;
1331: type group_pl_id_type is table of ben_cwb_summary.group_pl_id%type;
1332: type group_oipl_id_type is table of ben_cwb_summary.group_oipl_id%type;
1333: type elig_count_direct_type is table of
1334: ben_cwb_summary.elig_count_direct%type;
1335: type emp_recv_count_direct_type is table of
1336: ben_cwb_summary.emp_recv_count_direct%type;
1337: type elig_sal_val_direct_type is table of
1338: ben_cwb_summary.elig_sal_val_direct%type;

Line 1336: ben_cwb_summary.emp_recv_count_direct%type;

1332: type group_oipl_id_type is table of ben_cwb_summary.group_oipl_id%type;
1333: type elig_count_direct_type is table of
1334: ben_cwb_summary.elig_count_direct%type;
1335: type emp_recv_count_direct_type is table of
1336: ben_cwb_summary.emp_recv_count_direct%type;
1337: type elig_sal_val_direct_type is table of
1338: ben_cwb_summary.elig_sal_val_direct%type;
1339: type ws_val_direct_type is table of ben_cwb_summary.ws_val_direct%type;
1340: type stat_sal_val_direct_type is table of

Line 1338: ben_cwb_summary.elig_sal_val_direct%type;

1334: ben_cwb_summary.elig_count_direct%type;
1335: type emp_recv_count_direct_type is table of
1336: ben_cwb_summary.emp_recv_count_direct%type;
1337: type elig_sal_val_direct_type is table of
1338: ben_cwb_summary.elig_sal_val_direct%type;
1339: type ws_val_direct_type is table of ben_cwb_summary.ws_val_direct%type;
1340: type stat_sal_val_direct_type is table of
1341: ben_cwb_summary.stat_sal_val_direct%type;
1342: type oth_comp_val_direct_type is table of

Line 1339: type ws_val_direct_type is table of ben_cwb_summary.ws_val_direct%type;

1335: type emp_recv_count_direct_type is table of
1336: ben_cwb_summary.emp_recv_count_direct%type;
1337: type elig_sal_val_direct_type is table of
1338: ben_cwb_summary.elig_sal_val_direct%type;
1339: type ws_val_direct_type is table of ben_cwb_summary.ws_val_direct%type;
1340: type stat_sal_val_direct_type is table of
1341: ben_cwb_summary.stat_sal_val_direct%type;
1342: type oth_comp_val_direct_type is table of
1343: ben_cwb_summary.oth_comp_val_direct%type;

Line 1341: ben_cwb_summary.stat_sal_val_direct%type;

1337: type elig_sal_val_direct_type is table of
1338: ben_cwb_summary.elig_sal_val_direct%type;
1339: type ws_val_direct_type is table of ben_cwb_summary.ws_val_direct%type;
1340: type stat_sal_val_direct_type is table of
1341: ben_cwb_summary.stat_sal_val_direct%type;
1342: type oth_comp_val_direct_type is table of
1343: ben_cwb_summary.oth_comp_val_direct%type;
1344: type tot_comp_val_direct_type is table of
1345: ben_cwb_summary.tot_comp_val_direct%type;

Line 1343: ben_cwb_summary.oth_comp_val_direct%type;

1339: type ws_val_direct_type is table of ben_cwb_summary.ws_val_direct%type;
1340: type stat_sal_val_direct_type is table of
1341: ben_cwb_summary.stat_sal_val_direct%type;
1342: type oth_comp_val_direct_type is table of
1343: ben_cwb_summary.oth_comp_val_direct%type;
1344: type tot_comp_val_direct_type is table of
1345: ben_cwb_summary.tot_comp_val_direct%type;
1346: type rec_val_direct_type is table of ben_cwb_summary.rec_val_direct%type;
1347: type rec_mn_val_direct_type is table of

Line 1345: ben_cwb_summary.tot_comp_val_direct%type;

1341: ben_cwb_summary.stat_sal_val_direct%type;
1342: type oth_comp_val_direct_type is table of
1343: ben_cwb_summary.oth_comp_val_direct%type;
1344: type tot_comp_val_direct_type is table of
1345: ben_cwb_summary.tot_comp_val_direct%type;
1346: type rec_val_direct_type is table of ben_cwb_summary.rec_val_direct%type;
1347: type rec_mn_val_direct_type is table of
1348: ben_cwb_summary.rec_mn_val_direct%type;
1349: type rec_mx_val_direct_type is table of

Line 1346: type rec_val_direct_type is table of ben_cwb_summary.rec_val_direct%type;

1342: type oth_comp_val_direct_type is table of
1343: ben_cwb_summary.oth_comp_val_direct%type;
1344: type tot_comp_val_direct_type is table of
1345: ben_cwb_summary.tot_comp_val_direct%type;
1346: type rec_val_direct_type is table of ben_cwb_summary.rec_val_direct%type;
1347: type rec_mn_val_direct_type is table of
1348: ben_cwb_summary.rec_mn_val_direct%type;
1349: type rec_mx_val_direct_type is table of
1350: ben_cwb_summary.rec_mx_val_direct%type;

Line 1348: ben_cwb_summary.rec_mn_val_direct%type;

1344: type tot_comp_val_direct_type is table of
1345: ben_cwb_summary.tot_comp_val_direct%type;
1346: type rec_val_direct_type is table of ben_cwb_summary.rec_val_direct%type;
1347: type rec_mn_val_direct_type is table of
1348: ben_cwb_summary.rec_mn_val_direct%type;
1349: type rec_mx_val_direct_type is table of
1350: ben_cwb_summary.rec_mx_val_direct%type;
1351: type misc1_val_direct_type is table of
1352: ben_cwb_summary.misc1_val_direct%type;

Line 1350: ben_cwb_summary.rec_mx_val_direct%type;

1346: type rec_val_direct_type is table of ben_cwb_summary.rec_val_direct%type;
1347: type rec_mn_val_direct_type is table of
1348: ben_cwb_summary.rec_mn_val_direct%type;
1349: type rec_mx_val_direct_type is table of
1350: ben_cwb_summary.rec_mx_val_direct%type;
1351: type misc1_val_direct_type is table of
1352: ben_cwb_summary.misc1_val_direct%type;
1353: type misc2_val_direct_type is table of
1354: ben_cwb_summary.misc2_val_direct%type;

Line 1352: ben_cwb_summary.misc1_val_direct%type;

1348: ben_cwb_summary.rec_mn_val_direct%type;
1349: type rec_mx_val_direct_type is table of
1350: ben_cwb_summary.rec_mx_val_direct%type;
1351: type misc1_val_direct_type is table of
1352: ben_cwb_summary.misc1_val_direct%type;
1353: type misc2_val_direct_type is table of
1354: ben_cwb_summary.misc2_val_direct%type;
1355: type misc3_val_direct_type is table of
1356: ben_cwb_summary.misc3_val_direct%type;

Line 1354: ben_cwb_summary.misc2_val_direct%type;

1350: ben_cwb_summary.rec_mx_val_direct%type;
1351: type misc1_val_direct_type is table of
1352: ben_cwb_summary.misc1_val_direct%type;
1353: type misc2_val_direct_type is table of
1354: ben_cwb_summary.misc2_val_direct%type;
1355: type misc3_val_direct_type is table of
1356: ben_cwb_summary.misc3_val_direct%type;
1357: --
1358: l_group_per_in_ler_id_tab group_per_in_ler_id_type;

Line 1356: ben_cwb_summary.misc3_val_direct%type;

1352: ben_cwb_summary.misc1_val_direct%type;
1353: type misc2_val_direct_type is table of
1354: ben_cwb_summary.misc2_val_direct%type;
1355: type misc3_val_direct_type is table of
1356: ben_cwb_summary.misc3_val_direct%type;
1357: --
1358: l_group_per_in_ler_id_tab group_per_in_ler_id_type;
1359: l_group_pl_id_tab group_pl_id_type;
1360: l_group_oipl_id_tab group_oipl_id_type;

Line 1395: -- delete all the summary rows from ben_cwb_summary for

1391: --
1392: insert_refresh_job_marker(p_group_pl_id => p_group_pl_id
1393: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt);
1394: --
1395: -- delete all the summary rows from ben_cwb_summary for
1396: -- this group_pl_id and lf_evt_ocrd_dt
1397: delete from ben_cwb_summary summ
1398: where group_pl_id = p_group_pl_id
1399: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

Line 1397: delete from ben_cwb_summary summ

1393: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt);
1394: --
1395: -- delete all the summary rows from ben_cwb_summary for
1396: -- this group_pl_id and lf_evt_ocrd_dt
1397: delete from ben_cwb_summary summ
1398: where group_pl_id = p_group_pl_id
1399: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
1400: and group_per_in_ler_id <> -1;
1401: --

Line 1409: insert into ben_cwb_summary

1405: --
1406: -- Insert an empty summary row for each managers. This summary row
1407: -- will contain only the group_per_in_ler_id, group_pl_id, group_oipl_id,
1408: -- person_id and lf_evt_ocrd_dt
1409: insert into ben_cwb_summary
1410: (summary_id
1411: ,group_per_in_ler_id
1412: ,group_pl_id
1413: ,group_oipl_id

Line 1416: select ben_cwb_summary_s.nextval

1412: ,group_pl_id
1413: ,group_oipl_id
1414: ,person_id
1415: ,lf_evt_ocrd_dt)
1416: select ben_cwb_summary_s.nextval
1417: ,hrchy.emp_per_in_ler_id
1418: ,p_group_pl_id
1419: ,grp.group_oipl_id
1420: ,pil.person_id

Line 1464: update ben_cwb_summary

1460: --
1461: if (nvl(l_group_per_in_ler_id_tab.count,0) > 0)then
1462: forall i in l_group_per_in_ler_id_tab.first..
1463: l_group_per_in_ler_id_tab.last
1464: update ben_cwb_summary
1465: set elig_count_direct = l_elig_count_direct_tab(i)
1466: ,emp_recv_count_direct = l_emp_recv_count_direct_tab(i)
1467: ,elig_sal_val_direct = l_elig_sal_val_direct_tab(i)
1468: ,ws_val_direct = l_ws_val_direct_tab(i)

Line 1554: ,ben_cwb_summary summ

1550: summ.elig_sal_val_direct, summ.elig_sal_val_all) / 100)
1551: bdgt_iss_val_direct
1552: from ben_cwb_group_hrchy hrchy
1553: ,ben_cwb_person_groups grp
1554: ,ben_cwb_summary summ
1555: where hrchy.mgr_per_in_ler_id = p_group_per_in_ler_id
1556: and hrchy.lvl_num = 1
1557: and grp.group_per_in_ler_id = hrchy.emp_per_in_ler_id
1558: and summ.group_per_in_ler_id (+)= grp.group_per_in_ler_id

Line 1592: ,ben_cwb_summary summ

1588: ,sum(grp.ws_bdgt_iss_val * summ.elig_sal_val_direct / 100)
1589: ws_bdgt_iss_val_all
1590: from ben_cwb_group_hrchy hrchy
1591: ,ben_cwb_person_groups grp
1592: ,ben_cwb_summary summ
1593: where hrchy.mgr_per_in_ler_id = p_group_per_in_ler_id
1594: and hrchy.lvl_num >= 1
1595: and grp.group_per_in_ler_id = hrchy.emp_per_in_ler_id
1596: and summ.group_per_in_ler_id (+)= grp.group_per_in_ler_id

Line 1624: from ben_cwb_summary

1620: ,sum(ws_bdgt_iss_val_direct) ws_bdgt_iss_val_direct
1621: ,sum(ws_bdgt_iss_val_all) ws_bdgt_iss_val_all
1622: ,sum(bdgt_val_direct) bdgt_val_direct
1623: ,sum(bdgt_iss_val_direct) bdgt_iss_val
1624: from ben_cwb_summary
1625: where group_per_in_ler_id = p_group_per_in_ler_id
1626: group by group_pl_id, group_oipl_id
1627: order by group_pl_id, group_oipl_id;
1628: --

Line 1631: ben_cwb_summary.group_pl_id%type;

1627: order by group_pl_id, group_oipl_id;
1628: --
1629: -- Type delcarations for pl/sql tables
1630: type group_pl_id_type is table of
1631: ben_cwb_summary.group_pl_id%type;
1632: type group_oipl_id_type is table of
1633: ben_cwb_summary.group_oipl_id%type;
1634: type ws_bdgt_val_direct_type is table of
1635: ben_cwb_summary.ws_bdgt_val_direct%type;

Line 1633: ben_cwb_summary.group_oipl_id%type;

1629: -- Type delcarations for pl/sql tables
1630: type group_pl_id_type is table of
1631: ben_cwb_summary.group_pl_id%type;
1632: type group_oipl_id_type is table of
1633: ben_cwb_summary.group_oipl_id%type;
1634: type ws_bdgt_val_direct_type is table of
1635: ben_cwb_summary.ws_bdgt_val_direct%type;
1636: type ws_bdgt_val_all_type is table of
1637: ben_cwb_summary.ws_bdgt_val_all%type;

Line 1635: ben_cwb_summary.ws_bdgt_val_direct%type;

1631: ben_cwb_summary.group_pl_id%type;
1632: type group_oipl_id_type is table of
1633: ben_cwb_summary.group_oipl_id%type;
1634: type ws_bdgt_val_direct_type is table of
1635: ben_cwb_summary.ws_bdgt_val_direct%type;
1636: type ws_bdgt_val_all_type is table of
1637: ben_cwb_summary.ws_bdgt_val_all%type;
1638: type ws_bdgt_iss_val_direct_type is table of
1639: ben_cwb_summary.ws_bdgt_iss_val_direct%type;

Line 1637: ben_cwb_summary.ws_bdgt_val_all%type;

1633: ben_cwb_summary.group_oipl_id%type;
1634: type ws_bdgt_val_direct_type is table of
1635: ben_cwb_summary.ws_bdgt_val_direct%type;
1636: type ws_bdgt_val_all_type is table of
1637: ben_cwb_summary.ws_bdgt_val_all%type;
1638: type ws_bdgt_iss_val_direct_type is table of
1639: ben_cwb_summary.ws_bdgt_iss_val_direct%type;
1640: type ws_bdgt_iss_val_all_type is table of
1641: ben_cwb_summary.ws_bdgt_iss_val_all%type;

Line 1639: ben_cwb_summary.ws_bdgt_iss_val_direct%type;

1635: ben_cwb_summary.ws_bdgt_val_direct%type;
1636: type ws_bdgt_val_all_type is table of
1637: ben_cwb_summary.ws_bdgt_val_all%type;
1638: type ws_bdgt_iss_val_direct_type is table of
1639: ben_cwb_summary.ws_bdgt_iss_val_direct%type;
1640: type ws_bdgt_iss_val_all_type is table of
1641: ben_cwb_summary.ws_bdgt_iss_val_all%type;
1642: type bdgt_val_direct_type is table of
1643: ben_cwb_summary.bdgt_val_direct%type;

Line 1641: ben_cwb_summary.ws_bdgt_iss_val_all%type;

1637: ben_cwb_summary.ws_bdgt_val_all%type;
1638: type ws_bdgt_iss_val_direct_type is table of
1639: ben_cwb_summary.ws_bdgt_iss_val_direct%type;
1640: type ws_bdgt_iss_val_all_type is table of
1641: ben_cwb_summary.ws_bdgt_iss_val_all%type;
1642: type bdgt_val_direct_type is table of
1643: ben_cwb_summary.bdgt_val_direct%type;
1644: type bdgt_iss_val_direct_type is table of
1645: ben_cwb_summary.bdgt_iss_val_direct%type;

Line 1643: ben_cwb_summary.bdgt_val_direct%type;

1639: ben_cwb_summary.ws_bdgt_iss_val_direct%type;
1640: type ws_bdgt_iss_val_all_type is table of
1641: ben_cwb_summary.ws_bdgt_iss_val_all%type;
1642: type bdgt_val_direct_type is table of
1643: ben_cwb_summary.bdgt_val_direct%type;
1644: type bdgt_iss_val_direct_type is table of
1645: ben_cwb_summary.bdgt_iss_val_direct%type;
1646: --
1647: l_group_pl_id_tab group_pl_id_type;

Line 1645: ben_cwb_summary.bdgt_iss_val_direct%type;

1641: ben_cwb_summary.ws_bdgt_iss_val_all%type;
1642: type bdgt_val_direct_type is table of
1643: ben_cwb_summary.bdgt_val_direct%type;
1644: type bdgt_iss_val_direct_type is table of
1645: ben_cwb_summary.bdgt_iss_val_direct%type;
1646: --
1647: l_group_pl_id_tab group_pl_id_type;
1648: l_group_oipl_id_tab group_oipl_id_type;
1649: l_ws_bdgt_val_direct_tab ws_bdgt_val_direct_type;

Line 1859: from ben_cwb_summary sm

1855: and grp.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
1856: and grp.group_per_in_ler_id = pil.per_in_ler_id
1857: and pil.per_in_ler_stat_cd in ('PROCD','STRTD')
1858: and not exists (select 'Y'
1859: from ben_cwb_summary sm
1860: where sm.group_per_in_ler_id = grp.group_per_in_ler_id
1861: and sm.group_pl_id = grp.group_pl_id
1862: and sm.group_oipl_id = grp.group_oipl_id)
1863: group by hrchy.mgr_per_in_ler_id, group_oipl_id, pil.person_id;

Line 1928: ,ben_cwb_summary summ

1924: ,sum(misc1_val_direct) misc1_val
1925: ,sum(misc2_val_direct) misc2_val
1926: ,sum(misc3_val_direct) misc3_val
1927: from ben_cwb_group_hrchy hrchy
1928: ,ben_cwb_summary summ
1929: where hrchy.mgr_per_in_ler_id = v_group_per_in_ler_id
1930: and hrchy.lvl_num >=0
1931: and hrchy.emp_per_in_ler_id = summ.group_per_in_ler_id
1932: group by hrchy.mgr_per_in_ler_id, summ.group_pl_id, summ.group_oipl_id;

Line 2000: insert into ben_cwb_summary

1996: -- will contain only the group_per_in_ler_id, group_pl_id, group_oipl_id,
1997: -- person_id and lf_evt_ocrd_dt
1998: for l_empty_summ in csr_empty_summary(p_group_pl_id,p_lf_evt_ocrd_dt) loop
1999: --
2000: insert into ben_cwb_summary
2001: (summary_id
2002: ,group_per_in_ler_id
2003: ,group_pl_id
2004: ,group_oipl_id

Line 2007: values (ben_cwb_summary_s.nextval

2003: ,group_pl_id
2004: ,group_oipl_id
2005: ,person_id
2006: ,lf_evt_ocrd_dt)
2007: values (ben_cwb_summary_s.nextval
2008: ,l_empty_summ.mgr_per_in_ler_id
2009: ,l_empty_summ.group_pl_id
2010: ,l_empty_summ.group_oipl_id
2011: ,l_empty_summ.person_id

Line 2474: from ben_cwb_summary sm

2470: cursor c_summary is
2471: select sum(sm.elig_count_all)-sum(sm.elig_count_direct) indirect_count
2472: ,sum(sm.elig_count_all) all_count
2473: ,max(grp.bdgt_pop_cd) bdgt_pop_cd
2474: from ben_cwb_summary sm
2475: ,ben_cwb_person_groups grp
2476: where sm.group_per_in_ler_id = l_per_in_ler_id
2477: and sm.group_oipl_id = -1
2478: and sm.group_per_in_ler_id = grp.group_per_in_ler_id

Line 2642: ben_cwb_summary.group_pl_id%type index by binary_integer;

2638:
2639:
2640: -- Type delcarations for pl/sql tables
2641: type group_pl_id_type is table of
2642: ben_cwb_summary.group_pl_id%type index by binary_integer;
2643: type group_oipl_id_type is table of
2644: ben_cwb_summary.group_oipl_id%type index by binary_integer;
2645: type elig_count_direct_type is table of
2646: ben_cwb_summary.elig_count_direct%type index by binary_integer;

Line 2644: ben_cwb_summary.group_oipl_id%type index by binary_integer;

2640: -- Type delcarations for pl/sql tables
2641: type group_pl_id_type is table of
2642: ben_cwb_summary.group_pl_id%type index by binary_integer;
2643: type group_oipl_id_type is table of
2644: ben_cwb_summary.group_oipl_id%type index by binary_integer;
2645: type elig_count_direct_type is table of
2646: ben_cwb_summary.elig_count_direct%type index by binary_integer;
2647: type elig_count_all_type is table of
2648: ben_cwb_summary.elig_count_all%type index by binary_integer;

Line 2646: ben_cwb_summary.elig_count_direct%type index by binary_integer;

2642: ben_cwb_summary.group_pl_id%type index by binary_integer;
2643: type group_oipl_id_type is table of
2644: ben_cwb_summary.group_oipl_id%type index by binary_integer;
2645: type elig_count_direct_type is table of
2646: ben_cwb_summary.elig_count_direct%type index by binary_integer;
2647: type elig_count_all_type is table of
2648: ben_cwb_summary.elig_count_all%type index by binary_integer;
2649: type emp_recv_count_direct_type is table of
2650: ben_cwb_summary.emp_recv_count_direct%type index by binary_integer;

Line 2648: ben_cwb_summary.elig_count_all%type index by binary_integer;

2644: ben_cwb_summary.group_oipl_id%type index by binary_integer;
2645: type elig_count_direct_type is table of
2646: ben_cwb_summary.elig_count_direct%type index by binary_integer;
2647: type elig_count_all_type is table of
2648: ben_cwb_summary.elig_count_all%type index by binary_integer;
2649: type emp_recv_count_direct_type is table of
2650: ben_cwb_summary.emp_recv_count_direct%type index by binary_integer;
2651: type emp_recv_count_all_type is table of
2652: ben_cwb_summary. emp_recv_count_all%type index by binary_integer;

Line 2650: ben_cwb_summary.emp_recv_count_direct%type index by binary_integer;

2646: ben_cwb_summary.elig_count_direct%type index by binary_integer;
2647: type elig_count_all_type is table of
2648: ben_cwb_summary.elig_count_all%type index by binary_integer;
2649: type emp_recv_count_direct_type is table of
2650: ben_cwb_summary.emp_recv_count_direct%type index by binary_integer;
2651: type emp_recv_count_all_type is table of
2652: ben_cwb_summary. emp_recv_count_all%type index by binary_integer;
2653: type elig_sal_val_all_type is table of
2654: ben_cwb_summary.elig_sal_val_all%type index by binary_integer;

Line 2652: ben_cwb_summary. emp_recv_count_all%type index by binary_integer;

2648: ben_cwb_summary.elig_count_all%type index by binary_integer;
2649: type emp_recv_count_direct_type is table of
2650: ben_cwb_summary.emp_recv_count_direct%type index by binary_integer;
2651: type emp_recv_count_all_type is table of
2652: ben_cwb_summary. emp_recv_count_all%type index by binary_integer;
2653: type elig_sal_val_all_type is table of
2654: ben_cwb_summary.elig_sal_val_all%type index by binary_integer;
2655: type ws_val_direct_type is table of
2656: ben_cwb_summary.ws_val_direct%type index by binary_integer;

Line 2654: ben_cwb_summary.elig_sal_val_all%type index by binary_integer;

2650: ben_cwb_summary.emp_recv_count_direct%type index by binary_integer;
2651: type emp_recv_count_all_type is table of
2652: ben_cwb_summary. emp_recv_count_all%type index by binary_integer;
2653: type elig_sal_val_all_type is table of
2654: ben_cwb_summary.elig_sal_val_all%type index by binary_integer;
2655: type ws_val_direct_type is table of
2656: ben_cwb_summary.ws_val_direct%type index by binary_integer;
2657: type ws_val_all_type is table of
2658: ben_cwb_summary.ws_val_all%type index by binary_integer;

Line 2656: ben_cwb_summary.ws_val_direct%type index by binary_integer;

2652: ben_cwb_summary. emp_recv_count_all%type index by binary_integer;
2653: type elig_sal_val_all_type is table of
2654: ben_cwb_summary.elig_sal_val_all%type index by binary_integer;
2655: type ws_val_direct_type is table of
2656: ben_cwb_summary.ws_val_direct%type index by binary_integer;
2657: type ws_val_all_type is table of
2658: ben_cwb_summary.ws_val_all%type index by binary_integer;
2659: type stat_sal_val_direct_type is table of
2660: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;

Line 2658: ben_cwb_summary.ws_val_all%type index by binary_integer;

2654: ben_cwb_summary.elig_sal_val_all%type index by binary_integer;
2655: type ws_val_direct_type is table of
2656: ben_cwb_summary.ws_val_direct%type index by binary_integer;
2657: type ws_val_all_type is table of
2658: ben_cwb_summary.ws_val_all%type index by binary_integer;
2659: type stat_sal_val_direct_type is table of
2660: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;
2661: type stat_sal_val_all_type is table of
2662: ben_cwb_summary.stat_sal_val_all%type index by binary_integer;

Line 2660: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;

2656: ben_cwb_summary.ws_val_direct%type index by binary_integer;
2657: type ws_val_all_type is table of
2658: ben_cwb_summary.ws_val_all%type index by binary_integer;
2659: type stat_sal_val_direct_type is table of
2660: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;
2661: type stat_sal_val_all_type is table of
2662: ben_cwb_summary.stat_sal_val_all%type index by binary_integer;
2663: type oth_comp_val_direct_type is table of
2664: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;

Line 2662: ben_cwb_summary.stat_sal_val_all%type index by binary_integer;

2658: ben_cwb_summary.ws_val_all%type index by binary_integer;
2659: type stat_sal_val_direct_type is table of
2660: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;
2661: type stat_sal_val_all_type is table of
2662: ben_cwb_summary.stat_sal_val_all%type index by binary_integer;
2663: type oth_comp_val_direct_type is table of
2664: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;
2665: type oth_comp_val_all_type is table of
2666: ben_cwb_summary.oth_comp_val_all%type index by binary_integer;

Line 2664: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;

2660: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;
2661: type stat_sal_val_all_type is table of
2662: ben_cwb_summary.stat_sal_val_all%type index by binary_integer;
2663: type oth_comp_val_direct_type is table of
2664: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;
2665: type oth_comp_val_all_type is table of
2666: ben_cwb_summary.oth_comp_val_all%type index by binary_integer;
2667: type tot_comp_val_direct_type is table of
2668: ben_cwb_summary.tot_comp_val_direct%type index by binary_integer;

Line 2666: ben_cwb_summary.oth_comp_val_all%type index by binary_integer;

2662: ben_cwb_summary.stat_sal_val_all%type index by binary_integer;
2663: type oth_comp_val_direct_type is table of
2664: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;
2665: type oth_comp_val_all_type is table of
2666: ben_cwb_summary.oth_comp_val_all%type index by binary_integer;
2667: type tot_comp_val_direct_type is table of
2668: ben_cwb_summary.tot_comp_val_direct%type index by binary_integer;
2669: type tot_comp_val_all_type is table of
2670: ben_cwb_summary.tot_comp_val_all%type index by binary_integer;

Line 2668: ben_cwb_summary.tot_comp_val_direct%type index by binary_integer;

2664: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;
2665: type oth_comp_val_all_type is table of
2666: ben_cwb_summary.oth_comp_val_all%type index by binary_integer;
2667: type tot_comp_val_direct_type is table of
2668: ben_cwb_summary.tot_comp_val_direct%type index by binary_integer;
2669: type tot_comp_val_all_type is table of
2670: ben_cwb_summary.tot_comp_val_all%type index by binary_integer;
2671: type rec_val_direct_type is table of
2672: ben_cwb_summary.rec_val_direct%type index by binary_integer;

Line 2670: ben_cwb_summary.tot_comp_val_all%type index by binary_integer;

2666: ben_cwb_summary.oth_comp_val_all%type index by binary_integer;
2667: type tot_comp_val_direct_type is table of
2668: ben_cwb_summary.tot_comp_val_direct%type index by binary_integer;
2669: type tot_comp_val_all_type is table of
2670: ben_cwb_summary.tot_comp_val_all%type index by binary_integer;
2671: type rec_val_direct_type is table of
2672: ben_cwb_summary.rec_val_direct%type index by binary_integer;
2673: type rec_val_all_type is table of
2674: ben_cwb_summary.rec_val_all%type index by binary_integer;

Line 2672: ben_cwb_summary.rec_val_direct%type index by binary_integer;

2668: ben_cwb_summary.tot_comp_val_direct%type index by binary_integer;
2669: type tot_comp_val_all_type is table of
2670: ben_cwb_summary.tot_comp_val_all%type index by binary_integer;
2671: type rec_val_direct_type is table of
2672: ben_cwb_summary.rec_val_direct%type index by binary_integer;
2673: type rec_val_all_type is table of
2674: ben_cwb_summary.rec_val_all%type index by binary_integer;
2675: type rec_mn_val_direct_type is table of
2676: ben_cwb_summary.rec_mn_val_direct%type index by binary_integer;

Line 2674: ben_cwb_summary.rec_val_all%type index by binary_integer;

2670: ben_cwb_summary.tot_comp_val_all%type index by binary_integer;
2671: type rec_val_direct_type is table of
2672: ben_cwb_summary.rec_val_direct%type index by binary_integer;
2673: type rec_val_all_type is table of
2674: ben_cwb_summary.rec_val_all%type index by binary_integer;
2675: type rec_mn_val_direct_type is table of
2676: ben_cwb_summary.rec_mn_val_direct%type index by binary_integer;
2677: type rec_mn_val_all_type is table of
2678: ben_cwb_summary.rec_mn_val_all%type index by binary_integer;

Line 2676: ben_cwb_summary.rec_mn_val_direct%type index by binary_integer;

2672: ben_cwb_summary.rec_val_direct%type index by binary_integer;
2673: type rec_val_all_type is table of
2674: ben_cwb_summary.rec_val_all%type index by binary_integer;
2675: type rec_mn_val_direct_type is table of
2676: ben_cwb_summary.rec_mn_val_direct%type index by binary_integer;
2677: type rec_mn_val_all_type is table of
2678: ben_cwb_summary.rec_mn_val_all%type index by binary_integer;
2679: type rec_mx_val_direct_type is table of
2680: ben_cwb_summary.rec_mx_val_direct%type index by binary_integer;

Line 2678: ben_cwb_summary.rec_mn_val_all%type index by binary_integer;

2674: ben_cwb_summary.rec_val_all%type index by binary_integer;
2675: type rec_mn_val_direct_type is table of
2676: ben_cwb_summary.rec_mn_val_direct%type index by binary_integer;
2677: type rec_mn_val_all_type is table of
2678: ben_cwb_summary.rec_mn_val_all%type index by binary_integer;
2679: type rec_mx_val_direct_type is table of
2680: ben_cwb_summary.rec_mx_val_direct%type index by binary_integer;
2681: type rec_mx_val_all_type is table of
2682: ben_cwb_summary.rec_mx_val_all%type index by binary_integer;

Line 2680: ben_cwb_summary.rec_mx_val_direct%type index by binary_integer;

2676: ben_cwb_summary.rec_mn_val_direct%type index by binary_integer;
2677: type rec_mn_val_all_type is table of
2678: ben_cwb_summary.rec_mn_val_all%type index by binary_integer;
2679: type rec_mx_val_direct_type is table of
2680: ben_cwb_summary.rec_mx_val_direct%type index by binary_integer;
2681: type rec_mx_val_all_type is table of
2682: ben_cwb_summary.rec_mx_val_all%type index by binary_integer;
2683: type misc1_val_direct_type is table of
2684: ben_cwb_summary.misc1_val_direct%type index by binary_integer;

Line 2682: ben_cwb_summary.rec_mx_val_all%type index by binary_integer;

2678: ben_cwb_summary.rec_mn_val_all%type index by binary_integer;
2679: type rec_mx_val_direct_type is table of
2680: ben_cwb_summary.rec_mx_val_direct%type index by binary_integer;
2681: type rec_mx_val_all_type is table of
2682: ben_cwb_summary.rec_mx_val_all%type index by binary_integer;
2683: type misc1_val_direct_type is table of
2684: ben_cwb_summary.misc1_val_direct%type index by binary_integer;
2685: type misc1_val_all_type is table of
2686: ben_cwb_summary.misc1_val_all%type index by binary_integer;

Line 2684: ben_cwb_summary.misc1_val_direct%type index by binary_integer;

2680: ben_cwb_summary.rec_mx_val_direct%type index by binary_integer;
2681: type rec_mx_val_all_type is table of
2682: ben_cwb_summary.rec_mx_val_all%type index by binary_integer;
2683: type misc1_val_direct_type is table of
2684: ben_cwb_summary.misc1_val_direct%type index by binary_integer;
2685: type misc1_val_all_type is table of
2686: ben_cwb_summary.misc1_val_all%type index by binary_integer;
2687: type misc2_val_direct_type is table of
2688: ben_cwb_summary.misc2_val_direct%type index by binary_integer;

Line 2686: ben_cwb_summary.misc1_val_all%type index by binary_integer;

2682: ben_cwb_summary.rec_mx_val_all%type index by binary_integer;
2683: type misc1_val_direct_type is table of
2684: ben_cwb_summary.misc1_val_direct%type index by binary_integer;
2685: type misc1_val_all_type is table of
2686: ben_cwb_summary.misc1_val_all%type index by binary_integer;
2687: type misc2_val_direct_type is table of
2688: ben_cwb_summary.misc2_val_direct%type index by binary_integer;
2689: type misc2_val_all_type is table of
2690: ben_cwb_summary.misc2_val_all%type index by binary_integer;

Line 2688: ben_cwb_summary.misc2_val_direct%type index by binary_integer;

2684: ben_cwb_summary.misc1_val_direct%type index by binary_integer;
2685: type misc1_val_all_type is table of
2686: ben_cwb_summary.misc1_val_all%type index by binary_integer;
2687: type misc2_val_direct_type is table of
2688: ben_cwb_summary.misc2_val_direct%type index by binary_integer;
2689: type misc2_val_all_type is table of
2690: ben_cwb_summary.misc2_val_all%type index by binary_integer;
2691: type misc3_val_direct_type is table of
2692: ben_cwb_summary.misc3_val_direct%type index by binary_integer;

Line 2690: ben_cwb_summary.misc2_val_all%type index by binary_integer;

2686: ben_cwb_summary.misc1_val_all%type index by binary_integer;
2687: type misc2_val_direct_type is table of
2688: ben_cwb_summary.misc2_val_direct%type index by binary_integer;
2689: type misc2_val_all_type is table of
2690: ben_cwb_summary.misc2_val_all%type index by binary_integer;
2691: type misc3_val_direct_type is table of
2692: ben_cwb_summary.misc3_val_direct%type index by binary_integer;
2693: type misc3_val_all_type is table of
2694: ben_cwb_summary.misc3_val_all%type index by binary_integer;

Line 2692: ben_cwb_summary.misc3_val_direct%type index by binary_integer;

2688: ben_cwb_summary.misc2_val_direct%type index by binary_integer;
2689: type misc2_val_all_type is table of
2690: ben_cwb_summary.misc2_val_all%type index by binary_integer;
2691: type misc3_val_direct_type is table of
2692: ben_cwb_summary.misc3_val_direct%type index by binary_integer;
2693: type misc3_val_all_type is table of
2694: ben_cwb_summary.misc3_val_all%type index by binary_integer;
2695: type person_id_type is table of
2696: ben_cwb_summary.person_id%type index by binary_integer;

Line 2694: ben_cwb_summary.misc3_val_all%type index by binary_integer;

2690: ben_cwb_summary.misc2_val_all%type index by binary_integer;
2691: type misc3_val_direct_type is table of
2692: ben_cwb_summary.misc3_val_direct%type index by binary_integer;
2693: type misc3_val_all_type is table of
2694: ben_cwb_summary.misc3_val_all%type index by binary_integer;
2695: type person_id_type is table of
2696: ben_cwb_summary.person_id%type index by binary_integer;
2697: --
2698: -- declare pl/sql tables

Line 2696: ben_cwb_summary.person_id%type index by binary_integer;

2692: ben_cwb_summary.misc3_val_direct%type index by binary_integer;
2693: type misc3_val_all_type is table of
2694: ben_cwb_summary.misc3_val_all%type index by binary_integer;
2695: type person_id_type is table of
2696: ben_cwb_summary.person_id%type index by binary_integer;
2697: --
2698: -- declare pl/sql tables
2699: l_rts_group_pl_id_tab group_pl_id_type;
2700: l_rts_group_oipl_id_tab group_oipl_id_type;

Line 3150: ben_cwb_summary.group_pl_id%type index by binary_integer;

3146: ,p_emp_per_in_ler_id in number) is
3147:
3148: -- Type delcarations for pl/sql tables
3149: type group_pl_id_type is table of
3150: ben_cwb_summary.group_pl_id%type index by binary_integer;
3151: type group_oipl_id_type is table of
3152: ben_cwb_summary.group_oipl_id%type index by binary_integer;
3153: type elig_count_direct_type is table of
3154: ben_cwb_summary.elig_count_direct%type index by binary_integer;

Line 3152: ben_cwb_summary.group_oipl_id%type index by binary_integer;

3148: -- Type delcarations for pl/sql tables
3149: type group_pl_id_type is table of
3150: ben_cwb_summary.group_pl_id%type index by binary_integer;
3151: type group_oipl_id_type is table of
3152: ben_cwb_summary.group_oipl_id%type index by binary_integer;
3153: type elig_count_direct_type is table of
3154: ben_cwb_summary.elig_count_direct%type index by binary_integer;
3155: type emp_recv_count_direct_type is table of
3156: ben_cwb_summary.emp_recv_count_direct%type index by binary_integer;

Line 3154: ben_cwb_summary.elig_count_direct%type index by binary_integer;

3150: ben_cwb_summary.group_pl_id%type index by binary_integer;
3151: type group_oipl_id_type is table of
3152: ben_cwb_summary.group_oipl_id%type index by binary_integer;
3153: type elig_count_direct_type is table of
3154: ben_cwb_summary.elig_count_direct%type index by binary_integer;
3155: type emp_recv_count_direct_type is table of
3156: ben_cwb_summary.emp_recv_count_direct%type index by binary_integer;
3157: type elig_sal_val_direct_type is table of
3158: ben_cwb_summary.elig_sal_val_direct%type index by binary_integer;

Line 3156: ben_cwb_summary.emp_recv_count_direct%type index by binary_integer;

3152: ben_cwb_summary.group_oipl_id%type index by binary_integer;
3153: type elig_count_direct_type is table of
3154: ben_cwb_summary.elig_count_direct%type index by binary_integer;
3155: type emp_recv_count_direct_type is table of
3156: ben_cwb_summary.emp_recv_count_direct%type index by binary_integer;
3157: type elig_sal_val_direct_type is table of
3158: ben_cwb_summary.elig_sal_val_direct%type index by binary_integer;
3159: type ws_val_direct_type is table of
3160: ben_cwb_summary.ws_val_direct%type index by binary_integer;

Line 3158: ben_cwb_summary.elig_sal_val_direct%type index by binary_integer;

3154: ben_cwb_summary.elig_count_direct%type index by binary_integer;
3155: type emp_recv_count_direct_type is table of
3156: ben_cwb_summary.emp_recv_count_direct%type index by binary_integer;
3157: type elig_sal_val_direct_type is table of
3158: ben_cwb_summary.elig_sal_val_direct%type index by binary_integer;
3159: type ws_val_direct_type is table of
3160: ben_cwb_summary.ws_val_direct%type index by binary_integer;
3161: type stat_sal_val_direct_type is table of
3162: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;

Line 3160: ben_cwb_summary.ws_val_direct%type index by binary_integer;

3156: ben_cwb_summary.emp_recv_count_direct%type index by binary_integer;
3157: type elig_sal_val_direct_type is table of
3158: ben_cwb_summary.elig_sal_val_direct%type index by binary_integer;
3159: type ws_val_direct_type is table of
3160: ben_cwb_summary.ws_val_direct%type index by binary_integer;
3161: type stat_sal_val_direct_type is table of
3162: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;
3163: type oth_comp_val_direct_type is table of
3164: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;

Line 3162: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;

3158: ben_cwb_summary.elig_sal_val_direct%type index by binary_integer;
3159: type ws_val_direct_type is table of
3160: ben_cwb_summary.ws_val_direct%type index by binary_integer;
3161: type stat_sal_val_direct_type is table of
3162: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;
3163: type oth_comp_val_direct_type is table of
3164: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;
3165: type tot_comp_val_direct_type is table of
3166: ben_cwb_summary.tot_comp_val_direct%type index by binary_integer;

Line 3164: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;

3160: ben_cwb_summary.ws_val_direct%type index by binary_integer;
3161: type stat_sal_val_direct_type is table of
3162: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;
3163: type oth_comp_val_direct_type is table of
3164: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;
3165: type tot_comp_val_direct_type is table of
3166: ben_cwb_summary.tot_comp_val_direct%type index by binary_integer;
3167: type rec_val_direct_type is table of
3168: ben_cwb_summary.rec_val_direct%type index by binary_integer;

Line 3166: ben_cwb_summary.tot_comp_val_direct%type index by binary_integer;

3162: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;
3163: type oth_comp_val_direct_type is table of
3164: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;
3165: type tot_comp_val_direct_type is table of
3166: ben_cwb_summary.tot_comp_val_direct%type index by binary_integer;
3167: type rec_val_direct_type is table of
3168: ben_cwb_summary.rec_val_direct%type index by binary_integer;
3169: type rec_mn_val_direct_type is table of
3170: ben_cwb_summary.rec_mn_val_direct%type index by binary_integer;

Line 3168: ben_cwb_summary.rec_val_direct%type index by binary_integer;

3164: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;
3165: type tot_comp_val_direct_type is table of
3166: ben_cwb_summary.tot_comp_val_direct%type index by binary_integer;
3167: type rec_val_direct_type is table of
3168: ben_cwb_summary.rec_val_direct%type index by binary_integer;
3169: type rec_mn_val_direct_type is table of
3170: ben_cwb_summary.rec_mn_val_direct%type index by binary_integer;
3171: type rec_mx_val_direct_type is table of
3172: ben_cwb_summary.rec_mx_val_direct%type index by binary_integer;

Line 3170: ben_cwb_summary.rec_mn_val_direct%type index by binary_integer;

3166: ben_cwb_summary.tot_comp_val_direct%type index by binary_integer;
3167: type rec_val_direct_type is table of
3168: ben_cwb_summary.rec_val_direct%type index by binary_integer;
3169: type rec_mn_val_direct_type is table of
3170: ben_cwb_summary.rec_mn_val_direct%type index by binary_integer;
3171: type rec_mx_val_direct_type is table of
3172: ben_cwb_summary.rec_mx_val_direct%type index by binary_integer;
3173: type misc1_val_direct_type is table of
3174: ben_cwb_summary.misc1_val_direct%type index by binary_integer;

Line 3172: ben_cwb_summary.rec_mx_val_direct%type index by binary_integer;

3168: ben_cwb_summary.rec_val_direct%type index by binary_integer;
3169: type rec_mn_val_direct_type is table of
3170: ben_cwb_summary.rec_mn_val_direct%type index by binary_integer;
3171: type rec_mx_val_direct_type is table of
3172: ben_cwb_summary.rec_mx_val_direct%type index by binary_integer;
3173: type misc1_val_direct_type is table of
3174: ben_cwb_summary.misc1_val_direct%type index by binary_integer;
3175: type misc2_val_direct_type is table of
3176: ben_cwb_summary.misc2_val_direct%type index by binary_integer;

Line 3174: ben_cwb_summary.misc1_val_direct%type index by binary_integer;

3170: ben_cwb_summary.rec_mn_val_direct%type index by binary_integer;
3171: type rec_mx_val_direct_type is table of
3172: ben_cwb_summary.rec_mx_val_direct%type index by binary_integer;
3173: type misc1_val_direct_type is table of
3174: ben_cwb_summary.misc1_val_direct%type index by binary_integer;
3175: type misc2_val_direct_type is table of
3176: ben_cwb_summary.misc2_val_direct%type index by binary_integer;
3177: type misc3_val_direct_type is table of
3178: ben_cwb_summary.misc3_val_direct%type index by binary_integer;

Line 3176: ben_cwb_summary.misc2_val_direct%type index by binary_integer;

3172: ben_cwb_summary.rec_mx_val_direct%type index by binary_integer;
3173: type misc1_val_direct_type is table of
3174: ben_cwb_summary.misc1_val_direct%type index by binary_integer;
3175: type misc2_val_direct_type is table of
3176: ben_cwb_summary.misc2_val_direct%type index by binary_integer;
3177: type misc3_val_direct_type is table of
3178: ben_cwb_summary.misc3_val_direct%type index by binary_integer;
3179: -- declare pl/sql tables
3180: l_rts_group_pl_id_tab group_pl_id_type;

Line 3178: ben_cwb_summary.misc3_val_direct%type index by binary_integer;

3174: ben_cwb_summary.misc1_val_direct%type index by binary_integer;
3175: type misc2_val_direct_type is table of
3176: ben_cwb_summary.misc2_val_direct%type index by binary_integer;
3177: type misc3_val_direct_type is table of
3178: ben_cwb_summary.misc3_val_direct%type index by binary_integer;
3179: -- declare pl/sql tables
3180: l_rts_group_pl_id_tab group_pl_id_type;
3181: l_rts_group_oipl_id_tab group_oipl_id_type;
3182: l_grp_group_pl_id_tab group_pl_id_type;

Line 3604: insert into ben_cwb_summary

3600:
3601: -- if the new_mgr_per_in_ler_id was not manager earlier then,
3602: -- add the summary row for the person.
3603:
3604: insert into ben_cwb_summary
3605: (summary_id
3606: ,group_per_in_ler_id
3607: ,group_pl_id
3608: ,group_oipl_id

Line 3611: select ben_cwb_summary_s.nextval

3607: ,group_pl_id
3608: ,group_oipl_id
3609: ,person_id
3610: ,lf_evt_ocrd_dt)
3611: select ben_cwb_summary_s.nextval
3612: ,grp.group_per_in_ler_id
3613: ,grp.group_pl_id
3614: ,grp.group_oipl_id
3615: ,pil.person_id

Line 3623: from ben_cwb_summary

3619: where grp.group_per_in_ler_id = p_new_mgr_per_in_ler_id
3620: and grp.group_per_in_ler_id = pil.per_in_ler_id
3621: and pil.per_in_ler_stat_cd in ('PROCD','STRTD')
3622: and not exists(select null
3623: from ben_cwb_summary
3624: where group_per_in_ler_id = p_new_mgr_per_in_ler_id);
3625:
3626: if l_is_mgr = 'Y' then
3627: -- call reassign_mgr

Line 3674: delete from ben_cwb_summary

3670: if g_debug then
3671: hr_utility.set_location('Entering:'|| l_proc, 10);
3672: end if;
3673: --
3674: delete from ben_cwb_summary
3675: where group_pl_id = p_group_pl_id
3676: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
3677: --
3678: if g_debug then

Line 3878: end ben_cwb_summary_pkg; -- end of package

3874: --
3875: --
3876: end;
3877: --
3878: end ben_cwb_summary_pkg; -- end of package
3879: