DBA Data[Home] [Help]

APPS.OTA_TPM_SWI dependencies on PER_ALL_PEOPLE_F

Line 87: from per_all_people_f ppf

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