APPS.PER_CPN_BUS dependencies on PER_BUSINESS_GROUPS

Line 2746: from per_business_groups pbg,

2742: --
2743: -- Bug #2536636 --Modified the cursor with outer join
2744: cursor csr_leg_code is
2745: select pbg.legislation_code, pcp.business_group_id
2746: from per_business_groups pbg,
2747: per_competences pcp
2748: where pcp.competence_id = p_competence_id
2749: and pbg.business_group_id(+) = pcp.business_group_id;
2750:

Line 2754: l_business_group_id per_business_groups.business_group_id%Type;

2750:
2751: l_proc varchar2(72) := g_package||'return_legislation_code';
2752: l_legislation_code varchar2(150);
2753: -- Bug #2536636
2754: l_business_group_id per_business_groups.business_group_id%Type;
2755: --
2756: Begin
2757: hr_utility.set_location('Entering:'||l_proc, 5);
2758: --