DBA Data[Home] [Help]

APPS.PAY_NL_ATS_REPORT dependencies on HR_LOCATIONS

Line 153: from hr_locations hlc,

149: hlc.postal_code postcode,
150: hlc.town_or_city city,
151: pay_nl_general.get_country_name(hlc.country) country,
152: hlc.style add_style
153: from hr_locations hlc,
154: hr_organization_units hou
155: where hou.business_group_id = p_bg_id
156: and hou.organization_id = p_org_id
157: and hlc.location_id = hou.location_id;

Line 1781: from hr_locations hlc,

1777: hlc.postal_code postcode,
1778: hlc.town_or_city city,
1779: pay_nl_general.get_country_name(hlc.country) country,
1780: hlc.style add_style
1781: from hr_locations hlc,
1782: hr_organization_units hou
1783: where hou.business_group_id = p_bg_id
1784: and hou.organization_id = p_org_id
1785: and hlc.location_id = hou.location_id;