APPS.JTF_TTY_NA_TERRGP dependencies on JTF_RS_REP_MANAGERS
Line 1776: FROM jtf_rs_rep_managers A
1772: AND (ttygrp.active_to_date >= SYSDATE OR ttygrp.active_to_date IS NULL);
1773:
1774: CURSOR resource_managers_c IS
1775: SELECT DISTINCT a.parent_resource_id manager_id 1776: FROM jtf_rs_rep_managers A 1777: WHERE a.hierarchy_type <> 'MGR_TO_ADMIN'
1778: AND a.reports_to_flag = 'Y'
1779: AND a.parent_resource_id <> a.resource_id
1780: AND SYSDATE BETWEEN a.start_date_active AND NVL(end_date_active, SYSDATE+1)