APPS.PV_OPPORTUNITY_VHUK dependencies on PV_LEAD_WORKFLOWS

Line 290: SELECT PV_LEAD_WORKFLOWS_S.nextval INTO l_itemKey

286: fnd_msg_pub.Add;
287: END IF;
288: end if;
289:
290: SELECT PV_LEAD_WORKFLOWS_S.nextval INTO l_itemKey
291: FROM dual;
292:
293: FOR i in 1 .. p_user_name_tbl.count
294: LOOP

Line 1666: FROM pv_lead_workflows pw,

1662: IS
1663: SELECT pn.user_id, pn.resource_id, fu.user_name ,
1664: decode(pn.notification_type, 'MATCHED_TO', 'CM', 'PT') user_type,
1665: decode(pn.notification_type, 'MATCHED_TO', 0, pa.partner_id) partner_id
1666: FROM pv_lead_workflows pw,
1667: pv_lead_assignments pa,
1668: pv_party_notifications pn,
1669: jtf_rs_resource_extns extn,
1670: as_accesses_all asac,

Line 1692: FROM as_accesses_all ac, jtf_rs_resource_extns js, fnd_user fu, pv_lead_workflows pw

1688: AND sysdate between fu.start_date and nvl(fu.end_date,sysdate)
1689: UNION
1690: SELECT js.user_id, js.resource_id, fu.user_name,
1691: decode(pw.created_by - js.user_id,0,'AM','OTHER') user_type, 0 partner_id
1692: FROM as_accesses_all ac, jtf_rs_resource_extns js, fnd_user fu, pv_lead_workflows pw
1693: WHERE (('Y' = pc_notify_ot_flag and pw.created_by <> js.user_id)
1694: or ('Y' = pc_notify_am_flag and pw.created_by = js.user_id))
1695: AND ac.lead_id = pc_lead_id
1696: and ac.lead_id = pw.lead_id

Line 1717: FROM pv_lead_workflows pw

1713: ORDER BY 4;
1714:
1715: CURSOR lc_assign_ids (pc_lead_id number) is
1716: SELECT lead_workflow_id, wf_item_key, wf_item_type
1717: FROM pv_lead_workflows pw
1718: WHERE pw.routing_status = 'ACTIVE'
1719: AND pw.latest_routing_flag = 'Y'
1720: AND pw.lead_id = pc_lead_id;
1721: