APPS.BEN_DDR_BUS dependencies on BEN_DSGN_RQMT_F

Line 566: -- ben_dsgn_rqmt_f between plan, oipl, and opt.

562: -- ----------------------------------------------------------------------------
563: --
564: -- Description
565: -- This procedure is used to enforce the ARC relationship existing on
566: -- ben_dsgn_rqmt_f between plan, oipl, and opt.
567: --
568: -- Pre Conditions
569: -- None.
570: --

Line 609: from ben_dsgn_rqmt_f a

605: --
606: cursor c1 is
607: select a.pl_id, a.oipl_id, a.opt_id
608: -- into l_pl_id, l_oipl_id, l_opt_id
609: from ben_dsgn_rqmt_f a
610: where a.business_group_id +0 = p_business_group_id
611: and a.dsgn_rqmt_id = p_dsgn_rqmt_id
612: and p_effective_date
613: between a.effective_start_date

Line 708: from ben_dsgn_rqmt_f

704:
705: --
706: cursor c_chk_uniq_dsgn_rqmt is
707: select 'X'
708: from ben_dsgn_rqmt_f
709: where business_group_id = p_business_group_id
710: and grp_rlshp_cd = p_grp_rlshp_cd
711: and dsgn_typ_cd = p_dsgn_typ_cd
712: and p_effective_date

Line 1235: ben_dsgn_rqmt_f b

1231: --
1232: cursor csr_leg_code is
1233: select a.legislation_code
1234: from per_business_groups a,
1235: ben_dsgn_rqmt_f b
1236: where b.dsgn_rqmt_id = p_dsgn_rqmt_id
1237: and a.business_group_id = b.business_group_id;
1238: --
1239: -- Declare local variables