APPS.IGS_AS_GEN_006 dependencies on IGS_PS_UNIT_VER_ALL

Line 286: igs_ps_unit_ver_all uv,

282: sua.ci_end_dt,
283: sua.uoo_id,
284: sua.no_assessment_ind
285: FROM igs_en_su_attempt_all sua,
286: igs_ps_unit_ver_all uv,
287: igs_as_unit_class_all uc
288: WHERE ((cp_assess_cal_type IS NOT NULL
289: AND EXISTS (
290: SELECT 'x'

Line 913: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,

909: App_Exception.Raise_Exception;
910: END assp_ins_aia;
911: PROCEDURE assp_ins_aia_default(
912: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
913: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,
914: p_version_number IN IGS_PS_UNIT_VER_ALL.version_number%TYPE )
915: IS
916: BEGIN -- assp_ins_aia_default
917: -- Insert a default record into the IGS_AS_ITEM_ASSESSOR table

Line 914: p_version_number IN IGS_PS_UNIT_VER_ALL.version_number%TYPE )

910: END assp_ins_aia;
911: PROCEDURE assp_ins_aia_default(
912: p_ass_id IN IGS_AS_ITEM_ASSESSOR.ass_id%TYPE ,
913: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,
914: p_version_number IN IGS_PS_UNIT_VER_ALL.version_number%TYPE )
915: IS
916: BEGIN -- assp_ins_aia_default
917: -- Insert a default record into the IGS_AS_ITEM_ASSESSOR table
918: DECLARE