DBA Data[Home] [Help]

APPS.PAY_IE_PAYFILE_SEPA dependencies on HR_ORGANIZATION_UNITS

Line 234: ,hr_organization_units hou

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;
238:

Line 316: ,hr_organization_units hou

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;
320: --