DBA Data[Home] [Help]

APPS.BEN_CWB_BACK_OUT_CONC dependencies on BEN_BENEFIT_ACTIONS

Line 550: From ben_benefit_actions ben

546: ,debug_messages_flag
547: ,date_from
548: ,ptnl_ler_for_per_stat_cd
549: ,pl_id
550: From ben_benefit_actions ben
551: Where ben.benefit_action_id = p_benefit_action_id;
552: --
553: -- Local Variable declaration.
554: --

Line 689: From ben_benefit_actions ben

685: l_ler_thread c_ler_thread%rowtype;
686: --
687: Cursor c_parameter is
688: Select *
689: From ben_benefit_actions ben
690: Where ben.benefit_action_id = p_benefit_action_id;
691: --
692: l_parm c_parameter%rowtype;
693: --

Line 1094: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

1090:
1091: /* local variable defintions */
1092: l_proc varchar2(80) := g_package||'.process';
1093: l_request_id number;
1094: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1095: l_object_version_number ben_benefit_actions.object_version_number%type;
1096: l_person_id per_people_f.person_id%type;
1097: l_person_action_id ben_person_actions.person_action_id%type;
1098: l_ler_id ben_ler_f.ler_id%type;

Line 1095: l_object_version_number ben_benefit_actions.object_version_number%type;

1091: /* local variable defintions */
1092: l_proc varchar2(80) := g_package||'.process';
1093: l_request_id number;
1094: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1095: l_object_version_number ben_benefit_actions.object_version_number%type;
1096: l_person_id per_people_f.person_id%type;
1097: l_person_action_id ben_person_actions.person_action_id%type;
1098: l_ler_id ben_ler_f.ler_id%type;
1099: l_range_id ben_batch_ranges.range_id%type;

Line 1247: ben_benefit_actions_api.create_benefit_actions

1243: -- we are doing a restart.
1244: --
1245: If p_benefit_action_id is null then
1246: --
1247: ben_benefit_actions_api.create_benefit_actions
1248: (p_validate => false
1249: ,p_benefit_action_id => l_benefit_action_id
1250: ,p_process_date => l_effective_date
1251: ,p_mode_cd => 'S'