493: GROUP BY tmp1.resource_assignment_id;
494: END IF; -- time phase check
495: END IF;
496:
497: l_last_updated_by := FND_GLOBAL.USER_ID;
498: l_last_update_login := FND_GLOBAL.LOGIN_ID;
499: l_sysdate := SYSDATE;
500:
501: FORALL i in 1..l_res_asg_id_tab.count
494: END IF; -- time phase check
495: END IF;
496:
497: l_last_updated_by := FND_GLOBAL.USER_ID;
498: l_last_update_login := FND_GLOBAL.LOGIN_ID;
499: l_sysdate := SYSDATE;
500:
501: FORALL i in 1..l_res_asg_id_tab.count
502: UPDATE pa_resource_assignments
614: END IF; -- time phase check
615: END IF;
616:
617: l_sysdate := SYSDATE;
618: l_last_updated_by := FND_GLOBAL.USER_ID;
619: l_last_update_login := FND_GLOBAL.LOGIN_ID;
620:
621: FORALL i in 1..l_tgt_res_asg_id_tab.count
622: UPDATE pa_resource_assignments
615: END IF;
616:
617: l_sysdate := SYSDATE;
618: l_last_updated_by := FND_GLOBAL.USER_ID;
619: l_last_update_login := FND_GLOBAL.LOGIN_ID;
620:
621: FORALL i in 1..l_tgt_res_asg_id_tab.count
622: UPDATE pa_resource_assignments
623: SET transaction_source_code = l_txn_src_code_tab(i),