APPS.PA_FP_ORG_FCST_UTILS dependencies on PA_PROJECT_TYPES

Line 254: FROM pa_project_types ppt

250: INTO x_org_project_id
251: FROM pa_projects pp
252: WHERE pp.carrying_out_organization_id = p_organization_id
253: AND pp.project_type in ( SELECT ppt.project_type
254: FROM pa_project_types ppt
255: WHERE ppt.org_project_flag = 'Y')
256: AND pp.template_flag = 'N';
257: -- bug 3106741 AND NVL(pp.template_flag,'N') = 'N';
258:

Line 824: pa_project_types pt

820:
821: SELECT 'Y'
822: INTO l_org_project_exists
823: FROM pa_projects pp,
824: pa_project_types pt
825: WHERE pp.project_id = p_project_id
826: AND pt.project_type = pp.project_type
827: AND pt.org_project_flag = 'Y';
828:

Line 1674: pa_project_types_all pt

1670: l_org_project_exists := 'N';
1671: SELECT 'Y'
1672: INTO l_org_project_exists
1673: FROM pa_projects_all pp,
1674: pa_project_types_all pt
1675: WHERE pp.project_id = p_project_id
1676: AND pt.project_type = pp.project_type
1677: AND pp.org_id = pt.org_id
1678: AND pt.org_project_flag = 'Y';