APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 833: FROM jtf_rs_resource_extns_vl jrrev

829: FORALL i IN l_terr_change_tab.terr_id.FIRST .. l_terr_change_tab.terr_id.LAST
830: UPDATE jtf_terr_rsc_all jtr
831: SET jtr.person_id =
832: ( SELECT jrrev.source_id
833: FROM jtf_rs_resource_extns_vl jrrev
834: WHERE jrrev.category = 'EMPLOYEE'
835: AND jrrev.resource_id = jtr.resource_id )
836: WHERE jtr.resource_type= 'RS_EMPLOYEE'
837: AND jtr.terr_id = l_terr_change_tab.terr_id(i);