DBA Data[Home] [Help]

APPS.PAY_NL_ATS_REPORT dependencies on HR_LOCATIONS

Line 137: from hr_locations hlc,

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;

Line 1734: from hr_locations hlc,

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;