APPS.IGS_SS_EN_WRAPPERS dependencies on DUAL

Line 282: dual;

278: CURSOR c1 IS
279: SELECT
280: igs_pe_std_todo_ref_rf_num_s.NEXTVAL
281: FROM
282: dual;
283: l_reference_number NUMBER;
284: CURSOR c2 ( c_return_val NUMBER) IS
285: SELECT
286: person_id

Line 1796: FROM DUAL;

1792:
1793: CURSOR cur_seq_val
1794: IS
1795: SELECT igs_en_status_mail_req_s.nextval seq_val
1796: FROM DUAL;
1797:
1798: CURSOR cur_user_name IS SELECT user_name FROM fnd_user WHERE user_id = fnd_global.user_id;
1799:
1800: CURSOR cur_cal_desc IS SELECT description FROM igs_ca_inst WHERE cal_type = p_load_cal_type

Line 1883: FROM DUAL;

1879:
1880: CURSOR cur_seq_val
1881: IS
1882: SELECT igs_en_wf_trans_notif_s.nextval seq_val
1883: FROM DUAL;
1884:
1885: l_cur_seq_val cur_seq_val%ROWTYPE;
1886: l_wf_parameter_list_t WF_PARAMETER_LIST_T:=wf_parameter_list_t();
1887: l_wf_installed fnd_lookups.lookup_code%TYPE;