DBA Data[Home] [Help]

APPS.PAY_SE_EXPIRY_SUPPORT dependencies on HR_ORGANIZATION_UNITS

Line 177: FROM HR_ORGANIZATION_UNITS o1

173: FROM pay_assignment_actions
174: WHERE assignment_action_id=p_assignment_action_id;
175: CURSOR csr_holiday_start IS
176: SELECT substr(hoi4.ORG_INFORMATION3,4,2)
177: FROM HR_ORGANIZATION_UNITS o1
178: ,HR_ORGANIZATION_INFORMATION hoi1
179: ,HR_ORGANIZATION_INFORMATION hoi2
180: ,HR_ORGANIZATION_INFORMATION hoi3
181: ,HR_ORGANIZATION_INFORMATION hoi4