APPS.PA_BUDGET_CHECK_PVT dependencies on PA_PROJECTS

Line 86: FROM pa_projects

82: ( p_project_id NUMBER )
83: IS
84: SELECT trunc(start_date) --Added trunc for Bug 3899746
85: , trunc(completion_date) --Added trunc for Bug 3899746
86: FROM pa_projects
87: WHERE project_id = p_project_id;
88:
89: CURSOR l_task_dates_csr
90: ( p_task_id NUMBER )

Line 113: (p_pa_project_id pa_projects.project_id%type)

109:
110: --needed to get the field values associated to a AMG message
111:
112: CURSOR l_amg_project_csr
113: (p_pa_project_id pa_projects.project_id%type)
114: IS
115: SELECT segment1
116: FROM pa_projects p
117: WHERE p.project_id = p_pa_project_id;

Line 116: FROM pa_projects p

112: CURSOR l_amg_project_csr
113: (p_pa_project_id pa_projects.project_id%type)
114: IS
115: SELECT segment1
116: FROM pa_projects p
117: WHERE p.project_id = p_pa_project_id;
118:
119: CURSOR l_amg_task_csr
120: (p_pa_task_id pa_tasks.task_id%type)