DBA Data[Home] [Help]

APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on BEN_BENEFIT_ACTIONS

Line 466: From ben_benefit_actions ben

462: Order by ben.person_action_id
463: ;
464: Cursor c_parameter is
465: Select *
466: From ben_benefit_actions ben
467: Where ben.benefit_action_id = p_benefit_action_id
468: ;
469: l_parm c_parameter%rowtype;
470: l_commit number;

Line 673: From ben_benefit_actions ben

669: ,legal_entity_id
670: ,payroll_id
671: ,debug_messages_flag
672: ,audit_log_flag
673: From ben_benefit_actions ben
674: Where ben.benefit_action_id = p_benefit_action_id;
675: --
676: -- Local Variable declaration.
677: --

Line 761: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

757: --
758: l_effective_date date;
759: l_request_id number;
760: l_proc varchar2(80) := g_package||'.process';
761: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
762: l_object_version_number ben_benefit_actions.object_version_number%type;
763: l_person_id_out per_people_f.person_id%type;
764: l_range_id ben_batch_ranges.range_id%type;
765: l_chunk_size number;

Line 762: l_object_version_number ben_benefit_actions.object_version_number%type;

758: l_effective_date date;
759: l_request_id number;
760: l_proc varchar2(80) := g_package||'.process';
761: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
762: l_object_version_number ben_benefit_actions.object_version_number%type;
763: l_person_id_out per_people_f.person_id%type;
764: l_range_id ben_batch_ranges.range_id%type;
765: l_chunk_size number;
766: l_threads number;

Line 947: ben_benefit_actions_api.create_perf_benefit_actions

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