DBA Data[Home] [Help]

APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on HR_GENERAL

Line 758: select least(nvl(pps.actual_termination_date,hr_general.end_of_time),

754: l_ben_end_date date;
755: l_tax_year_end date;
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