DBA Data[Home] [Help]

APPS.BEN_BENXLAYT_XMLP_PKG dependencies on HR_LOOKUPS

Line 7: FROM hr_lookups

3:
4: function commentsformula(total_function in varchar2, data_element_type in varchar2, string_value in varchar2, condition_data_element in number, ext_data_element in number, sum_data_element in number) return varchar2 is
5: cursor get_function is
6: SELECT meaning
7: FROM hr_lookups
8: WHERE lookup_code = total_function
9: AND lookup_type = 'BEN_EXT_TTL_FNCTN';
10: l_function hr_lookups.meaning%type;
11:

Line 10: l_function hr_lookups.meaning%type;

6: SELECT meaning
7: FROM hr_lookups
8: WHERE lookup_code = total_function
9: AND lookup_type = 'BEN_EXT_TTL_FNCTN';
10: l_function hr_lookups.meaning%type;
11:
12: l_operator hr_lookups.meaning%type;
13: cursor get_data_element
14: (p_ext_data_elmt_id number) is

Line 12: l_operator hr_lookups.meaning%type;

8: WHERE lookup_code = total_function
9: AND lookup_type = 'BEN_EXT_TTL_FNCTN';
10: l_function hr_lookups.meaning%type;
11:
12: l_operator hr_lookups.meaning%type;
13: cursor get_data_element
14: (p_ext_data_elmt_id number) is
15: SELECT name
16: FROM ben_ext_data_elmt