DBA Data[Home] [Help]

APPS.JTF_TERR_JSP_REPORTS dependencies on HR_OPERATING_UNITS

Line 303: FROM hr_operating_units hr, jtf_terr_all jt

299:
300: /*Added for bug 7315889 */
301: CURSOR c_get_operating_unit(ci_terr_id VARCHAR2) IS
302: SELECT distinct hr.name operating_unit
303: FROM hr_operating_units hr, jtf_terr_all jt
304: WHERE hr.organization_id = jt.org_id
305: AND jt.terr_id = ci_terr_id;
306:
307: -- ADDED FOR BUG 7315889

Line 308: l_terr_operating_unit hr_operating_units.name%TYPE;

304: WHERE hr.organization_id = jt.org_id
305: AND jt.terr_id = ci_terr_id;
306:
307: -- ADDED FOR BUG 7315889
308: l_terr_operating_unit hr_operating_units.name%TYPE;
309:
310: begin
311:
312: --dbms_output.put_line('JTF_TERR_JSP_REPORTS.definition_rpt: BEGIN ');