APPS.BEN_CWB_BACK_OUT_CONC dependencies on BEN_BENEFIT_ACTIONS

Line 625: From ben_benefit_actions ben

621: ,debug_messages_flag
622: ,date_from
623: ,ptnl_ler_for_per_stat_cd
624: ,pl_id
625: From ben_benefit_actions ben
626: Where ben.benefit_action_id = p_benefit_action_id;
627: --
628: -- Local Variable declaration.
629: --

Line 764: From ben_benefit_actions ben

760: l_ler_thread c_ler_thread%rowtype;
761: --
762: Cursor c_parameter is
763: Select *
764: From ben_benefit_actions ben
765: Where ben.benefit_action_id = p_benefit_action_id;
766: --
767: l_parm c_parameter%rowtype;
768: --

Line 1170: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

1166:
1167: /* local variable defintions */
1168: l_proc varchar2(80) := g_package||'.process';
1169: l_request_id number;
1170: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1171: l_object_version_number ben_benefit_actions.object_version_number%type;
1172: l_person_id per_people_f.person_id%type;
1173: l_person_action_id ben_person_actions.person_action_id%type;
1174: l_ler_id ben_ler_f.ler_id%type;

Line 1171: l_object_version_number ben_benefit_actions.object_version_number%type;

1167: /* local variable defintions */
1168: l_proc varchar2(80) := g_package||'.process';
1169: l_request_id number;
1170: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1171: l_object_version_number ben_benefit_actions.object_version_number%type;
1172: l_person_id per_people_f.person_id%type;
1173: l_person_action_id ben_person_actions.person_action_id%type;
1174: l_ler_id ben_ler_f.ler_id%type;
1175: l_range_id ben_batch_ranges.range_id%type;

Line 1327: ben_benefit_actions_api.create_benefit_actions

1323: -- we are doing a restart.
1324: --
1325: If p_benefit_action_id is null then
1326: --
1327: ben_benefit_actions_api.create_benefit_actions
1328: (p_validate => false
1329: ,p_benefit_action_id => l_benefit_action_id
1330: ,p_process_date => l_effective_date
1331: ,p_mode_cd => 'S'