DBA Data[Home] [Help]

APPS.PQH_PROCESS_ACADEMIC_RANK dependencies on FND_DATE

Line 15: fnd_date.canonical_to_date(rank.pei_information2) pei_information2,

11: BEGIN
12: OPEN csr FOR
13: select
14: rank.pei_information1,
15: fnd_date.canonical_to_date(rank.pei_information2) pei_information2,
16: fnd_date.canonical_to_date(rank.pei_information3) pei_information3,
17: rank.pei_information4 pei_information4,
18: fnd_date.canonical_to_date(rank.pei_information5) pei_information5,
19: to_number(rank.person_extra_info_id ) person_extra_info_id,

Line 16: fnd_date.canonical_to_date(rank.pei_information3) pei_information3,

12: OPEN csr FOR
13: select
14: rank.pei_information1,
15: fnd_date.canonical_to_date(rank.pei_information2) pei_information2,
16: fnd_date.canonical_to_date(rank.pei_information3) pei_information3,
17: rank.pei_information4 pei_information4,
18: fnd_date.canonical_to_date(rank.pei_information5) pei_information5,
19: to_number(rank.person_extra_info_id ) person_extra_info_id,
20: to_number(rank.object_version_number) object_version_number

Line 18: fnd_date.canonical_to_date(rank.pei_information5) pei_information5,

14: rank.pei_information1,
15: fnd_date.canonical_to_date(rank.pei_information2) pei_information2,
16: fnd_date.canonical_to_date(rank.pei_information3) pei_information3,
17: rank.pei_information4 pei_information4,
18: fnd_date.canonical_to_date(rank.pei_information5) pei_information5,
19: to_number(rank.person_extra_info_id ) person_extra_info_id,
20: to_number(rank.object_version_number) object_version_number
21: from (
22: Select