DBA Data[Home] [Help]

APPS.PA_SWEEPER dependencies on PA_PROJECTS_ALL

Line 54: FROM pa_projects_all

50: DECLARE
51:
52: CURSOR c_prj_start IS
53: SELECT start_date
54: FROM pa_projects_all
55: WHERE project_id = p_project_id;
56:
57: CURSOR c_prj_budg IS
58: SELECT MIN(start_date)

Line 146: FROM pa_projects_all

142: DECLARE
143:
144: CURSOR c_prj_end IS
145: SELECT completion_date
146: FROM pa_projects_all
147: WHERE project_id = p_project_id;
148:
149: CURSOR c_prj_budg IS
150: SELECT MAX(end_date)