DBA Data[Home] [Help]

APPS.BEN_LRI_BUS dependencies on BEN_LER_INFO_TYPES

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

39: -- {Start Of Comments}
40: --
41: -- Description:
42: -- Validates that the ler information type exists in table
43: -- ben_ler_info_types where active_inactive_flag is 'Y'.
44: --
45: -- Pre Conditions:
46: -- Data must be existed in table ben_ler_info_types.
47: --

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

42: -- Validates that the ler information type exists in table
43: -- ben_ler_info_types where active_inactive_flag is 'Y'.
44: --
45: -- Pre Conditions:
46: -- Data must be existed in table ben_ler_info_types.
47: --
48: -- In Parameters:
49: -- p_information_type
50: --

Line 69: p_information_type in ben_ler_info_types.information_type%type

65: -- {End Of Comments}
66: -- ----------------------------------------------------------------------------
67: Procedure chk_ler_info_type
68: (
69: p_information_type in ben_ler_info_types.information_type%type
70: );
71: -- ----------------------------------------------------------------------------
72: -- |---------------------------< Chk_ler_id >----------------------------|
73: -- ----------------------------------------------------------------------------