APPS.IGS_EN_WLST_GEN_PROC dependencies on IGS_PS_UNIT_VER

Line 106: p_unit_cd OUT NOCOPY igs_ps_unit_ver.unit_cd%TYPE ,

102:
103: END getpersondetail ;
104:
105: PROCEDURE getuoodetail ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
106: p_unit_cd OUT NOCOPY igs_ps_unit_ver.unit_cd%TYPE ,
107: p_unit_title OUT NOCOPY igs_ps_unit_ver.title%TYPE ,
108: p_cal_type OUT NOCOPY igs_ps_unit_ofr_opt.cal_type%TYPE ,
109: p_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE ,
110: p_location_desc OUT NOCOPY igs_ad_location.description%TYPE ,

Line 107: p_unit_title OUT NOCOPY igs_ps_unit_ver.title%TYPE ,

103: END getpersondetail ;
104:
105: PROCEDURE getuoodetail ( p_uoo_id IN igs_ps_unit_ofr_opt.uoo_id%TYPE ,
106: p_unit_cd OUT NOCOPY igs_ps_unit_ver.unit_cd%TYPE ,
107: p_unit_title OUT NOCOPY igs_ps_unit_ver.title%TYPE ,
108: p_cal_type OUT NOCOPY igs_ps_unit_ofr_opt.cal_type%TYPE ,
109: p_alternate_code OUT NOCOPY igs_ca_inst.alternate_code%TYPE ,
110: p_location_desc OUT NOCOPY igs_ad_location.description%TYPE ,
111: p_unit_class OUT NOCOPY igs_ps_unit_ofr_opt.unit_class%TYPE ,

Line 135: igs_ps_unit_ver uv ,

131: ci.alternate_code , al.description location_desc ,
132: uoo.unit_class
133: FROM igs_ps_unit_ofr_opt uoo ,
134: igs_ad_location al ,
135: igs_ps_unit_ver uv ,
136: igs_ca_inst ci
137: WHERE uoo.unit_cd = uv.unit_cd
138: AND uoo.version_number = uv.version_number
139: AND uoo.cal_type = ci.cal_type

Line 1106: igs_ps_unit_ver uv

1102: CURSOR cur_org_unit_cd ( cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)
1103: IS
1104: SELECT NVL(uoo.owner_org_unit_cd,uv.owner_org_unit_cd)
1105: FROM igs_ps_unit_ofr_opt uoo,
1106: igs_ps_unit_ver uv
1107: WHERE uoo.uoo_id = cp_uoo_id
1108: AND uv.unit_cd= uoo.unit_cd
1109: AND uv.version_number= uoo.version_number;
1110: