[Home] [Help]
2419: from sys.dual
2420: where exists (
2421: select null
2422: from PER_ASSIGNMENTS_F A
2423: , FND_SESSIONS S
2424: where a.assignment_id = p_assignment_id
2425: and a.assignment_type = 'E'
2426: and effective_date
2427: between a.effective_start_date and a.effective_end_date
4536: and p_effective_date between effective_start_date and effective_end_date;
4537: --
4538: cursor c_session_date is
4539: select effective_date
4540: from fnd_sessions
4541: where session_id = userenv('sessionid');
4542: --
4543: --
4544: cursor c_cost_allocation_keyflex(p_cost_allocation_keyflex_id number) is
4566: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',28);
4567: close c_formula_id;
4568: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-formula_id :'
4569: || l_formula_id,29);
4570: -- Insert fnd_sessions row
4571: open c_session_date;
4572: fetch c_session_date into l_session_date;
4573: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff' || l_session_date,30);
4574: if c_session_date%notfound then
4572: fetch c_session_date into l_session_date;
4573: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff' || l_session_date,30);
4574: if c_session_date%notfound then
4575: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',31);
4576: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE) values(userenv('sessionid'), trunc(p_effective_date));
4577: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',32);
4578: end if;
4579: --
4580: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',33);
5267: HR_ALL_ORGANIZATION_UNITS_TL OTL ,
5268: HR_COMMENTS COM ,
5269: GL_SETS_OF_BOOKS GL ,
5270: PER_PAY_BASES PB ,
5271: FND_SESSIONS FND ,
5272: PER_COLLECTIVE_AGREEMENTS CA ,
5273: PER_CONTRACTS_F CO ,
5274: HR_ALL_ORGANIZATION_UNITS O1 ,
5275: BEN_PGM_F PGM ,