APPS.PER_CPN_BUS dependencies on PER_BUSINESS_GROUPS

Line 2752: from per_business_groups pbg,

2748: --
2749: -- Bug #2536636 --Modified the cursor with outer join
2750: cursor csr_leg_code is
2751: select pbg.legislation_code, pcp.business_group_id
2752: from per_business_groups pbg,
2753: per_competences pcp
2754: where pcp.competence_id = p_competence_id
2755: and pbg.business_group_id(+) = pcp.business_group_id;
2756:

Line 2760: l_business_group_id per_business_groups.business_group_id%Type;

2756:
2757: l_proc varchar2(72) := g_package||'return_legislation_code';
2758: l_legislation_code varchar2(150);
2759: -- Bug #2536636
2760: l_business_group_id per_business_groups.business_group_id%Type;
2761: --
2762: Begin
2763: hr_utility.set_location('Entering:'||l_proc, 5);
2764: --