133: hlc.postal_code postcode,
134: hlc.town_or_city city,
135: pay_nl_general.get_country_name(hlc.country) country,
136: hlc.style add_style
137: from hr_locations hlc,
138: hr_organization_units hou
139: where hou.business_group_id = p_bg_id
140: and hou.organization_id = p_org_id
141: and hlc.location_id = hou.location_id;
1730: hlc.postal_code postcode,
1731: hlc.town_or_city city,
1732: pay_nl_general.get_country_name(hlc.country) country,
1733: hlc.style add_style
1734: from hr_locations hlc,
1735: hr_organization_units hou
1736: where hou.business_group_id = p_bg_id
1737: and hou.organization_id = p_org_id
1738: and hlc.location_id = hou.location_id;