APPS.ASN_MIG_SALES_CREDITS_PVT dependencies on PV_PARTY_NOTIFICATIONS

Line 744: FROM pv_party_notifications WHERE lead_assignment_id = pc_assignment_id;

740:
741: CURSOR lc_get_pn(pc_assignment_id NUMBER) IS
742: SELECT notification_type, lead_assignment_id, user_id, user_name,
743: resource_id, decision_maker_flag, resource_response, response_date
744: FROM pv_party_notifications WHERE lead_assignment_id = pc_assignment_id;
745:
746: BEGIN
747:
748: IF (p_debug_flag = 'Y' AND