APPS.IGS_PS_CAL_RSR_VAL dependencies on IGS_PS_UNIT_STAT

Line 104: igs_ps_unit_stat st

100: p_ci_sequence_number NUMBER) IS
101: SELECT uoov.*,uoov.rowid row_id,uc.unit_mode,loc.description location_description
102: FROM igs_ps_unit_ofr_opt_all uoov,igs_as_unit_class_all uc, igs_ad_location_all loc,
103: igs_ps_unit_ver_all uv,
104: igs_ps_unit_stat st
105: WHERE uoov.cal_type = p_cal_type AND
106: uoov.ci_sequence_number = p_ci_sequence_number AND
107: (uoov.owner_org_unit_cd = p_org_unit_cd OR p_org_unit_cd IS NULL) AND
108: (uoov.unit_cd = p_unit_cd OR p_unit_cd IS NULL) AND

Line 460: FROM igs_ps_unit_ofr_pat uop , igs_ca_load_to_teach_v lteach ,igs_ps_unit_ver_all uv, igs_ps_unit_stat us

456: CURSOR cur_units( p_input_load_cal_type IGS_CA_INST_ALL.CAL_TYPE%TYPE,
457: p_input_load_sequence_number IGS_CA_INST_ALL.SEQUENCE_NUMBER%TYPE ) IS
458: SELECT DISTINCT uop.unit_cd,
459: uop.version_number
460: FROM igs_ps_unit_ofr_pat uop , igs_ca_load_to_teach_v lteach ,igs_ps_unit_ver_all uv, igs_ps_unit_stat us
461: WHERE lteach.load_cal_type = p_input_load_cal_type AND
462: lteach.load_ci_sequence_number = p_input_load_sequence_number AND
463: uop.cal_type = lteach.teach_cal_type AND
464: uop.ci_sequence_number = lteach.teach_ci_sequence_number AND