APPS.CSR_WIN_PROMIS_PKG dependencies on CSR_WIN_PROMIS_VL

Line 14: Insert, update, delete or lock tables belonging to view CSR_WIN_PROMIS_VL:

10: CSR_WIN_PROMIS_PKG
11:
12: Purpose
13: -------
14: Insert, update, delete or lock tables belonging to view CSR_WIN_PROMIS_VL:
15: - base table CSR_WIN_PROMIS_ALL_B, and
16: - translation table CSR_WIN_PROMIS_ALL_TL.
17: Check uniqueness of columns NAME and START/END_TIME combinations. Restore
18: data integrity to a corrupted base/translation pair.

Line 116: from csr_win_promis_vl

112: is
113: cursor c_prom ( p_prom_id number )
114: is
115: select row_id
116: from csr_win_promis_vl
117: where win_promis_id = p_prom_id;
118:
119: begin
120:

Line 273: from csr_win_promis_vl

269: is
270: cursor c_prom
271: is
272: select *
273: from csr_win_promis_vl
274: where win_promis_id = p_win_promis_id
275: for update nowait;
276:
277: l_rec c_prom%rowtype;