DBA Data[Home] [Help]

APPS.IGS_DA_TRNS_IMP dependencies on IGS_PS_UNIT_VER_ALL

Line 2669: FROM igs_ps_unit_ver_all OUTER

2665:
2666: CURSOR c_unit_ver
2667: IS
2668: SELECT version_number
2669: FROM igs_ps_unit_ver_all OUTER
2670: WHERE unit_cd = l_unit_cd
2671: AND unit_status = 'ACTIVE'
2672: AND version_number =
2673: (SELECT MAX (version_number)

Line 2674: FROM igs_ps_unit_ver_all inn

2670: WHERE unit_cd = l_unit_cd
2671: AND unit_status = 'ACTIVE'
2672: AND version_number =
2673: (SELECT MAX (version_number)
2674: FROM igs_ps_unit_ver_all inn
2675: WHERE OUTER.unit_cd = inn.unit_cd
2676: AND inn.unit_status = 'ACTIVE');
2677:
2678: CURSOR c_present_inst