[Home] [Help]
146: cursor lc_get_user_type (pc_username varchar2) is
147: select extn.category,
148: extn.source_id,
149: fuser.user_id
150: from fnd_user fuser,
151: jtf_rs_resource_extns extn
152: where fuser.user_name = pc_username
153: and fuser.user_id = extn.user_id;
154:
1302: , c.resource_id
1303: , c.decision_maker_flag
1304: , c.notification_type
1305: , c.user_id
1306: from pv_lead_workflows a, pv_lead_assignments b, pv_party_notifications c, fnd_user usr
1307: where a.lead_id = pc_lead_id
1308: and a.wf_status = g_wf_status_open
1309: and a.wf_item_type = b.wf_item_type
1310: and a.wf_item_key = b.wf_item_key
1937: is
1938: select a.wf_item_type, a.wf_item_key, a.routing_status, a.wf_status,
1939: b.lead_assignment_id, b.status, b.assign_sequence,
1940: c.rowid, c.resource_id, c.decision_maker_flag, c.user_id
1941: from pv_lead_workflows a, pv_lead_assignments b, pv_party_notifications c, fnd_user usr
1942: where a.lead_id = pc_lead_id
1943: and a.entity = pc_entity
1944: and a.wf_item_type = b.wf_item_type
1945: and a.wf_item_key = b.wf_item_key
1974: pc_notify_type varchar2) is
1975: select usr.user_name, pn.resource_id
1976: from pv_lead_assignments la,
1977: pv_party_notifications pn,
1978: fnd_user usr
1979: where la.wf_item_type = pc_itemtype
1980: and la.wf_item_key = pc_itemkey
1981: and la.partner_id = pc_partner_id
1982: and la.lead_assignment_id = pn.lead_assignment_id
1992: pc_notify_type varchar2) is
1993: select usr.user_name, pn.resource_id
1994: from pv_lead_assignments la,
1995: pv_party_notifications pn,
1996: fnd_user usr
1997: where la.wf_item_type = pc_itemtype
1998: and la.wf_item_key = pc_itemkey
1999: and la.partner_id = pc_partner_id
2000: and la.lead_assignment_id = pn.lead_assignment_id
3444: select la.partner_id,
3445: la.lead_assignment_id,
3446: fu.user_id,
3447: re.resource_id
3448: from fnd_user fu,
3449: jtf_rs_resource_extns re,
3450: hz_relationships emp,
3451: pv_partner_profiles pt,
3452: pv_lead_assignments la