Line 1449: from fnd_sessions where session_id = userenv('sessionid');
1445: is inserted in EFFECTIVE_DATE of the PROCESS_EVENTS. If need comes
1446: need to revisit the code to store the proper date.*/
1447: begin
1448: select effective_date into l_effective_date 1449: from fnd_sessions where session_id = userenv('sessionid'); 1450: exception
1451: when no_data_found then
1452: l_effective_date := p_new_date;
1453: end;