APPS.MSC_SCH_WB dependencies on DUAL

Line 1785: from dual;

1781: BEGIN
1782: if ( p_db_link is NULL) then
1783: select mrp_atp_schedule_temp_s.nextval
1784: into p_session_id
1785: from dual;
1786: else
1787: l_db_link := '@'||p_db_link;
1788: --sql_stmt := ' select mrp_atp_schedule_temp_s.nextval from dual@'||p_db_link;
1789: sql_stmt := 'begin msc_sch_wb.get_session_id'||l_db_link||'(:l_null_db_link,:p_session_id); end;';

Line 1788: --sql_stmt := ' select mrp_atp_schedule_temp_s.nextval from dual@'||p_db_link;

1784: into p_session_id
1785: from dual;
1786: else
1787: l_db_link := '@'||p_db_link;
1788: --sql_stmt := ' select mrp_atp_schedule_temp_s.nextval from dual@'||p_db_link;
1789: sql_stmt := 'begin msc_sch_wb.get_session_id'||l_db_link||'(:l_null_db_link,:p_session_id); end;';
1790: EXECUTE IMMEDIATE sql_stmt using l_null_db_link, out p_session_id;
1791:
1792: l_cursor := dbms_sql.open_cursor;