APPS.PER_APP_ASG_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 1129: from per_all_assignments_f paf

1125: -- Start of fix 3634447
1126: -- Cursor to get the current organization
1127: cursor current_org is
1128: select paf.organization_id
1129: from per_all_assignments_f paf
1130: where assignment_id = p_assignment_id
1131: and p_effective_start_date between effective_start_date
1132: and effective_end_date;
1133: --

Line 1134: l_old_org_id per_all_assignments_f.organization_id%Type;

1130: where assignment_id = p_assignment_id
1131: and p_effective_start_date between effective_start_date
1132: and effective_end_date;
1133: --
1134: l_old_org_id per_all_assignments_f.organization_id%Type;
1135: --
1136: -- End of fix 3634447
1137: begin
1138: --

Line 1629: from per_all_assignments_f a

1625: and a.business_group_id + 0 = p_business_group_id ;
1626: --
1627: cursor c3 is
1628: select max(a.effective_end_date)
1629: from per_all_assignments_f a
1630: where a.person_id = p_person_id
1631: and a.business_group_id + 0 = p_business_group_id
1632: and a.assignment_id <> p_assignment_id
1633: and a.assignment_type = 'A'

Line 1689: select 'Y' from per_all_assignments_f

1685: --
1686: l_exists varchar2(10);
1687: --
1688: cursor csr_hire_exists(cp_asg_id number, cp_effective_date date) is
1689: select 'Y' from per_all_assignments_f
1690: where assignment_id = cp_asg_id
1691: and assignment_type = 'E'
1692: and effective_start_date > cp_effective_date;
1693: --

Line 1899: select 'Y' from per_all_assignments_f a

1895: p_allowed out nocopy varchar2 ) IS
1896: --
1897: l_dummy varchar2(1) := 'N';
1898: cursor csr_chk_mode is
1899: select 'Y' from per_all_assignments_f a
1900: where p_assignment_id = a.assignment_id
1901: and (a.effective_start_date < p_effective_start_date);
1902: --
1903: begin