eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR

2455: ,p_work_type_id IN pa_project_assignments.work_type_id%TYPE := FND_API.G_MISS_NUM
2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2463: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR

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

2456: ,p_calendar_type IN pa_project_assignments.calendar_type%TYPE := FND_API.G_MISS_CHAR
2457: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
2458: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
2459: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
2460: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
2461: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
2462: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
2463: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
2464: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR

Line 2606: FROM pa_projects_all

2602: IF l_project_id is null THEN
2603:
2604: SELECT project_id
2605: INTO l_project_id
2606: FROM pa_projects_all
2607: WHERE segment1 = p_project_number;
2608:
2609: END IF;
2610:

Line 2614: FROM pa_projects_all pap,

2610:
2611: --Get the project type
2612: SELECT NVL(pt.administrative_flag,'N') admin_flag
2613: INTO l_admin_project
2614: FROM pa_projects_all pap,
2615: pa_project_types_all pt
2616: WHERE pap.project_id = l_project_id
2617: AND pt.project_type = pap.project_type
2618: -- AND nvl(pap.org_id, -99) = nvl(pt.org_id, -99); /* Added nvl for bug#2467666 */ -R12: Bug 4633092

Line 2919: FROM pa_projects_all pap,

2915: pap.carrying_out_organization_id carrying_out_organization_id,
2916: pap.location_id,
2917: hr.name organization_name,
2918: NVL(pt.administrative_flag,'N') admin_flag
2919: FROM pa_projects_all pap,
2920: hr_all_organization_units_tl hr, -- Bug 4358492
2921: pa_project_types_all pt
2922: WHERE pap.project_id = l_project_id
2923: AND pap.carrying_out_organization_id = hr.organization_id