DBA Data[Home] [Help]

APPS.IGS_EN_GEN_010 dependencies on IGS_PS_UNITASS_ITEM_V

Line 9863: FROM igs_ps_unitass_item_v usai_source,

9859:
9860: CURSOR c_usec_ass_itm (cp_unit_section_ass_item_id NUMBER,
9861: cp_dest_uoo_id NUMBER) IS
9862: SELECT usai_dest.UNIT_SECTION_ASS_ITEM_ID
9863: FROM igs_ps_unitass_item_v usai_source,
9864: igs_ps_unitass_item_v usai_dest,
9865: igs_as_assessmnt_itm ai_dest,
9866: igs_as_assessmnt_itm ai_source
9867: WHERE usai_source.unit_section_ass_item_id = cp_unit_section_ass_item_id

Line 9864: igs_ps_unitass_item_v usai_dest,

9860: CURSOR c_usec_ass_itm (cp_unit_section_ass_item_id NUMBER,
9861: cp_dest_uoo_id NUMBER) IS
9862: SELECT usai_dest.UNIT_SECTION_ASS_ITEM_ID
9863: FROM igs_ps_unitass_item_v usai_source,
9864: igs_ps_unitass_item_v usai_dest,
9865: igs_as_assessmnt_itm ai_dest,
9866: igs_as_assessmnt_itm ai_source
9867: WHERE usai_source.unit_section_ass_item_id = cp_unit_section_ass_item_id
9868: and usai_dest.uoo_id = cp_dest_uoo_id