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 6012: pa_project_types_all pt

6008: --MOAC Changes: Bug 4363092 : removed nvl usage with org_id
6009: SELECT NVL(pt.administrative_flag,'N') admin_flag
6010: INTO l_admin_project
6011: FROM pa_projects_all pap,
6012: pa_project_types_all pt
6013: WHERE pap.project_id = p_project_id
6014: AND pt.project_type = pap.project_type
6015: AND pap.org_id = pt.org_id;
6016:

Line 6949: pa_project_types_all pt

6945: hr.name organization_name,
6946: NVL(pt.administrative_flag,'N') admin_flag
6947: FROM pa_projects_all pap,
6948: hr_all_organization_units hr,
6949: pa_project_types_all pt
6950: WHERE pap.project_id = l_project_id
6951: AND pap.carrying_out_organization_id = hr.organization_id
6952: AND pap.org_id = pt.org_id -- Added for Bug 5389093
6953: AND pt.project_type = pap.project_type;