APPS.HR_PSF_SHD dependencies on HR_GENERAL

Line 178: select hr_general.effective_date into l_expiration_date from dual;

174: if ((l_action = 'INSERT' and l_date_chk = 'CURRENT') or l_action is null or (l_action = 'UPDATE' and l_date_chk = 'CURRENT'))
175: then
176: select count(*) into cnt from hr_all_positions_f where position_id = l_position_id and availability_status_id = 1;
177: if cnt = 0 then
178: select hr_general.effective_date into l_expiration_date from dual;
179:
180: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);
181: wf_event.AddParameterToList( 'DISPLAYNAME', '-', l_plist);
182: wf_event.AddParameterToList( 'DESCRIPTION', '-', l_plist);