APPS.JTF_TERR_ENGINE_GEN_PVT dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 4412: FROM jtf_rs_resource_extns_vl jrrev

4408: /* PERSON_ID required for OSO TAP */
4409: UPDATE jtf_terr_rsc_all jtr
4410: SET jtr.person_id =
4411: ( SELECT jrrev.source_id
4412: FROM jtf_rs_resource_extns_vl jrrev
4413: WHERE jrrev.category = 'EMPLOYEE'
4414: AND jrrev.resource_id = jtr.resource_id )
4415: WHERE jtr.resource_type= 'RS_EMPLOYEE'
4416: AND jtr.terr_id IN

Line 4422: FROM jtf_rs_resource_extns_vl jrrev

4418: FROM jtf_terr_usgs_all jtu
4419: WHERE jtu.source_id = p_source_id )
4420: AND EXISTS
4421: ( SELECT jrrev.resource_id
4422: FROM jtf_rs_resource_extns_vl jrrev
4423: WHERE jrrev.resource_id = jtr.resource_id );
4424:
4425:
4426: /* JDOCHERT: 05/07/03: BUG#2947497 FIX */