DBA Data[Home] [Help]

APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on HR_GENERAL

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

793: l_ben_end_date date;
794: l_tax_year_end date;
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