DBA Data[Home] [Help]

APPS.BEN_WHATIF_ELIG dependencies on BEN_CRT_ORDR

Line 2831: select * from ben_crt_ordr

2827: ,p_effective_date in date
2828: ) is
2829: --
2830: cursor c_crt_ordr is
2831: select * from ben_crt_ordr
2832: where person_id = p_person_id and
2833: crt_ordr_typ_cd = p_crt_ordr_typ_cd and
2834: business_group_id = p_business_group_id and
2835: p_effective_date between apls_perd_strtg_dt