APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_PARTICIPANTS

Line 4846: FROM per_participants

4842: -- Cursor to get the Participants of an appraisal other than MA
4843: CURSOR csr_get_appr_part (p_appraisal_id per_appraisals.appraisal_id%TYPE)
4844: IS
4845: SELECT participant_id, object_version_number, participation_type
4846: FROM per_participants
4847: WHERE participation_in_id = p_appraisal_id
4848: AND participation_in_table = 'PER_APPRAISALS'
4849: AND participation_in_column = 'APPRAISAL_ID'
4850: AND participation_type <> 'MAINAP'

Line 5782: UPDATE per_participants

5778:
5779: -- revoke the participant statuses and close them.NOt deleting them if feedback is already provided.
5780: FOR i IN csr_get_appr_part (l_appr_id)
5781: LOOP
5782: UPDATE per_participants
5783: SET participation_status = 'CLOSED'
5784: WHERE participant_id = i.participant_id;
5785: END LOOP;
5786: -- we are doing a direct update as update API will not work for terminated and traansfer employees

Line 8885: FROM per_participants

8881: -- Cursor to get the Participants of an appraisal other than MA
8882: CURSOR csr_get_appr_part (p_appraisal_id per_appraisals.appraisal_id%TYPE)
8883: IS
8884: SELECT participant_id, object_version_number, participation_type
8885: FROM per_participants
8886: WHERE participation_in_id = p_appraisal_id
8887: AND participation_in_table = 'PER_APPRAISALS'
8888: AND participation_in_column = 'APPRAISAL_ID'
8889: AND participation_type <> 'MAINAP'

Line 9066: UPDATE per_participants

9062:
9063: -- revoke the participant statuses and close them.NOt deleting them if feedback is already provided.
9064: FOR i IN csr_get_appr_part (l_appr_id)
9065: LOOP
9066: UPDATE per_participants
9067: SET participation_status = 'CLOSED'
9068: WHERE participant_id = i.participant_id;
9069: END LOOP;
9070: -- we are doing a direct update as update API will not work for terminated and traansfer employees

Line 10435: FROM per_participants

10431: -- Cursor to get the Participants of an appraisal other than MA
10432: CURSOR csr_get_appr_part (p_appraisal_id per_appraisals.appraisal_id%TYPE)
10433: IS
10434: SELECT participant_id, object_version_number, participation_type
10435: FROM per_participants
10436: WHERE participation_in_id = p_appraisal_id
10437: AND participation_in_table = 'PER_APPRAISALS'
10438: AND participation_in_column = 'APPRAISAL_ID'
10439: AND participation_type <> 'MAINAP'

Line 10778: UPDATE per_participants

10774:
10775: -- revoke the participant statuses and close them.NOt deleting them if feedback is already provided.
10776: FOR i IN csr_get_appr_part (l_appr_id)
10777: LOOP
10778: UPDATE per_participants
10779: SET participation_status = 'CLOSED'
10780: WHERE participant_id = i.participant_id;
10781: END LOOP;
10782: -- we are doing a direct update as update API will not work for terminated and traansfer employees

Line 10892: FROM per_participants

10888: -- Cursor to get the Participants of an appraisal other than MA
10889: CURSOR csr_get_appr_part (p_appraisal_id per_appraisals.appraisal_id%TYPE)
10890: IS
10891: SELECT participant_id, object_version_number, participation_type
10892: FROM per_participants
10893: WHERE participation_in_id = p_appraisal_id
10894: AND participation_in_table = 'PER_APPRAISALS'
10895: AND participation_in_column = 'APPRAISAL_ID'
10896: AND participation_type <> 'MAINAP'