APPS.BEN_PREMIUM_PLAN_CONCURRENT dependencies on BEN_BENEFIT_ACTIONS

Line 95: From ben_benefit_actions ben

91: Order by ben.person_action_id
92: ;
93: Cursor c_parameter is
94: Select *
95: From ben_benefit_actions ben
96: Where ben.benefit_action_id = p_benefit_action_id
97: ;
98: l_parm c_parameter%rowtype;
99: l_ovn number := null;

Line 344: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

340: l_effective_date date;
341: l_first_day_of_month date;
342: l_request_id number;
343: l_proc varchar2(80) := g_package||'.process';
344: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
345: l_object_version_number ben_benefit_actions.object_version_number%type;
346: l_person_action_id ben_person_actions.person_action_id%type;
347: l_ler_id ben_ler_f.ler_id%type;
348: l_range_id ben_batch_ranges.range_id%type;

Line 345: l_object_version_number ben_benefit_actions.object_version_number%type;

341: l_first_day_of_month date;
342: l_request_id number;
343: l_proc varchar2(80) := g_package||'.process';
344: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
345: l_object_version_number ben_benefit_actions.object_version_number%type;
346: l_person_action_id ben_person_actions.person_action_id%type;
347: l_ler_id ben_ler_f.ler_id%type;
348: l_range_id ben_batch_ranges.range_id%type;
349: l_start_person_action_id number := 0;