APPS.SSP_SMP_PKG dependencies on DUAL

Line 894: from dual;

890: (woman.due_date));
891: -- Bug 2663899 End
892: cursor csr_get_week_day is
893: select to_char(mpp_start_date,'DAY')
894: from dual;
895: --
896: l_day_of_the_week varchar2(20);
897: --
898: begin

Line 2295: from sys.dual

2291: ' for recalculation (p_del = '||l_deleting_ch||').');
2292: --
2293: insert into ssp_temp_affected_rows (MATERNITY_ID, p_deleting, locked)
2294: select p_maternity_id, l_deleting_ch, userenv('sessionid')
2295: from sys.dual
2296: where not exists
2297: (select null
2298: from ssp_temp_affected_rows t2
2299: where t2.maternity_id = p_maternity_id);