APPS.AP_WEB_EXPENSE_WF dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 16060: from wf_item_activity_statuses_h

16056: and rownum = 1;
16057: EXCEPTION WHEN NO_DATA_FOUND THEN
16058: select 'Y'
16059: into l_access_granted
16060: from wf_item_activity_statuses_h
16061: where item_type = l_item_type
16062: and ((item_key = to_char(p_item_key)) or (item_key like to_char(p_item_key) || '-%'))
16063: and notification_id = p_ntf_id
16064: and rownum = 1;

Line 16079: from wf_item_activity_statuses_h

16075: and rownum = 1;
16076: EXCEPTION WHEN NO_DATA_FOUND THEN
16077: select item_key
16078: into l_item_key
16079: from wf_item_activity_statuses_h
16080: where item_type = l_item_type
16081: and notification_id = p_ntf_id
16082: and rownum = 1;
16083: END;

Line 16107: from wf_item_activity_statuses_h

16103: and rownum = 1;
16104: EXCEPTION WHEN NO_DATA_FOUND THEN
16105: select 'Y'
16106: into l_access_granted
16107: from wf_item_activity_statuses_h
16108: where item_type = l_item_type
16109: and ((item_key like '%'||to_char(p_item_key)||'%') or (item_key = l_temp_item_key))
16110: and notification_id = p_ntf_id
16111: and rownum = 1;