APPS.IGR_IMP_003 dependencies on IGS_LOOKUPS_VIEW

Line 34: p_lookup_code igs_lookups_view.lookup_code%TYPE,

30:
31: /***************************Get Meaning for error code******************************/
32:
33: FUNCTION Get_Meaning(
34: p_lookup_code igs_lookups_view.lookup_code%TYPE,
35: p_lookup_type igs_lookups_view.lookup_type%TYPE
36: )
37: RETURN VARCHAR2 AS
38: /*******************************************************************************

Line 35: p_lookup_type igs_lookups_view.lookup_type%TYPE

31: /***************************Get Meaning for error code******************************/
32:
33: FUNCTION Get_Meaning(
34: p_lookup_code igs_lookups_view.lookup_code%TYPE,
35: p_lookup_type igs_lookups_view.lookup_type%TYPE
36: )
37: RETURN VARCHAR2 AS
38: /*******************************************************************************
39: Created By: Syam Krishnan

Line 48: lv_meaning igs_lookups_view.meaning%TYPE;

44: Change History
45: Who When What
46:
47: *******************************************************************************/
48: lv_meaning igs_lookups_view.meaning%TYPE;
49:
50: -- Cursor c_lkup is used to select the record (if any) that matches the
51: -- criteria passed via the parameters to the fucntion
52: CURSOR c_lkup (cp_lookup_type igs_lookups_view.lookup_type%TYPE,

Line 52: CURSOR c_lkup (cp_lookup_type igs_lookups_view.lookup_type%TYPE,

48: lv_meaning igs_lookups_view.meaning%TYPE;
49:
50: -- Cursor c_lkup is used to select the record (if any) that matches the
51: -- criteria passed via the parameters to the fucntion
52: CURSOR c_lkup (cp_lookup_type igs_lookups_view.lookup_type%TYPE,
53: cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS
54: SELECT
55: meaning
56: FROM

Line 53: cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS

49:
50: -- Cursor c_lkup is used to select the record (if any) that matches the
51: -- criteria passed via the parameters to the fucntion
52: CURSOR c_lkup (cp_lookup_type igs_lookups_view.lookup_type%TYPE,
53: cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS
54: SELECT
55: meaning
56: FROM
57: igs_lookups_view

Line 57: igs_lookups_view

53: cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS
54: SELECT
55: meaning
56: FROM
57: igs_lookups_view
58: WHERE
59: lookup_type = cp_lookup_type
60: AND lookup_code = cp_lookup_code;
61:

Line 544: igs_lookups_view lkupv,

540: SELECT
541: 'X'
542: FROM
543: igs_ca_inst_alt_v ciav,
544: igs_lookups_view lkupv,
545: igs_lookups_view lkupv1
546: WHERE
547: (ciav.s_cal_cat = 'ACADEMIC' AND ciav.s_cal_status IN ('ACTIVE')
548: AND (p_acad_cal_type, p_acad_ci_sequence_number) IN

Line 545: igs_lookups_view lkupv1

541: 'X'
542: FROM
543: igs_ca_inst_alt_v ciav,
544: igs_lookups_view lkupv,
545: igs_lookups_view lkupv1
546: WHERE
547: (ciav.s_cal_cat = 'ACADEMIC' AND ciav.s_cal_status IN ('ACTIVE')
548: AND (p_acad_cal_type, p_acad_ci_sequence_number) IN
549: (SELECT

Line 574: igs_lookups_view lkupv,

570: SELECT
571: 'X'
572: FROM
573: igs_ca_inst_alt_v ciav1,
574: igs_lookups_view lkupv,
575: igs_lookups_view lkupv1
576: WHERE
577: (ciav1.s_cal_cat = 'ADMISSION' and ciav1.s_cal_status in ('ACTIVE')
578: AND (p_adm_cal_type, p_adm_ci_sequence_number)

Line 575: igs_lookups_view lkupv1

571: 'X'
572: FROM
573: igs_ca_inst_alt_v ciav1,
574: igs_lookups_view lkupv,
575: igs_lookups_view lkupv1
576: WHERE
577: (ciav1.s_cal_cat = 'ADMISSION' and ciav1.s_cal_status in ('ACTIVE')
578: AND (p_adm_cal_type, p_adm_ci_sequence_number)
579: IN