[Home] [Help]
1619: -9999999999999999999999999999999999999 opt_id
1620: from ben_prtt_enrt_rslt_f pen,
1621: ben_elig_per_elctbl_chc epe,
1622: ben_plip_f cpp,
1623: ben_oipl_f cop,
1624: ben_pl_f pln
1625: where pen.person_id = c_person_id
1626: and pen.prtt_enrt_rslt_stat_cd is null
1627: and pen.pgm_id <> c_pgm_id
2897:
2898: --Bug 2390734 Changed the join condition to compare OPT.OPT_ID with OIPL.OPT_ID.(Intially it was being compared with itself)
2899: cursor c_opt_name(cv_oipl_id in number) is
2900: select ' : ' || opt.name
2901: from ben_oipl_f oipl,
2902: ben_opt_f opt
2903: where oipl.oipl_id = cv_oipl_id
2904: and opt.opt_id = oipl.opt_id --Bug 2390734
2905: and opt.business_group_id = p_business_group_id
2922: i binary_integer :=0;
2923: j binary_integer :=0;
2924: l_pl_notfnd boolean :=TRUE;
2925: l_init_flag boolean :=TRUE;
2926: l_prev_opt_id ben_oipl_f.opt_id%type := 0;
2927: l_status boolean;
2928: l_step integer;
2929: l_proc varchar2(72) := g_package||'multi_rows_edit';
2930: l_prev_oipl_id number := -999999;
2948: l_pl_rec ben_pl_f%rowtype;
2949: */
2950: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
2951: /*
2952: l_oipl_rec ben_oipl_f%rowtype;
2953: */
2954: l_plip_rec ben_cobj_cache.g_plip_inst_row;
2955: /*
2956: l_plip_rec ben_plip_f%rowtype;
3728: Raise l_integrity_error;
3729: End If;
3730: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
3731: NOT (dt_api.check_min_max_dates
3732: (p_base_table_name => 'ben_oipl_f',
3733: p_base_key_column => 'oipl_id',
3734: p_base_key_value => p_oipl_id,
3735: p_from_date => p_validation_start_date,
3736: p_to_date => p_validation_end_date))) Then
3733: p_base_key_column => 'oipl_id',
3734: p_base_key_value => p_oipl_id,
3735: p_from_date => p_validation_start_date,
3736: p_to_date => p_validation_end_date))) Then
3737: l_table_name := 'ben_oipl_f';
3738: Raise l_integrity_error;
3739: End If;
3740: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
3741: NOT (dt_api.check_min_max_dates