APPS.PAY_NO_TAX_LEVY dependencies on HR_ORGANIZATION_UNITS

Line 108: from hr_organization_units hou

104: -- cursor to get Legal Employer Name and Org Num
105:
106: cursor csr_le_name ( l_leg_emp_id NUMBER ) is
107: select hou.name
108: from hr_organization_units hou
109: where hou.organization_id = l_leg_emp_id;
110:
111:
112: cursor csr_org_number ( l_leg_emp_id NUMBER ) is

Line 591: select name from hr_organization_units

587: WHERE assignment_action_id = p_assignment_action_id ;
588:
589: --cursor to get the third party name
590: cursor csr_third_party_name is
591: select name from hr_organization_units
592: where organization_id = l_third_party_id ;
593:
594: -- cursor to fetch the balance value of TAX DEDUCTION BASIS
595: cursor csr_tax_dedn_basis is