DBA Data[Home] [Help]

APPS.PA_TEAM_TEMPLATES_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES_V

Line 316: FROM wf_item_activity_statuses_v

312: SET workflow_in_progress_flag = 'N'
313: WHERE team_template_id = l_team_template_id
314: AND NOT EXISTS(
315: SELECT 'Y'
316: FROM wf_item_activity_statuses_v
317: WHERE item_type = p_item_type
318: AND substr(item_key, 1, instr(item_key, '-')) = substr(p_item_key, 1, instr(p_item_key, '-'))
319: AND ((activity_status_code = 'DEFERRED' AND item_key <> p_item_key) OR
320: (activity_name='START_APPLY_TEAM_TEMPLATE_WF' AND activity_status_code = 'ACTIVE' AND item_key <> p_item_key)))