[Home] [Help]
21: procedure call.
22: 24 Nov 98 jcarpent 115.3 Check rltd_per_rsds_w_dsgntr_flag
23: Get dsgntr address if Y
24: 15 Dec 98 stee 115.4 Schema changes to
25: ben_dsgn_rqmt_f.
26: 21 Dec 98 jcarpent 115.5 Track date of elig change
27: 18 Jan 99 G Perry 115.6 LED V ED
28: 16 Apr 99 jcarpent 115.8 Added call to dpnt_cvg_elig_det_rl
29: 06 May 99 shdas 115.9 Added contexts to rule calls.
316: (c_effective_date in date
317: )
318: is
319: select null
320: from ben_dsgn_rqmt_f ddr
321: where (ddr.oipl_id = p_oipl_id
322: or ddr.pl_id = p_pl_id
323: or ddr.opt_id = (select oipl.opt_id
324: from ben_oipl_f oipl
339: ,p_contact_type in varchar2
340: )
341: is
342: select null
343: from ben_dsgn_rqmt_f ddr, ben_dsgn_rqmt_rlshp_typ rl
344: where ddr.dsgn_rqmt_id = rl.dsgn_rqmt_id(+)
345: and rl.rlshp_typ_cd = p_contact_type
346: and (ddr.oipl_id = p_oipl_id
347: or ddr.pl_id = p_pl_id
371: (c_effective_date in date
372: )
373: is
374: select null
375: from ben_dsgn_rqmt_f ddr
376: where ddr.grp_rlshp_cd is null
377: and (ddr.oipl_id = p_oipl_id
378: or ddr.pl_id = p_pl_id
379: or ddr.opt_id = (select oipl.opt_id
402: (c_effective_date in date
403: )
404: is
405: select null
406: from ben_dsgn_rqmt_f ddr,
407: ben_dsgn_rqmt_rlshp_typ rl
408: where ddr.dsgn_rqmt_id = rl.dsgn_rqmt_id(+)
409: and ddr.grp_rlshp_cd is not null
410: and rl.rlshp_typ_cd <> l_contact.contact_type