APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_PEOPLE_F

Line 5803: FROM per_people_f papf

5799: ,paaf.organization_id
5800: ,paaf.supervisor_id
5801: ,paaf.supervisor_assignment_id
5802: ,suppapf.full_name SUPERVISOR_NAME
5803: FROM per_people_f papf
5804: ,per_assignments_f paaf
5805: ,per_all_people_f suppapf
5806: WHERE paaf.assignment_id = p_assignment_id
5807: AND papf.person_id = paaf.person_id

Line 6012: ,per_people_f papf

6008: ,to_char(appraisal_date,'DD-MON-YYYY') appraisal_date
6009: ,pa.status
6010: ,pa.assignment_id
6011: FROM per_appraisals pa
6012: ,per_people_f papf
6013: ,per_people_f papf1
6014: WHERE pa.appraisal_id = p_appraisal_id
6015: AND pa.plan_id = p_plan_id
6016: AND pa.main_appraiser_id = papf.person_id

Line 6013: ,per_people_f papf1

6009: ,pa.status
6010: ,pa.assignment_id
6011: FROM per_appraisals pa
6012: ,per_people_f papf
6013: ,per_people_f papf1
6014: WHERE pa.appraisal_id = p_appraisal_id
6015: AND pa.plan_id = p_plan_id
6016: AND pa.main_appraiser_id = papf.person_id
6017: AND p_effective_date BETWEEN papf.effective_start_date AND

Line 6025: l_full_name per_people_f.full_name%type;

6021: papf1.effective_end_date;
6022: l_appraisal_dtls VARCHAR2(4000);
6023: l_person_id per_appraisals.appraisee_person_id%type;
6024: l_assignment_id per_appraisals.assignment_id%type;
6025: l_full_name per_people_f.full_name%type;
6026: BEGIN
6027: FOR i in g_selected_entities.FIRST .. g_selected_entities.LAST
6028: LOOP
6029: BEGIN

Line 6093: ,per_people_f papf

6089: ,pc.person_id
6090: ,papf.full_name scorecard_owner
6091: ,pc.status_code
6092: FROM per_personal_scorecards pc
6093: ,per_people_f papf
6094: WHERE pc.scorecard_id = p_sc_id
6095: AND pc.plan_id = p_plan_id
6096: AND pc.person_id = papf.person_id
6097: AND p_effective_date BETWEEN papf.effective_start_date AND

Line 6162: ,per_people_f papf

6158: ,paaf.job_id
6159: ,pc.assignment_id
6160: ,paaf.supervisor_id -- Bug7567079
6161: FROM per_personal_scorecards pc
6162: ,per_people_f papf
6163: ,per_assignments_f paaf
6164: WHERE pc.scorecard_id = p_sc_id
6165: AND pc.plan_id = p_plan_id
6166: AND pc.assignment_id = paaf.assignment_id

Line 6254: ,per_people_f papf

6250: ,paaf.job_id
6251: ,pc.assignment_id
6252: ,paaf.supervisor_id -- Bug7567079
6253: FROM per_personal_scorecards pc
6254: ,per_people_f papf
6255: ,per_assignments_f paaf
6256: WHERE pc.scorecard_id = p_sc_id
6257: AND pc.plan_id = p_plan_id
6258: AND pc.assignment_id = paaf.assignment_id