APPS.PA_SCHEDULE_PUB dependencies on PA_PROJECTS_ALL

Line 1011: FROM pa_projects_all ppa, pa_project_statuses pps

1007: -- For retrieving project_status_name
1008: -- 3054787: Select from tables directly to improve performance.
1009: CURSOR get_project_status_name IS
1010: SELECT pps.project_status_name
1011: FROM pa_projects_all ppa, pa_project_statuses pps
1012: WHERE ppa.project_id = p_project_id
1013: AND ppa.project_status_code = pps.project_status_code;
1014:
1015: l_project_status_name pa_project_statuses.project_status_name%TYPE;

Line 1961: FROM pa_projects_all ppa, pa_project_statuses pps

1957: -- For retrieving project_status_name
1958: -- 3054787: Select from tables directly to improve performance.
1959: CURSOR get_project_status_name IS
1960: SELECT pps.project_status_name
1961: FROM pa_projects_all ppa, pa_project_statuses pps
1962: WHERE ppa.project_id = p_project_id
1963: AND ppa.project_status_code = pps.project_status_code;
1964:
1965: l_project_status_name pa_project_statuses.project_status_name%TYPE;

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

3072:
3073: -- Taking out the orgnization id for passing to the get_proj_calendar_default */
3074: IF (p_project_id IS NOT NULL ) THEN
3075: BEGIN
3076: -- Modified to select from PA_PROJECTS_ALL instead of PA_PROJECTS.
3077: SELECT carrying_out_organization_id
3078: INTO l_t_carrying_out_org_id
3079: FROM PA_PROJECTS_ALL
3080: WHERE project_id = p_project_id;

Line 3079: FROM PA_PROJECTS_ALL

3075: BEGIN
3076: -- Modified to select from PA_PROJECTS_ALL instead of PA_PROJECTS.
3077: SELECT carrying_out_organization_id
3078: INTO l_t_carrying_out_org_id
3079: FROM PA_PROJECTS_ALL
3080: WHERE project_id = p_project_id;
3081:
3082: EXCEPTION
3083: WHEN NO_DATA_FOUND THEN