DBA Data[Home] [Help]

APPS.IEM_CLIENT_PUB dependencies on JTF_IH_ACTIVITIES

Line 2355: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = l_parent_ih_id

2351: IF ( l_action_id = 84 OR l_action_id =85 OR l_action_id =86) THEN
2352: -- resend/forward/re-reply need to copy doc_id and doc_ref from parent
2353: begin
2354: SELECT doc_id, doc_ref into l_activity_rec.doc_id, l_activity_rec.doc_ref
2355: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = l_parent_ih_id
2356: AND ACTION_ID in (22,30,31,33,65,72,74);
2357: exception
2358: when others then
2359: null;

Line 2474: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = l_parent_ih_id

2470: IF ( l_action_id = 84 OR l_action_id =85 OR l_action_id =86) THEN
2471: -- resend/forward/re-reply need to copy doc_id and doc_ref from parent
2472: begin
2473: SELECT doc_id, doc_ref into l_activity_rec.doc_id, l_activity_rec.doc_ref
2474: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = l_parent_ih_id
2475: AND ACTION_ID in (22,30,31,33,65,72,74);
2476: exception
2477: when others then
2478: null;