DBA Data[Home] [Help]

APPS.IGS_AS_CALC_AWARD_MARK dependencies on IGS_PS_US_REQ_REF_CD

Line 71: FROM igs_ps_us_req_ref_cd refcd,

67: AND refcd.reference_code_type = rct.reference_cd_type
68: AND rct.s_reference_cd_type = 'SUMMEAS')
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

Line 87: FROM igs_ps_us_req_ref_cd refcd,

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'
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