APPS.IGS_AS_ANON_GRD_PKG dependencies on IGS_PS_UNITASS_ITEM

Line 48: FROM igs_ps_unitass_item uooai,

44: AND anm.load_cal_type = ttl.load_cal_type
45: AND (anm.method <> 'ASSESSMENT'
46: OR (anm.method = 'ASSESSMENT'
47: AND (EXISTS ( SELECT 'X'
48: FROM igs_ps_unitass_item uooai,
49: igs_as_assessmnt_itm ai,
50: igs_as_assessmnt_typ ast
51: WHERE uooai.uoo_id = uoo.uoo_id
52: AND uooai.logical_delete_dt IS NULL

Line 74: FROM igs_ps_unitass_item uooai

70: AND ai.assessment_type = anm.assessment_type
71: AND ai.assessment_type = ast.assessment_type
72: AND ast.anon_grading_ind = 'Y'
73: AND NOT EXISTS (SELECT 'X'
74: FROM igs_ps_unitass_item uooai
75: WHERE uooai.uoo_id = uoo.uoo_id
76: AND uooai.logical_delete_dt IS NOT NULL)))));
77:
78:

Line 95: FROM igs_ps_unitass_item uooai,

91: WHERE uoo.cal_type = ttl2.teach_cal_type
92: AND uoo.ci_sequence_number = ttl2.teach_ci_sequence_number)
93: AND anm.load_cal_type = ttl.load_cal_type
94: AND (EXISTS ( SELECT 'X'
95: FROM igs_ps_unitass_item uooai,
96: igs_as_assessmnt_itm ai,
97: igs_as_assessmnt_typ ast
98: WHERE uooai.uoo_id = uoo.uoo_id
99: AND uooai.ass_id = p_ass_id

Line 124: FROM igs_ps_unitass_item uooai

120: AND uoai.ass_id = ai.ass_id
121: AND ai.assessment_type = ast.assessment_type
122: AND ast.anon_grading_ind = 'Y'
123: AND NOT EXISTS (SELECT 'X'
124: FROM igs_ps_unitass_item uooai
125: WHERE uooai.uoo_id = uoo.uoo_id
126: AND uooai.logical_delete_dt IS NOT NULL)));
127:
128: c_uoo_ai_rec c_uoo_ai%ROWTYPE;