APPS.BEN_APV_BUS dependencies on BEN_ACTL_PREM_VRBL_RT_F

Line 175: -- p_actl_prem_vrbl_rt_id Primary Key of BEN_ACTL_PREM_VRBL_RT_F

171: -- None.
172: --
173: -- In Parameters
174: -- p_ordr_num Sequence Number
175: -- p_actl_prem_vrbl_rt_id Primary Key of BEN_ACTL_PREM_VRBL_RT_F
176: -- p_actl_prem_id Foreign Key to BEN_ACTL_PREM_F
177: -- p_business_group_id
178: --
179: -- Post Success

Line 198: from ben_actl_prem_vrbl_rt_f

194: is
195: l_proc varchar2(72) := g_package||'chk_ordr_num_unique';
196: l_dummy char(1);
197: cursor c1 is select null
198: from ben_actl_prem_vrbl_rt_f
199: Where actl_prem_vrbl_rt_id <> nvl(p_actl_prem_vrbl_rt_id,-1)
200: and actl_prem_id = p_actl_prem_id
201: and ordr_num = p_ordr_num
202: and business_group_id = p_business_group_id;

Line 559: ben_actl_prem_vrbl_rt_f b

555: --
556: cursor csr_leg_code is
557: select a.legislation_code
558: from per_business_groups a,
559: ben_actl_prem_vrbl_rt_f b
560: where b.actl_prem_vrbl_rt_id = p_actl_prem_vrbl_rt_id
561: and a.business_group_id = b.business_group_id;
562: --
563: -- Declare local variables