DBA Data[Home] [Help]

APPS.PAY_NO_SUPPORT_ORDER dependencies on HR_ALL_ORGANIZATION_UNITS

Line 816: ,hr_all_organization_units hou

812: ,loc.address_line_2 line_2
813: ,loc.address_line_3 line_3
814: ,hr_general.decode_fnd_comm_lookup('NO_POSTAL_CODE',loc.postal_code) post_code
815: from hr_locations_all loc
816: ,hr_all_organization_units hou
817: where hou.organization_id = p_organization_id
818: and loc.location_id = hou.location_id
819: and loc.style = 'NO';
820: