APPS.BEN_SVA_BUS dependencies on PER_BUSINESS_GROUPS

Line 544: from per_business_groups a,

540: -- Declare cursor
541: --
542: cursor csr_leg_code is
543: select a.legislation_code
544: from per_business_groups a,
545: ben_svc_area_f b
546: where b.svc_area_id = p_svc_area_id
547: and a.business_group_id = b.business_group_id;
548: --

Line 551: l_legislation_code per_business_groups.legislation_code%type ; --varchar2(150);

547: and a.business_group_id = b.business_group_id;
548: --
549: -- Declare local variables
550: --
551: l_legislation_code per_business_groups.legislation_code%type ; --varchar2(150);
552: l_proc varchar2(72) := g_package||'return_legislation_code';
553: --
554: begin
555: --