DBA Data[Home] [Help]

APPS.BEN_MANAGE_OPEN_ENRT_WNDW dependencies on BEN_BENEFIT_ACTIONS

Line 128: From ben_benefit_actions ben

124: l_package varchar2(80);
125: --
126: Cursor c_parameter is
127: Select *
128: From ben_benefit_actions ben
129: Where ben.benefit_action_id = p_benefit_action_id;
130: --
131: l_parm c_parameter%rowtype;
132: --

Line 771: From ben_benefit_actions ben

767: ,bft_attribute4
768: ,bft_attribute5
769: ,bft_attribute6
770: ,bft_attribute7
771: From ben_benefit_actions ben
772: Where ben.benefit_action_id = p_benefit_action_id;
773: --
774: -- Local Variable declaration.
775: --

Line 969: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

965: -- local variable declaration.
966: --
967: l_request_id number;
968: l_proc varchar2(80) := g_package||'.process';
969: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
970: l_object_version_number ben_benefit_actions.object_version_number%type;
971: l_person_id per_people_f.person_id%type;
972: l_person_action_id ben_person_actions.person_action_id%type;
973: l_ler_id ben_ler_f.ler_id%type;

Line 970: l_object_version_number ben_benefit_actions.object_version_number%type;

966: --
967: l_request_id number;
968: l_proc varchar2(80) := g_package||'.process';
969: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
970: l_object_version_number ben_benefit_actions.object_version_number%type;
971: l_person_id per_people_f.person_id%type;
972: l_person_action_id ben_person_actions.person_action_id%type;
973: l_ler_id ben_ler_f.ler_id%type;
974: l_range_id ben_batch_ranges.range_id%type;

Line 1051: ben_benefit_actions_api.create_benefit_actions

1047: if g_debug then
1048: hr_utility.set_location (l_proc||' Create BFT ',30);
1049: end if;
1050: --
1051: ben_benefit_actions_api.create_benefit_actions
1052: (p_validate => false
1053: ,p_benefit_action_id => l_benefit_action_id
1054: ,p_process_date => l_effective_date
1055: ,p_mode_cd => 'S'