DBA Data[Home] [Help]

APPS.HRI_EDW_DIM_EVENTS dependencies on HRI_EDW_EVENT_HRCHY_CMBNS

Line 354: FROM hri_edw_event_hrchy_cmbns

350: ,sep_event_id
351: ,reason_type
352: ,facts
353: ,description
354: FROM hri_edw_event_hrchy_cmbns
355: WHERE combination_id = p_combination_id;
356:
357: BEGIN
358:

Line 370: INSERT INTO hri_edw_event_hrchy_cmbns

366: l_facts,
367: l_description;
368: IF (row_exists_cur%NOTFOUND OR row_exists_cur%NOTFOUND IS NULL) THEN
369: CLOSE row_exists_cur;
370: INSERT INTO hri_edw_event_hrchy_cmbns
371: ( combination_id
372: , gain_event_id
373: , loss_event_id
374: , rec_event_id

Line 390: UPDATE hri_edw_event_hrchy_cmbns

386: , p_facts
387: , p_description );
388: ELSE
389: CLOSE row_exists_cur;
390: UPDATE hri_edw_event_hrchy_cmbns
391: SET gain_event_id = p_gain_event_id
392: , loss_event_id = p_loss_event_id
393: , rec_event_id = p_rec_event_id
394: , sep_event_id = p_sep_event_id