APPS.PV_ASSIGN_UTIL_PVT dependencies on PV_LEAD_ASSIGNMENTS

Line 86: , pv_lead_assignments ass

82: , pc_item_type VARCHAR2)
83: IS
84: SELECT 'X'
85: FROM as_leads_all al
86: , pv_lead_assignments ass
87: WHERE al.lead_id = ass.lead_id
88: AND al.incumbent_partner_party_id = ass.partner_id
89: AND ass.wf_item_type = pc_item_type
90: AND ass.wf_item_key = pc_item_key

Line 550: select pv_lead_assignments_s.nextval into l_Lead_assignment_ID from sys.dual;

546:
547: raise FND_API.G_EXC_ERROR;
548: end if;
549:
550: select pv_lead_assignments_s.nextval into l_Lead_assignment_ID from sys.dual;
551:
552: -- Debug Message
553: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
554: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');

Line 562: insert into pv_lead_assignments(

558: 'p_assignment_rec.partner_id ' || p_assignment_rec.partner_id);
559: fnd_msg_pub.Add;
560: END IF;
561:
562: insert into pv_lead_assignments(
563: LEAD_ASSIGNMENT_ID,
564: LAST_UPDATE_DATE,
565: LAST_UPDATED_BY,
566: CREATION_DATE,

Line 905: delete from pv_lead_assignments

901: END IF;
902:
903: x_return_status := FND_API.G_RET_STS_SUCCESS ;
904:
905: delete from pv_lead_assignments
906: where lead_assignment_id = p_lead_assignment_id;
907:
908: if sql%rowcount <> 1 then
909:

Line 1739: FROM pv_lead_workflows pw, pv_lead_assignments pa,

1735:
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'