APPS.HRI_EDW_FCT_WRKFC_SPRTN dependencies on HRI_INV_SPRTN_RSNS

Line 100: FROM hri_inv_sprtn_rsns

96: -- to indicate if involuntary separations are being detected
97: --
98: CURSOR c_sep_rsn_type IS
99: SELECT termination_type
100: FROM hri_inv_sprtn_rsns
101: WHERE reason = p_reason;
102: --
103: BEGIN
104: --

Line 184: FROM hri_inv_sprtn_rsns

180: CURSOR update_value_csr
181: (v_reason_code VARCHAR2)
182: IS
183: SELECT termination_type, update_allowed_flag
184: FROM hri_inv_sprtn_rsns
185: WHERE reason = v_reason_code;
186:
187: BEGIN
188:

Line 206: INSERT INTO hri_inv_sprtn_rsns

202: /* If value does not already exist */
203: IF (update_value_csr%NOTFOUND OR update_value_csr%NOTFOUND IS NULL) THEN
204: CLOSE update_value_csr;
205: /* Insert it */
206: INSERT INTO hri_inv_sprtn_rsns
207: ( reason
208: , termination_type
209: , update_allowed_flag )
210: VALUES

Line 218: UPDATE hri_inv_sprtn_rsns

214: /* If termination type has changed and reason is updateable */
215: ELSIF (l_update_allowed = 'Y' AND l_term_type <> l_termination_type) THEN
216: CLOSE update_value_csr;
217: /* Update the reason and reset the update allowed flag */
218: UPDATE hri_inv_sprtn_rsns
219: SET termination_type = l_term_type,
220: update_allowed_flag = 'N'
221: WHERE reason = v_leaving_reason.lookup_code;
222: ELSE

Line 240: UPDATE hri_inv_sprtn_rsns

236: /* Check valid input */
237: IF (p_update_allowed = 'Y' OR p_update_allowed = 'N') THEN
238:
239: /* Update table */
240: UPDATE hri_inv_sprtn_rsns
241: SET update_allowed_flag = p_update_allowed
242: WHERE (reason = p_reason_code
243: OR p_reason_code IS NULL);
244: