APPS.PAY_NO_SUPPORT_ORDER dependencies on HR_ORGANIZATION_UNITS

Line 146: from hr_organization_units hou

142: -- cursor to get Legal Employer Name and Org Num
143:
144: cursor csr_le_details ( l_leg_emp_id NUMBER ) is
145: select hou.name ,hoi.org_information1
146: from hr_organization_units hou
147: ,hr_organization_information hoi
148: where hou.organization_id = l_leg_emp_id
149: and hoi.organization_id = l_leg_emp_id
150: and hoi.org_information_context = to_char('NO_LEGAL_EMPLOYER_DETAILS');

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

326: -- to get the Third Party Name
327: IF (l_third_party_id IS NOT NULL) THEN
328:
329: l_third_party_id := to_number(l_third_party_id) ;
330: select name into l_third_party_name from hr_organization_units where organization_id = l_third_party_id ;
331:
332:
333: END IF;
334: -------------------------------------------------------------------

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

940:
941: --fnd_file.put_line(fnd_file.log,'SUGARG: after l_third_party_id' || to_char(l_third_party_id));
942:
943: -- to get the Third Party Name
944: select name into l_third_party_name from hr_organization_units where organization_id = l_third_party_id ;
945:
946:
947: -- to get the third party Destination acc no.
948: OPEN csr_third_party_dest_acc (l_third_party_id) ;