DBA Data[Home] [Help]

APPS.PAY_IN_TAX_DECLARATION dependencies on FND_DATE

Line 71: , fnd_date.canonical_to_date(org.org_information2) locking_period_start

67: CURSOR csr_locking_period_details(c_person_id IN NUMBER)
68: IS
69: SELECT nvl(org.org_information1, 'N') locking_period
70: , nvl(org.org_information3, 0) window_period
71: , fnd_date.canonical_to_date(org.org_information2) locking_period_start
72: , TRUNC(SYSDATE - start_date) hire_duration
73: FROM hr_organization_information org
74: , per_people_f person
75: , per_assignments_f assign