APPS.PV_WORKFLOW_PUB dependencies on PV_LEAD_WORKFLOWS

Line 799: from pv_lead_workflows a, pv_lead_assignments la

795: cursor lc_get_pt_id (pc_itemtype varchar2,
796: pc_itemkey varchar2,
797: pc_sequence number) is
798: select la.partner_id, la.assign_sequence, a.lead_id, a.lead_workflow_id, la.lead_assignment_id
799: from pv_lead_workflows a, pv_lead_assignments la
800: where la.wf_item_type = pc_itemtype
801: and la.wf_item_key = pc_itemkey
802: and la.assign_sequence >= pc_sequence
803: and la.status in ( pv_assignment_pub.g_la_status_cm_approved,

Line 2267: FROM pv_lead_workflows

2263: -- routing, the routing status should remain ACTIVE even though the
2264: -- other partners may have timed out or rejected the assignment.
2265: --000000000000000000000000000000000000000000000000000000000000000000000000
2266: FOR x IN (SELECT routing_type
2267: FROM pv_lead_workflows
2268: WHERE lead_id = l_lead_id AND
2269: latest_routing_flag = 'Y')
2270: LOOP
2271: l_routing_type := x.routing_type;

Line 2972: FROM pv_lead_workflows a,

2968: document_type in out nocopy varchar2) IS
2969:
2970: cursor lc_get_assign_type_mean (pc_lead_id number) is
2971: SELECT LOWER(b.meaning) meaning
2972: FROM pv_lead_workflows a,
2973: fnd_lookup_values_vl b
2974: WHERE a.lead_id = pc_lead_id AND
2975: a.routing_type = b.lookup_code AND
2976: b.lookup_type = 'PV_ASSIGNMENT_TYPE';

Line 3001: FROM pv_lead_workflows a,

2997: document_type in out nocopy varchar2) IS
2998:
2999: CURSOR lc_get_vendor_org_name (pc_entity_id NUMBER) IS
3000: SELECT otl.name vendor_name
3001: FROM pv_lead_workflows a,
3002: fnd_user b,
3003: hr_all_organization_units o,
3004: hr_all_organization_units_tl otl,
3005: per_all_people_f p