DBA Data[Home] [Help]

APPS.IGS_AS_CALC_AWARD_MARK dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 62: igs_ps_unit_ofr_opt_all opt,

58: AND rct.s_reference_cd_type = 'SUMMEAS'
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

Line 73: igs_ps_unit_ofr_opt_all opt,

69: UNION
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

Line 89: igs_ps_unit_ofr_opt_all opt,

85: AND rct.s_reference_cd_type = 'SUMMEAS'
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