DBA Data[Home] [Help]

APPS.HR_PROCESS_PERSON_SS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1645: FROM wf_item_activity_statuses ws

1641: FROM
1642: (
1643: SELECT
1644: ws.process_activity
1645: FROM wf_item_activity_statuses ws
1646: ,wf_process_activities wp
1647: WHERE ws.item_type = p_item_type
1648: AND ws.item_key = p_item_key
1649: AND ws.process_activity = wp.instance_id

Line 1654: FROM wf_item_activity_statuses_h ws

1650: AND wp.activity_name = c_activity_name
1651: UNION ALL
1652: SELECT
1653: ws.process_activity
1654: FROM wf_item_activity_statuses_h ws
1655: ,wf_process_activities wp
1656: WHERE ws.item_type = p_item_type
1657: AND ws.item_key = p_item_key
1658: AND ws.process_activity = wp.instance_id

Line 7210: FROM wf_item_activity_statuses_v wfias

7206: ) IS
7207:
7208: CURSOR get_wf_actid (c_activity_name in varchar2) IS
7209: SELECT distinct wfias.activity_id
7210: FROM wf_item_activity_statuses_v wfias
7211: WHERE wfias.item_type = p_item_type
7212: and wfias.item_key = p_item_key
7213: and wfias.activity_name = c_activity_name;
7214: