eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_PARTICIPANTS

Line 3768: select PARTICIPANT_ID ,OBJECT_VERSION_NUMBER,PARTICIPATION_TYPE from per_participants

3764: l_appr_ret_status varchar2(1);
3765: l_check_elig varchar2(1);
3766: -- Cursor to get the Participants of an appraisal other than MA
3767: CURSOR csr_get_appr_part(p_appraisal_id per_appraisals.appraisal_id%TYPE) IS
3768: select PARTICIPANT_ID ,OBJECT_VERSION_NUMBER,PARTICIPATION_TYPE from per_participants
3769: where participation_in_id =p_appraisal_id
3770: and participation_in_table = 'PER_APPRAISALS'
3771: and participation_in_column = 'APPRAISAL_ID'
3772: and PARTICIPATION_TYPE <> 'MAINAP'

Line 4351: UPDATE PER_PARTICIPANTS

4347: WHERE appraisal_id =l_appr_id;
4348: -- revoke the participant statuses and close them.NOt deleting them if feedback is already provided.
4349: FOR i in csr_get_appr_part(l_appr_id)
4350: LOOP
4351: UPDATE PER_PARTICIPANTS
4352: SET PARTICIPATION_STATUS ='CLOSED'
4353: WHERE PARTICIPANT_ID =i.PARTICIPANT_ID ;
4354: END LOOP;
4355: -- we are doing a direct update as update API will not work for terminated and traansfer employees