DBA Data[Home] [Help]

APPS.GCS_CONS_IMPACT_ANALYSIS_PKG dependencies on GCS_CURR_TREATMENTS_TL

Line 706: FROM gcs_curr_treatments_tl gcs_orig,

702: p_date_token => l_trx_date);
703:
704: SELECT gcs_orig.curr_treatment_name, gcs_new.curr_treatment_name
705: INTO l_orig_treatment, l_new_treatment
706: FROM gcs_curr_treatments_tl gcs_orig,
707: gcs_curr_treatments_tl gcs_new
708: WHERE gcs_orig.curr_treatment_id = l_orig_curr_trtmnt_id
709: AND gcs_new.curr_treatment_id = l_new_curr_trtmnt_id
710: AND gcs_orig.language = USERENV('LANG')

Line 707: gcs_curr_treatments_tl gcs_new

703:
704: SELECT gcs_orig.curr_treatment_name, gcs_new.curr_treatment_name
705: INTO l_orig_treatment, l_new_treatment
706: FROM gcs_curr_treatments_tl gcs_orig,
707: gcs_curr_treatments_tl gcs_new
708: WHERE gcs_orig.curr_treatment_id = l_orig_curr_trtmnt_id
709: AND gcs_new.curr_treatment_id = l_new_curr_trtmnt_id
710: AND gcs_orig.language = USERENV('LANG')
711: AND gcs_new.language = USERENV('LANG');