APPS.PA_PROJECTS_MAINT_PUB dependencies on PA_PROJECT_STATUSES

Line 140: l_project_status_code pa_project_statuses.project_status_code%TYPE;

136: l_ship_to_customer_id hz_cust_accounts.cust_account_id%TYPE; -- Bug 2977891
137: -- 4363092 end
138:
139: l_organization_id hr_organization_units.organization_id%TYPE;
140: l_project_status_code pa_project_statuses.project_status_code%TYPE;
141: l_project_id pa_projects.project_id%TYPE;
142: l_project_type pa_projects_all.project_type%TYPE;
143: l_project_number_out pa_projects.segment1%TYPE;
144: l_probability_member_id pa_probability_members.probability_member_id%TYPE;

Line 3393: FROM pa_project_statuses pps

3389: WHERE project_id = c_project_id;
3390:
3391: CURSOR cur_get_system_status(c_status_code IN VARCHAR2) IS
3392: SELECT pps.project_system_status_code
3393: FROM pa_project_statuses pps
3394: WHERE pps.project_status_code = nvl(c_status_code,' ');
3395:
3396: Invalid_Arg_Exc EXCEPTION;
3397: l_rec_project_details cur_get_project_details%ROWTYPE;