APPS.PV_ASSIGN_UTIL_PVT dependencies on PV_PARTY_NOTIFICATIONS

Line 337: CURSOR C2 IS SELECT PV_PARTY_NOTIFICATIONS_S.nextval FROM sys.dual;

333: IS
334: l_api_name CONSTANT VARCHAR2(30) := 'Create_party_notification';
335: l_api_version_number CONSTANT NUMBER := 1.0;
336:
337: CURSOR C2 IS SELECT PV_PARTY_NOTIFICATIONS_S.nextval FROM sys.dual;
338: l_party_notification_id number;
339:
340: BEGIN
341:

Line 376: INSERT into pv_party_notifications (

372: FETCH C2 INTO l_party_notification_id;
373: CLOSE C2;
374:
375:
376: INSERT into pv_party_notifications (
377: PARTY_NOTIFICATION_ID,
378: LAST_UPDATE_DATE,
379: LAST_UPDATED_BY,
380: CREATION_DATE,

Line 1740: pv_party_notifications pn

1736: cursor lc_get_pt_access(pc_lead_id number)
1737: is
1738: SELECT pn.resource_id
1739: FROM pv_lead_workflows pw, pv_lead_assignments pa,
1740: pv_party_notifications pn
1741: WHERE pw.wf_item_key = pa.wf_item_key
1742: AND pa.lead_assignment_id = pn.lead_assignment_id
1743: AND pw.latest_routing_flag = 'Y'
1744: AND pw.lead_id = pc_lead_id