83: l_lp_id ota_training_plans.learning_path_id%TYPE := null;
84:
85: cursor csr_person_full_name is
86: select ppf.full_name 87: from per_all_people_f ppf 88: where ppf.person_id = p_person_id
89: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date;
90:
91: Cursor csr_get_lp_id IS