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_ASGMT_WFSTD dependencies on PA_PROJECT_TYPES_ALL

Line 168: pa_project_types_all pt

164: hr.name organization_name,
165: NVL(pt.administrative_flag,'N') admin_flag
166: FROM pa_projects_all pap,
167: hr_all_organization_units hr,
168: pa_project_types_all pt
169: WHERE pap.project_id = l_project_id
170: AND pap.carrying_out_organization_id =
171: hr.organization_id
172: AND pap.org_id = pt.org_id -- Added for Bug 5389093

Line 6028: pa_project_types_all pt

6024: --MOAC Changes: Bug 4363092 : removed nvl usage with org_id
6025: SELECT NVL(pt.administrative_flag,'N') admin_flag
6026: INTO l_admin_project
6027: FROM pa_projects_all pap,
6028: pa_project_types_all pt
6029: WHERE pap.project_id = p_project_id
6030: AND pt.project_type = pap.project_type
6031: AND pap.org_id = pt.org_id;
6032:

Line 6965: pa_project_types_all pt

6961: hr.name organization_name,
6962: NVL(pt.administrative_flag,'N') admin_flag
6963: FROM pa_projects_all pap,
6964: hr_all_organization_units hr,
6965: pa_project_types_all pt
6966: WHERE pap.project_id = l_project_id
6967: AND pap.carrying_out_organization_id = hr.organization_id
6968: AND pap.org_id = pt.org_id -- Added for Bug 5389093
6969: AND pt.project_type = pap.project_type;