[Home] [Help]
2671: CURSOR csr_vacanies_by_person IS
2672: SELECT pasf.vacancy_id
2673: ,pv.name ||' ('||pr.name||')' name
2674: FROM per_assignments_f pasf,
2675: per_assignment_status_types past,
2676: per_vacancies pv,
2677: per_requisitions pr
2678: WHERE pasf.person_id = p_person_id
2679: AND p_effective_date BETWEEN pasf.effective_start_date
2758:
2759: CURSOR csr_deployment_by_person IS
2760: SELECT pasf.assignment_id, pasf.position_id, pasf.grade_id, pp.name
2761: FROM per_assignments_f pasf,
2762: per_assignment_status_types past,
2763: hr_positions_f pp
2764: WHERE pasf.person_id = p_person_id
2765: AND p_effective_date BETWEEN pasf.effective_start_date
2766: AND pasf.effective_end_date
2802:
2803: CURSOR csr_deployment_by_person IS
2804: SELECT pasf.assignment_id, pasf.job_id, pasf.grade_id, pj.name
2805: FROM per_assignments_f pasf,
2806: per_assignment_status_types past,
2807: per_jobs_vl pj
2808: WHERE pasf.person_id = p_person_id
2809: AND p_effective_date BETWEEN pasf.effective_start_date
2810: AND pasf.effective_end_date
2844:
2845: CURSOR csr_deployment_by_person IS
2846: SELECT pasf.assignment_id, pasf.organization_id, hou.name
2847: FROM per_assignments_f pasf,
2848: per_assignment_status_types past,
2849: hr_organization_units hou
2850: WHERE pasf.person_id = p_person_id
2851: AND p_effective_date BETWEEN pasf.effective_start_date
2852: AND pasf.effective_end_date
2887: SELECT pasf.assignment_id
2888: ,pasf.vacancy_id
2889: ,pv.name||' ('||pr.name||')' name
2890: FROM per_assignments_f pasf,
2891: per_assignment_status_types past,
2892: per_vacancies pv,
2893: per_requisitions pr
2894: WHERE pasf.person_id = p_person_id
2895: AND p_effective_date BETWEEN pasf.effective_start_date