596: p_delimiter=> p_delimiter
597: )
598: ),
599: GREATEST (
600: hr_gbnicar.uk_tax_yr_start (p_session_date),
601: l_start_date
602: )
603: );
604: -- Field 31 contains the effective_end_date, if empty default to end of UK Tax Year
614: p_delimiter=> p_delimiter
615: )
616: ),
617: LEAST (
618: hr_gbnicar.uk_tax_yr_end (p_session_date),
619: NVL (
620: l_final_process_date,
621: hr_gbnicar.uk_tax_yr_end (p_session_date)
622: )
617: LEAST (
618: hr_gbnicar.uk_tax_yr_end (p_session_date),
619: NVL (
620: l_final_process_date,
621: hr_gbnicar.uk_tax_yr_end (p_session_date)
622: )
623: )
624: );
625: