DBA Data[Home] [Help]

APPS.HR_AUTH_BRIDGE dependencies on BEN_PRTT_ENRT_RSLT_F

Line 200: FROM ben_prtt_enrt_rslt_f pen

196: RETURN varchar2 IS
197: --
198: CURSOR c_interim IS
199: SELECT rplcs_sspndd_rslt_id
200: FROM ben_prtt_enrt_rslt_f pen
201: WHERE pen.rplcs_sspndd_rslt_id = p_prtt_enrt_rslt_id
202: AND pen.business_group_id = p_business_group_id
203: AND p_effective_date BETWEEN pen.effective_start_date AND pen.effective_end_date;
204:

Line 205: l_rplcs_sspndd_rslt_id ben_prtt_enrt_rslt_f.rplcs_sspndd_rslt_id%type;

201: WHERE pen.rplcs_sspndd_rslt_id = p_prtt_enrt_rslt_id
202: AND pen.business_group_id = p_business_group_id
203: AND p_effective_date BETWEEN pen.effective_start_date AND pen.effective_end_date;
204:
205: l_rplcs_sspndd_rslt_id ben_prtt_enrt_rslt_f.rplcs_sspndd_rslt_id%type;
206: l_ret_val varchar2(100);
207: --
208: BEGIN
209: --