APPS.PAY_NO_SAL_STATISTICS_ARCHIVE dependencies on HR_LOCATIONS

Line 213: FROM hr_locations

209:
210:
211: CURSOR csr_location (p_location_id NUMBER) IS
212: SELECT rpad(Address_line_1 || ', ' || Address_line_2 ||', ' ||Address_line_3,30,' ') address, postal_code
213: FROM hr_locations
214: WHERE location_id = p_location_id;
215:
216: --
217: L_ACTION_INFO_ID NUMBER;