DBA Data[Home] [Help]

APPS.PAY_GB_EPS dependencies on FND_SESSIONS

Line 1414: select effective_date into system_date from fnd_sessions where session_id = userenv('SESSIONID');

1410: is
1411: tax_year number;
1412: system_date date;
1413: begin
1414: select effective_date into system_date from fnd_sessions where session_id = userenv('SESSIONID');
1415: if( to_char(system_date,'mmdd')>'0406' ) then
1416: tax_year := to_number(to_char(system_date,'YYYY')) ;
1417: ELSE tax_year := to_number(to_char(system_date,'YYYY'))- 1;
1418: end if;