[Home] [Help]
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(
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