PCM - Correct GRP logic in NPL_eSponsor Tableau database

Problem Statement

When looking into PCM modules for the NPL records, all records have their Brand/Global Reporting Product documented.

When looking at the same record in the tableau NPL_eSponsor database, some of them are missing the GRP.

Current logic is fetching the GRP based on the SAP code for the PCM ID. Logic needs to be amended to fetch the GRP value as documented as PCM creation (considering this is a mandatory field)

Acceptance Criteria

• All PCM NPL records reflected in the NPL_eSponsor database have a GRP documented (as per what reflected in PCM module)
• GRP logic is changed from "fetching based on SAP code" to "reading the GRP documented" at PCM header level (mandatory field)