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 5029: -- Validates that business_group is present in PER_BUSINESS_GROUPS

5025: -- |-------------------------< chk_bgr_id >-----------------------------------|
5026: -- ----------------------------------------------------------------------------
5027: --
5028: -- Description:
5029: -- Validates that business_group is present in PER_BUSINESS_GROUPS
5030: --
5031: -- Pre-conditions:
5032: -- None.
5033: --

Line 5073: FROM PER_BUSINESS_GROUPS

5069: INTO l_exists
5070: FROM sys.dual
5071: WHERE EXISTS
5072: (SELECT null
5073: FROM PER_BUSINESS_GROUPS
5074: WHERE business_group_id = p_bgr_id);
5075: EXCEPTION
5076: WHEN NO_DATA_FOUND THEN NULL;
5077: END;