APPS.BEN_DETERMINE_ELIGIBILITY3 dependencies on BEN_DSGN_RQMT_RLSHP_TYP

Line 43: from ben_dsgn_rqmt_rlshp_typ drr

39: and ddr.effective_end_date;
40: --
41: cursor c_get_rlshp_typ(p_dsgn_rqmt_id in number) is
42: select *
43: from ben_dsgn_rqmt_rlshp_typ drr
44: where drr.dsgn_rqmt_id = p_dsgn_rqmt_id
45: and drr.business_group_id = p_business_group_id;
46: --
47: cursor c_dsgn_rl_typ(p_mn_dpnts_rqd_num in number

Line 64: from ben_dsgn_rqmt_rlshp_typ drr

60: between ppf.effective_start_date
61: and ppf.effective_end_date
62: and (ctr.contact_type in
63: (select rlshp_typ_cd drr
64: from ben_dsgn_rqmt_rlshp_typ drr
65: where drr.dsgn_rqmt_id = p_dsgn_rqmt_id
66: and drr.business_group_id = p_business_group_id)
67: or not exists (select null
68: from ben_dsgn_rqmt_rlshp_typ drr

Line 68: from ben_dsgn_rqmt_rlshp_typ drr

64: from ben_dsgn_rqmt_rlshp_typ drr
65: where drr.dsgn_rqmt_id = p_dsgn_rqmt_id
66: and drr.business_group_id = p_business_group_id)
67: or not exists (select null
68: from ben_dsgn_rqmt_rlshp_typ drr
69: where drr.dsgn_rqmt_id = p_dsgn_rqmt_id
70: and drr.business_group_id = p_business_group_id))
71: having count(*) >= nvl(p_mn_dpnts_rqd_num, 0);
72: --