APPS.IGS_ST_GEN_003 dependencies on IGS_OR_INSTITUTION

Line 13: || IGS_OR_INSTITUTION.GOVT_INSTITUTION_CD is modified from NUMBER to VARCHAR2.

9: || Change History :
10: || Who When What
11: || pkpatel 05-MAR-2002 Bug NO: 2224621
12: || Modified P_GOVT_EXEMPTION_INST_CD from NUMBER to VARCHAR2 in STAP_GET_SCA_DATA. Since its source
13: || IGS_OR_INSTITUTION.GOVT_INSTITUTION_CD is modified from NUMBER to VARCHAR2.
14: || (reverse chronological order - newest change first)
15: */
16:
17: Function Stap_Get_Prsn_Dsblty(

Line 762: || IGS_OR_INSTITUTION.GOVT_INSTITUTION_CD is modified from NUMBER to VARCHAR2.

758: || Change History :
759: || Who When What
760: || pkpatel 05-MAR-2002 Bug NO: 2224621
761: || Modified GOVT_EXEMPTION_INST_CD from NUMBER to VARCHAR2. Since its source
762: || IGS_OR_INSTITUTION.GOVT_INSTITUTION_CD is modified from NUMBER to VARCHAR2.
763: || (reverse chronological order - newest change first)
764: */
765: gv_other_detail VARCHAR2(255);
766: BEGIN -- stap_get_sca_data

Line 852: FROM IGS_OR_INSTITUTION ins

848: CURSOR c_inst_code (
849: cp_exemption_institution_cd
850: IGS_AV_ADV_STANDING.exemption_institution_cd%TYPE) IS
851: SELECT ins.govt_institution_cd
852: FROM IGS_OR_INSTITUTION ins
853: WHERE ins.institution_cd = cp_exemption_institution_cd;
854: CURSOR c_get_hpo IS
855: SELECT scho.differential_hecs_ind,
856: scho.hecs_payment_option,

Line 951: -- determine the government exemption IGS_OR_INSTITUTION code

947: NULL);
948: ELSE
949: v_prior_studies_exemption := v_temp_prior_studies_exemption;
950: END IF;
951: -- determine the government exemption IGS_OR_INSTITUTION code
952: OPEN c_inst_code(v_exemption_institution_cd);
953: FETCH c_inst_code INTO v_govt_exemption_inst_cd;
954: IF (c_inst_code%NOTFOUND) THEN
955: -- exemption IGS_OR_INSTITUTION is a DEETYA value

Line 955: -- exemption IGS_OR_INSTITUTION is a DEETYA value

951: -- determine the government exemption IGS_OR_INSTITUTION code
952: OPEN c_inst_code(v_exemption_institution_cd);
953: FETCH c_inst_code INTO v_govt_exemption_inst_cd;
954: IF (c_inst_code%NOTFOUND) THEN
955: -- exemption IGS_OR_INSTITUTION is a DEETYA value
956: v_govt_exemption_inst_cd := v_exemption_institution_cd;
957: END IF;
958: CLOSE c_inst_code;
959: END IF;