27: If p_code IS NOT NULL
28: THEN
29: OPEN x_codes for
30: SELECT action_code, Description
31: FROM mtl_actions
32: WHERE NVL(disable_flag,'N') = 'N'
33: AND action_code like (p_code);
34: Else
35: OPEN x_codes for
33: AND action_code like (p_code);
34: Else
35: OPEN x_codes for
36: SELECT action_code, Description
37: FROM mtl_actions
38: WHERE NVL(disable_flag,'N') = 'N';
39: END IF;
40:
41: END expiration_action_code;