DBA Data[Home] [Help]

APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_PROJECTS_ALL

Line 102: pa_projects_all pal

98: SELECT ppa.assignment_type, ppa.project_id, ppa.start_date, ppa.status_code,
99: pps.project_status_name, ppa.pending_approval_flag
100: FROM pa_project_assignments ppa,
101: pa_project_statuses pps,
102: pa_projects_all pal
103: WHERE ppa.assignment_id = p_assignment_id
104: AND ppa.project_id = pal.project_id
105: AND pal.project_status_code = pps.project_status_code;
106:

Line 2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

2394: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

Line 2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR

2395: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2396: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2397: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2398: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2399: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2400: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2401: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2402: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2403: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

Line 2545: FROM pa_projects_all

2541: IF l_project_id is null THEN
2542:
2543: SELECT project_id
2544: INTO l_project_id
2545: FROM pa_projects_all
2546: WHERE segment1 = p_project_number;
2547:
2548: END IF;
2549:

Line 2553: FROM pa_projects_all pap,

2549:
2550: --Get the project type
2551: SELECT NVL(pt.administrative_flag,'N') admin_flag
2552: INTO l_admin_project
2553: FROM pa_projects_all pap,
2554: pa_project_types_all pt
2555: WHERE pap.project_id = l_project_id
2556: AND pt.project_type = pap.project_type
2557: -- AND nvl(pap.org_id, -99) = nvl(pt.org_id, -99); /* Added nvl for bug#2467666 */ -R12: Bug 4633092

Line 2858: FROM pa_projects_all pap,

2854: pap.carrying_out_organization_id carrying_out_organization_id,
2855: pap.location_id,
2856: hr.name organization_name,
2857: NVL(pt.administrative_flag,'N') admin_flag
2858: FROM pa_projects_all pap,
2859: hr_all_organization_units_tl hr, -- Bug 4358492
2860: pa_project_types_all pt
2861: WHERE pap.project_id = l_project_id
2862: AND pap.carrying_out_organization_id = hr.organization_id