APPS.OTA_TPS_BUS1 dependencies on OTA_TRAINING_PLAN_MEMBERS

Line 307: FROM OTA_TRAINING_PLAN_MEMBERS

303: WHERE time_period_id = p_time_period_id;
304: --
305: CURSOR csr_members IS
306: SELECT NULL
307: FROM OTA_TRAINING_PLAN_MEMBERS
308: WHERE training_plan_id = p_training_plan_id;
309: --
310: BEGIN
311: --

Line 350: -- in OTA_TRAINING_PLAN_MEMBERS

346: END IF;
347: END IF;
348: --
349: -- If it is a changing update, no members are allowed
350: -- in OTA_TRAINING_PLAN_MEMBERS
351: --
352: hr_utility.set_location(' Step:'|| l_proc, 40);
353: IF l_api_updating AND
354: NVL(ota_tps_shd.g_old_rec.time_period_id, hr_api.g_number) <>

Line 785: FROM OTA_TRAINING_PLAN_MEMBERS tpm

781: l_proc varchar2(72) := g_package||'chk_del_training_plan_id';
782:
783: CURSOR csr_del_training_plan_id IS
784: SELECT NULL
785: FROM OTA_TRAINING_PLAN_MEMBERS tpm
786: WHERE tpm.training_plan_id = p_training_plan_id
787: UNION
788: SELECT NULL
789: FROM OTA_TRAINING_PLAN_COSTS tpc

Line 901: FROM ota_training_plan_members

897: l_proc VARCHAR2(72) := g_package|| 'chk_tp_date_range';
898:
899: CURSOR csr_get_tpm IS
900: SELECT training_plan_member_id
901: FROM ota_training_plan_members
902: WHERE training_plan_id = p_training_plan_id
903: AND ( earliest_start_date < p_start_date
904: OR ( p_end_date IS NOT NULL AND target_completion_date > p_end_date) )
905: and member_status_type_id <>'CANCELLED'

Line 910: FROM ota_training_plan_members

906: AND ROWNUM = 1;
907:
908: CURSOR csr_max_tpm_tcd IS
909: SELECT max(target_completion_date)
910: FROM ota_training_plan_members
911: WHERE training_plan_id = p_training_plan_id
912: and member_status_type_id <>'CANCELLED';
913:
914: l_exists NUMBER(9);