1224: -- Start of fix 3634447
1225: -- Cursor to get the current organization
1226: cursor current_org is
1227: select paf.organization_id
1228: from per_all_assignments_f paf
1229: where assignment_id = p_assignment_id
1230: and p_effective_start_date between effective_start_date
1231: and effective_end_date;
1232: --
1229: where assignment_id = p_assignment_id
1230: and p_effective_start_date between effective_start_date
1231: and effective_end_date;
1232: --
1233: l_old_org_id per_all_assignments_f.organization_id%Type;
1234:
1235: -- Start changes for bug 13059935
1236: cursor ASS_CUR is
1237: select *
1824: and a.business_group_id + 0 = p_business_group_id ;
1825: --
1826: cursor c3 is
1827: select max(a.effective_end_date)
1828: from per_all_assignments_f a
1829: where a.person_id = p_person_id
1830: and a.business_group_id + 0 = p_business_group_id
1831: and a.assignment_id <> p_assignment_id
1832: and a.assignment_type = 'A'
1888: --
1889: l_exists varchar2(10);
1890: --
1891: cursor csr_hire_exists(cp_asg_id number, cp_effective_date date) is
1892: select 'Y' from per_all_assignments_f
1893: where assignment_id = cp_asg_id
1894: and assignment_type = 'E'
1895: and effective_start_date > cp_effective_date;
1896: --
2116: p_allowed out nocopy varchar2 ) IS
2117: --
2118: l_dummy varchar2(1) := 'N';
2119: cursor csr_chk_mode is
2120: select 'Y' from per_all_assignments_f a
2121: where p_assignment_id = a.assignment_id
2122: and (a.effective_start_date < p_effective_start_date);
2123: --
2124: begin