DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_PJRM dependencies on PA_PROJECT_TYPES_ALL

Line 58: from pa_project_types_all pt,

54: UNION
55: select 'Administrative or Unassigned Time Type' , 'PA_ARPR_ADM_UNASS_PRJ_TYP'
56: from dual
57: where exists ( select pt.project_type
58: from pa_project_types_all pt,
59: pa_projects_all p
60: where p.project_id = p_project_id
61: and pt.project_type = p.project_type
62: and ( nvl(pt.administrative_flag, 'N') = 'Y'