Inner Query IN keyword is missing after converting Oracle procedure to Postgre procedure

[rajatjha28]

Sample Oracle query - CURSOR C_FACTURE_NEW IS SELECT * FROM FACTURE WHERE ACTIDGESTION = P_ACTIDGESTION AND FACID IN ( SELECT FACID FROM DOSRUBECHEANCIER WHERE **DOSID IN (**SELECT DOSID FROM DOSSIER WHERE ACTID = P_ACTIDGESTION) );

After converting to Postgre - C_FACTURE_NEW CURSOR FOR SELECT * FROM FACTURE WHERE ACTIDGESTION = P_ACTIDGESTION AND FACID IN ( SELECT FACID FROM DOSRUBECHEANCIER WHERE **DOSID(**SELECT DOSID FROM DOSSIER WHERE ACTID = P_ACTIDGESTION) );