1043: Begin
1044: --
1045: select effective_date
1046: into l_effective_date 1047: from fnd_sessions 1048: where session_id = userenv('sessionid');
1049: --
1050: -- find the previous 6-Apr
1051: select to_date('06-04-' || to_char( to_number(
Line 1509: from fnd_sessions
1505: Begin
1506: --
1507: select effective_date
1508: into l_effective_date 1509: from fnd_sessions 1510: where session_id = userenv('sessionid');
1511:
1512: --
1513: begin