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_PREMIUM_PLAN_CONCURRENT dependencies on BEN_PERSON_ACTIONS

Line 54: l_person_id ben_person_actions.person_id%type;

50: --
51: -- Local variable declaration
52: --
53: l_proc varchar2(80) := g_package||'.do_multithread';
54: l_person_id ben_person_actions.person_id%type;
55: l_person_action_id ben_person_actions.person_action_id%type;
56: l_object_version_number ben_person_actions.object_version_number%type;
57: l_ler_id ben_person_actions.ler_id%type;
58: l_range_id ben_batch_ranges.range_id%type;

Line 55: l_person_action_id ben_person_actions.person_action_id%type;

51: -- Local variable declaration
52: --
53: l_proc varchar2(80) := g_package||'.do_multithread';
54: l_person_id ben_person_actions.person_id%type;
55: l_person_action_id ben_person_actions.person_action_id%type;
56: l_object_version_number ben_person_actions.object_version_number%type;
57: l_ler_id ben_person_actions.ler_id%type;
58: l_range_id ben_batch_ranges.range_id%type;
59: l_record_number number := 0;

Line 56: l_object_version_number ben_person_actions.object_version_number%type;

52: --
53: l_proc varchar2(80) := g_package||'.do_multithread';
54: l_person_id ben_person_actions.person_id%type;
55: l_person_action_id ben_person_actions.person_action_id%type;
56: l_object_version_number ben_person_actions.object_version_number%type;
57: l_ler_id ben_person_actions.ler_id%type;
58: l_range_id ben_batch_ranges.range_id%type;
59: l_record_number number := 0;
60: l_start_person_action_id number := 0;

Line 57: l_ler_id ben_person_actions.ler_id%type;

53: l_proc varchar2(80) := g_package||'.do_multithread';
54: l_person_id ben_person_actions.person_id%type;
55: l_person_action_id ben_person_actions.person_action_id%type;
56: l_object_version_number ben_person_actions.object_version_number%type;
57: l_ler_id ben_person_actions.ler_id%type;
58: l_range_id ben_batch_ranges.range_id%type;
59: l_record_number number := 0;
60: l_start_person_action_id number := 0;
61: l_end_person_action_id number := 0;

Line 86: From ben_person_actions ben

82: Select ben.person_id
83: ,ben.person_action_id
84: ,ben.object_version_number
85: ,ben.ler_id
86: From ben_person_actions ben
87: Where ben.benefit_action_id = p_benefit_action_id
88: And ben.action_status_cd <> 'P'
89: And ben.person_action_id between
90: l_start_person_action_id and l_end_person_action_id

Line 346: l_person_action_id ben_person_actions.person_action_id%type;

342: l_request_id number;
343: l_proc varchar2(80) := g_package||'.process';
344: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
345: l_object_version_number ben_benefit_actions.object_version_number%type;
346: l_person_action_id ben_person_actions.person_action_id%type;
347: l_ler_id ben_ler_f.ler_id%type;
348: l_range_id ben_batch_ranges.range_id%type;
349: l_start_person_action_id number := 0;
350: l_end_person_action_id number := 0;

Line 457: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);

453: --
454: -- Store actl_prem_id into person actions table.
455: --
456: If ( not skip) then
457: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);
458: l_actn := 'Inserting Ben_person_actions...';
459: select ben_person_actions_s.nextval
460: into l_person_action_id
461: from sys.dual;

Line 458: l_actn := 'Inserting Ben_person_actions...';

454: -- Store actl_prem_id into person actions table.
455: --
456: If ( not skip) then
457: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);
458: l_actn := 'Inserting Ben_person_actions...';
459: select ben_person_actions_s.nextval
460: into l_person_action_id
461: from sys.dual;
462:

Line 459: select ben_person_actions_s.nextval

455: --
456: If ( not skip) then
457: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);
458: l_actn := 'Inserting Ben_person_actions...';
459: select ben_person_actions_s.nextval
460: into l_person_action_id
461: from sys.dual;
462:
463: insert into ben_person_actions

Line 463: insert into ben_person_actions

459: select ben_person_actions_s.nextval
460: into l_person_action_id
461: from sys.dual;
462:
463: insert into ben_person_actions
464: (person_action_id,
465: person_id,
466: ler_id,
467: benefit_action_id,