APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_PROJECT_STATUSES

Line 37: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;

33: l_new_open_asgn_number pa_project_assignments.assignment_number%TYPE;
34: l_new_open_asgn_row_id ROWID;
35: l_return_status VARCHAR2(1);
36: l_ret_code VARCHAR2(1);
37: l_system_status_code pa_project_statuses.project_system_status_code%TYPE;
38: l_cc_ok VARCHAR2(1);
39: l_error_message_code VARCHAR2(2000);
40: l_wf_type VARCHAR2(80);
41: l_wf_item_type VARCHAR2(2000);

Line 50: l_project_status_code pa_project_statuses.project_status_code%TYPE;

46: l_project_manager_name VARCHAR2(200);
47: l_project_party_id NUMBER ;
48: l_project_role_id NUMBER ;
49: l_project_role_name VARCHAR2(80);
50: l_project_status_code pa_project_statuses.project_status_code%TYPE;
51: l_project_status_name pa_project_statuses.project_status_name%TYPE;
52: l_assignment_status_name pa_project_statuses.project_status_name%TYPE;
53: l_asgn_text VARCHAR2(30);
54: l_allow_asgmt VARCHAR2(1);

Line 51: l_project_status_name pa_project_statuses.project_status_name%TYPE;

47: l_project_party_id NUMBER ;
48: l_project_role_id NUMBER ;
49: l_project_role_name VARCHAR2(80);
50: l_project_status_code pa_project_statuses.project_status_code%TYPE;
51: l_project_status_name pa_project_statuses.project_status_name%TYPE;
52: l_assignment_status_name pa_project_statuses.project_status_name%TYPE;
53: l_asgn_text VARCHAR2(30);
54: l_allow_asgmt VARCHAR2(1);
55: l_work_type_id NUMBER;

Line 52: l_assignment_status_name pa_project_statuses.project_status_name%TYPE;

48: l_project_role_id NUMBER ;
49: l_project_role_name VARCHAR2(80);
50: l_project_status_code pa_project_statuses.project_status_code%TYPE;
51: l_project_status_name pa_project_statuses.project_status_name%TYPE;
52: l_assignment_status_name pa_project_statuses.project_status_name%TYPE;
53: l_asgn_text VARCHAR2(30);
54: l_allow_asgmt VARCHAR2(1);
55: l_work_type_id NUMBER;
56: l_raw_revenue NUMBER;

Line 92: FROM PA_PROJECT_STATUSES

88:
89: /* Created for bug 2381199 */
90: CURSOR get_system_status IS
91: SELECT project_system_status_code
92: FROM PA_PROJECT_STATUSES
93: WHERE project_status_code = l_assignment_rec.status_code;
94: /* Created for bug 2381199 */
95:
96: -- Bottom Up Flow