APPS.PA_SCHEDULE_PUB dependencies on PA_PROJECTS_ALL

Line 1480: FROM pa_projects_all ppa, pa_project_statuses pps

1476: -- For retrieving project_status_name
1477: -- 3054787: Select from tables directly to improve performance.
1478: CURSOR get_project_status_name IS
1479: SELECT pps.project_status_name
1480: FROM pa_projects_all ppa, pa_project_statuses pps
1481: WHERE ppa.project_id = p_project_id
1482: AND ppa.project_status_code = pps.project_status_code;
1483:
1484: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 2433: FROM pa_projects_all ppa, pa_project_statuses pps

2429: -- For retrieving project_status_name
2430: -- 3054787: Select from tables directly to improve performance.
2431: CURSOR get_project_status_name IS
2432: SELECT pps.project_status_name
2433: FROM pa_projects_all ppa, pa_project_statuses pps
2434: WHERE ppa.project_id = p_project_id
2435: AND ppa.project_status_code = pps.project_status_code;
2436:
2437: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 3556: -- Modified to select from PA_PROJECTS_ALL instead of PA_PROJECTS.

3552:
3553: -- Taking out the orgnization id for passing to the get_proj_calendar_default */
3554: IF (p_project_id IS NOT NULL ) THEN
3555: BEGIN
3556: -- Modified to select from PA_PROJECTS_ALL instead of PA_PROJECTS.
3557: SELECT carrying_out_organization_id
3558: INTO l_t_carrying_out_org_id
3559: FROM PA_PROJECTS_ALL
3560: WHERE project_id = p_project_id;

Line 3559: FROM PA_PROJECTS_ALL

3555: BEGIN
3556: -- Modified to select from PA_PROJECTS_ALL instead of PA_PROJECTS.
3557: SELECT carrying_out_organization_id
3558: INTO l_t_carrying_out_org_id
3559: FROM PA_PROJECTS_ALL
3560: WHERE project_id = p_project_id;
3561:
3562: EXCEPTION
3563: WHEN NO_DATA_FOUND THEN