APPS.PV_MATCH_V2_PUB dependencies on PV_PARTY_NOTIFICATIONS

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 2725: PV_PARTY_NOTIFICATIONS PVPN,

2721: select PVLA.PARTNER_ID, PVPN.RESOURCE_ID, 'PN' source ,
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