APPS.OKS_WF_K_PROCESS_PVT dependencies on WF_PROCESS_ACTIVITIES

Line 745: FROM wf_item_activity_statuses wias, wf_process_activities wpa

741: l_rowfound BOOLEAN := FALSE;
742: l_api_name CONSTANT VARCHAR2(50) := 'activity_exist_in_process';
743: CURSOR check_activity_csr IS
744: SELECT '1'
745: FROM wf_item_activity_statuses wias, wf_process_activities wpa
746: WHERE wias.item_type = p_item_type
747: AND wias.item_key = p_item_key
748: AND wias.process_activity = wpa.instance_id
749: AND wpa.ACTIVITY_ITEM_TYPE = p_item_type

Line 789: FROM wf_item_activity_statuses wias, wf_process_activities wpa

785: l_api_name CONSTANT VARCHAR2(50) := 'get_notified_activity';
786:
787: CURSOR check_activity_csr IS
788: SELECT ACTIVITY_NAME
789: FROM wf_item_activity_statuses wias, wf_process_activities wpa
790: WHERE wias.item_type = p_item_type
791: AND wias.item_key = p_item_key
792: AND wias.process_activity = wpa.instance_id
793: AND wpa.ACTIVITY_ITEM_TYPE = p_item_type