DBA Data[Home] [Help]

APPS.IEM_CLIENT_PUB dependencies on JTF_IH_ACTIVITIES

Line 2409: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = l_parent_ih_id

2405: IF ( l_action_id = 84 OR l_action_id =85 OR l_action_id =86) THEN
2406: -- resend/forward/re-reply need to copy doc_id and doc_ref from parent
2407: begin
2408: SELECT doc_id, doc_ref into l_activity_rec.doc_id, l_activity_rec.doc_ref
2409: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = l_parent_ih_id
2410: AND ACTION_ID in (22,30,31,33,65,72,74);
2411: exception
2412: when others then
2413: null;

Line 2528: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = l_parent_ih_id

2524: IF ( l_action_id = 84 OR l_action_id =85 OR l_action_id =86) THEN
2525: -- resend/forward/re-reply need to copy doc_id and doc_ref from parent
2526: begin
2527: SELECT doc_id, doc_ref into l_activity_rec.doc_id, l_activity_rec.doc_ref
2528: FROM JTF_IH_ACTIVITIES WHERE INTERACTION_ID = l_parent_ih_id
2529: AND ACTION_ID in (22,30,31,33,65,72,74);
2530: exception
2531: when others then
2532: null;