APPS.IGS_PS_GEN_008 dependencies on IGS_PS_UNIT_VER_ALL

Line 1269: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us

1265: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1266: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1267: )IS
1268: SELECT uoo.*
1269: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us
1270: WHERE uoo.cal_type = cp_cal_type
1271: AND uoo.ci_sequence_number = cp_ci_sequence_number
1272: AND uoo.location_cd = cp_location_cd
1273: AND uoo.unit_class = cp_unit_class

Line 1292: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us

1288: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1289: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1290: )IS
1291: SELECT uoo.*
1292: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us
1293: WHERE uoo.cal_type = cp_cal_type
1294: AND uoo.ci_sequence_number = cp_ci_sequence_number
1295: AND uoo.location_cd = cp_location_cd
1296: AND uoo.unit_class = cp_unit_class

Line 2723: igs_ps_unit_ver_all uv,

2719: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2720: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2721: SELECT uoo.*
2722: FROM igs_ps_unit_ofr_opt uoo,
2723: igs_ps_unit_ver_all uv,
2724: igs_ps_unit_stat us
2725: WHERE uoo.unit_cd = cp_unit_cd
2726: AND uoo.version_number = cp_version_number
2727: AND uoo.location_cd = cp_location_cd

Line 2776: igs_ps_unit_ver_all uv,

2772: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2773: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2774: SELECT uoo.uoo_id,uoo.sup_uoo_id
2775: FROM igs_ps_unit_ofr_opt uoo,
2776: igs_ps_unit_ver_all uv,
2777: igs_ps_unit_stat us
2778: WHERE uoo.unit_cd = cp_unit_cd
2779: AND uoo.version_number = cp_version_number
2780: AND uoo.location_cd = cp_location_cd