Access value from other cursor

Hi All,

I want to update some tables based on comparison with values from HZ tables. I have 3 cursor which holds different values. Now I want to compare the values in the table to the HZ tables and then update. The current script throws me "PL/SQL: ORA-00904: "PER_CON"."EMAIL_ADDRESS": invalid identifier" as this value is in different cursor. Please help me how I can modify the script to access values in other cursor as well.

Thanks for your help

CREATE OR REPLACE PROCEDURE XXPQ_GDPR_DATA_MASKING(P_PARTY_ID IN NUMBER,ERRBUFF OUT VARCHAR2,RETCODE OUT NUMBER)ASCURSOR  PERSON_DATA ISselect PERSON_NAME,PERSON_FIRST_NAME,PERSON_MIDDLE_NAME,PERSON_LAST_NAME from apps.HZ_PERSON_PROFILESWHERE PARTY_ID=P_PARTY_ID;CURSOR  PERSON_CONTACT ISSELECT DISTINCT HZP.PARTY_NAME  PARTY_NAME       ,HZCP.Contact_point_type  CONTACT_POINT_TYPE       ,NVL(HZCP.raw_phone_number,HZCP.phone_number) PHONE_NUMBER       ,HZCP.Email_address  EMAIL_ADDRESS       ,HZCP.Phone_line_type PHONE_LINE_TYPE  FROM apps.HZ_CONTACT_POINTS HZCP       ,apps.HZ_PARTY_SITES HZPS       ,apps.HZ_PARTIES HZP       ,apps.HZ_CUST_ACCOUNTS HCA WHERE HZCP.owner_table_name ='HZ_PARTY_SITES'       AND HZCP.OWNER_TABLE_ID= HZPS.ORIG_SYSTEM_REFERENCE       AND HZPS.party_id = HZP.Party_Id       AND HZP.PARTY_TYPE = 'PERSON'       AND HCA.PARTY_ID= HZP.PARTY_ID       AND HCA.PARTY_ID = P_PARTY_IDUNION ALLSELECT DISTINCT HZP1.PARTY_NAME  PARTY_NAME       ,HZCP.Contact_point_type  CONTACT_POINT_TYPE       ,NVL(HZCP.raw_phone_number,HZCP.phone_number) PHONE_NUMBER       ,HZCP.Email_address  EMAIL_ADDRESS       ,HZCP.Phone_line_type PHONE_LINE_TYPE  FROM apps.HZ_CONTACT_POINTS HZCP       ,apps.HZ_PARTIES HZP       ,apps.HZ_PARTIES HZP1       ,apps.hz_relationships HR WHERE HZCP.owner_table_name = 'HZ_PARTIES'       AND HZCP.owner_table_id = HZP.PARTY_ID       AND HZP.PARTY_TYPE = 'PARTY_RELATIONSHIP'       AND HR.PARTY_ID= HZP.PARTY_ID       AND HZP1.PARTY_ID = HR.SUBJECT_ID