APPS.HR_GENERIC_UTIL dependencies on PER_TIME_PERIOD_TYPES

Line 15: l_no_periods per_time_period_types.number_per_fiscal_year%type;

11: PROCEDURE get_period_details (p_proc_period_type IN VARCHAR2,
12: p_base_period_type OUT NOCOPY VARCHAR2,
13: p_multiple OUT NOCOPY NUMBER) IS
14: --
15: l_no_periods per_time_period_types.number_per_fiscal_year%type;
16: --
17: l_proc VARCHAR2(100) := 'hr_generic_util.GET_PERIOD_DETAILS';
18: --
19: BEGIN

Line 25: FROM per_time_period_types

21: hr_utility.set_location(l_proc, 10);
22: --
23: SELECT number_per_fiscal_year
24: INTO l_no_periods
25: FROM per_time_period_types
26: WHERE period_type = p_proc_period_type;
27: --
28: hr_utility.set_location(l_proc, 20);
29: --