APPS.BEN_CBS_BUS dependencies on BEN_PREM_CSTG_BY_SGMT_F

Line 318: from ben_prem_cstg_by_sgmt_f

314: is
315: l_proc varchar2(72) := g_package||'chk_sgmt_num_unique';
316: l_dummy char(1);
317: cursor c1 is select null
318: from ben_prem_cstg_by_sgmt_f
319: Where prem_cstg_by_sgmt_id <> nvl(p_prem_cstg_by_sgmt_id,-1)
320: and actl_prem_id = p_actl_prem_id
321: and sgmt_num = p_sgmt_num
322: and business_group_id = p_business_group_id;

Line 863: ben_prem_cstg_by_sgmt_f b

859: --
860: cursor csr_leg_code is
861: select a.legislation_code
862: from per_business_groups a,
863: ben_prem_cstg_by_sgmt_f b
864: where b.prem_cstg_by_sgmt_id = p_prem_cstg_by_sgmt_id
865: and a.business_group_id = b.business_group_id;
866: --
867: -- Declare local variables