DBA Data[Home] [Help]

APPS.IGF_SE_GEN_001 dependencies on DUAL

Line 338: FROM dual;

334: WHERE awd.award_id = cp_award_id;
335:
336: CURSOR c_next_auth IS
337: SELECT igf_se_auth_s1.NEXTVAL
338: FROM dual;
339:
340: CURSOR c_auth_check(cv_award_id igf_aw_award.award_id%TYPE,
341: cv_ld_cal_type igs_ca_inst.cal_type%TYPE,
342: cv_ld_seq_no igs_ca_inst.sequence_number%TYPE

Line 1620: SELECT igs_pe_res_chg_s.nextval INTO l_seq_val from DUAL;

1616:
1617: -- Getting a unique number from the sequence
1618: -- using a IGS_PE sequence for this.
1619:
1620: SELECT igs_pe_res_chg_s.nextval INTO l_seq_val from DUAL;
1621:
1622: -- Initialize the wf_event_t object
1623: WF_EVENT_T.Initialize(l_wf_event_t);
1624: