APPS.SSP_SMP_PKG dependencies on DUAL

Line 887: from dual;

883: (woman.due_date));
884: -- Bug 2663899 End
885: cursor csr_get_week_day is
886: select to_char(mpp_start_date,'DAY')
887: from dual;
888: --
889: l_day_of_the_week varchar2(20);
890: --
891: begin

Line 2216: from sys.dual

2212: ' for recalculation (p_del = '||l_deleting_ch||').');
2213: --
2214: insert into ssp_temp_affected_rows (MATERNITY_ID, p_deleting, locked)
2215: select p_maternity_id, l_deleting_ch, userenv('sessionid')
2216: from sys.dual
2217: where not exists
2218: (select null
2219: from ssp_temp_affected_rows t2
2220: where t2.maternity_id = p_maternity_id);