[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
3042: ecr.acty_base_rt_id,
3043: nvl(ecr.dflt_val, ecr.val) val
3044: from ben_elig_per_elctbl_chc epe1,
3045: ben_elig_per_elctbl_chc epe,
3046: ben_enrt_rt ecr
3047: where epe1.prtt_enrt_rslt_id =p_prtt_enrt_rslt_id and
3048: epe1.per_in_ler_id = p_per_in_ler_id and
3049: epe1.business_group_id=p_business_group_id and
3050: epe1.pgm_id = epe.pgm_id and
5537: ,abr.element_type_id
5538: ,abr.input_value_id
5539: ,prv.rt_strt_dt
5540: from ben_prtt_rt_val prv
5541: ,ben_enrt_rt ecr
5542: ,ben_acty_base_rt_f abr
5543: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5544: and prv.prtt_rt_val_stat_cd is null
5545: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id (+) */
5590: ,prv.object_version_number
5591: ,ecr.enrt_rt_id
5592: ,ecr.acty_base_rt_id
5593: from ben_prtt_rt_val prv,
5594: ben_enrt_rt ecr
5595: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5596: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id
5597: and prv.rt_end_dt <> hr_api.g_eot
5598: and prv.business_group_id = p_business_group_id
5743:
5744: if g_debug then
5745: hr_utility.set_location('delete prtt',3459);
5746: end if;
5747: update ben_enrt_rt
5748: set prtt_rt_val_id = null
5749: where enrt_rt_id = l_prv.enrt_rt_id;
5750: --
5751: ben_prtt_rt_val_api.delete_prtt_rt_val
6257: ,abr.input_value_id
6258: ,abr.entr_val_at_enrt_flag
6259: ,prv.rt_strt_dt
6260: from ben_prtt_rt_val prv
6261: ,ben_enrt_rt ecr
6262: ,ben_acty_base_rt_f abr
6263: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6264: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id (+)
6265: and prv.business_group_id = p_business_group_id
6281: ,prv.object_version_number
6282: ,ecr.enrt_rt_id
6283: ,ecr.acty_base_rt_id
6284: from ben_prtt_rt_val prv,
6285: ben_enrt_rt ecr
6286: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6287: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id
6288: and prv.rt_end_dt <> hr_api.g_eot
6289: and prv.business_group_id = p_business_group_id
6298: ,abr.element_type_id
6299: ,abr.input_value_id
6300: ,prv.rt_end_dt --This is needed to determine the future started rate
6301: from ben_prtt_rt_val prv
6302: ,ben_enrt_rt ecr
6303: ,ben_acty_base_rt_f abr
6304: where prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6305: and prv.rt_end_dt > p_rt_end_dt
6306: and prv.prtt_rt_val_id = ecr.prtt_rt_val_id (+)
6777: p_person_id number,
6778: p_per_in_ler_id number,
6779: p_effective_date date) is
6780: --
6781: --Bug 3412562 Doesn't look like we need link to ben_enrt_rt table here.
6782: --
6783: cursor c_prv is
6784: select prv.prtt_rt_val_id
6785: ,prv.object_version_number
7718: end if;
7719: if g_debug then
7720: hr_utility.set_location('delete prtt',3459);
7721: end if;
7722: update ben_enrt_rt
7723: set prtt_rt_val_id = null
7724: where enrt_rt_id = l_prv.enrt_rt_id;
7725: --
7726: ben_prtt_rt_val_api.delete_prtt_rt_val
8262: end if;
8263: if g_debug then
8264: hr_utility.set_location('delete prtt',3459);
8265: end if;
8266: update ben_enrt_rt
8267: set prtt_rt_val_id = null
8268: where enrt_rt_id = l_prv.enrt_rt_id;
8269: --
8270: ben_prtt_rt_val_api.delete_prtt_rt_val