APPS.PAY_AE_SI_REPORTS dependencies on HR_LOCATIONS

Line 111: FROM hr_locations loc

107:
108: /*Cursor for fetching Employer's PO Box and Emirate Code */
109: CURSOR csr_employer_address (l_loc_id number) IS
110: SELECT loc.address_line_3, loc.LOC_INFORMATION15
111: FROM hr_locations loc
112: WHERE loc.location_id = l_loc_id;
113:
114: /*Cursor for fetching Employer's Emirate */
115: CURSOR csr_employer_emirate (l_emirate varchar2) IS