DBA Data[Home] [Help]

APPS.PV_MATCH_V3_PUB dependencies on PV_LEAD_WORKFLOWS

Line 3341: pv_lead_workflows plw

3337: , plw.routing_type
3338: , pla.wf_item_key
3339: , pla.assign_sequence
3340: FROM pv_lead_assignments pla,
3341: pv_lead_workflows plw
3342: WHERE plw.lead_id = pc_lead_id
3343: AND plw.wf_item_key = pla.wf_item_key
3344: AND plw.wf_item_type = pla.wf_item_type
3345: AND pla.partner_id = pc_partner_id

Line 3510: FROM pv_lead_workflows

3506:
3507: CURSOR lc_routing_status (pc_wf_item_key VARCHAR2)
3508: IS
3509: SELECT routing_status
3510: FROM pv_lead_workflows
3511: WHERE wf_item_key = pc_wf_item_key
3512: AND wf_item_type = 'PVASGNMT'
3513: AND latest_routing_flag = 'Y';
3514: