DBA Data[Home] [Help]

APPS.AHL_RA_ANALYSER_PVT dependencies on CSI_COUNTER_TEMPLATE_VL

Line 60: FROM csi_counter_template_vl NEW,

56: NEW.END_DATE_ACTIVE, -- l_tmp_new_end_date_tbl
57: OVER.COUNTER_ID, -- l_tmp_over_ctr_id_tbl
58: OVER.START_DATE_ACTIVE, -- l_tmp_over_start_date_tbl
59: OVER.END_DATE_ACTIVE -- l_tmp_over_end_date_tbl
60: FROM csi_counter_template_vl NEW,
61: csi_counter_template_vl OVER,
62: AHL_RA_CTR_ASSOCIATIONS CTR
63: WHERE CTR.SINCE_NEW_COUNTER_ID = NEW.COUNTER_ID
64: AND CTR.SINCE_OVERHAUL_COUNTER_ID = OVER.COUNTER_ID(+);

Line 61: csi_counter_template_vl OVER,

57: OVER.COUNTER_ID, -- l_tmp_over_ctr_id_tbl
58: OVER.START_DATE_ACTIVE, -- l_tmp_over_start_date_tbl
59: OVER.END_DATE_ACTIVE -- l_tmp_over_end_date_tbl
60: FROM csi_counter_template_vl NEW,
61: csi_counter_template_vl OVER,
62: AHL_RA_CTR_ASSOCIATIONS CTR
63: WHERE CTR.SINCE_NEW_COUNTER_ID = NEW.COUNTER_ID
64: AND CTR.SINCE_OVERHAUL_COUNTER_ID = OVER.COUNTER_ID(+);
65: