DBA Data[Home] [Help]

APPS.BEN_BACK_OUT_CONC dependencies on BEN_BENEFIT_ACTIONS

Line 212: From ben_benefit_actions ben

208: l_ler_abs_thread c_ler_abs_thread%rowtype;
209:
210: Cursor c_parameter is
211: Select *
212: From ben_benefit_actions ben
213: Where ben.benefit_action_id = p_benefit_action_id;
214: --
215: l_parm c_parameter%rowtype;
216: --

Line 724: From ben_benefit_actions ben

720: ,date_from
721: ,uneai_effective_date
722: ,ptnl_ler_for_per_stat_cd
723: ,inelg_action_cd
724: From ben_benefit_actions ben
725: Where ben.benefit_action_id = p_benefit_action_id;
726: --
727: -- Local Variable declaration.
728: --

Line 923: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

919: -- local variable declaration.
920: --
921: l_request_id number;
922: l_proc varchar2(80) := g_package||'.process';
923: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
924: l_object_version_number ben_benefit_actions.object_version_number%type;
925: l_person_id per_people_f.person_id%type;
926: l_person_action_id ben_person_actions.person_action_id%type;
927: l_ler_id ben_ler_f.ler_id%type;

Line 924: l_object_version_number ben_benefit_actions.object_version_number%type;

920: --
921: l_request_id number;
922: l_proc varchar2(80) := g_package||'.process';
923: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
924: l_object_version_number ben_benefit_actions.object_version_number%type;
925: l_person_id per_people_f.person_id%type;
926: l_person_action_id ben_person_actions.person_action_id%type;
927: l_ler_id ben_ler_f.ler_id%type;
928: l_range_id ben_batch_ranges.range_id%type;

Line 974: ben_benefit_actions_api.create_benefit_actions

970: -- we are doing a restart.
971: --
972: If p_benefit_action_id is null then
973: --
974: ben_benefit_actions_api.create_benefit_actions
975: (p_validate => false
976: ,p_benefit_action_id => l_benefit_action_id
977: ,p_process_date => l_effective_date
978: ,p_mode_cd => 'S'