DBA Data[Home] [Help]

APPS.HR_PROCESS_PERSON_SS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1793: FROM wf_item_activity_statuses ws

1789: FROM
1790: (
1791: SELECT
1792: ws.process_activity
1793: FROM wf_item_activity_statuses ws
1794: ,wf_process_activities wp
1795: WHERE ws.item_type = p_item_type
1796: AND ws.item_key = p_item_key
1797: AND ws.process_activity = wp.instance_id

Line 1802: FROM wf_item_activity_statuses_h ws

1798: AND wp.activity_name = c_activity_name
1799: UNION ALL
1800: SELECT
1801: ws.process_activity
1802: FROM wf_item_activity_statuses_h ws
1803: ,wf_process_activities wp
1804: WHERE ws.item_type = p_item_type
1805: AND ws.item_key = p_item_key
1806: AND ws.process_activity = wp.instance_id

Line 7782: FROM wf_item_activity_statuses_v wfias

7778: ) IS
7779:
7780: CURSOR get_wf_actid (c_activity_name in varchar2) IS
7781: SELECT distinct wfias.activity_id
7782: FROM wf_item_activity_statuses_v wfias
7783: WHERE wfias.item_type = p_item_type
7784: and wfias.item_key = p_item_key
7785: and wfias.activity_name = c_activity_name;
7786: