DBA Data[Home] [Help]

APPS.BEN_PRB_BUS dependencies on PER_BUSINESS_GROUPS

Line 810: from per_business_groups a,

806: -- Declare cursor
807: --
808: cursor csr_leg_code is
809: select a.legislation_code
810: from per_business_groups a,
811: ben_pl_regy_bod_f b
812: where b.pl_regy_bod_id = p_pl_regy_bod_id
813: and a.business_group_id = b.business_group_id;
814: --

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

813: and a.business_group_id = b.business_group_id;
814: --
815: -- Declare local variables
816: --
817: l_legislation_code per_business_groups.legislation_code%type; --varchar2(150);
818: l_proc varchar2(72) := g_package||'return_legislation_code';
819: --
820: begin
821: --