APPS.IEM_EMAIL_PROC_PVT dependencies on JTF_IH_WRAP_UPS

Line 1327: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu

1323: -- Add a Activity for CREATE SR
1324: -- select result reason outcome for activity
1325: select wu.outcome_id, wu.result_id, wu.reason_id INTO
1326: l_activity_rec.outcome_id, l_activity_rec.result_id, l_activity_rec.reason_id
1327: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
1328: where aa.action_id =65
1329: and aa.action_item_id =45
1330: and aa.default_wrap_id = wu.wrap_id;
1331: l_activity_rec.start_date_time := SYSDATE;

Line 1377: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu

1373: if l_noti_flag='Y' then
1374: -- update the itneraction with result reason outcome
1375: select wu.outcome_id, wu.result_id, wu.reason_id INTO
1376: l_interaction_rec.outcome_id, l_interaction_rec.result_id, l_interaction_rec.reason_id
1377: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
1378: where aa.action_id =65
1379: and aa.action_item_id =45
1380: and aa.default_wrap_id = wu.wrap_id;
1381: l_interaction_rec.interaction_id:=l_interaction_id;

Line 1553: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu

1549:
1550: -- update the itneraction with result reason outcome
1551: select wu.outcome_id, wu.result_id, wu.reason_id INTO
1552: l_interaction_rec.outcome_id, l_interaction_rec.result_id, l_interaction_rec.reason_id
1553: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
1554: where aa.action_id =75
1555: and aa.action_item_id =45
1556: and aa.default_wrap_id = wu.wrap_id;
1557: l_interaction_rec.interaction_id:=l_interaction_id;

Line 3083: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu

3079: l_activity_rec:=p_activity_rec;
3080: BEGIN
3081: select wu.outcome_id, wu.result_id, wu.reason_id INTO
3082: l_activity_rec.outcome_id, l_activity_rec.result_id, l_activity_rec.reason_id
3083: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
3084: where aa.action_id =l_activity_rec.action_id
3085: and aa.action_item_id = l_activity_rec.action_item_id
3086: and aa.default_wrap_id = wu.wrap_id;
3087: EXCEPTION WHEN OTHERS THEN

Line 3176: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu

3172: select wu.outcome_id, wu.result_id, wu.reason_id into
3173: l_interaction_rec.outcome_id,
3174: l_interaction_rec.result_id,
3175: l_interaction_rec.reason_id
3176: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
3177: where aa.action_id =p_action_id
3178: and aa.action_item_id = 45
3179: and aa.default_wrap_id = wu.wrap_id;
3180: EXCEPTION WHEN OTHERS THEN