APPS.HR_NEW_USER_REG_SS dependencies on FND_SESSIONS

Line 132: select 1 into l_session_c from fnd_sessions where session_id=userenv('sessionid');

128: (itemtype => WfItemType
129: ,itemkey => WfItemKey
130: ,aname => 'P_EFFECTIVE_DATE'),'RRRR-MM-DD');
131: begin
132: select 1 into l_session_c from fnd_sessions where session_id=userenv('sessionid');
133: exception
134: when no_data_found then
135: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'),l_effective_date);
136: end;

Line 135: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'),l_effective_date);

131: begin
132: select 1 into l_session_c from fnd_sessions where session_id=userenv('sessionid');
133: exception
134: when no_data_found then
135: insert into fnd_sessions(session_id,effective_date) values(userenv('sessionid'),l_effective_date);
136: end;
137:
138: process_selected_transaction
139: (p_item_type => WfItemType,