APPS.HR_ORGANIZATION_API dependencies on PER_BUSINESS_GROUPS

Line 474: from per_business_groups_perf bus

470: -- for the current business group
471: --
472: cursor csr_cost_idsel is
473: select bus.cost_allocation_structure
474: from per_business_groups_perf bus
475: where bus.business_group_id = p_business_group_id;
476: --
477: begin
478: --

Line 1588: from per_business_groups_perf bus

1584: --
1585: --
1586: cursor csr_cost_idsel is
1587: select bus.cost_allocation_structure
1588: from per_business_groups_perf bus
1589: where bus.business_group_id = l_business_group_id;
1590: --
1591: -- Start of 3187772
1592: l_old_cost_segments c_cost_segments%rowtype;

Line 2260: from per_business_groups pbg,

2256: IS
2257: --
2258: cursor csr_get_leg_code is
2259: select legislation_code
2260: from per_business_groups pbg,
2261: hr_all_organization_units hou
2262: where hou.organization_id = p_organization_id
2263: and pbg.business_group_id = hou.business_group_id;
2264:

Line 5083: -- Validates that business_group is present in PER_BUSINESS_GROUPS

5079: -- |-------------------------< chk_bgr_id >-----------------------------------|
5080: -- ----------------------------------------------------------------------------
5081: --
5082: -- Description:
5083: -- Validates that business_group is present in PER_BUSINESS_GROUPS
5084: --
5085: -- Pre-conditions:
5086: -- None.
5087: --

Line 5127: FROM PER_BUSINESS_GROUPS

5123: INTO l_exists
5124: FROM sys.dual
5125: WHERE EXISTS
5126: (SELECT null
5127: FROM PER_BUSINESS_GROUPS
5128: WHERE business_group_id = p_bgr_id);
5129: EXCEPTION
5130: WHEN NO_DATA_FOUND THEN NULL;
5131: END;