APPS.BEN_EXT_SMART_TOTAL dependencies on HR_LOOKUPS

Line 22: enabled_flag check for hr_lookups

18: 12/09/98 115.1 PDas Modified Calc_Smart_Total
19: Procedure
20: 12/28/98 115.2 PDas Added get_value procedure
21: 02/03/99 115.3 PDas Deleted date and
22: enabled_flag check for hr_lookups
23: 02/08/99 115.4 PDas Moved function get_value to benxutil.pkb
24: 02/10/99 115.5 PDas Modified Calc_Smart_Total
25: Procedure
26: - added p_frmt_mask_cd paramater

Line 130: l_frmt_mask_cd hr_lookups.lookup_code%type;

126: --
127: l_proc varchar2(72) := g_package||'.get_sum_params';
128: --
129: l_seq_num number(9);
130: l_frmt_mask_cd hr_lookups.lookup_code%type;
131: --
132: cursor sum_c is
133: SELECT c.seq_num,
134: d.frmt_mask_cd

Line 143: FROM hr_lookups

139: AND d.ext_data_elmt_id = c.ext_data_elmt_id;
140: --
141: cursor mask_c is
142: SELECT meaning
143: FROM hr_lookups
144: WHERE lookup_type = 'BEN_EXT_FRMT_MASK'
145: AND lookup_code = l_frmt_mask_cd;
146: --
147: Begin

Line 312: l_frmt_mask hr_lookups.meaning%TYPE; -- UTF8 varchar2(80);

308: l_cond_column varchar2(30);
309: --
310: l_sum_rcd_id number(15);
311: l_sum_column varchar2(30);
312: l_frmt_mask hr_lookups.meaning%TYPE; -- UTF8 varchar2(80);
313: l_sum_col_frmt_mask hr_lookups.meaning%TYPE; -- UTF8 varchar2(80);
314: l_smart_total varchar2(200);
315: --
316: l_where_string varchar2(2000);

Line 313: l_sum_col_frmt_mask hr_lookups.meaning%TYPE; -- UTF8 varchar2(80);

309: --
310: l_sum_rcd_id number(15);
311: l_sum_column varchar2(30);
312: l_frmt_mask hr_lookups.meaning%TYPE; -- UTF8 varchar2(80);
313: l_sum_col_frmt_mask hr_lookups.meaning%TYPE; -- UTF8 varchar2(80);
314: l_smart_total varchar2(200);
315: --
316: l_where_string varchar2(2000);
317: l_smart_ttl_string varchar2(2000);

Line 319: l_oper hr_lookups.meaning%type;

315: --
316: l_where_string varchar2(2000);
317: l_smart_ttl_string varchar2(2000);
318: l_ttl_cond_val varchar2(200);
319: l_oper hr_lookups.meaning%type;
320: --
321: cid integer;
322: res integer;
323: l_ext_rcd_id number;