DBA Data[Home] [Help]

APPS.PV_MATCH_V3_PUB dependencies on PV_PARTY_NOTIFICATIONS

Line 3500: FROM pv_party_notifications

3496: AS
3497: CURSOR lc_cm_for_partner (pc_lead_assign_id NUMBER, pc_wf_item_key VARCHAR2)
3498: IS
3499: SELECT 'N'
3500: FROM pv_party_notifications
3501: WHERE lead_assignment_id = pc_lead_assign_id
3502: AND wf_item_type = 'PVASGNMT'
3503: AND wf_item_key = pc_wf_item_key
3504: --AND notification_type = 'MATCHED_TO'