APPS.BEN_AVA_BUS dependencies on BEN_ACTL_PREM_VRBL_RT_RL_F

Line 339: -- p_actl_prem_vrbl_rt_rl_id Primary Key of BEN_ACTL_PREM_VRBL_RT_RL_F

335: -- None.
336: --
337: -- In Parameters
338: -- p_ordr_to_aply_num Sequence Number
339: -- p_actl_prem_vrbl_rt_rl_id Primary Key of BEN_ACTL_PREM_VRBL_RT_RL_F
340: -- p_actl_prem_id Foreign Key to BEN_ACTL_PREM_F
341: -- p_business_group_id
342: --
343: -- Post Success

Line 362: from ben_actl_prem_vrbl_rt_rl_f

358: is
359: l_proc varchar2(72) := g_package||'chk_ordr_to_aply_num_unique';
360: l_dummy char(1);
361: cursor c1 is select null
362: from ben_actl_prem_vrbl_rt_rl_f
363: Where actl_prem_vrbl_rt_rl_id <> nvl(p_actl_prem_vrbl_rt_rl_id,-1)
364: and actl_prem_id = p_actl_prem_id
365: and ordr_to_aply_num = p_ordr_to_aply_num
366: and business_group_id = p_business_group_id;

Line 737: ben_actl_prem_vrbl_rt_rl_f b

733: --
734: cursor csr_leg_code is
735: select a.legislation_code
736: from per_business_groups a,
737: ben_actl_prem_vrbl_rt_rl_f b
738: where b.actl_prem_vrbl_rt_rl_id = p_actl_prem_vrbl_rt_rl_id
739: and a.business_group_id = b.business_group_id;
740: --
741: -- Declare local variables