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 4409: , per_all_assignments_f PAAF

4405:
4406: cursor ou_person is
4407: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4408: from hr_organization_information HOI
4409: , per_all_assignments_f PAAF
4410: where HOI.organization_id = PAAF.organization_id
4411: and PAAF.person_id = p_person_id
4412: and p_effective_date between
4413: PAAF.effective_start_date and PAAF.effective_end_date

Line 4420: , per_all_assignments_f PAAF

4416: --
4417: cursor ou_assignment is
4418: select nvl(org_information1,fnd_profile.value('ORG_ID'))
4419: from hr_organization_information HOI
4420: , per_all_assignments_f PAAF
4421: where HOI.organization_id = PAAF.organization_id
4422: and PAAF.assignment_id = p_assignment_id
4423: and p_effective_date between
4424: PAAF.effective_start_date and PAAF.effective_end_date