APPS.BEN_BVR_BUS dependencies on BEN_BNFT_VRBL_RT_F

Line 92: -- p_bnft_vrbl_rt_id Primary Key of BEN_BNFT_VRBL_RT_F

88: -- None.
89: --
90: -- In Parameters
91: -- p_ordr_num Sequence Number
92: -- p_bnft_vrbl_rt_id Primary Key of BEN_BNFT_VRBL_RT_F
93: -- p_cvg_amt_calc_mthd_id Foreign Key to BEN_CVG_AMT_CALC_MTHD_F
94: -- p_business_group_id
95: --
96: -- Post Success

Line 115: from ben_bnft_vrbl_rt_f

111: is
112: l_proc varchar2(72) := g_package||'chk_ordr_num_unique';
113: l_dummy char(1);
114: cursor c1 is select null
115: from ben_bnft_vrbl_rt_f
116: Where bnft_vrbl_rt_id <> nvl(p_bnft_vrbl_rt_id,-1)
117: and cvg_amt_calc_mthd_id = p_cvg_amt_calc_mthd_id
118: and ordr_num = p_ordr_num
119: and business_group_id = p_business_group_id;

Line 562: ben_bnft_vrbl_rt_f b

558: --
559: cursor csr_leg_code is
560: select a.legislation_code
561: from per_business_groups a,
562: ben_bnft_vrbl_rt_f b
563: where b.bnft_vrbl_rt_id = p_bnft_vrbl_rt_id
564: and a.business_group_id = b.business_group_id;
565: --
566: -- Declare local variables