1119: Begin
1120: --
1121: select effective_date
1122: into l_effective_date 1123: from fnd_sessions 1124: where session_id = userenv('sessionid');
1125: --
1126: -- find the previous 6-Apr
1127: select to_date('06-04-' || to_char( to_number(
Line 1623: from fnd_sessions
1619: Begin
1620: --
1621: select effective_date
1622: into l_effective_date 1623: from fnd_sessions 1624: where session_id = userenv('sessionid');
1625:
1626: --
1627: begin