DBA Data[Home] [Help]

APPS.BEN_BACK_OUT_CONC dependencies on BEN_BENEFIT_ACTIONS

Line 207: From ben_benefit_actions ben

203: l_ler_abs_thread c_ler_abs_thread%rowtype;
204:
205: Cursor c_parameter is
206: Select *
207: From ben_benefit_actions ben
208: Where ben.benefit_action_id = p_benefit_action_id;
209: --
210: l_parm c_parameter%rowtype;
211: --

Line 698: From ben_benefit_actions ben

694: ,date_from
695: ,uneai_effective_date
696: ,ptnl_ler_for_per_stat_cd
697: ,inelg_action_cd
698: From ben_benefit_actions ben
699: Where ben.benefit_action_id = p_benefit_action_id;
700: --
701: -- Local Variable declaration.
702: --

Line 897: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

893: -- local variable declaration.
894: --
895: l_request_id number;
896: l_proc varchar2(80) := g_package||'.process';
897: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
898: l_object_version_number ben_benefit_actions.object_version_number%type;
899: l_person_id per_people_f.person_id%type;
900: l_person_action_id ben_person_actions.person_action_id%type;
901: l_ler_id ben_ler_f.ler_id%type;

Line 898: l_object_version_number ben_benefit_actions.object_version_number%type;

894: --
895: l_request_id number;
896: l_proc varchar2(80) := g_package||'.process';
897: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
898: l_object_version_number ben_benefit_actions.object_version_number%type;
899: l_person_id per_people_f.person_id%type;
900: l_person_action_id ben_person_actions.person_action_id%type;
901: l_ler_id ben_ler_f.ler_id%type;
902: l_range_id ben_batch_ranges.range_id%type;

Line 948: ben_benefit_actions_api.create_benefit_actions

944: -- we are doing a restart.
945: --
946: If p_benefit_action_id is null then
947: --
948: ben_benefit_actions_api.create_benefit_actions
949: (p_validate => false
950: ,p_benefit_action_id => l_benefit_action_id
951: ,p_process_date => l_effective_date
952: ,p_mode_cd => 'S'