APPS.PAY_DK_GENERAL dependencies on HR_ORGANIZATION_UNITS

Line 223: ,HR_ORGANIZATION_UNITS hou

219: CURSOR get_sp_details( p_payroll_action_id NUMBER) IS
220: SELECT hoi2.org_information1 cvr_number
221: FROM HR_ORGANIZATION_INFORMATION hoi1
222: ,HR_ORGANIZATION_INFORMATION hoi2
223: ,HR_ORGANIZATION_UNITS hou
224: ,PAY_PAYROLL_ACTIONS ppa
225: WHERE ppa.payroll_action_id = p_payroll_action_id
226: and hoi1.org_information_context ='CLASS'
227: and hoi1.org_information1 ='DK_SERVICE_PROVIDER'