APPS.PV_MATCH_V2_PUB dependencies on PV_LEAD_WORKFLOWS

Line 508: from pv_party_notifications pvpn, pv_lead_assignments pvla , pv_lead_workflows pvlw

504: where jtfre.resource_id = pc_resource_id;
505:
506: cursor lc_is_cm (pc_resource_id number, pc_lead_id number) is
507: select 'X'
508: from pv_party_notifications pvpn, pv_lead_assignments pvla , pv_lead_workflows pvlw
509: where pvlw.lead_id = pc_lead_id
510: and pvlw.entity = 'OPPORTUNITY'
511: and pvlw.LATEST_ROUTING_FLAG = 'Y'
512: and pvlw.routing_status = 'MATCHED'

Line 2700: from pv_lead_workflows

2696: l_wf_status varchar2(30);
2697:
2698: cursor lc_get_lead_status ( pc_lead_id NUMBER) is
2699: select wf_status, routing_status
2700: from pv_lead_workflows
2701: where lead_id = pc_lead_id
2702: and latest_routing_flag = 'Y';
2703:
2704: cursor lc_id_type (pc_party_rel_id number) is

Line 2726: PV_LEAD_WORKFLOWS PVLW

2722: PVLA.STATUS, to_char(PVLA.STATUS_DATE, 'YYYY-MM-DD HH:MM:SS'),
2723: pvpn.DECISION_MAKER_FLAG
2724: from PV_LEAD_ASSIGNMENTS PVLA,
2725: PV_PARTY_NOTIFICATIONS PVPN,
2726: PV_LEAD_WORKFLOWS PVLW
2727: where pvlw.LEAD_ID = pc_lead_id
2728: and pvlw.LATEST_ROUTING_FLAG = 'Y'
2729: and pvlw.WF_ITEM_KEY = pvla.WF_ITEM_KEY
2730: and pvlw.WF_ITEM_TYPE = pvla.WF_ITEM_TYPE