APPS.SSP_SMP_SUPPORT_PKG dependencies on PER_TIME_PERIODS

Line 743: from per_time_periods period

739: --
740: -- Get minimum closed period
741: cursor csr_minimum_closed(p_payroll_id number) is
742: select nvl(max(period.start_date),to_date('01/01/0001','DD/MM/YYYY'))
743: from per_time_periods period
744: where period.payroll_id = p_payroll_id
745: and period.prd_information_category = 'GB'
746: and period.prd_information1 = 'Closed';
747: --

Line 752: from per_time_periods period

748: -- Get period details
749: cursor csr_payroll_period is
750: select min(period.start_date),
751: min(nvl(period.end_date,hr_general.end_of_time))
752: from per_time_periods period
753: where period.payroll_id = l_payroll_id
754: and period.start_date > l_closed_period
755: --6959669 begin
756: -- and nvl(period.cut_off_date,period.end_date) <= l_last_process_date