APPS.PV_WORKFLOW_PUB dependencies on PV_PARTY_NOTIFICATIONS

Line 369: update pv_party_notifications

365: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
366: raise FND_API.G_EXC_ERROR;
367: end if;
368:
369: update pv_party_notifications
370: set resource_response = pv_assignment_pub.g_la_status_cm_timeout,
371: response_date = sysdate,
372: object_version_number = object_version_number + 1,
373: last_update_date = sysdate,

Line 1222: pv_party_notifications pn,

1218: pc_partner_id number,
1219: pc_notify_type varchar2) is
1220: select usr.user_name, pn.resource_id
1221: from pv_lead_assignments la,
1222: pv_party_notifications pn,
1223: fnd_user usr
1224: where la.wf_item_type = pc_itemtype
1225: and la.wf_item_key = pc_itemkey
1226: and la.partner_id = pc_partner_id

Line 1238: pv_party_notifications pn,

1234: pc_partner_id number,
1235: pc_notify_type varchar2) is
1236: select usr.user_name, pn.resource_id
1237: from pv_lead_assignments la,
1238: pv_party_notifications pn,
1239: fnd_user usr
1240: where la.wf_item_type = pc_itemtype
1241: and la.wf_item_key = pc_itemkey
1242: and la.partner_id = pc_partner_id

Line 1249: pv_party_notifications pn2

1245: and pn.user_id = usr.user_id
1246: and not exists
1247: (select 1
1248: from pv_lead_assignments la2,
1249: pv_party_notifications pn2
1250: where la2.wf_item_type = pc_itemtype
1251: and la2.wf_item_key = pc_itemkey
1252: and la2.partner_id <> la.partner_id
1253: and la2.status in (pv_assignment_pub.g_la_status_cm_timeout,