APPS.GCS_CONS_IMPACT_ANALYSIS_PKG dependencies on GCS_TREATMENTS_TL

Line 656: FROM gcs_treatments_tl gcs_orig, gcs_treatments_tl gcs_new

652: p_date_token => l_trx_date);
653:
654: SELECT gcs_orig.treatment_name, gcs_new.treatment_name
655: INTO l_orig_treatment, l_new_treatment
656: FROM gcs_treatments_tl gcs_orig, gcs_treatments_tl gcs_new
657: WHERE gcs_orig.treatment_id = l_orig_treatment_id
658: AND gcs_new.treatment_id = l_new_treatment_id
659: AND gcs_orig.language = USERENV('LANG')
660: AND gcs_new.language = USERENV('LANG');