[Home] [Help]
79: 115.30 Dec 07 1998 Hdang Add parameter into multi-row edit to
80: handle last year enrollment but not
81: default current year.
82: 115.31 Dec 10 1998 Hdang modify the c_prv to eliminate duplicate
83: row cause by multi-row ben_enrt_rt.
84: 115.32 Dec 11 1998 lmcdonal When deleting rows in multi-row, join to
85: choice table.
86: 115.33 Dec 15 1998 pxdas Added Code for logging change event
87: 115.34 Dec 16 1998 pxdas Modified Change_exists_in_db procedure
3231: ecr.acty_base_rt_id,
3232: nvl(ecr.dflt_val, ecr.val) val
3233: from ben_elig_per_elctbl_chc epe1,
3234: ben_elig_per_elctbl_chc epe,
3235: ben_enrt_rt ecr
3236: where epe1.prtt_enrt_rslt_id =p_prtt_enrt_rslt_id and
3237: epe1.per_in_ler_id = p_per_in_ler_id and
3238: epe1.business_group_id=p_business_group_id and
3239: epe1.pgm_id = epe.pgm_id and
5826: ,abr.element_type_id
5827: ,abr.input_value_id
5828: ,prv.rt_strt_dt
5829: from ben_prtt_rt_val prv
5830: ,ben_enrt_rt ecr
5831: ,ben_acty_base_rt_f abr
5832: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5833: and prv.prtt_rt_val_stat_cd is null
5834: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id (+) */
5879: ,prv.object_version_number
5880: ,ecr.enrt_rt_id
5881: ,ecr.acty_base_rt_id
5882: from ben_prtt_rt_val prv,
5883: ben_enrt_rt ecr
5884: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5885: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id
5886: and prv.rt_end_dt <> hr_api.g_eot
5887: and prv.business_group_id = p_business_group_id
6032:
6033: if g_debug then
6034: hr_utility.set_location('delete prtt',3459);
6035: end if;
6036: update ben_enrt_rt
6037: set prtt_rt_val_id = null
6038: where enrt_rt_id = l_prv.enrt_rt_id;
6039: --
6040: ben_prtt_rt_val_api.delete_prtt_rt_val
6508: ,abr.input_value_id
6509: ,abr.entr_val_at_enrt_flag
6510: ,prv.rt_strt_dt
6511: from ben_prtt_rt_val prv
6512: ,ben_enrt_rt ecr
6513: ,ben_acty_base_rt_f abr
6514: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6515: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id (+)
6516: and prv.business_group_id = p_business_group_id
6532: ,prv.object_version_number
6533: ,ecr.enrt_rt_id
6534: ,ecr.acty_base_rt_id
6535: from ben_prtt_rt_val prv,
6536: ben_enrt_rt ecr
6537: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6538: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id
6539: and prv.rt_end_dt <> hr_api.g_eot
6540: and prv.business_group_id = p_business_group_id
6549: ,abr.element_type_id
6550: ,abr.input_value_id
6551: ,prv.rt_end_dt --This is needed to determine the future started rate
6552: from ben_prtt_rt_val prv
6553: ,ben_enrt_rt ecr
6554: ,ben_acty_base_rt_f abr
6555: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6556: and prv.rt_end_dt > p_rt_end_dt
6557: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id (+)
7311: cursor c_enrt_rt(p_prtt_rt_val_id number
7312: ) is
7313: select ecr.*
7314: ,enb.elig_per_elctbl_chc_id enb_per_elctbl_chc_id
7315: from ben_enrt_rt ecr
7316: ,ben_enrt_bnft enb
7317: where ecr.prtt_rt_val_id = p_prtt_rt_val_id
7318: and exists (select null
7319: from ben_prtt_enrt_rslt_f pen
7338: p_person_id number,
7339: p_per_in_ler_id number,
7340: p_effective_date date) is
7341: --
7342: --Bug 3412562 Doesn't look like we need link to ben_enrt_rt table here.
7343: --
7344: cursor c_prv is
7345: select prv.prtt_rt_val_id
7346: ,prv.object_version_number
7367: cursor c_enrt_rt(p_prtt_rt_val_id number
7368: ) is
7369: select ecr.*
7370: ,enb.elig_per_elctbl_chc_id enb_per_elctbl_chc_id
7371: from ben_enrt_rt ecr
7372: ,ben_enrt_bnft enb
7373: where ecr.prtt_rt_val_id = p_prtt_rt_val_id
7374: and exists (select null
7375: from ben_prtt_enrt_rslt_f pen
8676: end if;
8677: if g_debug then
8678: hr_utility.set_location('delete prtt',3459);
8679: end if;
8680: update ben_enrt_rt
8681: set prtt_rt_val_id = null
8682: where enrt_rt_id = l_prv.enrt_rt_id;
8683: --
8684: ben_prtt_rt_val_api.delete_prtt_rt_val
9493: end if;
9494: if g_debug then
9495: hr_utility.set_location('delete prtt',3459);
9496: end if;
9497: update ben_enrt_rt
9498: set prtt_rt_val_id = null
9499: where enrt_rt_id = l_prv.enrt_rt_id;
9500: --
9501: ben_prtt_rt_val_api.delete_prtt_rt_val