eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_ST_GEN_004 dependencies on IGS_PS_UNIT_VER

Line 636: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,

632: WHERE submission_yr = p_submission_yr AND
633: submission_number = p_submission_number
634: FOR UPDATE OF gslo.last_updated_by NOWAIT;
635: CURSOR c_get_indus_ind (
636: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
637: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
638: SELECT uv.industrial_ind
639: FROM IGS_PS_UNIT_VER uv
640: WHERE uv.unit_cd = cp_unit_cd AND

Line 637: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS

633: submission_number = p_submission_number
634: FOR UPDATE OF gslo.last_updated_by NOWAIT;
635: CURSOR c_get_indus_ind (
636: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
637: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
638: SELECT uv.industrial_ind
639: FROM IGS_PS_UNIT_VER uv
640: WHERE uv.unit_cd = cp_unit_cd AND
641: uv.version_number = cp_version_number;

Line 639: FROM IGS_PS_UNIT_VER uv

635: CURSOR c_get_indus_ind (
636: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
637: cp_version_number IGS_PS_UNIT_VER.version_number%TYPE) IS
638: SELECT uv.industrial_ind
639: FROM IGS_PS_UNIT_VER uv
640: WHERE uv.unit_cd = cp_unit_cd AND
641: uv.version_number = cp_version_number;
642: CURSOR c_update_total_eftsu IS
643: SELECT gslo.person_id,

Line 1674: -- get the industrial indicator from IGS_PS_UNIT_VER

1670: v_tuition_fee, -- OUT NOCOPY
1671: v_hecs_fee, -- OUT NOCOPY
1672: v_differential_hecs_ind); -- OUT NOCOPY
1673: END IF;
1674: -- get the industrial indicator from IGS_PS_UNIT_VER
1675: IF v_unit_cd IS NULL OR
1676: v_unit_cd <> v_enr_snpsht_rec.unit_cd OR
1677: v_uv_version_number IS NULL OR
1678: v_uv_version_number <> v_enr_snpsht_rec.uv_version_number THEN

Line 1878: -- get the industrial indicator from IGS_PS_UNIT_VER

1874: v_tuition_fee, -- OUT NOCOPY
1875: v_hecs_fee, -- OUT NOCOPY
1876: v_differential_hecs_ind); -- OUT NOCOPY
1877: END IF;
1878: -- get the industrial indicator from IGS_PS_UNIT_VER
1879: IF v_unit_cd IS NULL OR
1880: v_unit_cd <> v_enr_snpsht_rec.unit_cd OR
1881: v_uv_version_number IS NULL OR
1882: v_uv_version_number <> v_enr_snpsht_rec.uv_version_number THEN

Line 3015: IGS_PS_UNIT_VER uv,

3011: ess.ci_cal_type,
3012: ess.ci_sequence_number,
3013: uoo.uoo_id
3014: FROM IGS_EN_ST_SNAPSHOT ess,
3015: IGS_PS_UNIT_VER uv,
3016: IGS_ST_GVTSEMLOAD_CA gslc,
3017: igs_ps_unit_ofr_opt uoo
3018: WHERE ess.snapshot_dt_time = cp_snapshot_dt_time AND
3019: ess.ci_cal_type = gslc.cal_type AND

Line 3206: v_industrial_ind IGS_PS_UNIT_VER.industrial_ind%TYPE;

3202: v_crv_version_number IGS_ST_GVT_STDNT_LBL.version_number%TYPE;
3203: v_govt_reportable_ind VARCHAR2(1);
3204: v_govt_discipline_group_cd
3205: IGS_EN_ST_SNAPSHOT.govt_discipline_group_cd%TYPE;
3206: v_industrial_ind IGS_PS_UNIT_VER.industrial_ind%TYPE;
3207: v_old_cntr NUMBER;
3208: v_new_cntr NUMBER;
3209: v_citizenship_cd IGS_PE_STATISTICS.citizenship_cd%TYPE;
3210: v_perm_resident_cd IGS_PE_STATISTICS.perm_resident_cd%TYPE;