APPS.PAY_NO_UNION_DUES dependencies on HR_ORGANIZATION_UNITS

Line 119: from hr_organization_units hou

115: -- cursor to get Legal Employer Name and Org Num
116:
117: cursor csr_le_details ( l_leg_emp_id NUMBER ) is
118: select hou.name ,hoi.org_information1
119: from hr_organization_units hou
120: ,hr_organization_information hoi
121: where hou.organization_id = l_leg_emp_id
122: and hoi.organization_id = l_leg_emp_id
123: and hoi.org_information_context = to_char('NO_LEGAL_EMPLOYER_DETAILS');

Line 645: select name into l_third_party_name from hr_organization_units where organization_id = l_third_party_id ;

641: l_third_party_id := to_number(rec_asg_detail.res_val_5) ;
642:
643: -- to get the Third Party Name
644: begin
645: select name into l_third_party_name from hr_organization_units where organization_id = l_third_party_id ;
646: exception
647: when others then
648: null;
649: end;