APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_LER_F

Line 612: from ben_ler_f

608: l_ler_id number;
609: begin
610: select ler_id
611: into l_ler_id
612: from ben_ler_f
613: where typ_cd = 'GSP'
614: and lf_evt_oper_cd = p_oper_code
615: and business_group_id = p_bg_id
616: and p_effective_date between effective_start_date and effective_end_date;

Line 3774: FROM ben_ler_f

3770: IS
3771: CURSOR csr_ler_id
3772: IS
3773: SELECT ler_id
3774: FROM ben_ler_f
3775: WHERE typ_cd = 'GSP'
3776: AND lf_evt_oper_cd = 'SYNC'
3777: AND business_group_id = p_business_group_id
3778: AND effective_start_date = pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id, null);