APPS.PER_ASG_BUS3 dependencies on PER_PERIODS_OF_PLACEMENT

Line 881: ,p_pop_date_start IN per_periods_of_placement.date_start%TYPE

877: (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
878: ,p_business_group_id IN per_all_assignments_f.business_group_id%TYPE
879: ,p_person_id IN per_all_assignments_f.person_id%TYPE
880: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
881: ,p_pop_date_start IN per_periods_of_placement.date_start%TYPE
882: ,p_validation_start_date IN DATE
883: ,p_validation_end_date IN DATE
884: ,p_effective_date IN DATE
885: ,p_object_version_number IN per_all_assignments_f.object_version_number%TYPE

Line 891: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;

887: --
888: l_api_updating BOOLEAN;
889: l_exists VARCHAR2(1);
890: l_proc VARCHAR2(72):= g_package||'chk_pop_date_start';
891: l_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
892: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
893: --
894: CURSOR csr_valid_placement is
895: SELECT pop.business_group_id,

Line 897: FROM per_periods_of_placement pop

893: --
894: CURSOR csr_valid_placement is
895: SELECT pop.business_group_id,
896: pop.actual_termination_date
897: FROM per_periods_of_placement pop
898: WHERE pop.person_id = p_person_id
899: AND pop.date_start = p_pop_date_start
900: AND p_validation_start_date BETWEEN pop.date_start AND
901: NVL(actual_termination_date, hr_api.g_eot);