DBA Data[Home] [Help]

APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PER_PERIODS_OF_SERVICE

Line 713: from per_periods_of_service pps,

709:
710:
711: cursor csr_ben_start_date is
712: select greatest(pps.date_start, l_tax_year_start)
713: from per_periods_of_service pps,
714: per_all_assignments_f paf
715: where paf.period_of_service_id = pps.period_of_service_id
716: and paf.assignment_id = p_assignment_id;
717:

Line 760: from per_periods_of_service pps,

756:
757: cursor csr_ben_end_date is
758: select least(nvl(pps.actual_termination_date,hr_general.end_of_time),
759: l_tax_year_end)
760: from per_periods_of_service pps,
761: per_all_assignments_f paf
762: where paf.period_of_service_id = pps.period_of_service_id
763: and paf.assignment_id = p_assignment_id;
764: