DBA Data[Home] [Help]

APPS.BEN_CWB_UTILS dependencies on BEN_BENEFIT_ACTIONS

Line 199: l_benefit_action_id ben_benefit_actions.benefit_action_id%TYPE;

195: is
196: --
197: -- Declare cursors and local variables
198: --
199: l_benefit_action_id ben_benefit_actions.benefit_action_id%TYPE;
200: l_object_version_number ben_benefit_actions.object_version_number%TYPE;
201: --
202: begin
203: --

Line 200: l_object_version_number ben_benefit_actions.object_version_number%TYPE;

196: --
197: -- Declare cursors and local variables
198: --
199: l_benefit_action_id ben_benefit_actions.benefit_action_id%TYPE;
200: l_object_version_number ben_benefit_actions.object_version_number%TYPE;
201: --
202: begin
203: --
204: -- Issue a savepoint if operating in validation only mode

Line 213: select ben_benefit_actions_s.nextval

209: -- Process Logic
210: --
211: l_object_version_number := 1;
212: --
213: select ben_benefit_actions_s.nextval
214: into l_benefit_action_id
215: from sys.dual;
216: --
217: insert into ben_benefit_actions

Line 217: insert into ben_benefit_actions

213: select ben_benefit_actions_s.nextval
214: into l_benefit_action_id
215: from sys.dual;
216: --
217: insert into ben_benefit_actions
218: (benefit_action_id
219: ,process_date
220: ,uneai_effective_date
221: ,mode_cd