APPS.BEN_DETERMINE_RATES dependencies on BEN_MANAGE_CWB_LIFE_EVENTS

Line 566: ben_manage_cwb_life_events.g_cwb_person_groups_rec := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;

562: l_nsuv_num := 1 ;
563: --
564: if nvl(p_mode, 'X') = 'W' then
565: --
566: ben_manage_cwb_life_events.g_cwb_person_groups_rec := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
567: ben_manage_cwb_life_events.g_cwb_person_rates_rec := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
568: --
569: end if;
570: --

Line 567: ben_manage_cwb_life_events.g_cwb_person_rates_rec := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;

563: --
564: if nvl(p_mode, 'X') = 'W' then
565: --
566: ben_manage_cwb_life_events.g_cwb_person_groups_rec := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
567: ben_manage_cwb_life_events.g_cwb_person_rates_rec := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
568: --
569: end if;
570: --
571: FOR i IN p_acty_base_rt_id_table.FIRST .. p_acty_base_rt_id_table.LAST LOOP

Line 826: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then

822: if nvl(p_mode, 'X') = 'W' then
823: --
824: if l_acty_typ_cd(i) = 'CWBDB' then -- Distribution Budget values.
825: --
826: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
827: --
828: -- Populate dist_bdgt_val, dist_bdgt_mn_val, dist_bdgt_mx_val,
829: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,
830: --

Line 831: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_val :=

827: --
828: -- Populate dist_bdgt_val, dist_bdgt_mn_val, dist_bdgt_mx_val,
829: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,
830: --
831: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_val :=
832: nvl(l_val(i), l_dflt_val(i));
833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);
834: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);
835: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);

Line 833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);

829: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,
830: --
831: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_val :=
832: nvl(l_val(i), l_dflt_val(i));
833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);
834: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);
835: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);
836: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_val := l_iss_val(i);
837: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_date := null; -- 9999 What is this val

Line 834: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);

830: --
831: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_val :=
832: nvl(l_val(i), l_dflt_val(i));
833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);
834: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);
835: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);
836: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_val := l_iss_val(i);
837: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_date := null; -- 9999 What is this val
838: else

Line 835: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);

831: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_val :=
832: nvl(l_val(i), l_dflt_val(i));
833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);
834: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);
835: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);
836: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_val := l_iss_val(i);
837: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_date := null; -- 9999 What is this val
838: else
839: --

Line 836: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_val := l_iss_val(i);

832: nvl(l_val(i), l_dflt_val(i));
833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);
834: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);
835: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);
836: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_val := l_iss_val(i);
837: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_date := null; -- 9999 What is this val
838: else
839: --
840: -- Populate dist_bdgt_val, dist_bdgt_mn_val, dist_bdgt_mx_val,

Line 837: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_date := null; -- 9999 What is this val

833: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mn_val := l_mn_elcn_val(i);
834: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_mx_val := l_mx_elcn_val(i);
835: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_incr_val := l_incrmt_elcn_val(i);
836: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_val := l_iss_val(i);
837: ben_manage_cwb_life_events.g_cwb_person_groups_rec.dist_bdgt_iss_date := null; -- 9999 What is this val
838: else
839: --
840: -- Populate dist_bdgt_val, dist_bdgt_mn_val, dist_bdgt_mx_val,
841: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,

Line 843: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_val := nvl(l_val(i), l_dflt_val(i));

839: --
840: -- Populate dist_bdgt_val, dist_bdgt_mn_val, dist_bdgt_mx_val,
841: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,
842: --
843: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_val := nvl(l_val(i), l_dflt_val(i));
844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);
845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);
846: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);
847: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);

Line 844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);

840: -- Populate dist_bdgt_val, dist_bdgt_mn_val, dist_bdgt_mx_val,
841: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,
842: --
843: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_val := nvl(l_val(i), l_dflt_val(i));
844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);
845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);
846: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);
847: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);
848: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_date := null; -- 9999 What is this val

Line 845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);

841: -- dist_bdgt_incr_val, dist_bdgt_iss_val, dist_bdgt_iss_date,
842: --
843: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_val := nvl(l_val(i), l_dflt_val(i));
844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);
845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);
846: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);
847: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);
848: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_date := null; -- 9999 What is this val
849: end if;

Line 846: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);

842: --
843: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_val := nvl(l_val(i), l_dflt_val(i));
844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);
845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);
846: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);
847: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);
848: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_date := null; -- 9999 What is this val
849: end if;
850: --

Line 847: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);

843: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_val := nvl(l_val(i), l_dflt_val(i));
844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);
845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);
846: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);
847: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);
848: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_date := null; -- 9999 What is this val
849: end if;
850: --
851: elsif l_acty_typ_cd(i) = 'CWBWB' then -- Worksheet Budget values.

Line 848: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_date := null; -- 9999 What is this val

844: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mn_val := l_mn_elcn_val(i);
845: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_mx_val := l_mx_elcn_val(i);
846: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_incr_val := l_incrmt_elcn_val(i);
847: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_val := l_iss_val(i);
848: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_dist_bdgt_iss_date := null; -- 9999 What is this val
849: end if;
850: --
851: elsif l_acty_typ_cd(i) = 'CWBWB' then -- Worksheet Budget values.
852: --

Line 853: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then

849: end if;
850: --
851: elsif l_acty_typ_cd(i) = 'CWBWB' then -- Worksheet Budget values.
852: --
853: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
854: --
855: -- Populate ws_bdgt_val, ws_bdgt_mn_val, ws_bdgt_mx_val,
856: -- ws_bdgt_incr_val, ws_bdgt_iss_val, ws_bdgt_iss_date,
857: --

Line 858: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_val :=

854: --
855: -- Populate ws_bdgt_val, ws_bdgt_mn_val, ws_bdgt_mx_val,
856: -- ws_bdgt_incr_val, ws_bdgt_iss_val, ws_bdgt_iss_date,
857: --
858: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_val :=
859: nvl(l_val(i), l_dflt_val(i));
860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);
861: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);
862: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);

Line 860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);

856: -- ws_bdgt_incr_val, ws_bdgt_iss_val, ws_bdgt_iss_date,
857: --
858: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_val :=
859: nvl(l_val(i), l_dflt_val(i));
860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);
861: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);
862: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);
863: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_val := l_iss_val(i);
864: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_date := null; -- 9999 What is this val

Line 861: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);

857: --
858: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_val :=
859: nvl(l_val(i), l_dflt_val(i));
860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);
861: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);
862: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);
863: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_val := l_iss_val(i);
864: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_date := null; -- 9999 What is this val
865: --

Line 862: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);

858: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_val :=
859: nvl(l_val(i), l_dflt_val(i));
860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);
861: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);
862: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);
863: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_val := l_iss_val(i);
864: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_date := null; -- 9999 What is this val
865: --
866: else

Line 863: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_val := l_iss_val(i);

859: nvl(l_val(i), l_dflt_val(i));
860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);
861: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);
862: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);
863: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_val := l_iss_val(i);
864: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_date := null; -- 9999 What is this val
865: --
866: else
867: --

Line 864: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_date := null; -- 9999 What is this val

860: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mn_val := l_mn_elcn_val(i);
861: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_mx_val := l_mx_elcn_val(i);
862: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_incr_val := l_incrmt_elcn_val(i);
863: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_val := l_iss_val(i);
864: ben_manage_cwb_life_events.g_cwb_person_groups_rec.ws_bdgt_iss_date := null; -- 9999 What is this val
865: --
866: else
867: --
868: -- Populate ws_bdgt_val, ws_bdgt_mn_val, ws_bdgt_mx_val,

Line 871: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_val :=

867: --
868: -- Populate ws_bdgt_val, ws_bdgt_mn_val, ws_bdgt_mx_val,
869: -- ws_bdgt_incr_val, ws_bdgt_iss_val, ws_bdgt_iss_date,
870: --
871: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_val :=
872: nvl(l_val(i), l_dflt_val(i));
873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);
874: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);
875: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);

Line 873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);

869: -- ws_bdgt_incr_val, ws_bdgt_iss_val, ws_bdgt_iss_date,
870: --
871: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_val :=
872: nvl(l_val(i), l_dflt_val(i));
873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);
874: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);
875: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);
876: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_val := l_iss_val(i);
877: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_date := null; -- 9999 What is this val

Line 874: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);

870: --
871: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_val :=
872: nvl(l_val(i), l_dflt_val(i));
873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);
874: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);
875: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);
876: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_val := l_iss_val(i);
877: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_date := null; -- 9999 What is this val
878: --

Line 875: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);

871: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_val :=
872: nvl(l_val(i), l_dflt_val(i));
873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);
874: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);
875: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);
876: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_val := l_iss_val(i);
877: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_date := null; -- 9999 What is this val
878: --
879: end if;

Line 876: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_val := l_iss_val(i);

872: nvl(l_val(i), l_dflt_val(i));
873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);
874: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);
875: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);
876: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_val := l_iss_val(i);
877: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_date := null; -- 9999 What is this val
878: --
879: end if;
880: --

Line 877: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_date := null; -- 9999 What is this val

873: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mn_val := l_mn_elcn_val(i);
874: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_mx_val := l_mx_elcn_val(i);
875: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_incr_val := l_incrmt_elcn_val(i);
876: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_val := l_iss_val(i);
877: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_ws_bdgt_iss_date := null; -- 9999 What is this val
878: --
879: end if;
880: --
881: elsif l_acty_typ_cd(i) = 'CWBR' then -- Reserve Budget values.

Line 883: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then

879: end if;
880: --
881: elsif l_acty_typ_cd(i) = 'CWBR' then -- Reserve Budget values.
882: --
883: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
884: --
885: -- Populate rsrv_val, rsrv_mn_val, rsrv_mx_val, rsrv_incr_val
886: --
887: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_val :=

Line 887: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_val :=

883: if l_currepe_row.pl_id = ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id then
884: --
885: -- Populate rsrv_val, rsrv_mn_val, rsrv_mx_val, rsrv_incr_val
886: --
887: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_val :=
888: nvl(l_val(i), l_dflt_val(i));
889: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mn_val := l_mn_elcn_val(i);
890: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mx_val := l_mx_elcn_val(i);
891: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_incr_val := l_incrmt_elcn_val(i);

Line 889: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mn_val := l_mn_elcn_val(i);

885: -- Populate rsrv_val, rsrv_mn_val, rsrv_mx_val, rsrv_incr_val
886: --
887: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_val :=
888: nvl(l_val(i), l_dflt_val(i));
889: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mn_val := l_mn_elcn_val(i);
890: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mx_val := l_mx_elcn_val(i);
891: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_incr_val := l_incrmt_elcn_val(i);
892: --
893: else

Line 890: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mx_val := l_mx_elcn_val(i);

886: --
887: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_val :=
888: nvl(l_val(i), l_dflt_val(i));
889: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mn_val := l_mn_elcn_val(i);
890: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mx_val := l_mx_elcn_val(i);
891: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_incr_val := l_incrmt_elcn_val(i);
892: --
893: else
894: --

Line 891: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_incr_val := l_incrmt_elcn_val(i);

887: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_val :=
888: nvl(l_val(i), l_dflt_val(i));
889: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mn_val := l_mn_elcn_val(i);
890: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_mx_val := l_mx_elcn_val(i);
891: ben_manage_cwb_life_events.g_cwb_person_groups_rec.rsrv_incr_val := l_incrmt_elcn_val(i);
892: --
893: else
894: --
895: -- Populate rsrv_val, rsrv_mn_val, rsrv_mx_val, rsrv_incr_val

Line 897: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_val :=

893: else
894: --
895: -- Populate rsrv_val, rsrv_mn_val, rsrv_mx_val, rsrv_incr_val
896: --
897: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_val :=
898: nvl(l_val(i), l_dflt_val(i));
899: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mn_val := l_mn_elcn_val(i);
900: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mx_val := l_mx_elcn_val(i);
901: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_incr_val := l_incrmt_elcn_val(i);

Line 899: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mn_val := l_mn_elcn_val(i);

895: -- Populate rsrv_val, rsrv_mn_val, rsrv_mx_val, rsrv_incr_val
896: --
897: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_val :=
898: nvl(l_val(i), l_dflt_val(i));
899: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mn_val := l_mn_elcn_val(i);
900: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mx_val := l_mx_elcn_val(i);
901: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_incr_val := l_incrmt_elcn_val(i);
902: --
903: end if;

Line 900: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mx_val := l_mx_elcn_val(i);

896: --
897: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_val :=
898: nvl(l_val(i), l_dflt_val(i));
899: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mn_val := l_mn_elcn_val(i);
900: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mx_val := l_mx_elcn_val(i);
901: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_incr_val := l_incrmt_elcn_val(i);
902: --
903: end if;
904: --

Line 901: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_incr_val := l_incrmt_elcn_val(i);

897: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_val :=
898: nvl(l_val(i), l_dflt_val(i));
899: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mn_val := l_mn_elcn_val(i);
900: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_mx_val := l_mx_elcn_val(i);
901: ben_manage_cwb_life_events.g_cwb_person_rates_rec.copy_rsrv_incr_val := l_incrmt_elcn_val(i);
902: --
903: end if;
904: --
905: elsif l_acty_typ_cd(i) = 'CWBWS' then -- Worksheet values.

Line 913: ben_manage_cwb_life_events.g_cwb_person_rates_rec.WS_RT_START_DATE := l_rt_strt_dt(i);

909: -- ws_mn_val
910: -- ws_mx_val
911: -- ws_incr_val
912: --
913: ben_manage_cwb_life_events.g_cwb_person_rates_rec.WS_RT_START_DATE := l_rt_strt_dt(i);
914: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_val :=
915: nvl(l_val(i), l_dflt_val(i));
916: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mn_val := l_mn_elcn_val(i);
917: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mx_val := l_mx_elcn_val(i);

Line 914: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_val :=

910: -- ws_mx_val
911: -- ws_incr_val
912: --
913: ben_manage_cwb_life_events.g_cwb_person_rates_rec.WS_RT_START_DATE := l_rt_strt_dt(i);
914: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_val :=
915: nvl(l_val(i), l_dflt_val(i));
916: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mn_val := l_mn_elcn_val(i);
917: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mx_val := l_mx_elcn_val(i);
918: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_incr_val := l_incrmt_elcn_val(i);

Line 916: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mn_val := l_mn_elcn_val(i);

912: --
913: ben_manage_cwb_life_events.g_cwb_person_rates_rec.WS_RT_START_DATE := l_rt_strt_dt(i);
914: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_val :=
915: nvl(l_val(i), l_dflt_val(i));
916: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mn_val := l_mn_elcn_val(i);
917: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mx_val := l_mx_elcn_val(i);
918: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_incr_val := l_incrmt_elcn_val(i);
919: --
920: -- Multi currency support. Add caching mechanism

Line 917: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mx_val := l_mx_elcn_val(i);

913: ben_manage_cwb_life_events.g_cwb_person_rates_rec.WS_RT_START_DATE := l_rt_strt_dt(i);
914: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_val :=
915: nvl(l_val(i), l_dflt_val(i));
916: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mn_val := l_mn_elcn_val(i);
917: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mx_val := l_mx_elcn_val(i);
918: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_incr_val := l_incrmt_elcn_val(i);
919: --
920: -- Multi currency support. Add caching mechanism
921: --

Line 918: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_incr_val := l_incrmt_elcn_val(i);

914: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_val :=
915: nvl(l_val(i), l_dflt_val(i));
916: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mn_val := l_mn_elcn_val(i);
917: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_mx_val := l_mx_elcn_val(i);
918: ben_manage_cwb_life_events.g_cwb_person_rates_rec.ws_incr_val := l_incrmt_elcn_val(i);
919: --
920: -- Multi currency support. Add caching mechanism
921: --
922: open c_abr(p_acty_base_rt_id_table(i));

Line 934: ben_manage_cwb_life_events.g_cwb_person_rates_rec.elig_sal_val := l_val(i);

930: elsif l_acty_typ_cd(i) = 'CWBES' then -- Worksheet values.
931: --
932: -- elig_sal_val
933: --
934: ben_manage_cwb_life_events.g_cwb_person_rates_rec.elig_sal_val := l_val(i);
935: --
936: elsif l_acty_typ_cd(i) = 'CWBSS' then -- Worksheet values.
937: -- stat_sal_val
938: --

Line 939: ben_manage_cwb_life_events.g_cwb_person_rates_rec.stat_sal_val := l_val(i);

935: --
936: elsif l_acty_typ_cd(i) = 'CWBSS' then -- Worksheet values.
937: -- stat_sal_val
938: --
939: ben_manage_cwb_life_events.g_cwb_person_rates_rec.stat_sal_val := l_val(i);
940: --
941: elsif l_acty_typ_cd(i) = 'CWBOS' then -- Worksheet values.
942: --
943: -- oth_comp_val

Line 945: ben_manage_cwb_life_events.g_cwb_person_rates_rec.oth_comp_val := l_val(i);

941: elsif l_acty_typ_cd(i) = 'CWBOS' then -- Worksheet values.
942: --
943: -- oth_comp_val
944: --
945: ben_manage_cwb_life_events.g_cwb_person_rates_rec.oth_comp_val := l_val(i);
946: --
947: elsif l_acty_typ_cd(i) = 'CWBTC' then -- Worksheet values.
948: --
949: -- tot_comp_val

Line 951: ben_manage_cwb_life_events.g_cwb_person_rates_rec.tot_comp_val := l_val(i);

947: elsif l_acty_typ_cd(i) = 'CWBTC' then -- Worksheet values.
948: --
949: -- tot_comp_val
950: --
951: ben_manage_cwb_life_events.g_cwb_person_rates_rec.tot_comp_val := l_val(i);
952: --
953: elsif l_acty_typ_cd(i) = 'CWBMR1' then -- Worksheet values.
954: --
955: -- misc1_val

Line 957: ben_manage_cwb_life_events.g_cwb_person_rates_rec.misc1_val := l_val(i);

953: elsif l_acty_typ_cd(i) = 'CWBMR1' then -- Worksheet values.
954: --
955: -- misc1_val
956: --
957: ben_manage_cwb_life_events.g_cwb_person_rates_rec.misc1_val := l_val(i);
958: --
959: elsif l_acty_typ_cd(i) = 'CWBMR2' then -- Worksheet values.
960: --
961: -- misc2_val

Line 963: ben_manage_cwb_life_events.g_cwb_person_rates_rec.misc2_val := l_val(i);

959: elsif l_acty_typ_cd(i) = 'CWBMR2' then -- Worksheet values.
960: --
961: -- misc2_val
962: --
963: ben_manage_cwb_life_events.g_cwb_person_rates_rec.misc2_val := l_val(i);
964: --
965: elsif l_acty_typ_cd(i) = 'CWBMR3' then -- Worksheet values.
966: --
967: -- misc3_val

Line 969: ben_manage_cwb_life_events.g_cwb_person_rates_rec.misc3_val := l_val(i);

965: elsif l_acty_typ_cd(i) = 'CWBMR3' then -- Worksheet values.
966: --
967: -- misc3_val
968: --
969: ben_manage_cwb_life_events.g_cwb_person_rates_rec.misc3_val := l_val(i);
970: --
971: elsif l_acty_typ_cd(i) = 'CWBRA' then -- Worksheet values.
972: --
973: -- rec_val number,

Line 978: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_val :=

974: -- rec_mn_val number,
975: -- rec_mx_val number,
976: -- rec_incr_val
977: --
978: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_val :=
979: nvl(l_val(i), l_dflt_val(i)) ;
980: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mn_val := l_mn_elcn_val(i);
981: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mx_val := l_mx_elcn_val(i);
982: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_incr_val := l_incrmt_elcn_val(i);

Line 980: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mn_val := l_mn_elcn_val(i);

976: -- rec_incr_val
977: --
978: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_val :=
979: nvl(l_val(i), l_dflt_val(i)) ;
980: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mn_val := l_mn_elcn_val(i);
981: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mx_val := l_mx_elcn_val(i);
982: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_incr_val := l_incrmt_elcn_val(i);
983: --
984: end if;

Line 981: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mx_val := l_mx_elcn_val(i);

977: --
978: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_val :=
979: nvl(l_val(i), l_dflt_val(i)) ;
980: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mn_val := l_mn_elcn_val(i);
981: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mx_val := l_mx_elcn_val(i);
982: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_incr_val := l_incrmt_elcn_val(i);
983: --
984: end if;
985: --

Line 982: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_incr_val := l_incrmt_elcn_val(i);

978: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_val :=
979: nvl(l_val(i), l_dflt_val(i)) ;
980: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mn_val := l_mn_elcn_val(i);
981: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_mx_val := l_mx_elcn_val(i);
982: ben_manage_cwb_life_events.g_cwb_person_rates_rec.rec_incr_val := l_incrmt_elcn_val(i);
983: --
984: end if;
985: --
986: end if;

Line 1074: ben_manage_cwb_life_events.populate_cwb_rates(

1070: END IF;
1071: -- Handle auto issue of budgets.
1072: -- For multi currency support added new paramaters.
1073: --
1074: ben_manage_cwb_life_events.populate_cwb_rates(
1075: --
1076: -- Columns needed for ben_cwb_person_rates
1077: --
1078: p_person_id => p_person_id

Line 2536: ben_manage_cwb_life_events.g_cwb_person_groups_rec

2532: p_rec => l_asg_benass_row
2533: );
2534: END IF;
2535: --
2536: ben_manage_cwb_life_events.g_cwb_person_groups_rec
2537: := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
2538: ben_manage_cwb_life_events.g_cwb_person_rates_rec
2539: := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
2540: ben_manage_cwb_life_events.populate_cwb_rates(

Line 2537: := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;

2533: );
2534: END IF;
2535: --
2536: ben_manage_cwb_life_events.g_cwb_person_groups_rec
2537: := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
2538: ben_manage_cwb_life_events.g_cwb_person_rates_rec
2539: := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
2540: ben_manage_cwb_life_events.populate_cwb_rates(
2541: --

Line 2538: ben_manage_cwb_life_events.g_cwb_person_rates_rec

2534: END IF;
2535: --
2536: ben_manage_cwb_life_events.g_cwb_person_groups_rec
2537: := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
2538: ben_manage_cwb_life_events.g_cwb_person_rates_rec
2539: := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
2540: ben_manage_cwb_life_events.populate_cwb_rates(
2541: --
2542: -- Columns needed for ben_cwb_person_rates

Line 2539: := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;

2535: --
2536: ben_manage_cwb_life_events.g_cwb_person_groups_rec
2537: := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
2538: ben_manage_cwb_life_events.g_cwb_person_rates_rec
2539: := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
2540: ben_manage_cwb_life_events.populate_cwb_rates(
2541: --
2542: -- Columns needed for ben_cwb_person_rates
2543: --

Line 2540: ben_manage_cwb_life_events.populate_cwb_rates(

2536: ben_manage_cwb_life_events.g_cwb_person_groups_rec
2537: := ben_manage_cwb_life_events.g_cwb_person_groups_rec_temp;
2538: ben_manage_cwb_life_events.g_cwb_person_rates_rec
2539: := ben_manage_cwb_life_events.g_cwb_person_rates_rec_temp;
2540: ben_manage_cwb_life_events.populate_cwb_rates(
2541: --
2542: -- Columns needed for ben_cwb_person_rates
2543: --
2544: p_person_id => p_person_id