APPS.SSP_SMP_SUPPORT_PKG dependencies on PER_TIME_PERIODS

Line 698: from per_time_periods period

694: --
695: -- Get minimum closed period
696: cursor csr_minimum_closed(p_payroll_id number) is
697: select nvl(max(period.start_date),to_date('01/01/0001','DD/MM/YYYY'))
698: from per_time_periods period
699: where period.payroll_id = p_payroll_id
700: and period.prd_information_category = 'GB'
701: and period.prd_information1 = 'Closed';
702: --

Line 707: from per_time_periods period

703: -- Get period details
704: cursor csr_payroll_period is
705: select min(period.start_date),
706: min(nvl(period.end_date,hr_general.end_of_time))
707: from per_time_periods period
708: where period.payroll_id = l_payroll_id
709: and period.start_date > l_closed_period
710: --6959669 begin
711: -- and nvl(period.cut_off_date,period.end_date) <= l_last_process_date