APPS.HR_CANCEL_PLACEMENT_API dependencies on PER_PERIODS_OF_PLACEMENT

Line 30: l_business_group_id per_periods_of_placement.business_group_id%TYPE;

26: -- Declare cursors and local variables
27: --
28: l_proc VARCHAR2(72) := g_package||'cancel_placement';
29: l_system_person_type per_person_types.system_person_type%TYPE;
30: l_business_group_id per_periods_of_placement.business_group_id%TYPE;
31: l_date_start DATE;
32: l_effective_date DATE;
33: --
34: CURSOR csr_date_start IS

Line 37: FROM per_periods_of_placement pp

33: --
34: CURSOR csr_date_start IS
35: SELECT date_start,
36: business_group_id
37: FROM per_periods_of_placement pp
38: WHERE pp.person_id = p_person_id
39: AND l_effective_date BETWEEN pp.date_start
40: AND NVL(pp.actual_termination_date,hr_general.end_of_time);
41: --