APPS.IGS_AD_APLINS_ADMREQ_PKG dependencies on IGS_TR_TYPE

Line 342: igs_tr_type b

338:
339: CURSOR c_not_post_adm (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
340: SELECT 'X'
341: FROM igs_tr_item a,
342: igs_tr_type b
343: WHERE a.tracking_id = cp_tracking_id
344: AND b.tracking_type = a.tracking_type
345: AND b.S_TRACKING_TYPE <> 'POST_ADMISSION' ;
346:

Line 404: FROM igs_tr_item titem, igs_tr_type ttype

400: --begin apadegal adtd001 igs.m
401: -- cursor to find the System Tracking type of the given Tracking item
402: CURSOR c_track_type (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
403: SELECT ttype.S_TRACKING_TYPE
404: FROM igs_tr_item titem, igs_tr_type ttype
405: WHERE titem.tracking_id = cp_tracking_id AND
406: titem.tracking_type = ttype.tracking_type;
407:
408: lv_tracking_type IGS_TR_TYPE.S_TRACKING_TYPE%TYPE;

Line 408: lv_tracking_type IGS_TR_TYPE.S_TRACKING_TYPE%TYPE;

404: FROM igs_tr_item titem, igs_tr_type ttype
405: WHERE titem.tracking_id = cp_tracking_id AND
406: titem.tracking_type = ttype.tracking_type;
407:
408: lv_tracking_type IGS_TR_TYPE.S_TRACKING_TYPE%TYPE;
409:
410: --end apadegal adtd001 igs.m
411: BEGIN
412: