DBA Data[Home] [Help]

APPS.BEN_CPO_BUS dependencies on PER_BUSINESS_GROUPS

Line 550: from per_business_groups a,

546: -- Declare cursor
547: --
548: cursor csr_leg_code is
549: select a.legislation_code
550: from per_business_groups a,
551: ben_popl_org_f b
552: where b.popl_org_id = p_popl_org_id
553: and a.business_group_id = b.business_group_id;
554: --

Line 557: l_legislation_code per_business_groups.legislation_code%TYPE; -- UTF8 varchar2(150);

553: and a.business_group_id = b.business_group_id;
554: --
555: -- Declare local variables
556: --
557: l_legislation_code per_business_groups.legislation_code%TYPE; -- UTF8 varchar2(150);
558: l_proc varchar2(72) := g_package||'return_legislation_code';
559: --
560: begin
561: --