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 593: select name from hr_organization_units

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