DBA Data[Home] [Help]

APPS.PAY_IE_PAYFILE_SEPA dependencies on HR_LOCATIONS

Line 233: FROM hr_locations hlc

229: ,hlc.address_line_3 address_3
230: ,hlc.country country
231: ,hlc.postal_code postcode
232: ,hlc.region_2 geo_code
233: FROM hr_locations hlc
234: ,hr_organization_units hou
235: WHERE hou.business_group_id = p_bg_id
236: AND hou.organization_id = p_org_id
237: AND hlc.location_id = hou.location_id;

Line 315: FROM hr_locations hlc

311: ,hlc.address_line_3 address_3
312: ,hlc.country country
313: ,hlc.postal_code postcode
314: ,hlc.region_2 geo_code
315: FROM hr_locations hlc
316: ,hr_organization_units hou
317: WHERE hou.business_group_id = p_bg_id
318: AND hou.organization_id = p_payee_id
319: AND hlc.location_id = hou.location_id;