DBA Data[Home] [Help]

APPS.IGS_AS_APPR_GRD_SCH_PKG dependencies on IGS_AS_ASSESSMNT_ITM

Line 148: igs_as_assessmnt_itm ai,

144: */
145: CURSOR c_us_ass_item IS
146: SELECT COUNT(ai.assessment_type)
147: FROM igs_ps_unitass_item uai,
148: igs_as_assessmnt_itm ai,
149: igs_ps_unit_ofr_opt uoo
150: WHERE uai.ass_id = ai.ass_id AND
151: uai.uoo_id = uoo.uoo_id AND
152: uoo.unit_cd = old_references.unit_cd AND

Line 161: igs_as_assessmnt_itm ai

157: uai.logical_delete_dt IS NULL;
158: CURSOR c_u_ass_item IS
159: SELECT COUNT(ai.assessment_type)
160: FROM igs_as_unitass_item uai,
161: igs_as_assessmnt_itm ai
162: WHERE uai.ass_id = ai.ass_id AND
163: uai.unit_cd = old_references.unit_cd AND
164: uai.version_number = old_references.version_number AND
165: ai.assessment_type = old_references.assessment_type AND