APPS.IGS_AS_CALC_AWARD_MARK dependencies on IGS_GE_REF_CD_TYPE

Line 47: igs_ge_ref_cd_type rct

43: IS
44: SELECT 'X'
45: FROM igs_ps_usec_ref_cd refcd,
46: igs_ps_usec_ref usecref,
47: igs_ge_ref_cd_type rct
48: WHERE usecref.uoo_id = cp_uoo_id
49: AND usecref.unit_section_reference_id = refcd.unit_section_reference_id
50: AND refcd.reference_code_type = rct.reference_cd_type
51: AND rct.s_reference_cd_type = 'SUMMEAS'

Line 54: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct

50: AND refcd.reference_code_type = rct.reference_cd_type
51: AND rct.s_reference_cd_type = 'SUMMEAS'
52: UNION
53: SELECT 'X'
54: FROM igs_ps_unit_ref_cd urc, igs_ge_ref_cd_type rct
55: WHERE urc.unit_cd = cp_unit_cd
56: AND urc.version_number = cp_version_number
57: AND urc.reference_cd_type = rct.reference_cd_type
58: AND rct.s_reference_cd_type = 'SUMMEAS'

Line 63: igs_ge_ref_cd_type rct

59: AND NOT EXISTS ( SELECT refcd.reference_code_type
60: FROM igs_ps_usec_ref_cd refcd,
61: igs_ps_usec_ref usecref,
62: igs_ps_unit_ofr_opt_all opt,
63: igs_ge_ref_cd_type rct
64: WHERE usecref.uoo_id = cp_uoo_id
65: AND usecref.unit_section_reference_id =
66: refcd.unit_section_reference_id
67: AND refcd.reference_code_type = rct.reference_cd_type

Line 74: igs_ge_ref_cd_type rct

70: SELECT 'X'
71: FROM igs_ps_us_req_ref_cd refcd,
72: igs_ps_usec_ref usecref,
73: igs_ps_unit_ofr_opt_all opt,
74: igs_ge_ref_cd_type rct
75: WHERE usecref.uoo_id = cp_uoo_id
76: AND usecref.unit_section_reference_id = refcd.unit_section_reference_id
77: AND refcd.reference_cd_type = rct.reference_cd_type
78: AND rct.s_reference_cd_type = 'SUMMEAS'

Line 81: FROM igs_ps_unitreqref_cd urc, igs_ge_ref_cd_type rct

77: AND refcd.reference_cd_type = rct.reference_cd_type
78: AND rct.s_reference_cd_type = 'SUMMEAS'
79: UNION
80: SELECT 'X'
81: FROM igs_ps_unitreqref_cd urc, igs_ge_ref_cd_type rct
82: WHERE urc.unit_cd = cp_unit_cd
83: AND urc.version_number = cp_version_number
84: AND urc.reference_cd_type = rct.reference_cd_type
85: AND rct.s_reference_cd_type = 'SUMMEAS'

Line 90: igs_ge_ref_cd_type rct

86: AND NOT EXISTS ( SELECT refcd.reference_cd_type
87: FROM igs_ps_us_req_ref_cd refcd,
88: igs_ps_usec_ref usecref,
89: igs_ps_unit_ofr_opt_all opt,
90: igs_ge_ref_cd_type rct
91: WHERE usecref.uoo_id = cp_uoo_id
92: AND usecref.unit_section_reference_id =
93: refcd.unit_section_reference_id
94: AND refcd.reference_cd_type = rct.reference_cd_type