DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PA_PROJECT_TYPES_ALL

Line 3749: , pa_project_types_all t

3745:
3746: SELECT DISTINCT UPPER(t.project_type_class_code)
3747: INTO x_project_type
3748: FROM pa_projects_all p
3749: , pa_project_types_all t
3750: WHERE 1=1
3751: AND p.project_id = p_project_Id
3752: AND p.project_type = t.project_type
3753: /*AND NVL(p.org_id,-99) = NVL(t.org_id,-99); -- Added NVL for bug 3989132*/

Line 5916: ,pa_project_types_all pt

5912: INTO l_proj_type_count
5913: FROM pji_xbs_denorm denorm
5914: ,pa_proj_elem_ver_structure vs
5915: ,pa_projects_all proj
5916: ,pa_project_types_all pt
5917: WHERE struct_type = 'PRG'
5918: AND sup_project_id = p_project_id
5919: AND struct_version_id IS NULL
5920: AND NVL(denorm.relationship_type,'WF') IN ('WF',l_relationship_type)