APPS.HR_PSF_SHD dependencies on HR_GENERAL

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

150: end if;
151:
152: select count(*) into cnt from hr_all_positions_f where position_id = l_position_id and availability_status_id = 1;
153: if cnt = 0 then
154: select hr_general.effective_date into l_expiration_date from dual;
155:
156: wf_event.AddParameterToList( 'USER_NAME', 'POS'||':'||l_position_id, l_plist);
157: wf_event.AddParameterToList( 'DISPLAYNAME', '-', l_plist);
158: wf_event.AddParameterToList( 'DESCRIPTION', '-', l_plist);