DBA Data[Home] [Help]

APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTF_TERR_RSC_ALL

Line 1108: UPDATE jtf_terr_rsc_all jtr

1104: NULL;
1105: END;
1106:
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'

Line 1323: UPDATE jtf_terr_rsc_all jtr

1319: IS
1320:
1321: BEGIN
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'