DBA Data[Home] [Help]

APPS.APRX_WT dependencies on JG_ZZ_COMPANY_INFO

Line 171: WHERE hrl.location_id = JG_ZZ_COMPANY_INFO.get_location_id;

167: var.zip,
168: var.province,
169: var.state
170: FROM hr_locations hrl
171: WHERE hrl.location_id = JG_ZZ_COMPANY_INFO.get_location_id;
172:
173: EXCEPTION
174: WHEN NO_DATA_FOUND THEN
175: RAISE_APPLICATION_ERROR(-20010,sqlerrm);