APPS.PAY_GB_EAS_SCOTLAND_FUNCTIONS dependencies on PER_TIME_PERIODS

Line 215: l_asg_period_start_date per_time_periods.start_date%TYPE;

211: AND ppf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;
212: --
213: l_asg_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
214: l_asg_payroll_id pay_payrolls_f.payroll_id%TYPE;
215: l_asg_period_start_date per_time_periods.start_date%TYPE;
216: --
217: CURSOR get_asg_period_start_date IS
218: SELECT ptp.start_date
219: FROM per_time_periods ptp, fnd_sessions fs

Line 219: FROM per_time_periods ptp, fnd_sessions fs

215: l_asg_period_start_date per_time_periods.start_date%TYPE;
216: --
217: CURSOR get_asg_period_start_date IS
218: SELECT ptp.start_date
219: FROM per_time_periods ptp, fnd_sessions fs
220: WHERE fs.session_id = userenv('sessionid')
221: AND ptp.payroll_id = l_asg_payroll_id
222: AND fs.effective_date = ptp.regular_payment_date;
223: --

Line 280: FROM per_time_periods ptp

276: l_count NUMBER := 0;
277: --
278: CURSOR get_pay_date IS
279: SELECT nvl(regular_payment_date, to_date('01-01-0001', 'DD-MM-YYYY'))
280: FROM per_time_periods ptp
281: WHERE l_asg_period_start_date BETWEEN ptp.start_date AND ptp.end_Date
282: AND ptp.payroll_id = l_payroll_id;
283: --
284: BEGIN

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;