[Home] [Help]
4839: l_rsv_fte number;
4840:
4841: cursor csr_valid_fte(p_position_id number, p_effective_date date) is
4842: select sum(poei_information6) fte
4843: from per_position_extra_info
4844: where position_id = p_position_id
4845: and information_type= 'PER_RESERVED'
4846: and p_effective_date
4847: between fnd_date.canonical_to_date(poei_information3)
4860: and position_id = p_position_id
4861: union
4862: select start_date
4863: from (select fnd_date.canonical_to_date(poei_information3) start_date
4864: from per_position_extra_info
4865: where position_id = p_position_id
4866: and information_type = 'PER_RESERVED') a
4867: where a.start_date between p_validation_start_date and p_validation_end_date;
4868: Begin
5038: l_api_updating boolean;
5039:
5040: cursor c_seasonal is
5041: select 'X'
5042: from per_position_extra_info
5043: where position_id = p_position_id
5044: and information_type = 'PER_SEASONAL';
5045: begin
5046: l_api_updating := hr_psf_shd.api_updating
5077: l_api_updating boolean;
5078: --
5079: cursor c_overlap is
5080: select 'X'
5081: from per_position_extra_info
5082: where position_id = p_position_id
5083: and information_type = 'PER_OVERLAP';
5084: begin
5085: if g_debug then
5128: l_position_family varchar2(100);
5129: l_chk boolean := false;
5130: cursor c1 is
5131: select poei_information3
5132: from per_position_extra_info
5133: where position_id = p_position_id
5134: and information_type = 'PER_FAMILY'
5135: and poei_information3 in ('ACADEMIC','FACULTY');
5136: begin
7415: select '1'
7416: into l_exists
7417: from sys.dual
7418: where exists(select null
7419: from per_position_extra_info
7420: where position_id = p_position_id);
7421: exception when no_data_found then
7422: null;
7423: end;