DBA Data[Home] [Help]

APPS.BEN_ABR_BUS dependencies on BEN_PL_TYP_OPT_TYP_F

Line 2556: from BEN_PL_TYP_OPT_TYP_F

2552: cursor chk_opt_usg_pltyp is
2553: select null
2554: from BEN_PL_TYP_F
2555: where PL_TYP_ID in (select pl_typ_id
2556: from BEN_PL_TYP_OPT_TYP_F
2557: where opt_id = p_opt_id
2558: and business_group_id = p_business_group_id
2559: and p_effective_start_date between effective_start_date and effective_end_date)
2560: and OPT_TYP_CD = 'ABS'