APPS.PA_FORECAST_ITEMS_GEN_WF_PKG dependencies on PA_ORGANIZATIONS_EXPEND_V

Line 35: l_name pa_organizations_expend_v.name%TYPE;

31: l_x_return_status VARCHAR2(50);
32: l_lock_for VARCHAR2(5);
33: l_x_msg_count NUMBER;
34: l_x_msg_data VARCHAR2(50);
35: l_name pa_organizations_expend_v.name%TYPE;
36: l_save_thresh NUMBER ;
37: l_project_id NUMBER;
38: l_wf_type_code VARCHAR2(30);
39: l_err_code NUMBER := 0;

Line 101: FROM pa_organizations_expend_v

97: /* Bug remmed out for bug 1777250 due to perf team request
98:
99: SELECT name
100: INTO l_name
101: FROM pa_organizations_expend_v
102: WHERE organization_id = ( select expenditure_organization_id
103: FROM pa_project_assignments
104: WHERE assignment_id = p_assignment_id);
105:

Line 304: l_orgz_name pa_organizations_expend_v.name%TYPE;

300: l_resource_id NUMBER;
301: l_asgmt_start_date DATE;
302: l_asgmt_end_date DATE;
303: l_process_mode VARCHAR2(30);
304: l_orgz_name pa_organizations_expend_v.name%TYPE;
305: l_lock_for VARCHAR2(5);
306: li_lock_status NUMBER;
307: l_x_return_status VARCHAR2(50);
308: l_x_msg_count NUMBER;