APPS.PA_PROJ_STRUCTURE_PVT dependencies on PA_PROJECTS_ALL

Line 96: from pa_projects_all

92: where task_id = l_task_id;
93: --
94: CURSOR get_project_dates(l_project_id NUMBER) IS
95: select start_date, completion_date
96: from pa_projects_all
97: where project_id = l_project_id;
98: --
99: CURSOR IS_CC_PRVDR(l_project_id NUMBER) IS
100: select cc_prvdr_flag

Line 101: from pa_project_types_all t, pa_projects_all p

97: where project_id = l_project_id;
98: --
99: CURSOR IS_CC_PRVDR(l_project_id NUMBER) IS
100: select cc_prvdr_flag
101: from pa_project_types_all t, pa_projects_all p
102: --Added the org_id join for bug 5561054
103: where t.org_id = p.org_id
104: and t.project_type = p.project_type and
105: p.project_id = l_project_id;