APPS.IGS_AD_WF_P2A dependencies on DUAL

Line 80: FROM sys.dual;

76: WHERE admission_application_type = cp_app_type;
77:
78: CURSOR c_seq_num IS
79: SELECT IGS_SS_ADM_APPL_S.NEXTVAL
80: FROM sys.dual;
81:
82: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
83: l_login_role VARCHAR2(30);
84: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;

Line 301: FROM dual;

297: WHERE admission_application_type = cp_app_type;
298:
299: CURSOR c_appl_type_uhk_prl IS
300: SELECT FND_PROFILE.VALUE('IGS_AD_APPL_TYPE_UHK') value
301: FROM dual;
302:
303: CURSOR c_appl_fee_uhk_prl IS
304: SELECT FND_PROFILE.VALUE('IGS_AD_APPL_FEE_UHK') value
305: FROM dual;

Line 305: FROM dual;

301: FROM dual;
302:
303: CURSOR c_appl_fee_uhk_prl IS
304: SELECT FND_PROFILE.VALUE('IGS_AD_APPL_FEE_UHK') value
305: FROM dual;
306:
307: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
308: l_login_role VARCHAR2(30);
309: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;