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