APPS.PA_ASGMT_WFSTD dependencies on PA_ASSIGNMENTS_HISTORY

Line 181: FROM pa_assignments_history

177: IS
178: SELECT assignment_effort prev_effort,
179: (trunc(end_date) -
180: (trunc(start_date)+1)) prev_duration
181: FROM pa_assignments_history
182: WHERE assignment_id = l_assignment_id
183: AND nvl(last_approved_flag,'N') = 'Y';
184: */
185:

Line 190: FROM pa_assignments_history

186: CURSOR l_prev_asgmt_info_csr (l_assignment_id IN NUMBER)
187: IS
188: SELECT assignment_effort prev_effort,
189: (trunc(end_date) - trunc(start_date) + 1) prev_duration
190: FROM pa_assignments_history
191: WHERE assignment_id = l_assignment_id
192: AND nvl(last_approved_flag,'N') = 'Y';
193:
194: l_assignments_rec l_assignments_csr%ROWTYPE;

Line 3449: l_change_id pa_assignments_history.change_id%TYPE;

3445: p_item_key IN VARCHAR2,
3446: x_return_status OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3447: IS
3448: l_apprvl_status_code pa_project_statuses.project_status_code%TYPE;
3449: l_change_id pa_assignments_history.change_id%TYPE;
3450: l_return_status VARCHAR2(30);
3451: l_msg_count NUMBER := 0;
3452: l_msg_data VARCHAR2(500);
3453: l_record_version_number NUMBER := 0;

Line 4842: FROM pa_assignments_history

4838: IS
4839: SELECT assignment_effort prev_effort,
4840: (trunc(end_date) -
4841: (trunc(start_date)+1)) prev_duration
4842: FROM pa_assignments_history
4843: WHERE assignment_id = l_assignment_id
4844: AND nvl(last_approved_flag,'N') = 'Y';
4845:
4846: CURSOR l_assignments_csr IS