DBA Data[Home] [Help]

APPS.BEN_EHW_BUS dependencies on PER_BUSINESS_GROUPS

Line 664: from per_business_groups a,

660: -- Declare cursor
661: --
662: cursor csr_leg_code is
663: select a.legislation_code
664: from per_business_groups a,
665: ben_elig_hrs_wkd_prte_f b
666: where b.elig_hrs_wkd_prte_id = p_elig_hrs_wkd_prte_id
667: and a.business_group_id = b.business_group_id;
668: --

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

667: and a.business_group_id = b.business_group_id;
668: --
669: -- Declare local variables
670: --
671: l_legislation_code per_business_groups.legislation_code%TYPE; -- UTF8 varchar2(150);
672: l_proc varchar2(72) := g_package||'return_legislation_code';
673: --
674: begin
675: --