APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_LOOKUP_VALUES

Line 470: CURSOR c_decl_ofr_rsn (cp_lookup_code igs_lookup_values.lookup_code%TYPE) IS

466: AND apl.nominated_course_cd = new_references.nominated_course_cd ;
467:
468: l_is_inst_reconsidered VARCHAR2(1) DEFAULT NULL;
469:
470: CURSOR c_decl_ofr_rsn (cp_lookup_code igs_lookup_values.lookup_code%TYPE) IS
471: SELECT 1
472: FROM IGS_LOOKUP_VALUES lkupv
473: WHERE lookup_type = 'IGS_AD_DECL_OFR_REAS'
474: AND lkupv.CLOSED_IND <> 'N'

Line 472: FROM IGS_LOOKUP_VALUES lkupv

468: l_is_inst_reconsidered VARCHAR2(1) DEFAULT NULL;
469:
470: CURSOR c_decl_ofr_rsn (cp_lookup_code igs_lookup_values.lookup_code%TYPE) IS
471: SELECT 1
472: FROM IGS_LOOKUP_VALUES lkupv
473: WHERE lookup_type = 'IGS_AD_DECL_OFR_REAS'
474: AND lkupv.CLOSED_IND <> 'N'
475: AND LOOKUP_CODE = cp_lookup_code;
476:

Line 1790: igs_lookup_values lv

1786: CURSOR c_pti (cp_person_id igs_pe_person.person_id%TYPE) IS
1787: SELECT pti.rowid row_id,pti.*, lv.lookup_code lv_end_method
1788: FROM igs_pe_typ_instances_all pti,
1789: igs_pe_person_types ppt,
1790: igs_lookup_values lv
1791: WHERE pti.person_id = cp_person_id
1792: AND ppt.person_type_code = pti.person_type_code
1793: AND ppt.system_type = 'PROSPECT'
1794: AND pti.end_date IS NULL

Line 1851: cp_end_method igs_lookup_values.lookup_code%TYPE) IS

1847: CURSOR c_ptyp_inst (cp_person_id igs_ad_ps_appl_inst.person_id%TYPE,
1848: cp_admission_appl_number igs_ad_ps_appl_inst.admission_appl_number%TYPE,
1849: cp_nominated_course_cd igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
1850: cp_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
1851: cp_end_method igs_lookup_values.lookup_code%TYPE) IS
1852: SELECT pti.rowid row_id,pti.*
1853: FROM igs_pe_typ_instances_all pti,
1854: igs_pe_person_types ppt
1855: WHERE pti.person_id = cp_person_id

Line 1868: FROM igs_lookup_values lv

1864:
1865: CURSOR c_per_end_type
1866: IS
1867: SELECT lv.lookup_code
1868: FROM igs_lookup_values lv
1869: WHERE lv.lookup_type = 'PERSON_TYPE_END_METHOD'
1870: AND lv.lookup_code = 'DELETE_APPLICATION'
1871: AND lv.closed_ind = 'N';
1872:

Line 1873: lv_end_method igs_lookup_values.lookup_code%TYPE;

1869: WHERE lv.lookup_type = 'PERSON_TYPE_END_METHOD'
1870: AND lv.lookup_code = 'DELETE_APPLICATION'
1871: AND lv.closed_ind = 'N';
1872:
1873: lv_end_method igs_lookup_values.lookup_code%TYPE;
1874:
1875: BEGIN
1876:
1877: OPEN c_per_end_type;