|Transaction Date||Month||To be audited by||Ram|
I want to insert value in To be Audited column by using search criteria based on month. So if Month Appears May I will have a different auditor say Ram and so on. Please note that To be audited by is an Editable Text Box appearing with Tabular Report in APEX and Ram, Shyam, Raja are drop down list(LOV). So if I chose 1-May-13 and Ram from drop down list, the corresponding To be Audited Field based on month chosen is populated by Ram. How do I achieve this?
Any help on this will highly be appreciated.
I am using page processing to accomplish this with the following code
SET AUDITED_BY = (SELECT EMP_NAME FROM EMPLOYEE
WHERE REGION = :P7_REGION AND PROCESSED_BY = :P7_PROCESSED_BY)
But it's throwing error WHEN USED IN PL/SQL EXPRESSION.
Can anyone help me solve the problem?