[Home] [Help]
7726: CURSOR csr_person_dtls (p_assignment_id IN NUMBER, p_effective_date IN DATE)
7727: IS
7728: SELECT papf.person_id, papf.full_name full_name, paaf.assignment_id, paaf.assignment_number, paaf.position_id,
7729: paaf.organization_id, paaf.supervisor_id, paaf.supervisor_assignment_id, suppapf.full_name supervisor_name
7730: FROM per_people_f papf, per_assignments_f paaf, per_all_people_f suppapf
7731: WHERE paaf.assignment_id = p_assignment_id
7732: AND papf.person_id = paaf.person_id
7733: AND p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date
7734: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
7956: papf1.full_name "APPRAISEE_NAME",
7957: TO_CHAR (appraisal_period_start_date, 'DD-MON-YYYY') appraisal_period_start_date,
7958: TO_CHAR (appraisal_period_end_date, 'DD-MON-YYYY') appraisal_period_end_date,
7959: TO_CHAR (appraisal_date, 'DD-MON-YYYY') appraisal_date, pa.status, pa.assignment_id
7960: FROM per_appraisals pa, per_people_f papf, per_people_f papf1
7961: WHERE pa.appraisal_id = p_appraisal_id
7962: AND pa.plan_id = p_plan_id
7963: AND pa.main_appraiser_id = papf.person_id
7964: AND p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date
7967:
7968: l_appraisal_dtls VARCHAR2 (4000);
7969: l_person_id per_appraisals.appraisee_person_id%TYPE;
7970: l_assignment_id per_appraisals.assignment_id%TYPE;
7971: l_full_name per_people_f.full_name%TYPE;
7972: BEGIN
7973: FOR i IN g_selected_entities.FIRST .. g_selected_entities.LAST
7974: LOOP
7975: BEGIN
8043: IS
8044: CURSOR csr_sc_dtls (p_sc_id IN NUMBER, p_plan_id IN NUMBER, p_effective_date IN DATE)
8045: IS
8046: SELECT pc.scorecard_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code
8047: FROM per_personal_scorecards pc, per_people_f papf
8048: WHERE pc.scorecard_id = p_sc_id
8049: AND pc.plan_id = p_plan_id
8050: AND pc.person_id = papf.person_id
8051: AND p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date;
8123: CURSOR csr_sc_dtls (p_sc_id IN NUMBER, p_plan_id IN NUMBER, p_effective_date IN DATE)
8124: IS
8125: SELECT pc.scorecard_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code, papf.business_group_id,
8126: paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id, paaf.supervisor_id -- Bug7567079
8127: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
8128: WHERE pc.scorecard_id = p_sc_id
8129: AND pc.plan_id = p_plan_id
8130: AND pc.assignment_id = paaf.assignment_id
8131: AND pc.person_id = papf.person_id
8213: CURSOR csr_sc_dtls (p_sc_id IN NUMBER, p_plan_id IN NUMBER, p_effective_date IN DATE)
8214: IS
8215: SELECT pc.scorecard_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code, papf.business_group_id,
8216: paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id, paaf.supervisor_id -- Bug7567079
8217: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
8218: WHERE pc.scorecard_id = p_sc_id
8219: AND pc.plan_id = p_plan_id
8220: AND pc.assignment_id = paaf.assignment_id
8221: AND pc.person_id = papf.person_id
9856: IS
9857: SELECT pc.scorecard_id, pc.person_id, pc.object_version_number, papf.full_name scorecard_owner, pc.status_code,
9858: papf.business_group_id, paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id,
9859: paaf.supervisor_id -- Bug7567079
9860: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
9861: WHERE pc.scorecard_id = p_sc_id
9862: AND pc.plan_id = p_plan_id
9863: AND pc.assignment_id = paaf.assignment_id
9864: AND pc.person_id = papf.person_id
10073: IS
10074: SELECT pc.scorecard_id, pc.plan_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code,
10075: papf.business_group_id, paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id,
10076: paaf.supervisor_id -- Bug7567079
10077: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
10078: WHERE pc.scorecard_id = p_sc_id
10079: AND pc.assignment_id = paaf.assignment_id
10080: AND pc.person_id = papf.person_id
10081: AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
10135: IS
10136: SELECT pc.scorecard_id, pc.plan_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code,
10137: papf.business_group_id, paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id,
10138: paaf.supervisor_id -- Bug7567079
10139: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
10140: WHERE pc.scorecard_id = p_sc_id
10141: AND pc.assignment_id = paaf.assignment_id
10142: AND pc.person_id = papf.person_id
10143: AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
10235: IS
10236: SELECT pc.scorecard_id, pc.plan_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code,
10237: papf.business_group_id, paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id,
10238: paaf.supervisor_id -- Bug7567079
10239: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
10240: WHERE pc.scorecard_id = p_sc_id
10241: AND pc.assignment_id = paaf.assignment_id
10242: AND pc.person_id = papf.person_id
10243: AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
10307: IS
10308: SELECT pc.scorecard_id, pc.plan_id, pc.person_id, papf.full_name scorecard_owner, pc.status_code,
10309: papf.business_group_id, paaf.organization_id, paaf.position_id, paaf.job_id, pc.assignment_id,
10310: paaf.supervisor_id -- Bug7567079
10311: FROM per_personal_scorecards pc, per_people_f papf, per_assignments_f paaf
10312: WHERE pc.scorecard_id = p_sc_id
10313: AND pc.assignment_id = paaf.assignment_id
10314: AND pc.person_id = papf.person_id
10315: AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date