Need a query to link the Import costs process id with load interface id is passed as parameter

Hi Team,

I am working on a query which is consuming by dell Bhoomi integration platform to the status of the ESS Job.

So they are passing the load_request_id (the process id for load interface file for import) as parameter for the BI Report and they need the status of

load interface file for import status along with Import costs status which is the base table process ID.

I found for Import costs PJC_TXN_XFACE_STAGE_ALL is the interface table to get the load_request_Id and Request_ID in same table.

I found an issues in this process the data is being moved to PJC_TXN_XFACE_ALL after that data in PJC_TXN_XFACE_STAGE_ALL is purging as part oracle standard process.