APPS.BEN_LRI_BUS dependencies on BEN_LER_INFO_TYPES

Line 106: -- ben_ler_info_types where active_inactive_flag is 'Y'.

102: -- {Start Of Comments}
103: --
104: -- Description:
105: -- Validates that the ler information type exists in table
106: -- ben_ler_info_types where active_inactive_flag is 'Y'.
107: --
108: -- Pre Conditions:
109: -- Data must be existed in table ben_ler_info_types.
110: --

Line 109: -- Data must be existed in table ben_ler_info_types.

105: -- Validates that the ler information type exists in table
106: -- ben_ler_info_types where active_inactive_flag is 'Y'.
107: --
108: -- Pre Conditions:
109: -- Data must be existed in table ben_ler_info_types.
110: --
111: -- In Parameters:
112: -- p_information_type
113: --

Line 132: (p_information_type in ben_ler_info_types.information_type%type

128: -- {End Of Comments}
129: -- ----------------------------------------------------------------------------
130:
131: Procedure chk_ler_info_type
132: (p_information_type in ben_ler_info_types.information_type%type
133: ) is
134: --
135: l_proc varchar2(72) := g_package||'chk_ler_info_type';
136: l_flag ben_ler_info_types.active_inactive_flag%type;

Line 136: l_flag ben_ler_info_types.active_inactive_flag%type;

132: (p_information_type in ben_ler_info_types.information_type%type
133: ) is
134: --
135: l_proc varchar2(72) := g_package||'chk_ler_info_type';
136: l_flag ben_ler_info_types.active_inactive_flag%type;
137: --
138: cursor c_ler_info_type (code varchar2) is
139: select ler.active_inactive_flag
140: from ben_ler_info_types ler

Line 140: from ben_ler_info_types ler

136: l_flag ben_ler_info_types.active_inactive_flag%type;
137: --
138: cursor c_ler_info_type (code varchar2) is
139: select ler.active_inactive_flag
140: from ben_ler_info_types ler
141: where ler.information_type = code;
142: --
143: Begin
144: hr_utility.set_location('Entering:'||l_proc, 1);

Line 291: l_multi_occur_flag ben_ler_info_types.multiple_occurences_flag%type;

287: ,p_ler_id in ben_ler_extra_info.ler_id%type
288: ) is
289: --
290: l_proc varchar2(72) := g_package||'chk_multiple_occurences_flag';
291: l_multi_occur_flag ben_ler_info_types.multiple_occurences_flag%type;
292: l_dummy varchar2(1);
293: l_found_ler boolean;
294: --
295: cursor c_multi_occur_flag (code varchar2) is

Line 297: from ben_ler_info_types

293: l_found_ler boolean;
294: --
295: cursor c_multi_occur_flag (code varchar2) is
296: select multiple_occurences_flag
297: from ben_ler_info_types
298: where information_type = code;
299: --
300: cursor c_get_row (code varchar2, id number) is
301: select 'x'