APPS.IGS_PE_USERID_PKG dependencies on WF_ITEMS

Line 638: FROM wf_items

634:
635: --Find if there is an incomplete request filed
636: CURSOR c_check_wf (cp_wf_name VARCHAR2, cp_item_key VARCHAR2) IS
637: SELECT 1
638: FROM wf_items
639: WHERE item_type = item_type
640: AND item_key like cp_item_key||'%'
641: AND END_DATE IS NULL;
642:

Line 646: FROM wf_items

642:
643: -- Find the unique name
644: CURSOR c_get_wf_name(cp_wf_name VARCHAR2, cp_item_key VARCHAR2) IS
645: SELECT l_item_key||(max(NVL(substr(item_key,length(l_item_key)+1,10),0))+1)
646: FROM wf_items
647: WHERE item_type = cp_wf_name
648: AND item_key like cp_item_key||'%' ;
649:
650: CURSOR c_hz_parties(cp_person_number VARCHAR2) IS