APPS.BEN_PCG_BUS dependencies on PER_BUSINESS_GROUPS

Line 399: from per_business_groups a,

395: -- Declare cursor
396: --
397: cursor csr_leg_code is
398: select a.legislation_code
399: from per_business_groups a,
400: ben_prtt_clm_gd_or_svc_typ b
401: where b.prtt_clm_gd_or_svc_typ_id = p_prtt_clm_gd_or_svc_typ_id
402: and a.business_group_id = b.business_group_id;
403: --

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

402: and a.business_group_id = b.business_group_id;
403: --
404: -- Declare local variables
405: --
406: l_legislation_code per_business_groups.legislation_code%TYPE; -- UTF8 varchar2(150);
407: l_proc varchar2(72) := g_package||'return_legislation_code';
408: --
409: begin
410: --