APPS.AP_WEB_EXPENSE_WF dependencies on WF_ITEM_ACTIVITY_STATUSES_H

Line 15094: from wf_item_activity_statuses_h

15090: and rownum = 1;
15091: EXCEPTION WHEN NO_DATA_FOUND THEN
15092: select 'Y'
15093: into l_access_granted
15094: from wf_item_activity_statuses_h
15095: where item_type = l_item_type
15096: and ((item_key = to_char(p_item_key)) or (item_key like to_char(p_item_key) || '-%'))
15097: and notification_id = p_ntf_id
15098: and rownum = 1;

Line 15113: from wf_item_activity_statuses_h

15109: and rownum = 1;
15110: EXCEPTION WHEN NO_DATA_FOUND THEN
15111: select item_key
15112: into l_item_key
15113: from wf_item_activity_statuses_h
15114: where item_type = l_item_type
15115: and notification_id = p_ntf_id
15116: and rownum = 1;
15117: END;

Line 15141: from wf_item_activity_statuses_h

15137: and rownum = 1;
15138: EXCEPTION WHEN NO_DATA_FOUND THEN
15139: select 'Y'
15140: into l_access_granted
15141: from wf_item_activity_statuses_h
15142: where item_type = l_item_type
15143: and item_key like '%'||to_char(p_item_key)||'%'
15144: and notification_id = p_ntf_id
15145: and rownum = 1;