[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
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
8406: IS
8407: SELECT pps.scorecard_id, pps.person_id, pps.assignment_id, NVL (pps.supervisor_id, paf.supervisor_id) supervisor_id,
8408: NVL (pps.supervisor_assignment_id, paf.supervisor_assignment_id) supervisor_assignment_id,
8409: pps.object_version_number, hr_general.decode_person_name (pps.person_id) worker_name
8410: FROM per_personal_scorecards pps, per_assignments_f paf
8411: WHERE pps.plan_id = p_plan_id
8412: AND pps.assignment_id = paf.assignment_id
8413: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
8414:
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
10322: IS
10323: CURSOR csr_curr_sup (p_sc_id IN NUMBER)
10324: IS
10325: SELECT paf.supervisor_id, paf.supervisor_assignment_id, sc.object_version_number
10326: FROM per_personal_scorecards sc, per_assignments_f paf
10327: WHERE sc.scorecard_id = p_sc_id
10328: AND sc.assignment_id = paf.assignment_id
10329: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date;
10330: