APPS.IGS_AD_SS_GEN_001 dependencies on DUAL

Line 5414: SELECT FND_LOBS_S.NEXTVAL INTO l_fileid FROM dual;

5410:
5411: -- Insert data in the FND_LOBS table without the FILE_DATA.
5412: -- FILE_DATA would be updated from the Controller of the calling page since
5413: -- there is issue of passing BLOB data type to PL/SQL from OA Framework.
5414: SELECT FND_LOBS_S.NEXTVAL INTO l_fileid FROM dual;
5415:
5416: INSERT INTO FND_LOBS(
5417: FILE_ID,
5418: FILE_NAME,

Line 5516: SELECT FND_LOBS_S.NEXTVAL INTO l_fileid FROM dual;

5512:
5513: -- Insert data in the FND_LOBS table without the FILE_DATA.
5514: -- FILE_DATA would be updated from the Controller of the calling page since
5515: -- there is issue of passing BLOB data type to PL/SQL from OA Framework.
5516: SELECT FND_LOBS_S.NEXTVAL INTO l_fileid FROM dual;
5517:
5518: INSERT INTO FND_LOBS(
5519: FILE_ID,
5520: FILE_NAME,

Line 5895: FROM dual;

5891: p_event IN OUT NOCOPY WF_EVENT_T) return varchar2
5892: IS
5893: CURSOR c_pre_sub_uhk_prl IS
5894: SELECT FND_PROFILE.VALUE('IGS_AD_PRESUB_APPL_UHK') value
5895: FROM dual;
5896:
5897:
5898: l_person_id NUMBER;
5899: l_ss_adm_appl_id NUMBER;