DBA Data[Home] [Help]

APPS.IGS_AS_GEN_007 dependencies on IGS_CA_INST_REL

Line 856: igs_ca_inst_rel cir

852: FROM igs_pe_std_todo st,
853: igs_pe_std_todo_ref str,
854: igs_en_su_attempt_all sua,
855: igs_as_unit_class uc,
856: igs_ca_inst_rel cir
857: WHERE ((NVL (p_person_id, 9999999999) = 9999999999)
858: OR (st.person_id = p_person_id)
859: )
860: AND st.logical_delete_dt IS NULL

Line 1226: igs_ca_inst_rel cir

1222: FROM igs_ps_unitass_item usai,
1223: igs_as_assessmnt_itm ai,
1224: igs_ps_unit_ofr_opt uai,
1225: igs_as_unit_class uc,
1226: igs_ca_inst_rel cir
1227: WHERE usai.uoo_id = uai.uoo_id
1228: AND uai.unit_class = uc.unit_class
1229: AND uc.closed_ind = 'N'
1230: AND usai.ass_id = ai.ass_id

Line 1284: igs_ca_inst_rel cir

1280: uai.grading_schema_cd,
1281: uai.gs_version_number
1282: FROM igs_as_unitass_item uai,
1283: igs_as_assessmnt_itm ai,
1284: igs_ca_inst_rel cir
1285: WHERE uai.ass_id = ai.ass_id
1286: AND (p_teach_perd_cal_type IS NULL
1287: OR uai.cal_type = p_teach_perd_cal_type
1288: )