APPS.PAY_GB_EAS_SCOTLAND_FUNCTIONS dependencies on PER_TIME_PERIOD_TYPES

Line 13: FROM per_all_assignments_f paaf, pay_all_payrolls_f pap, per_time_period_types ptpt, fnd_sessions fs

9: FUNCTION get_current_freq(p_assignment_id IN NUMBER) RETURN NUMBER IS
10: --
11: CURSOR get_freq IS
12: SELECT ptpt.number_per_fiscal_year
13: FROM per_all_assignments_f paaf, pay_all_payrolls_f pap, per_time_period_types ptpt, fnd_sessions fs
14: WHERE fs.session_id = userenv('sessionid')
15: AND paaf.assignment_id = p_assignment_id
16: AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_Date
17: AND pap.payroll_id = paaf.payroll_id

Line 21: l_freq per_time_period_types.number_per_fiscal_year%TYPE;

17: AND pap.payroll_id = paaf.payroll_id
18: AND fs.effective_date BETWEEN pap.effective_start_date AND pap.effective_end_Date
19: AND pap.period_type = ptpt.period_type;
20: --
21: l_freq per_time_period_types.number_per_fiscal_year%TYPE;
22: --
23: BEGIN
24: --
25: hr_utility.trace('Entering GET_CURRENT_FREQ, p_assignment_id='||p_assignment_id);

Line 425: FROM per_time_periods ptp, per_time_period_types ptpt, fnd_sessions fs

421: l_count NUMBER := 0;
422: --
423: CURSOR get_freq IS
424: SELECT number_per_fiscal_year
425: FROM per_time_periods ptp, per_time_period_types ptpt, fnd_sessions fs
426: WHERE fs.session_id = userenv('sessionid')
427: AND fs.effective_date BETWEEN ptp.start_date AND ptp.end_Date
428: AND ptp.payroll_id = l_payroll_id
429: AND ptp.period_type = ptpt.period_type;