DBA Data[Home] [Help]

APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on BEN_BENEFIT_ACTIONS

Line 452: From ben_benefit_actions ben

448: Order by ben.person_action_id
449: ;
450: Cursor c_parameter is
451: Select *
452: From ben_benefit_actions ben
453: Where ben.benefit_action_id = p_benefit_action_id
454: ;
455: l_parm c_parameter%rowtype;
456: l_commit number;

Line 659: From ben_benefit_actions ben

655: ,legal_entity_id
656: ,payroll_id
657: ,debug_messages_flag
658: ,audit_log_flag
659: From ben_benefit_actions ben
660: Where ben.benefit_action_id = p_benefit_action_id;
661: --
662: -- Local Variable declaration.
663: --

Line 747: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

743: --
744: l_effective_date date;
745: l_request_id number;
746: l_proc varchar2(80) := g_package||'.process';
747: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
748: l_object_version_number ben_benefit_actions.object_version_number%type;
749: l_person_id_out per_people_f.person_id%type;
750: l_range_id ben_batch_ranges.range_id%type;
751: l_chunk_size number;

Line 748: l_object_version_number ben_benefit_actions.object_version_number%type;

744: l_effective_date date;
745: l_request_id number;
746: l_proc varchar2(80) := g_package||'.process';
747: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
748: l_object_version_number ben_benefit_actions.object_version_number%type;
749: l_person_id_out per_people_f.person_id%type;
750: l_range_id ben_batch_ranges.range_id%type;
751: l_chunk_size number;
752: l_threads number;

Line 933: ben_benefit_actions_api.create_perf_benefit_actions

929: -- we are doing a restart.
930: --
931: if p_benefit_action_id is null then
932: --
933: ben_benefit_actions_api.create_perf_benefit_actions
934: (p_validate => false
935: ,p_benefit_action_id => l_benefit_action_id
936: ,p_process_date => l_effective_date
937: ,p_mode_cd => 'S'