APPS.HR_ORGANIZATION_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 1515: l_business_group_id per_all_assignments_f.business_group_id%Type;

1511: l_cost_alloc_key_id hr_all_organization_units.cost_allocation_keyflex_id%Type
1512: := p_cost_allocation_keyflex_id;
1513: l_cost_name pay_cost_allocation_keyflex.concatenated_segments%Type;
1514: l_old_cost_name pay_cost_allocation_keyflex.concatenated_segments%Type;
1515: l_business_group_id per_all_assignments_f.business_group_id%Type;
1516: --
1517: -- bug 3039046 new variables for derived values where key flex id is known.
1518: --
1519: l_cost_segment1 varchar2(60) := p_segment1;

Line 4463: , per_all_assignments_f PAAF

4459:
4460: cursor ou_person is
4461: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4462: from hr_organization_information HOI
4463: , per_all_assignments_f PAAF
4464: where HOI.organization_id = PAAF.organization_id
4465: and PAAF.person_id = p_person_id
4466: and p_effective_date between
4467: PAAF.effective_start_date and PAAF.effective_end_date

Line 4474: , per_all_assignments_f PAAF

4470: --
4471: cursor ou_assignment is
4472: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4473: from hr_organization_information HOI
4474: , per_all_assignments_f PAAF
4475: where HOI.organization_id = PAAF.organization_id
4476: and PAAF.assignment_id = p_assignment_id
4477: and p_effective_date between
4478: PAAF.effective_start_date and PAAF.effective_end_date