APPS.IGF_SL_GEN dependencies on IGF_SL_DL_SETUP_ALL

Line 415: FUNCTION get_dl_version(p_ci_cal_type igf_sl_dl_setup_all.ci_cal_type%TYPE,

411: END get_enrollment_desc;
412:
413:
414:
415: FUNCTION get_dl_version(p_ci_cal_type igf_sl_dl_setup_all.ci_cal_type%TYPE,
416: p_ci_seq_num igf_sl_dl_setup_all.ci_sequence_number%TYPE)
417: RETURN VARCHAR2
418: AS
419: /*************************************************************

Line 416: p_ci_seq_num igf_sl_dl_setup_all.ci_sequence_number%TYPE)

412:
413:
414:
415: FUNCTION get_dl_version(p_ci_cal_type igf_sl_dl_setup_all.ci_cal_type%TYPE,
416: p_ci_seq_num igf_sl_dl_setup_all.ci_sequence_number%TYPE)
417: RETURN VARCHAR2
418: AS
419: /*************************************************************
420: Created By : venagara

Line 429: l_dl_version igf_sl_dl_setup_all.dl_version%TYPE;

425: Who When What
426:
427: (reverse chronological order - newest change first)
428: ***************************************************************/
429: l_dl_version igf_sl_dl_setup_all.dl_version%TYPE;
430: CURSOR c_dl_setup IS
431: SELECT dl_version FROM igf_sl_dl_setup_all
432: WHERE ci_cal_type = p_ci_cal_type
433: AND ci_sequence_number = p_ci_seq_num;

Line 431: SELECT dl_version FROM igf_sl_dl_setup_all

427: (reverse chronological order - newest change first)
428: ***************************************************************/
429: l_dl_version igf_sl_dl_setup_all.dl_version%TYPE;
430: CURSOR c_dl_setup IS
431: SELECT dl_version FROM igf_sl_dl_setup_all
432: WHERE ci_cal_type = p_ci_cal_type
433: AND ci_sequence_number = p_ci_seq_num;
434: BEGIN
435: