Line 1826: l_effective_date := HR_GBNICAR.NICAR_SESSION_DATE(0);
1822: THEN
1823: IF p_effective_date IS NULL -- e.g. when a purge takes place in online mode
1824: THEN
1825: IF l_earliest_possible_FTE_date IS NULL THEN 1826: l_effective_date := HR_GBNICAR.NICAR_SESSION_DATE(0); 1827: ELSE
1828: l_effective_date := l_earliest_possible_FTE_date;
1829: END IF;
1830: -- if at this point l_effective_date is still null