APPS.JTF_TERR_JSP_REPORTS dependencies on HR_OPERATING_UNITS

Line 279: FROM hr_operating_units hr, jtf_terr_all jt

275:
276: /*Added for bug 7315889 */
277: CURSOR c_get_operating_unit(ci_terr_id VARCHAR2) IS
278: SELECT distinct hr.name operating_unit
279: FROM hr_operating_units hr, jtf_terr_all jt
280: WHERE hr.organization_id = jt.org_id
281: AND jt.terr_id = ci_terr_id;
282:
283: -- ADDED FOR BUG 7315889

Line 284: l_terr_operating_unit hr_operating_units.name%TYPE;

280: WHERE hr.organization_id = jt.org_id
281: AND jt.terr_id = ci_terr_id;
282:
283: -- ADDED FOR BUG 7315889
284: l_terr_operating_unit hr_operating_units.name%TYPE;
285:
286: begin
287:
288: --dbms_output.put_line('JTF_TERR_JSP_REPORTS.definition_rpt: BEGIN ');