APPS.PSP_ENC_CRT_XML dependencies on PA_PROJECTS_ALL

Line 13: l_project_number pa_projects_all.segment1%TYPE;

9: p_expenditure_type in varchar2) return char is
10:
11: v_retcode NUMBER;
12: l_chart_of_accts VARCHAR2(20); gl_flex_values VARCHAR2(2000);
13: l_project_number pa_projects_all.segment1%TYPE;
14: l_award_number VARCHAR2(15);
15: l_task_number VARCHAR2(25);
16: l_org_name hr_all_organization_units_tl.name%TYPE;
17: BEGIN

Line 30: FROM pa_projects_all

26: RETURN(gl_flex_values);
27: ELSE
28: SELECT segment1
29: INTO l_project_number
30: FROM pa_projects_all
31: WHERE project_id = p_project_id;
32:
33: SELECT task_number
34: INTO l_task_number