APPS.IGF_SL_LAR_CREATION dependencies on DUAL

Line 854: SELECT igf_sl_cl_loan_seq_s.NEXTVAL into lv_incr_seq FROM DUAL;

850: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_lar_creation.ret_loan_number.debug','FFEL Loan Number Step 1');
851: END IF;
852:
853: -- Range is 1 to 46655. So, RECYCLE option should be provided.
854: SELECT igf_sl_cl_loan_seq_s.NEXTVAL into lv_incr_seq FROM DUAL;
855:
856: lv_incr_seq_char := igf_sl_gen.base10_to_base36(lv_incr_seq);
857:
858: -- Bug 3102439. To get OPE ID.

Line 3381: SELECT TO_CHAR(SYSDATE,'DDDYY') INTO lv_incr_date FROM DUAL;

3377: END IF;
3378: CLOSE cur_cl_setup;
3379:
3380: -- Base 36 Date Code for CommonLine Loan Number
3381: SELECT TO_CHAR(SYSDATE,'DDDYY') INTO lv_incr_date FROM DUAL;
3382: p_incr_date_code := igf_sl_gen.base10_to_base36(lv_incr_date);
3383:
3384: -- fa134
3385: IF p_base_id IS NOT NULL AND