[Home] [Help]
2456: from sys.dual
2457: where exists (
2458: select null
2459: from PER_ASSIGNMENTS_F A
2460: , FND_SESSIONS S
2461: where a.assignment_id = p_assignment_id
2462: and a.assignment_type = 'E'
2463: and effective_date
2464: between a.effective_start_date and a.effective_end_date
4576: and p_effective_date between effective_start_date and effective_end_date;
4577: --
4578: cursor c_session_date is
4579: select effective_date
4580: from fnd_sessions
4581: where session_id = userenv('sessionid');
4582: --
4583: --
4584: cursor c_cost_allocation_keyflex(p_cost_allocation_keyflex_id number) is
4606: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',28);
4607: close c_formula_id;
4608: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff-formula_id :'
4609: || l_formula_id,29);
4610: -- Insert fnd_sessions row
4611: open c_session_date;
4612: fetch c_session_date into l_session_date;
4613: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff' || l_session_date,30);
4614: if c_session_date%notfound then
4612: fetch c_session_date into l_session_date;
4613: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff' || l_session_date,30);
4614: if c_session_date%notfound then
4615: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',31);
4616: insert into fnd_sessions (SESSION_ID, EFFECTIVE_DATE) values(userenv('sessionid'), trunc(p_effective_date));
4617: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',32);
4618: end if;
4619: --
4620: hr_utility.set_location('hr_assignment.per_dflt_asg_cost_alloc_ff',33);
5311: HR_ALL_ORGANIZATION_UNITS_TL OTL ,
5312: HR_COMMENTS COM ,
5313: GL_SETS_OF_BOOKS GL ,
5314: PER_PAY_BASES PB ,
5315: FND_SESSIONS FND ,
5316: PER_COLLECTIVE_AGREEMENTS CA ,
5317: PER_CONTRACTS_F CO ,
5318: HR_ALL_ORGANIZATION_UNITS O1 ,
5319: BEN_PGM_F PGM ,