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_MANAGE_CWB_LIFE_EVENTS dependencies on BEN_CWB_PERSON_GROUPS

Line 1833: * Delete data from ben_cwb_person_rates, ben_cwb_person_groups,

1829: * if there are no rows in ben_cwb_person_rates with
1830: * ELIG_FLAG = Y and only consider uncloned data
1831: * then
1832: *
1833: * Delete data from ben_cwb_person_rates, ben_cwb_person_groups,
1834: * ben_per_in_ler, ben_ptnl_ler_for_per, ben_pil_elctbl_chc_popl,
1835: * ben_elig_per_elctbl_chc, ben_group_heirarchy,
1836: * ben_cwb_person_tasks.
1837: */

Line 1954: from ben_cwb_person_groups cpg

1950: and pet.pl_id = cv_pl_id;
1951: --
1952: cursor c_cpg(c_group_pl_id number, c_group_lf_evt_ocrd_dt date) is
1953: select cpg.*
1954: from ben_cwb_person_groups cpg
1955: where cpg.group_pl_id = c_group_pl_id
1956: and cpg.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
1957: and cpg.group_per_in_ler_id =
1958: (select cpg1.group_per_in_ler_id

Line 1959: from ben_cwb_person_groups cpg1

1955: where cpg.group_pl_id = c_group_pl_id
1956: and cpg.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
1957: and cpg.group_per_in_ler_id =
1958: (select cpg1.group_per_in_ler_id
1959: from ben_cwb_person_groups cpg1
1960: where cpg1.group_pl_id = c_group_pl_id
1961: and cpg1.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
1962: and rownum = 1);
1963: --

Line 2160: -- create row in ben_cwb_person_groups

2156: for l_cpg_rec in c_cpg(ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2157: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt)
2158: loop
2159: --
2160: -- create row in ben_cwb_person_groups
2161: --
2162: hr_utility.set_location('Creating missing ben_cwb_person_groups', 50);
2163: insert into ben_cwb_person_groups
2164: (group_per_in_ler_id,

Line 2162: hr_utility.set_location('Creating missing ben_cwb_person_groups', 50);

2158: loop
2159: --
2160: -- create row in ben_cwb_person_groups
2161: --
2162: hr_utility.set_location('Creating missing ben_cwb_person_groups', 50);
2163: insert into ben_cwb_person_groups
2164: (group_per_in_ler_id,
2165: group_pl_id ,
2166: group_oipl_id ,

Line 2163: insert into ben_cwb_person_groups

2159: --
2160: -- create row in ben_cwb_person_groups
2161: --
2162: hr_utility.set_location('Creating missing ben_cwb_person_groups', 50);
2163: insert into ben_cwb_person_groups
2164: (group_per_in_ler_id,
2165: group_pl_id ,
2166: group_oipl_id ,
2167: lf_evt_ocrd_dt ,

Line 3280: -- Procedure to populate ben_cwb_person_rates, ben_cwb_person_groups.

3276: fnd_message.raise_error;
3277: --
3278: end global_process;
3279: --
3280: -- Procedure to populate ben_cwb_person_rates, ben_cwb_person_groups.
3281: --
3282: procedure populate_cwb_rates(
3283: --
3284: -- Columns needed for ben_cwb_person_rates

Line 3298: -- Columns needed by BEN_CWB_PERSON_GROUPS

3294: ,p_acty_base_rt_id in number default null
3295: ,p_elig_flag in varchar2 default 'Y'
3296: ,p_inelig_rsn_cd in varchar2 default null
3297: --
3298: -- Columns needed by BEN_CWB_PERSON_GROUPS
3299: --
3300: ,p_due_dt in date default null
3301: ,p_access_cd in varchar2 default null
3302: ,p_elig_per_elctbl_chc_id in number default null

Line 3354: -- Populate BEN_CWB_PERSON_GROUPS

3350: end if;
3351: --
3352: if p_pl_id = g_cache_group_plan_rec.group_pl_id then
3353: --
3354: -- Populate BEN_CWB_PERSON_GROUPS
3355: -- Primary Key: GROUP_PER_IN_LER_ID, GROUP_PL_ID, GROUP_OIPL_ID
3356: --
3357: if g_debug then
3358: hr_utility.set_location ('Group rate ' ,15);

Line 3386: insert into ben_cwb_person_groups

3382: open c_group_oipl(g_cache_group_plan_rec.group_lf_evt_ocrd_dt);
3383: fetch c_group_oipl into l_group_oipl_id;
3384: close c_group_oipl;
3385: --
3386: insert into ben_cwb_person_groups
3387: (group_per_in_ler_id,
3388: group_pl_id ,
3389: group_oipl_id ,
3390: lf_evt_ocrd_dt ,

Line 3951: from ben_cwb_person_groups cpg

3947: l_copy_person_bdgt_count binary_integer;
3948: --
3949: cursor c_cpg(c_group_pl_id number, c_group_lf_evt_ocrd_dt date) is
3950: select cpg.*
3951: from ben_cwb_person_groups cpg
3952: where cpg.group_pl_id = c_group_pl_id
3953: and cpg.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
3954: and cpg.group_per_in_ler_id =
3955: (select cpg1.group_per_in_ler_id

Line 3956: from ben_cwb_person_groups cpg1

3952: where cpg.group_pl_id = c_group_pl_id
3953: and cpg.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
3954: and cpg.group_per_in_ler_id =
3955: (select cpg1.group_per_in_ler_id
3956: from ben_cwb_person_groups cpg1
3957: where cpg1.group_pl_id = c_group_pl_id
3958: and cpg1.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
3959: and rownum = 1);
3960: --

Line 3961: l_copy_dist_bdgt_val ben_cwb_person_groups.dist_bdgt_val%type;

3957: where cpg1.group_pl_id = c_group_pl_id
3958: and cpg1.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
3959: and rownum = 1);
3960: --
3961: l_copy_dist_bdgt_val ben_cwb_person_groups.dist_bdgt_val%type;
3962: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;
3963: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
3964: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
3965: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;

Line 3962: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;

3958: and cpg1.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
3959: and rownum = 1);
3960: --
3961: l_copy_dist_bdgt_val ben_cwb_person_groups.dist_bdgt_val%type;
3962: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;
3963: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
3964: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
3965: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
3966: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;

Line 3963: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;

3959: and rownum = 1);
3960: --
3961: l_copy_dist_bdgt_val ben_cwb_person_groups.dist_bdgt_val%type;
3962: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;
3963: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
3964: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
3965: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
3966: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
3967: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;

Line 3964: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;

3960: --
3961: l_copy_dist_bdgt_val ben_cwb_person_groups.dist_bdgt_val%type;
3962: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;
3963: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
3964: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
3965: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
3966: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
3967: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
3968: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;

Line 3965: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;

3961: l_copy_dist_bdgt_val ben_cwb_person_groups.dist_bdgt_val%type;
3962: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;
3963: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
3964: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
3965: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
3966: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
3967: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
3968: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
3969: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;

Line 3966: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;

3962: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;
3963: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
3964: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
3965: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
3966: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
3967: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
3968: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
3969: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
3970: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;

Line 3967: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;

3963: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
3964: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
3965: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
3966: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
3967: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
3968: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
3969: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
3970: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
3971: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;

Line 3968: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;

3964: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
3965: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
3966: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
3967: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
3968: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
3969: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
3970: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
3971: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
3972: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;

Line 3969: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;

3965: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
3966: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
3967: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
3968: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
3969: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
3970: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
3971: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
3972: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
3973: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;

Line 3970: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;

3966: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
3967: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
3968: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
3969: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
3970: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
3971: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
3972: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
3973: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
3974: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;

Line 3971: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;

3967: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
3968: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
3969: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
3970: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
3971: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
3972: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
3973: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
3974: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;
3975: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;

Line 3972: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;

3968: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
3969: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
3970: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
3971: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
3972: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
3973: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
3974: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;
3975: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;
3976: l_copy_rsrv_incr_val ben_cwb_person_groups.rsrv_incr_val%type;

Line 3973: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;

3969: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
3970: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
3971: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
3972: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
3973: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
3974: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;
3975: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;
3976: l_copy_rsrv_incr_val ben_cwb_person_groups.rsrv_incr_val%type;
3977: --

Line 3974: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;

3970: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
3971: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
3972: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
3973: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
3974: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;
3975: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;
3976: l_copy_rsrv_incr_val ben_cwb_person_groups.rsrv_incr_val%type;
3977: --
3978: CURSOR c_pl_dsgn (c_group_pl_id NUMBER, c_group_lf_evt_ocrd_dt DATE)

Line 3975: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;

3971: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
3972: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
3973: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
3974: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;
3975: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;
3976: l_copy_rsrv_incr_val ben_cwb_person_groups.rsrv_incr_val%type;
3977: --
3978: CURSOR c_pl_dsgn (c_group_pl_id NUMBER, c_group_lf_evt_ocrd_dt DATE)
3979: IS

Line 3976: l_copy_rsrv_incr_val ben_cwb_person_groups.rsrv_incr_val%type;

3972: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
3973: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
3974: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;
3975: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;
3976: l_copy_rsrv_incr_val ben_cwb_person_groups.rsrv_incr_val%type;
3977: --
3978: CURSOR c_pl_dsgn (c_group_pl_id NUMBER, c_group_lf_evt_ocrd_dt DATE)
3979: IS
3980: SELECT group_oipl_id

Line 4103: there is no record in ben_cwb_person_groups .

4099: end if;
4100:
4101: /* 5124534 :
4102: if g_cache_cpg_rec.count is still zero means
4103: there is no record in ben_cwb_person_groups .
4104: populate group_pl_id,group_oipl_id,budget values
4105: into g_cache_cpg_rec
4106:
4107: */

Line 4217: -- Create the ben_cwb_person_groups data.

4213: end if;
4214: --
4215: end loop;
4216: --
4217: -- Create the ben_cwb_person_groups data.
4218: --
4219: if nvl(g_cache_cpg_rec.count, 0) > 0 then
4220: --
4221: for l_cpg_count in 1..g_cache_cpg_rec.count loop

Line 4223: -- update ben_cwb_person_groups with budget copy_ columns

4219: if nvl(g_cache_cpg_rec.count, 0) > 0 then
4220: --
4221: for l_cpg_count in 1..g_cache_cpg_rec.count loop
4222: --
4223: -- update ben_cwb_person_groups with budget copy_ columns
4224: --
4225: if nvl(l_copy_person_bdgt_count, 0) > 0 then
4226: for l_bdgt_count in 1..l_copy_person_bdgt_count loop
4227: --

Line 4280: -- create row in ben_cwb_person_groups

4276: end loop;
4277: --
4278: end if;
4279: --
4280: -- create row in ben_cwb_person_groups
4281: --
4282: hr_utility.set_location('Creating missing ben_cwb_person_groups', 1234);
4283: insert into ben_cwb_person_groups
4284: (group_per_in_ler_id,

Line 4282: hr_utility.set_location('Creating missing ben_cwb_person_groups', 1234);

4278: end if;
4279: --
4280: -- create row in ben_cwb_person_groups
4281: --
4282: hr_utility.set_location('Creating missing ben_cwb_person_groups', 1234);
4283: insert into ben_cwb_person_groups
4284: (group_per_in_ler_id,
4285: group_pl_id ,
4286: group_oipl_id ,

Line 4283: insert into ben_cwb_person_groups

4279: --
4280: -- create row in ben_cwb_person_groups
4281: --
4282: hr_utility.set_location('Creating missing ben_cwb_person_groups', 1234);
4283: insert into ben_cwb_person_groups
4284: (group_per_in_ler_id,
4285: group_pl_id ,
4286: group_oipl_id ,
4287: lf_evt_ocrd_dt ,

Line 4828: from ben_cwb_person_groups cpg

4824: ) is
4825: --
4826: cursor c_high_mgr_cpg(c_group_pl_id number, c_lf_evt_ocrd_dt date) is
4827: select cpg.rowid, cpg.*
4828: from ben_cwb_person_groups cpg
4829: where cpg.group_pl_id = c_group_pl_id
4830: and cpg.lf_evt_ocrd_dt = c_lf_evt_ocrd_dt
4831: and exists
4832: (select null

Line 4845: from ben_cwb_person_groups cpg

4841: for update;
4842: --
4843: cursor c_leaf_mgr_cpg(c_group_pl_id number, c_lf_evt_ocrd_dt date) is
4844: select cpg.rowid, cpg.*
4845: from ben_cwb_person_groups cpg
4846: where cpg.group_pl_id = c_group_pl_id
4847: and cpg.lf_evt_ocrd_dt = c_lf_evt_ocrd_dt
4848: and not exists
4849: (select null

Line 4907: update ben_cwb_person_groups

4903: l_iss_dt := null;
4904: --
4905: end if;
4906: --
4907: update ben_cwb_person_groups
4908: set dist_bdgt_val = dflt_dist_bdgt_val,
4909: ws_bdgt_val = dflt_ws_bdgt_val,
4910: ws_bdgt_val_last_upd_date = p_lf_evt_ocrd_dt,
4911: dist_bdgt_val_last_upd_date = p_lf_evt_ocrd_dt,

Line 4949: update ben_cwb_person_groups

4945: l_iss_dt := null;
4946: --
4947: end if;
4948: --
4949: update ben_cwb_person_groups
4950: set ws_bdgt_val = dflt_ws_bdgt_val,
4951: ws_bdgt_val_last_upd_date = p_lf_evt_ocrd_dt,
4952: ws_bdgt_iss_val = l_dflt_ws_bdgt_val,
4953: ws_bdgt_iss_date = l_iss_dt,