SSHR View SIT Details before/After Approval from backend.

SELECT SEGMENT1, SEGMENT2, SEGMENT3
 --SEGMENT1, SEGMENT2 ALREADY DATE EXISTS, NOW WE ARE GOING TO UPDATE SEGMENT3
FROM  PER_ANALYSIS_CRITERIA   
WHERE ANALYSIS_CRITERIA_ID = 4593109

SEGMENT1        SEGMENT2        SEGMENT3
09-AUG-2015     23-AUG-2015     <NULL>


SSHR>update ABVOVE SIT, UPDATE THE SEGMENT3 WITH 24-Aug-2015 AND SUBMITTED FOR APPROVAL.
NOTIFICATION_ID = 9482183


0. WF_NOTIFICATIONS

SELECT ITEM_kEY FROM WF_NOTIFICATIONS
WHERE NOTIFICATION_ID = 9482183

 ITEM_KEY = 9702

1. HR_API_TRANSACTIONS

SELECT * FROM HR_API_TRANSACTIONS
WHERE ITEM_KEY = 9702

TRANSACTION_ID = 68093

2. HR_API_TRANSACTION_STEPS

SELECT * FROM HR_API_TRANSACTION_STEPS
WHERE TRANSACTION_ID = 68093

TRANSACTION_STEP_ID = 69242

3. HR_API_TRANSACTION_VALUES - join the TABLE WITH HR_API_TRANSACTION_STEPS TABLE USING COLUMN TRANSACTION_STEP_ID.

SELECT * FROM HR_API_TRANSACTION_VALUES
WHERE TRANSACTION_STEP_ID = 69242

JOIN THE TABLE

SELECT TRANSACTION_VALUE_ID  , NUMBER_VALUE
FROM HR_API_TRANSACTION_VALUES HRVALUE, HR_API_TRANSACTION_STEPS HRSTEPS
WHERE HRVALUE.TRANSACTION_STEP_ID = HRSTEPS.TRANSACTION_STEP_ID
AND HRVALUE.TRANSACTION_STEP_ID = 69242
AND NAME = 'P_ANALYSIS_CRITERIA_ID'

TRANSACTION_VALUE_ID = 66655
NUMBER_VALUE = 4961894 -- ANALYSIS_CRITERIA_ID

4. PER_ANALYSIS_CRITERIA

SELECT * FROM PER_ANALYSIS_CRITERIA    WHERE ANALYSIS_CRITERIA_ID = 4961894

SEGMENT3
24-Aug-2015

DATA EXISTS IN THE PER_ANALYSIS_CRITERIA  BUT CANT VIEW IN THE FRONT END BECOZ THE PER_PERSON_ANALYSES DOESNT HAVE THE ENTRY.

5. once final approval done.

ENTRY WILL BE EXISTS IN THE PER_PERSON_ANALYSES.