APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on PER_PERIODS_OF_SERVICE

Line 752: from per_periods_of_service pps,

748:
749:
750: cursor csr_ben_start_date is
751: select greatest(pps.date_start, l_tax_year_start)
752: from per_periods_of_service pps,
753: per_all_assignments_f paf
754: where paf.period_of_service_id = pps.period_of_service_id
755: and paf.assignment_id = p_assignment_id;
756:

Line 799: from per_periods_of_service pps,

795:
796: cursor csr_ben_end_date is
797: select least(nvl(pps.actual_termination_date,hr_general.end_of_time),
798: l_tax_year_end)
799: from per_periods_of_service pps,
800: per_all_assignments_f paf
801: where paf.period_of_service_id = pps.period_of_service_id
802: and paf.assignment_id = p_assignment_id;
803: