DBA Data[Home] [Help]

APPS.ASN_MIG_SALES_CREDITS_PVT dependencies on PV_LEAD_ASSIGNMENTS

Line 738: FROM pv_lead_assignments

734: SELECT partner_id, assign_sequence, lead_id, status, status_date,
735: wf_item_type, wf_item_key, source_type, related_party_id,
736: partner_access_code, reason_code, related_party_access_code,
737: lead_assignment_id
738: FROM pv_lead_assignments
739: WHERE wf_item_type = pc_itemtype AND wf_item_key = pc_itemkey;
740:
741: CURSOR lc_get_pn(pc_assignment_id NUMBER) IS
742: SELECT notification_type, lead_assignment_id, user_id, user_name,