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 1878: * Delete data from ben_cwb_person_rates, ben_cwb_person_groups,

1874: * if there are no rows in ben_cwb_person_rates with
1875: * ELIG_FLAG = Y and only consider uncloned data
1876: * then
1877: *
1878: * Delete data from ben_cwb_person_rates, ben_cwb_person_groups,
1879: * ben_per_in_ler, ben_ptnl_ler_for_per, ben_pil_elctbl_chc_popl,
1880: * ben_elig_per_elctbl_chc, ben_group_heirarchy,
1881: * ben_cwb_person_tasks.
1882: */

Line 1999: from ben_cwb_person_groups cpg

1995: and pet.pl_id = cv_pl_id;
1996: --
1997: cursor c_cpg(c_group_pl_id number, c_group_lf_evt_ocrd_dt date) is
1998: select cpg.*
1999: from ben_cwb_person_groups cpg
2000: where cpg.group_pl_id = c_group_pl_id
2001: and cpg.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
2002: and cpg.group_per_in_ler_id =
2003: (select cpg1.group_per_in_ler_id

Line 2004: from ben_cwb_person_groups cpg1

2000: where cpg.group_pl_id = c_group_pl_id
2001: and cpg.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
2002: and cpg.group_per_in_ler_id =
2003: (select cpg1.group_per_in_ler_id
2004: from ben_cwb_person_groups cpg1
2005: where cpg1.group_pl_id = c_group_pl_id
2006: and cpg1.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
2007: and rownum = 1);
2008: --

Line 2205: -- create row in ben_cwb_person_groups

2201: for l_cpg_rec in c_cpg(ben_manage_cwb_life_events.g_cache_group_plan_rec.group_pl_id,
2202: ben_manage_cwb_life_events.g_cache_group_plan_rec.group_lf_evt_ocrd_dt)
2203: loop
2204: --
2205: -- create row in ben_cwb_person_groups
2206: --
2207: hr_utility.set_location('Creating missing ben_cwb_person_groups', 50);
2208: insert into ben_cwb_person_groups
2209: (group_per_in_ler_id,

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

2203: loop
2204: --
2205: -- create row in ben_cwb_person_groups
2206: --
2207: hr_utility.set_location('Creating missing ben_cwb_person_groups', 50);
2208: insert into ben_cwb_person_groups
2209: (group_per_in_ler_id,
2210: group_pl_id ,
2211: group_oipl_id ,

Line 2208: insert into ben_cwb_person_groups

2204: --
2205: -- create row in ben_cwb_person_groups
2206: --
2207: hr_utility.set_location('Creating missing ben_cwb_person_groups', 50);
2208: insert into ben_cwb_person_groups
2209: (group_per_in_ler_id,
2210: group_pl_id ,
2211: group_oipl_id ,
2212: lf_evt_ocrd_dt ,

Line 3086: FND_STATS.GATHER_TABLE_STATS('BEN','BEN_CWB_PERSON_GROUPS');

3082: -- BEGIN: Gather stats for the CWB tables that are updated with group_per_in_ler_id's BUG#13436491
3083: --
3084: FND_STATS.GATHER_TABLE_STATS('BEN','BEN_CWB_GROUP_HRCHY');
3085: FND_STATS.GATHER_TABLE_STATS('BEN','BEN_CWB_PERSON_RATES');
3086: FND_STATS.GATHER_TABLE_STATS('BEN','BEN_CWB_PERSON_GROUPS');
3087: -- END changes BUG#13436491
3088: fnd_file.put_line(which => fnd_file.log,
3089: -- buff => 'Completed : Populating heirarchy data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));
3090: buff => 'Completed : Populating hierarchy data, ' || to_char(sysdate,'dd-mm-yyyy hh24:mi:ss'));

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

3328: fnd_message.raise_error;
3329: --
3330: end global_process;
3331: --
3332: -- Procedure to populate ben_cwb_person_rates, ben_cwb_person_groups.
3333: --
3334: procedure populate_cwb_rates(
3335: --
3336: -- Columns needed for ben_cwb_person_rates

Line 3350: -- Columns needed by BEN_CWB_PERSON_GROUPS

3346: ,p_acty_base_rt_id in number default null
3347: ,p_elig_flag in varchar2 default 'Y'
3348: ,p_inelig_rsn_cd in varchar2 default null
3349: --
3350: -- Columns needed by BEN_CWB_PERSON_GROUPS
3351: --
3352: ,p_due_dt in date default null
3353: ,p_access_cd in varchar2 default null
3354: ,p_elig_per_elctbl_chc_id in number default null

Line 3406: -- Populate BEN_CWB_PERSON_GROUPS

3402: end if;
3403: --
3404: if p_pl_id = g_cache_group_plan_rec.group_pl_id then
3405: --
3406: -- Populate BEN_CWB_PERSON_GROUPS
3407: -- Primary Key: GROUP_PER_IN_LER_ID, GROUP_PL_ID, GROUP_OIPL_ID
3408: --
3409: if g_debug then
3410: hr_utility.set_location ('Group rate ' ,15);

Line 3438: insert into ben_cwb_person_groups

3434: open c_group_oipl(g_cache_group_plan_rec.group_lf_evt_ocrd_dt);
3435: fetch c_group_oipl into l_group_oipl_id;
3436: close c_group_oipl;
3437: --
3438: insert into ben_cwb_person_groups
3439: (group_per_in_ler_id,
3440: group_pl_id ,
3441: group_oipl_id ,
3442: lf_evt_ocrd_dt ,

Line 4003: from ben_cwb_person_groups cpg

3999: l_copy_person_bdgt_count binary_integer;
4000: --
4001: cursor c_cpg(c_group_pl_id number, c_group_lf_evt_ocrd_dt date) is
4002: select cpg.*
4003: from ben_cwb_person_groups cpg
4004: where cpg.group_pl_id = c_group_pl_id
4005: and cpg.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
4006: and cpg.group_per_in_ler_id =
4007: (select cpg1.group_per_in_ler_id

Line 4008: from ben_cwb_person_groups cpg1

4004: where cpg.group_pl_id = c_group_pl_id
4005: and cpg.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
4006: and cpg.group_per_in_ler_id =
4007: (select cpg1.group_per_in_ler_id
4008: from ben_cwb_person_groups cpg1
4009: where cpg1.group_pl_id = c_group_pl_id
4010: and cpg1.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
4011: and rownum = 1);
4012: --

Line 4013: l_copy_dist_bdgt_val ben_cwb_person_groups.dist_bdgt_val%type;

4009: where cpg1.group_pl_id = c_group_pl_id
4010: and cpg1.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
4011: and rownum = 1);
4012: --
4013: l_copy_dist_bdgt_val ben_cwb_person_groups.dist_bdgt_val%type;
4014: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;
4015: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
4016: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
4017: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;

Line 4014: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;

4010: and cpg1.lf_evt_ocrd_dt = c_group_lf_evt_ocrd_dt
4011: and rownum = 1);
4012: --
4013: l_copy_dist_bdgt_val ben_cwb_person_groups.dist_bdgt_val%type;
4014: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;
4015: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
4016: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
4017: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
4018: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;

Line 4015: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;

4011: and rownum = 1);
4012: --
4013: l_copy_dist_bdgt_val ben_cwb_person_groups.dist_bdgt_val%type;
4014: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;
4015: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
4016: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
4017: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
4018: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
4019: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;

Line 4016: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;

4012: --
4013: l_copy_dist_bdgt_val ben_cwb_person_groups.dist_bdgt_val%type;
4014: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;
4015: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
4016: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
4017: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
4018: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
4019: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
4020: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;

Line 4017: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;

4013: l_copy_dist_bdgt_val ben_cwb_person_groups.dist_bdgt_val%type;
4014: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;
4015: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
4016: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
4017: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
4018: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
4019: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
4020: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
4021: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;

Line 4018: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;

4014: l_copy_dist_bdgt_mn_val ben_cwb_person_groups.dist_bdgt_mn_val%type;
4015: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
4016: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
4017: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
4018: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
4019: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
4020: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
4021: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
4022: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;

Line 4019: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;

4015: l_copy_dist_bdgt_mx_val ben_cwb_person_groups.dist_bdgt_mx_val%type;
4016: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
4017: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
4018: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
4019: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
4020: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
4021: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
4022: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
4023: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;

Line 4020: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;

4016: l_copy_dist_bdgt_incr_val ben_cwb_person_groups.dist_bdgt_incr_val%type;
4017: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
4018: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
4019: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
4020: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
4021: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
4022: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
4023: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
4024: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;

Line 4021: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;

4017: l_copy_dist_bdgt_iss_val ben_cwb_person_groups.dist_bdgt_iss_val%type;
4018: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
4019: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
4020: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
4021: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
4022: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
4023: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
4024: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
4025: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;

Line 4022: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;

4018: l_copy_dist_bdgt_iss_date ben_cwb_person_groups.dist_bdgt_iss_date%type;
4019: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
4020: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
4021: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
4022: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
4023: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
4024: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
4025: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
4026: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;

Line 4023: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;

4019: l_copy_ws_bdgt_val ben_cwb_person_groups.ws_bdgt_val%type;
4020: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
4021: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
4022: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
4023: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
4024: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
4025: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
4026: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;
4027: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;

Line 4024: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;

4020: l_copy_ws_bdgt_mn_val ben_cwb_person_groups.ws_bdgt_mn_val%type;
4021: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
4022: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
4023: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
4024: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
4025: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
4026: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;
4027: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;
4028: l_copy_rsrv_incr_val ben_cwb_person_groups.rsrv_incr_val%type;

Line 4025: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;

4021: l_copy_ws_bdgt_mx_val ben_cwb_person_groups.ws_bdgt_mx_val%type;
4022: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
4023: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
4024: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
4025: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
4026: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;
4027: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;
4028: l_copy_rsrv_incr_val ben_cwb_person_groups.rsrv_incr_val%type;
4029: --

Line 4026: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;

4022: l_copy_ws_bdgt_incr_val ben_cwb_person_groups.ws_bdgt_incr_val%type;
4023: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
4024: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
4025: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
4026: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;
4027: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;
4028: l_copy_rsrv_incr_val ben_cwb_person_groups.rsrv_incr_val%type;
4029: --
4030: CURSOR c_pl_dsgn (c_group_pl_id NUMBER, c_group_lf_evt_ocrd_dt DATE)

Line 4027: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;

4023: l_copy_ws_bdgt_iss_val ben_cwb_person_groups.ws_bdgt_iss_val%type;
4024: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
4025: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
4026: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;
4027: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;
4028: l_copy_rsrv_incr_val ben_cwb_person_groups.rsrv_incr_val%type;
4029: --
4030: CURSOR c_pl_dsgn (c_group_pl_id NUMBER, c_group_lf_evt_ocrd_dt DATE)
4031: IS

Line 4028: l_copy_rsrv_incr_val ben_cwb_person_groups.rsrv_incr_val%type;

4024: l_copy_ws_bdgt_iss_date ben_cwb_person_groups.ws_bdgt_iss_date%type;
4025: l_copy_rsrv_val ben_cwb_person_groups.rsrv_val%type;
4026: l_copy_rsrv_mn_val ben_cwb_person_groups.rsrv_mn_val%type;
4027: l_copy_rsrv_mx_val ben_cwb_person_groups.rsrv_mx_val%type;
4028: l_copy_rsrv_incr_val ben_cwb_person_groups.rsrv_incr_val%type;
4029: --
4030: CURSOR c_pl_dsgn (c_group_pl_id NUMBER, c_group_lf_evt_ocrd_dt DATE)
4031: IS
4032: SELECT group_oipl_id

Line 4155: there is no record in ben_cwb_person_groups .

4151: end if;
4152:
4153: /* 5124534 :
4154: if g_cache_cpg_rec.count is still zero means
4155: there is no record in ben_cwb_person_groups .
4156: populate group_pl_id,group_oipl_id,budget values
4157: into g_cache_cpg_rec
4158:
4159: */

Line 4269: -- Create the ben_cwb_person_groups data.

4265: end if;
4266: --
4267: end loop;
4268: --
4269: -- Create the ben_cwb_person_groups data.
4270: --
4271: if nvl(g_cache_cpg_rec.count, 0) > 0 then
4272: --
4273: for l_cpg_count in 1..g_cache_cpg_rec.count loop

Line 4275: -- update ben_cwb_person_groups with budget copy_ columns

4271: if nvl(g_cache_cpg_rec.count, 0) > 0 then
4272: --
4273: for l_cpg_count in 1..g_cache_cpg_rec.count loop
4274: --
4275: -- update ben_cwb_person_groups with budget copy_ columns
4276: --
4277: if nvl(l_copy_person_bdgt_count, 0) > 0 then
4278: for l_bdgt_count in 1..l_copy_person_bdgt_count loop
4279: --

Line 4332: -- create row in ben_cwb_person_groups

4328: end loop;
4329: --
4330: end if;
4331: --
4332: -- create row in ben_cwb_person_groups
4333: --
4334: hr_utility.set_location('Creating missing ben_cwb_person_groups', 1234);
4335: insert into ben_cwb_person_groups
4336: (group_per_in_ler_id,

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

4330: end if;
4331: --
4332: -- create row in ben_cwb_person_groups
4333: --
4334: hr_utility.set_location('Creating missing ben_cwb_person_groups', 1234);
4335: insert into ben_cwb_person_groups
4336: (group_per_in_ler_id,
4337: group_pl_id ,
4338: group_oipl_id ,

Line 4335: insert into ben_cwb_person_groups

4331: --
4332: -- create row in ben_cwb_person_groups
4333: --
4334: hr_utility.set_location('Creating missing ben_cwb_person_groups', 1234);
4335: insert into ben_cwb_person_groups
4336: (group_per_in_ler_id,
4337: group_pl_id ,
4338: group_oipl_id ,
4339: lf_evt_ocrd_dt ,

Line 4880: from ben_cwb_person_groups cpg

4876: ) is
4877: --
4878: cursor c_high_mgr_cpg(c_group_pl_id number, c_lf_evt_ocrd_dt date) is
4879: select cpg.rowid, cpg.*
4880: from ben_cwb_person_groups cpg
4881: where cpg.group_pl_id = c_group_pl_id
4882: and cpg.lf_evt_ocrd_dt = c_lf_evt_ocrd_dt
4883: and exists
4884: ( SELECT /*+ no_unnest */ NULL

Line 4899: from ben_cwb_person_groups cpg

4895: for update;
4896: --
4897: cursor c_leaf_mgr_cpg(c_group_pl_id number, c_lf_evt_ocrd_dt date) is
4898: select cpg.rowid, cpg.*
4899: from ben_cwb_person_groups cpg
4900: where cpg.group_pl_id = c_group_pl_id
4901: and cpg.lf_evt_ocrd_dt = c_lf_evt_ocrd_dt
4902: and not exists
4903: (select /*+ no_unnest */ null

Line 4961: update ben_cwb_person_groups

4957: l_iss_dt := null;
4958: --
4959: end if;
4960: --
4961: update ben_cwb_person_groups
4962: set dist_bdgt_val = dflt_dist_bdgt_val,
4963: ws_bdgt_val = dflt_ws_bdgt_val,
4964: ws_bdgt_val_last_upd_date = p_lf_evt_ocrd_dt,
4965: dist_bdgt_val_last_upd_date = p_lf_evt_ocrd_dt,

Line 5003: update ben_cwb_person_groups

4999: l_iss_dt := null;
5000: --
5001: end if;
5002: --
5003: update ben_cwb_person_groups
5004: set ws_bdgt_val = dflt_ws_bdgt_val,
5005: ws_bdgt_val_last_upd_date = p_lf_evt_ocrd_dt,
5006: ws_bdgt_iss_val = l_dflt_ws_bdgt_val,
5007: ws_bdgt_iss_date = l_iss_dt,