APPS.BEN_IREC_BACK_OUT_CONC dependencies on BEN_BENEFIT_ACTIONS

Line 126: From ben_benefit_actions ben

122: l_ler_thread c_ler_thread%rowtype;
123: --
124: Cursor c_parameter is
125: Select *
126: From ben_benefit_actions ben
127: Where ben.benefit_action_id = p_benefit_action_id;
128: --
129: l_parm c_parameter%rowtype;
130: --

Line 468: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

464:
465: /* local variable defintions */
466: l_proc varchar2(80) := g_package||'.process';
467: l_request_id number;
468: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
469: l_object_version_number ben_benefit_actions.object_version_number%type;
470: l_person_id per_people_f.person_id%type;
471: l_person_action_id ben_person_actions.person_action_id%type;
472: l_ler_id ben_ler_f.ler_id%type;

Line 469: l_object_version_number ben_benefit_actions.object_version_number%type;

465: /* local variable defintions */
466: l_proc varchar2(80) := g_package||'.process';
467: l_request_id number;
468: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
469: l_object_version_number ben_benefit_actions.object_version_number%type;
470: l_person_id per_people_f.person_id%type;
471: l_person_action_id ben_person_actions.person_action_id%type;
472: l_ler_id ben_ler_f.ler_id%type;
473: l_range_id ben_batch_ranges.range_id%type;

Line 621: ben_benefit_actions_api.create_benefit_actions

617: --
618:
619: If p_benefit_action_id is null then
620: --
621: ben_benefit_actions_api.create_benefit_actions
622: (p_validate => false
623: ,p_benefit_action_id => l_benefit_action_id
624: ,p_process_date => l_effective_date
625: ,p_mode_cd => 'S'

Line 954: From ben_benefit_actions ben

950: ,ptnl_ler_for_per_stat_cd
951: ,person_id
952: , pstl_zip_rng_id -- using this for assignment id
953: -- ,pl_id
954: From ben_benefit_actions ben
955: Where ben.benefit_action_id = p_benefit_action_id;
956: --
957: -- Local Variable declaration.
958: --