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_PROJECT_TYPES_ALL

Line 2554: pa_project_types_all pt

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
2558: AND pap.org_id = pt.org_id;

Line 2860: pa_project_types_all pt

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
2863: AND pt.project_type = pap.project_type
2864: AND pap.org_id = pt.org_id -- Bug 4358492