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