Terminated Employee Pending Expenses with Manager details in the Cloud
Problem : Terminated Employee Pending Expenses with Manager details in the Cloud. Solution : Query created to find the inactive employee’s expense report select CARD_PROGRAM_NAME,EXPENSE_REPORT_NUM,EXPENSE_STATUS_CODE,ORIG_REIMBURSABLE_AMOUNT,DESCRIPTION,EXP_CREATION_DATE,ACTUAL_TERMINATION_DATE,PERSON_NUMBER,FULL_NAME,Manager_Emp_number,Manager_Name from (select ecp.CARD_PROGRAM_NAME, eer.EXPENSE_REPORT_NUM, eer.EXPENSE_STATUS_CODE,…
Read More