DBA Data[Home] [Help]

APPS.IGS_EN_GEN_010 dependencies on IGS_EN_UNIT_SET_MAP

Line 7946: FROM igs_en_unit_set_map usm,

7942: -- false log entry is made and the insert or update is not carried out for bug 3149133.
7943: ------------------------------------------------------------------------------------------------
7944: CURSOR c_acad_us (cp_new_admin_unit_Set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE) IS
7945: SELECT usm.stream_unit_set_Cd
7946: FROM igs_en_unit_set_map usm,
7947: igs_ps_us_prenr_cfg upc
7948: WHERE upc.unit_set_cd = cp_new_admin_unit_set_cd
7949: AND usm.mapping_set_cd = upc.mapping_set_cd
7950: AND usm.sequence_no = upc.sequence_no;

Line 8449: FROM igs_en_unit_set_map usm,

8445: ------------------------------------------------------------------------------------------------
8446:
8447: CURSOR c_acad_us (cp_old_admin_unit_Set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE) IS
8448: SELECT usm.stream_unit_set_Cd
8449: FROM igs_en_unit_set_map usm,
8450: igs_ps_us_prenr_cfg upc
8451: WHERE upc.unit_set_cd = cp_old_admin_unit_set_cd
8452: AND usm.mapping_set_cd = upc.mapping_set_cd
8453: AND usm.sequence_no = upc.sequence_no;