APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 1111: FROM jtf_rs_resource_extns_vl jrrev

1107: FORALL i IN l_terr_change_tab.terr_id.FIRST .. l_terr_change_tab.terr_id.LAST
1108: UPDATE jtf_terr_rsc_all jtr
1109: SET jtr.person_id =
1110: ( SELECT jrrev.source_id
1111: FROM jtf_rs_resource_extns_vl jrrev
1112: WHERE jrrev.category = 'EMPLOYEE'
1113: AND jrrev.resource_id = jtr.resource_id )
1114: WHERE jtr.resource_type= 'RS_EMPLOYEE'
1115: AND jtr.terr_id = l_terr_change_tab.terr_id(i);

Line 1326: FROM jtf_rs_resource_extns_vl jrrev

1322:
1323: UPDATE jtf_terr_rsc_all jtr
1324: SET jtr.person_id =
1325: ( SELECT jrrev.source_id
1326: FROM jtf_rs_resource_extns_vl jrrev
1327: WHERE jrrev.category = 'EMPLOYEE'
1328: AND jrrev.resource_id = jtr.resource_id )
1329: WHERE jtr.resource_type= 'RS_EMPLOYEE'
1330: AND jtr.terr_id = p_terr_id;