DBA Data[Home] [Help]

APPS.PAY_IN_TAX_DECLARATION dependencies on HR_ORGANIZATION_INFORMATION

Line 73: FROM hr_organization_information org

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
76: , hr_soft_coding_keyflex scl
77: WHERE org.org_information_context = 'PER_IN_TAX_DECL_DETAILS'