APPS.BSC_UPDATE dependencies on DUAL

Line 2008: FROM DUAL;

2004:
2005: --LOCKING: get the sequence nextval here and then use it
2006: SELECT BSC_DB_PROCESS_ID_S.NEXTVAL
2007: INTO h_process_id
2008: FROM DUAL;
2009:
2010: INSERT INTO BSC_DB_PROCESS_CONTROL (
2011: PROCESS_ID,
2012: PROCESS_NAME,

Line 4881: FROM DUAL;

4877: -- Create a new process in BSC_DB_PROCESS_CONTROL
4878: --LOCKING: get the sequence nextval here and then use it
4879: SELECT bsc_db_process_id_s.nextval
4880: INTO h_process_id
4881: FROM DUAL;
4882:
4883: INSERT INTO bsc_db_process_control (process_id, process_name,
4884: creation_date, created_by, last_update_date,last_updated_by,
4885: last_update_login, status)

Line 5195: FROM DUAL;

5191:
5192: --LOCKING: get the sequence nextval here and then use it
5193: SELECT bsc_db_process_id_s.nextval
5194: INTO h_process_id
5195: FROM DUAL;
5196:
5197: -- Create a new process in BSC_DB_PROCESS_CONTROL
5198: INSERT INTO bsc_db_process_control (process_id, process_name,
5199: creation_date, created_by, last_update_date,last_updated_by,

Line 5422: FROM DUAL;

5418:
5419: -- LOCKING: get the sequence next val here and then use it
5420: SELECT bsc_db_process_id_s.nextval
5421: INTO h_process_id
5422: FROM DUAL;
5423:
5424: -- Create a new process in BSC_DB_PROCESS_CONTROL
5425: INSERT INTO bsc_db_process_control (process_id, process_name,
5426: creation_date, created_by, last_update_date,last_updated_by,