APPS.PAY_NO_UNION_DUES dependencies on HR_LOCATIONS_ALL

Line 572: from hr_locations_all loc

568: select loc.address_line_1 line_1
569: ,loc.address_line_2 line_2
570: ,loc.address_line_3 line_3
571: ,hr_general.decode_fnd_comm_lookup('NO_POSTAL_CODE',loc.postal_code) post_code
572: from hr_locations_all loc
573: ,hr_all_organization_units hou
574: where hou.organization_id = p_organization_id
575: and loc.location_id = hou.location_id
576: and loc.style = 'NO';