Line 1419: l_period_name pa_periods_all.period_name%TYPE;
1415: -------------------------------------------------------------------
1416:
1417: FUNCTION get_pa_period_name( x_ei_date IN date, x_gl_date IN date ) return varchar2
1418: IS 1419: l_period_name pa_periods_all.period_name%TYPE; 1420: BEGIN
1421:
1422: -- The PA date is derived as the end date of the earliest open or
1423: -- future PA period on or after the EI date. The GL date which is