APPS.PER_ASG_BUS1 dependencies on FND_DATE

Line 7408: between fnd_date.canonical_to_date(poei_information3)

7404:
7405: /* select 'x'
7406: from per_position_extra_info
7407: where p_assignment_start_date
7408: between fnd_date.canonical_to_date(poei_information3)
7409: and fnd_date.canonical_to_date(poei_information4)
7410: -- Start changes for bug 10220040
7411: and p_assignment_end_date
7412: between fnd_date.canonical_to_date(poei_information3)

Line 7409: and fnd_date.canonical_to_date(poei_information4)

7405: /* select 'x'
7406: from per_position_extra_info
7407: where p_assignment_start_date
7408: between fnd_date.canonical_to_date(poei_information3)
7409: and fnd_date.canonical_to_date(poei_information4)
7410: -- Start changes for bug 10220040
7411: and p_assignment_end_date
7412: between fnd_date.canonical_to_date(poei_information3)
7413: and fnd_date.canonical_to_date(poei_information4)

Line 7412: between fnd_date.canonical_to_date(poei_information3)

7408: between fnd_date.canonical_to_date(poei_information3)
7409: and fnd_date.canonical_to_date(poei_information4)
7410: -- Start changes for bug 10220040
7411: and p_assignment_end_date
7412: between fnd_date.canonical_to_date(poei_information3)
7413: and fnd_date.canonical_to_date(poei_information4)
7414: -- End changes for bug 10220040
7415: and position_id= p_position_id -- l_position_id -- for bug 7129787
7416: and information_type = 'PER_OVERLAP'; */

Line 7413: and fnd_date.canonical_to_date(poei_information4)

7409: and fnd_date.canonical_to_date(poei_information4)
7410: -- Start changes for bug 10220040
7411: and p_assignment_end_date
7412: between fnd_date.canonical_to_date(poei_information3)
7413: and fnd_date.canonical_to_date(poei_information4)
7414: -- End changes for bug 10220040
7415: and position_id= p_position_id -- l_position_id -- for bug 7129787
7416: and information_type = 'PER_OVERLAP'; */
7417:

Line 7419: fnd_date.canonical_to_date(poei_information3) effective_start_date,

7415: and position_id= p_position_id -- l_position_id -- for bug 7129787
7416: and information_type = 'PER_OVERLAP'; */
7417:
7418: select
7419: fnd_date.canonical_to_date(poei_information3) effective_start_date,
7420: nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr')) effective_end_date
7421: from (
7422: select poei_information3,poei_information4
7423: from per_position_extra_info

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

7416: and information_type = 'PER_OVERLAP'; */
7417:
7418: select
7419: fnd_date.canonical_to_date(poei_information3) effective_start_date,
7420: nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr')) effective_end_date
7421: from (
7422: select poei_information3,poei_information4
7423: from per_position_extra_info
7424: where information_type = 'PER_OVERLAP'

Line 7427: between fnd_date.canonical_to_date(poei_information3)

7423: from per_position_extra_info
7424: where information_type = 'PER_OVERLAP'
7425: and position_id = p_position_id)
7426: where p_assignment_start_date
7427: between fnd_date.canonical_to_date(poei_information3)
7428: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'))
7429: order by 1,2 desc;
7430:
7431: cursor c_position_type is

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

7424: where information_type = 'PER_OVERLAP'
7425: and position_id = p_position_id)
7426: where p_assignment_start_date
7427: between fnd_date.canonical_to_date(poei_information3)
7428: and nvl(fnd_date.canonical_to_date(poei_information4), to_date('31/12/4712','dd/mm/rrrr'))
7429: order by 1,2 desc;
7430:
7431: cursor c_position_type is
7432: select position_type