APPS.PA_COMP_PROFILE_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES
Line 1218: FROM wf_item_activity_statuses
1214: BEGIN
1215: -- if viewing method is through URL
1216: SELECT item_key
1217: INTO l_profile_id 1218: FROM wf_item_activity_statuses 1219: where notification_id = to_number(document_id);
1220: EXCEPTION
1221: WHEN NO_DATA_FOUND THEN
1222: -- if viewing method is email