APPS.BEN_EVALUATE_DPNT_ELG_PROFILES dependencies on BEN_DSGN_RQMT_F

Line 25: ben_dsgn_rqmt_f.

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.

Line 313: from ben_dsgn_rqmt_f ddr

309: (c_effective_date in date
310: )
311: is
312: select null
313: from ben_dsgn_rqmt_f ddr
314: where (ddr.oipl_id = p_oipl_id
315: or ddr.pl_id = p_pl_id
316: or ddr.opt_id = (select oipl.opt_id
317: from ben_oipl_f oipl

Line 336: from ben_dsgn_rqmt_f ddr, ben_dsgn_rqmt_rlshp_typ rl

332: ,p_contact_type in varchar2
333: )
334: is
335: select null
336: from ben_dsgn_rqmt_f ddr, ben_dsgn_rqmt_rlshp_typ rl
337: where ddr.dsgn_rqmt_id = rl.dsgn_rqmt_id(+)
338: and rl.rlshp_typ_cd = p_contact_type
339: and (ddr.oipl_id = p_oipl_id
340: or ddr.pl_id = p_pl_id

Line 368: from ben_dsgn_rqmt_f ddr

364: (c_effective_date in date
365: )
366: is
367: select null
368: from ben_dsgn_rqmt_f ddr
369: where ddr.grp_rlshp_cd is null
370: and (ddr.oipl_id = p_oipl_id
371: or ddr.pl_id = p_pl_id
372: or ddr.opt_id = (select oipl.opt_id

Line 399: from ben_dsgn_rqmt_f ddr,

395: (c_effective_date in date
396: )
397: is
398: select null
399: from ben_dsgn_rqmt_f ddr,
400: ben_dsgn_rqmt_rlshp_typ rl
401: where ddr.dsgn_rqmt_id = rl.dsgn_rqmt_id(+)
402: and ddr.grp_rlshp_cd is not null
403: and rl.rlshp_typ_cd <> l_contact.contact_type