APPS.PA_TEAM_TEMPLATES_PKG dependencies on PA_PROJECT_ASSIGNMENTS

Line 269: FROM pa_project_assignments

265: AND record_version_number = p_record_version_number
266: AND nvl(workflow_in_progress_flag, 'N') <> 'Y'
267: AND NOT EXISTS
268: (SELECT 'X'
269: FROM pa_project_assignments
270: WHERE assignment_template_id = p_team_template_id
271: AND template_flag <> 'Y');
272:
273: IF (SQL%NOTFOUND) THEN