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,
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
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