APPS.OTA_TPM_SWI dependencies on OTA_TRAINING_PLANS

Line 83: l_lp_id ota_training_plans.learning_path_id%TYPE := null;

79: l_add_struct_d hr_dflex_utility.l_ignore_dfcode_varray :=
80: hr_dflex_utility.l_ignore_dfcode_varray();
81:
82: l_proc VARCHAR2(72) := g_package ||'create_training_plan_member';
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

Line 93: From ota_training_plans

89: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date;
90:
91: Cursor csr_get_lp_id IS
92: Select learning_path_id
93: From ota_training_plans
94: Where training_plan_id = p_training_plan_id;
95:
96: BEGIN
97: hr_utility.set_location(' Entering:' || l_proc,10);