DBA Data[Home] [Help]

APPS.PAY_IN_TAX_DECLARATION dependencies on HR_ORGANIZATION_INFORMATION

Line 74: FROM hr_organization_information org

70: SELECT nvl(org.org_information1, 'N') locking_period
71: , nvl(org.org_information3, 0) window_period
72: , fnd_date.canonical_to_date(org.org_information2) locking_period_start
73: , TRUNC(SYSDATE - start_date) hire_duration
74: FROM hr_organization_information org
75: , per_people_f person
76: , per_assignments_f assign
77: , hr_soft_coding_keyflex scl
78: WHERE org.org_information_context = 'PER_IN_TAX_DECL_DETAILS'