APPS.IGS_AS_SU_ATMPT_ITM_PKG dependencies on IGS_TR_TYPE

Line 165: v_s_tracking_type igs_tr_type.s_tracking_type%TYPE;

161: | is changed.
162: *=======================================================================*************************************/
163: AS
164: v_message_name VARCHAR2 (30);
165: v_s_tracking_type igs_tr_type.s_tracking_type%TYPE;
166: v_s_tracking_status igs_tr_status.s_tracking_status%TYPE;
167: CURSOR cp_tri (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
168: SELECT tt.s_tracking_type,
169: trs.s_tracking_status

Line 171: igs_tr_type tt,

167: CURSOR cp_tri (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
168: SELECT tt.s_tracking_type,
169: trs.s_tracking_status
170: FROM igs_tr_item tri,
171: igs_tr_type tt,
172: igs_tr_status trs
173: WHERE tri.tracking_id = cp_tracking_id
174: AND tri.tracking_type = tt.tracking_type
175: AND tri.tracking_status = trs.tracking_status;