APPS.PAY_NL_PAYFILE dependencies on HR_LOCATIONS_ALL

Line 483: FROM hr_locations_all hla

479: AND nvl(pas.date_to,to_date('31/12/4712','DD/MM/YYYY'));
480: --
481: CURSOR csr_get_org_address(p_payee_id NUMBER) IS
482: SELECT substr(hr_general.decode_lookup('HR_NL_CITY',town_or_city),1,35) town_or_city
483: FROM hr_locations_all hla
484: ,hr_all_organization_units hou
485: WHERE hou.organization_id = p_payee_id
486: AND hou.location_id = hla.location_id;
487: --