APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_PROJECT_TYPES_ALL

Line 2615: pa_project_types_all pt

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

Line 2921: pa_project_types_all pt

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