APPS.IEM_EMAIL_PROC_PVT dependencies on JTF_IH_WRAP_UPS

Line 2125: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu

2121: -- Add a Activity for CREATE SR
2122: -- select result reason outcome for activity
2123: select wu.outcome_id, wu.result_id, wu.reason_id INTO
2124: l_activity_rec.outcome_id, l_activity_rec.result_id, l_activity_rec.reason_id
2125: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
2126: where aa.action_id =65
2127: and aa.action_item_id =45
2128: and aa.default_wrap_id = wu.wrap_id;
2129: l_activity_rec.start_date_time := SYSDATE;

Line 2190: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu

2186: if l_noti_flag='Y' then
2187: -- update the itneraction with result reason outcome
2188: select wu.outcome_id, wu.result_id, wu.reason_id INTO
2189: l_interaction_rec.outcome_id, l_interaction_rec.result_id, l_interaction_rec.reason_id
2190: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
2191: where aa.action_id =65
2192: and aa.action_item_id =45
2193: and aa.default_wrap_id = wu.wrap_id;
2194: l_interaction_rec.interaction_id:=l_interaction_id;

Line 2420: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu

2416:
2417: -- update the itneraction with result reason outcome
2418: select wu.outcome_id, wu.result_id, wu.reason_id INTO
2419: l_interaction_rec.outcome_id, l_interaction_rec.result_id, l_interaction_rec.reason_id
2420: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
2421: where aa.action_id =75
2422: and aa.action_item_id =45
2423: and aa.default_wrap_id = wu.wrap_id;
2424: l_interaction_rec.interaction_id:=l_interaction_id;

Line 4178: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu

4174: l_activity_rec:=p_activity_rec;
4175: BEGIN
4176: select wu.outcome_id, wu.result_id, wu.reason_id INTO
4177: l_activity_rec.outcome_id, l_activity_rec.result_id, l_activity_rec.reason_id
4178: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
4179: where aa.action_id =l_activity_rec.action_id
4180: and aa.action_item_id = l_activity_rec.action_item_id
4181: and aa.default_wrap_id = wu.wrap_id;
4182: EXCEPTION WHEN OTHERS THEN

Line 4271: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu

4267: select wu.outcome_id, wu.result_id, wu.reason_id into
4268: l_interaction_rec.outcome_id,
4269: l_interaction_rec.result_id,
4270: l_interaction_rec.reason_id
4271: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
4272: where aa.action_id =p_action_id
4273: and aa.action_item_id = 45
4274: and aa.default_wrap_id = wu.wrap_id;
4275: EXCEPTION WHEN OTHERS THEN