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.GHR_FEHB_PLAN_DESIGN dependencies on BEN_LER_F

Line 11: l_ler_id ben_ler_f.ler_id%type;

7: g_package varchar2(100) := 'ghr_fehb_plan_design.';
8:
9: procedure create_sub_life_events(p_target_business_group_id in number)
10: is
11: l_ler_id ben_ler_f.ler_id%type;
12: l_effective_start_date ben_ler_f.effective_start_date%type;
13: l_effective_end_date ben_ler_f.effective_end_date%type;
14: l_object_version_number ben_ler_f.object_version_number%type;
15: l_ler_name ben_ler_f.name%type;

Line 12: l_effective_start_date ben_ler_f.effective_start_date%type;

8:
9: procedure create_sub_life_events(p_target_business_group_id in number)
10: is
11: l_ler_id ben_ler_f.ler_id%type;
12: l_effective_start_date ben_ler_f.effective_start_date%type;
13: l_effective_end_date ben_ler_f.effective_end_date%type;
14: l_object_version_number ben_ler_f.object_version_number%type;
15: l_ler_name ben_ler_f.name%type;
16: l_ler_short_code ben_ler_f.short_code%type;

Line 13: l_effective_end_date ben_ler_f.effective_end_date%type;

9: procedure create_sub_life_events(p_target_business_group_id in number)
10: is
11: l_ler_id ben_ler_f.ler_id%type;
12: l_effective_start_date ben_ler_f.effective_start_date%type;
13: l_effective_end_date ben_ler_f.effective_end_date%type;
14: l_object_version_number ben_ler_f.object_version_number%type;
15: l_ler_name ben_ler_f.name%type;
16: l_ler_short_code ben_ler_f.short_code%type;
17: l_target_business_group_id number := 1503;

Line 14: l_object_version_number ben_ler_f.object_version_number%type;

10: is
11: l_ler_id ben_ler_f.ler_id%type;
12: l_effective_start_date ben_ler_f.effective_start_date%type;
13: l_effective_end_date ben_ler_f.effective_end_date%type;
14: l_object_version_number ben_ler_f.object_version_number%type;
15: l_ler_name ben_ler_f.name%type;
16: l_ler_short_code ben_ler_f.short_code%type;
17: l_target_business_group_id number := 1503;
18: l_exists Varchar2(1);

Line 15: l_ler_name ben_ler_f.name%type;

11: l_ler_id ben_ler_f.ler_id%type;
12: l_effective_start_date ben_ler_f.effective_start_date%type;
13: l_effective_end_date ben_ler_f.effective_end_date%type;
14: l_object_version_number ben_ler_f.object_version_number%type;
15: l_ler_name ben_ler_f.name%type;
16: l_ler_short_code ben_ler_f.short_code%type;
17: l_target_business_group_id number := 1503;
18: l_exists Varchar2(1);
19:

Line 16: l_ler_short_code ben_ler_f.short_code%type;

12: l_effective_start_date ben_ler_f.effective_start_date%type;
13: l_effective_end_date ben_ler_f.effective_end_date%type;
14: l_object_version_number ben_ler_f.object_version_number%type;
15: l_ler_name ben_ler_f.name%type;
16: l_ler_short_code ben_ler_f.short_code%type;
17: l_target_business_group_id number := 1503;
18: l_exists Varchar2(1);
19:
20: Cursor check_if_ler_exists is

Line 22: from ben_ler_f

18: l_exists Varchar2(1);
19:
20: Cursor check_if_ler_exists is
21: select 'Y'
22: from ben_ler_f
23: where name = l_ler_name
24: and business_group_id = p_target_business_group_id;
25: Begin
26: for i in 1..3 Loop

Line 66: l_le_name BEN_LER_F.name%type;

62: l_formula_name ff_formulas_f.formula_name%type;
63: l_pt_name BEN_PER_INFO_CHG_CS_LER_F.name%type;
64: l_source_table BEN_PER_INFO_CHG_CS_LER_F.source_table%type;
65: l_source_column BEN_PER_INFO_CHG_CS_LER_F.source_column%type;
66: l_le_name BEN_LER_F.name%type;
67:
68:
69: cursor c_get_ler_id is
70: select ler_id,effective_start_date from ben_ler_f

Line 70: select ler_id,effective_start_date from ben_ler_f

66: l_le_name BEN_LER_F.name%type;
67:
68:
69: cursor c_get_ler_id is
70: select ler_id,effective_start_date from ben_ler_f
71: where name = l_le_name
72: and business_group_id = p_target_business_group_id;
73:
74: l_proc varchar2(100) := 'create_person_type_usages';

Line 81: l_ler_id ben_ler_f.ler_id%type;

77: l_clpse_lf_evt_id ben_clpse_lf_evt_f.clpse_lf_evt_id%type;
78: l_esd date := to_date('1951/01/01','yyyy/mm/dd');
79: l_eed date := to_date('4712/12/31','yyyy/mm/dd');
80: l_ovn number;
81: l_ler_id ben_ler_f.ler_id%type;
82: l_ler_id1 ben_ler_f.ler_id%type;
83: l_ler_id2 ben_ler_f.ler_id%type;
84: l_ler_id3 ben_ler_f.ler_id%type;
85: l_effective_date date;

Line 82: l_ler_id1 ben_ler_f.ler_id%type;

78: l_esd date := to_date('1951/01/01','yyyy/mm/dd');
79: l_eed date := to_date('4712/12/31','yyyy/mm/dd');
80: l_ovn number;
81: l_ler_id ben_ler_f.ler_id%type;
82: l_ler_id1 ben_ler_f.ler_id%type;
83: l_ler_id2 ben_ler_f.ler_id%type;
84: l_ler_id3 ben_ler_f.ler_id%type;
85: l_effective_date date;
86:

Line 83: l_ler_id2 ben_ler_f.ler_id%type;

79: l_eed date := to_date('4712/12/31','yyyy/mm/dd');
80: l_ovn number;
81: l_ler_id ben_ler_f.ler_id%type;
82: l_ler_id1 ben_ler_f.ler_id%type;
83: l_ler_id2 ben_ler_f.ler_id%type;
84: l_ler_id3 ben_ler_f.ler_id%type;
85: l_effective_date date;
86:
87:

Line 84: l_ler_id3 ben_ler_f.ler_id%type;

80: l_ovn number;
81: l_ler_id ben_ler_f.ler_id%type;
82: l_ler_id1 ben_ler_f.ler_id%type;
83: l_ler_id2 ben_ler_f.ler_id%type;
84: l_ler_id3 ben_ler_f.ler_id%type;
85: l_effective_date date;
86:
87:
88: cursor c_get_ff_id is

Line 389: l_ler_id ben_ler_f.ler_id%type;

385: l_clpse_lf_evt_id ben_clpse_lf_evt_f.clpse_lf_evt_id%type;
386: l_esd date := to_date('1951/01/01','yyyy/mm/dd');
387: l_eed date := to_date('4712/12/31','yyyy/mm/dd');
388: l_ovn number;
389: l_ler_id ben_ler_f.ler_id%type;
390: l_ler_id1 ben_ler_f.ler_id%type;
391: l_ler_id2 ben_ler_f.ler_id%type;
392: l_ler_id3 ben_ler_f.ler_id%type;
393: l_effective_date date;

Line 390: l_ler_id1 ben_ler_f.ler_id%type;

386: l_esd date := to_date('1951/01/01','yyyy/mm/dd');
387: l_eed date := to_date('4712/12/31','yyyy/mm/dd');
388: l_ovn number;
389: l_ler_id ben_ler_f.ler_id%type;
390: l_ler_id1 ben_ler_f.ler_id%type;
391: l_ler_id2 ben_ler_f.ler_id%type;
392: l_ler_id3 ben_ler_f.ler_id%type;
393: l_effective_date date;
394: l_le_name BEN_LER_F.name%type;

Line 391: l_ler_id2 ben_ler_f.ler_id%type;

387: l_eed date := to_date('4712/12/31','yyyy/mm/dd');
388: l_ovn number;
389: l_ler_id ben_ler_f.ler_id%type;
390: l_ler_id1 ben_ler_f.ler_id%type;
391: l_ler_id2 ben_ler_f.ler_id%type;
392: l_ler_id3 ben_ler_f.ler_id%type;
393: l_effective_date date;
394: l_le_name BEN_LER_F.name%type;
395: l_ctr number;

Line 392: l_ler_id3 ben_ler_f.ler_id%type;

388: l_ovn number;
389: l_ler_id ben_ler_f.ler_id%type;
390: l_ler_id1 ben_ler_f.ler_id%type;
391: l_ler_id2 ben_ler_f.ler_id%type;
392: l_ler_id3 ben_ler_f.ler_id%type;
393: l_effective_date date;
394: l_le_name BEN_LER_F.name%type;
395: l_ctr number;
396: l_proc varchar2(100) := 'create_collapse_rule';

Line 394: l_le_name BEN_LER_F.name%type;

390: l_ler_id1 ben_ler_f.ler_id%type;
391: l_ler_id2 ben_ler_f.ler_id%type;
392: l_ler_id3 ben_ler_f.ler_id%type;
393: l_effective_date date;
394: l_le_name BEN_LER_F.name%type;
395: l_ctr number;
396: l_proc varchar2(100) := 'create_collapse_rule';
397: l_seq ben_clpse_lf_evt_f.seq%type;
398: -- Check whether an existing Collapsing rule is there between

Line 415: select ler_id,effective_start_date from ben_ler_f

411: from ben_clpse_lf_evt_f clp
412: where clp.business_group_id = p_target_business_group_id;
413:
414: cursor c_chk_ler is
415: select ler_id,effective_start_date from ben_ler_f
416: where name = l_le_name
417: and business_group_id = p_target_business_group_id;
418: begin
419: hr_utility.set_location('Entering: '|| g_package||l_proc, 5);