DBA Data[Home] [Help]

APPS.BEN_PREMIUM_CONCURRENT dependencies on BEN_BENEFIT_ACTIONS

Line 256: From ben_benefit_actions ben

252: Order by ben.person_action_id
253: ;
254: Cursor c_parameter is
255: Select *
256: From ben_benefit_actions ben
257: Where ben.benefit_action_id = p_benefit_action_id
258: ;
259: l_parm c_parameter%rowtype;
260: l_ovn number := null;

Line 482: From ben_benefit_actions ben

478: ,ler_id
479: ,organization_id
480: ,legal_entity_id
481: ,debug_messages_flag
482: From ben_benefit_actions ben
483: Where ben.benefit_action_id = p_benefit_action_id;
484: --
485: -- Local Variable declaration.
486: --

Line 604: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

600: -- local variable declaration.
601: --
602: l_request_id number;
603: l_proc varchar2(80) := g_package||'.process';
604: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
605: l_object_version_number ben_benefit_actions.object_version_number%type;
606: l_person_id per_people_f.person_id%type;
607: l_person_action_id ben_person_actions.person_action_id%type;
608: l_ler_id ben_ler_f.ler_id%type;

Line 605: l_object_version_number ben_benefit_actions.object_version_number%type;

601: --
602: l_request_id number;
603: l_proc varchar2(80) := g_package||'.process';
604: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
605: l_object_version_number ben_benefit_actions.object_version_number%type;
606: l_person_id per_people_f.person_id%type;
607: l_person_action_id ben_person_actions.person_action_id%type;
608: l_ler_id ben_ler_f.ler_id%type;
609: l_range_id ben_batch_ranges.range_id%type;

Line 701: ben_benefit_actions_api.create_benefit_actions

697:
698: hr_utility.set_location('p_benefit_action_id is null',14);
699: l_restart := FALSE;
700:
701: ben_benefit_actions_api.create_benefit_actions
702: (p_validate => false
703: ,p_benefit_action_id => l_benefit_action_id
704: ,p_process_date => l_effective_date
705: ,p_mode_cd => 'S'