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 3389: FROM pa_project_statuses pps

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