eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_FORFEITURE_CONCURRENT dependencies on BEN_BENEFIT_ACTIONS

Line 981: From ben_benefit_actions ben

977: Order by ben.person_action_id
978: ;
979: Cursor c_parameter is
980: Select *
981: From ben_benefit_actions ben
982: Where ben.benefit_action_id = p_benefit_action_id
983: ;
984: l_parm c_parameter%rowtype;
985: l_ovn number := null;

Line 1269: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

1265: --
1266: l_effective_date date;
1267: l_request_id number;
1268: l_proc varchar2(80) := g_package||'.process_by_plan';
1269: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1270: l_object_version_number ben_benefit_actions.object_version_number%type;
1271: l_person_action_id ben_person_actions.person_action_id%type;
1272: l_ler_id ben_ler_f.ler_id%type;
1273: l_range_id ben_batch_ranges.range_id%type;

Line 1270: l_object_version_number ben_benefit_actions.object_version_number%type;

1266: l_effective_date date;
1267: l_request_id number;
1268: l_proc varchar2(80) := g_package||'.process_by_plan';
1269: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1270: l_object_version_number ben_benefit_actions.object_version_number%type;
1271: l_person_action_id ben_person_actions.person_action_id%type;
1272: l_ler_id ben_ler_f.ler_id%type;
1273: l_range_id ben_batch_ranges.range_id%type;
1274: l_start_person_action_id number := 0;

Line 1633: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;

1629: -- local variable declaration.
1630: --
1631: l_request_id number;
1632: l_proc varchar2(80) := g_package||'.process';
1633: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1634: l_object_version_number ben_benefit_actions.object_version_number%type;
1635: l_person_id per_people_f.person_id%type;
1636: l_person_action_id ben_person_actions.person_action_id%type;
1637: l_ler_id ben_ler_f.ler_id%type;

Line 1634: l_object_version_number ben_benefit_actions.object_version_number%type;

1630: --
1631: l_request_id number;
1632: l_proc varchar2(80) := g_package||'.process';
1633: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
1634: l_object_version_number ben_benefit_actions.object_version_number%type;
1635: l_person_id per_people_f.person_id%type;
1636: l_person_action_id ben_person_actions.person_action_id%type;
1637: l_ler_id ben_ler_f.ler_id%type;
1638: l_range_id ben_batch_ranges.range_id%type;

Line 1718: ben_benefit_actions_api.create_benefit_actions

1714:
1715: hr_utility.set_location('p_benefit_action_id is null',14);
1716: l_restart := FALSE;
1717:
1718: ben_benefit_actions_api.create_benefit_actions
1719: (p_validate => false
1720: ,p_benefit_action_id => l_benefit_action_id
1721: ,p_process_date => l_effective_date
1722: ,p_mode_cd => 'S'