APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_ASSIGNMENTS_HISTORY

Line 882: FROM pa_assignments_history

878: ,l_assignment_rec.attribute12
879: ,l_assignment_rec.attribute13
880: ,l_assignment_rec.attribute14
881: ,l_assignment_rec.attribute15
882: FROM pa_assignments_history
883: WHERE assignment_id = p_assignment_id
884: AND last_approved_flag = 'Y';
885:
886:

Line 898: PA_ASSIGNMENTS_HISTORY_PKG.Delete_Row( p_assignment_id => p_assignment_id

894: --
895: --Delete the last approved record from the assignment history table.
896: --
897: IF (FND_MSG_PUB.Count_Msg = 0) THEN
898: PA_ASSIGNMENTS_HISTORY_PKG.Delete_Row( p_assignment_id => p_assignment_id
899: ,p_last_approved_flag => 'Y'
900: ,x_return_status => l_return_status);
901: END IF;
902:

Line 1183: l_his_project_subteam_id pa_assignments_history.project_subteam_id%TYPE;

1179: l_old_work_type pa_work_types_vl.name%TYPE;
1180: l_new_subteam_name pa_project_subteams.name%TYPE;
1181: l_old_subteam_name pa_project_subteams.name%TYPE;
1182: l_project_subteam_id pa_project_subteam_parties.project_subteam_id%TYPE;
1183: l_his_project_subteam_id pa_assignments_history.project_subteam_id%TYPE;
1184: l_msg_index_out NUMBER;
1185: l_change_id NUMBER;
1186: l_return_status VARCHAR2(1);
1187: l_msg_count NUMBER;

Line 1218: FROM pa_assignments_history

1214: AND primary_subteam_flag = 'Y';
1215:
1216: CURSOR get_his_project_subteam_id IS
1217: SELECT project_subteam_id
1218: FROM pa_assignments_history
1219: WHERE assignment_id = p_assignment_id
1220: AND last_approved_flag = 'Y';
1221:
1222: CURSOR get_work_type_names (new_work_type_id NUMBER, old_work_type_id NUMBER) IS

Line 1411: -- get project_subteam_id from pa_assignments_history, it history table doesn't have a record

1407: l_project_subteam_id := NULL;
1408: END IF;
1409: CLOSE get_project_subteam_id;
1410:
1411: -- get project_subteam_id from pa_assignments_history, it history table doesn't have a record
1412: -- for this assignment, pass current project_subteam_id.
1413: OPEN get_his_project_subteam_id;
1414: FETCH get_his_project_subteam_id INTO l_his_project_subteam_id;
1415: IF get_his_project_subteam_id%NOTFOUND THEN