DBA Data[Home] [Help]

APPS.PAY_KR_YEA_PKG dependencies on HR_NI_CHK_PKG

Line 1670: select hr_ni_chk_pkg.chk_nat_id_format(aei_information2, 'DDD-DD-DDDDD'),

1666: )
1667: ------------------------------------------------------------------------
1668: is
1669: cursor csr_aei is
1670: select hr_ni_chk_pkg.chk_nat_id_format(aei_information2, 'DDD-DD-DDDDD'),
1671: aei_information3,
1672: fnd_date.canonical_to_date(aei_information15), -- Bug 8644512
1673: fnd_date.canonical_to_date(aei_information16), -- Bug 8644512
1674: fnd_date.canonical_to_date(aei_information17), -- Bug 8644512

Line 1899: hr_ni_chk_pkg.chk_nat_id_format(aei_information3, 'DDD-DD-DDDDD') aei3,

1895: cursor csr_aei is
1896: select fnd_date.canonical_to_date(aei_information23) aei23, -- Bug 8644512
1897: fnd_date.canonical_to_date(aei_information1) aei1,
1898: aei_information2 aei2,
1899: hr_ni_chk_pkg.chk_nat_id_format(aei_information3, 'DDD-DD-DDDDD') aei3,
1900: fnd_date.canonical_to_date(aei_information24) aei24, -- Bug 8644512
1901: fnd_date.canonical_to_date(aei_information25) aei25, -- Bug 8644512
1902: nvl(to_number(aei_information4), 0) aei4,
1903: nvl(to_number(aei_information5), 0) aei5,