APPS.HR_PSF_BUS dependencies on FND_DATE

Line 4848: between fnd_date.canonical_to_date(poei_information3)

4844: from (SELECT poei_information6, poei_information3, poei_information4, ROWNUM rn FROM per_position_extra_info
4845: where position_id = p_position_id
4846: and information_type= 'PER_RESERVED') PEI
4847: where p_effective_date
4848: between fnd_date.canonical_to_date(poei_information3)
4849: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
4850: --
4851: cursor csr_valid_eff_date(p_position_id number,
4852: p_validation_start_date date,

Line 4849: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);

4845: where position_id = p_position_id
4846: and information_type= 'PER_RESERVED') PEI
4847: where p_effective_date
4848: between fnd_date.canonical_to_date(poei_information3)
4849: and nvl(fnd_date.canonical_to_date(poei_information4),hr_general.end_of_time);
4850: --
4851: cursor csr_valid_eff_date(p_position_id number,
4852: p_validation_start_date date,
4853: p_validation_end_date date) is

Line 4864: from (select fnd_date.canonical_to_date(poei_information3) start_date, ROWNUM rn -- bug 9387763

4860: and p_validation_end_date
4861: and position_id = p_position_id
4862: union
4863: select start_date
4864: from (select fnd_date.canonical_to_date(poei_information3) start_date, ROWNUM rn -- bug 9387763
4865: from per_position_extra_info
4866: where position_id = p_position_id
4867: and information_type = 'PER_RESERVED') a
4868: where a.start_date between p_validation_start_date and p_validation_end_date;

Line 5280: fnd_date.canonical_to_date(poei_information3) effective_start_date,

5276: and ast.per_system_status <> 'TERM_ASSIGN';
5277:
5278: cursor c_pos_overlap_dates(lp_asg_start_date date, lp_asg_end_date date) is
5279: select
5280: fnd_date.canonical_to_date(poei_information3) effective_start_date,
5281: fnd_date.canonical_to_date(poei_information4) effective_end_date
5282: from (
5283: select poei_information3, poei_information4
5284: from per_position_extra_info

Line 5281: fnd_date.canonical_to_date(poei_information4) effective_end_date

5277:
5278: cursor c_pos_overlap_dates(lp_asg_start_date date, lp_asg_end_date date) is
5279: select
5280: fnd_date.canonical_to_date(poei_information3) effective_start_date,
5281: fnd_date.canonical_to_date(poei_information4) effective_end_date
5282: from (
5283: select poei_information3, poei_information4
5284: from per_position_extra_info
5285: where information_type = 'PER_OVERLAP'

Line 5288: between fnd_date.canonical_to_date(poei_information3)

5284: from per_position_extra_info
5285: where information_type = 'PER_OVERLAP'
5286: and position_id = p_position_id)
5287: where lp_asg_start_date
5288: between fnd_date.canonical_to_date(poei_information3)
5289: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'))
5290: and lp_asg_end_date
5291: between fnd_date.canonical_to_date(poei_information3)
5292: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'));

Line 5289: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'))

5285: where information_type = 'PER_OVERLAP'
5286: and position_id = p_position_id)
5287: where lp_asg_start_date
5288: between fnd_date.canonical_to_date(poei_information3)
5289: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'))
5290: and lp_asg_end_date
5291: between fnd_date.canonical_to_date(poei_information3)
5292: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'));
5293:

Line 5291: between fnd_date.canonical_to_date(poei_information3)

5287: where lp_asg_start_date
5288: between fnd_date.canonical_to_date(poei_information3)
5289: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'))
5290: and lp_asg_end_date
5291: between fnd_date.canonical_to_date(poei_information3)
5292: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'));
5293:
5294: l_asg_id number;
5295: l_asg_start_date date;

Line 5292: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'));

5288: between fnd_date.canonical_to_date(poei_information3)
5289: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'))
5290: and lp_asg_end_date
5291: between fnd_date.canonical_to_date(poei_information3)
5292: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'));
5293:
5294: l_asg_id number;
5295: l_asg_start_date date;
5296: l_asg_end_date date;