APPS.IGS_AS_ADI_UPLD_AIO_PKG dependencies on IGS_PS_UNITASS_ITEM

Line 634: FROM igs_ps_unitass_item uooai,

630: AND (ai.ass_id = p_ass_id
631: OR p_ass_id IS NULL
632: )
633: AND (EXISTS ( SELECT 'X'
634: FROM igs_ps_unitass_item uooai,
635: igs_ps_unit_ofr_opt uoo
636: WHERE uoo.uoo_id = cp_uoo_id
637: AND uooai.uoo_id = uoo.uoo_id
638: AND uooai.ass_id = ai.ass_id

Line 661: FROM igs_ps_unitass_item uooai

657: )
658: AND uoai.grading_schema_cd = gs.grading_schema_cd
659: AND uoai.gs_version_number = gs.version_number
660: AND NOT EXISTS ( SELECT 'X'
661: FROM igs_ps_unitass_item uooai
662: WHERE uooai.uoo_id = uoo.uoo_id
663: AND uooai.logical_delete_dt IS NULL
664: AND uooai.ass_id = ai.ass_id)));
665: --