APPS.BEN_BENXLAYT_XMLP_PKG dependencies on HR_GENERAL

Line 49: l_where_clause := l_where_clause || l_cond_data_elmt || ' ' || hr_general.decode_lookup('BEN_EXT_OPER',where_clause.oper_cd)

45: open get_data_element(where_clause.cond_ext_data_elmt_id);
46: fetch get_data_element into l_cond_data_elmt;
47: close get_data_element;
48: l_where_flag := TRUE ;
49: l_where_clause := l_where_clause || l_cond_data_elmt || ' ' || hr_general.decode_lookup('BEN_EXT_OPER',where_clause.oper_cd)
50: || ' ' || where_clause.val || ' ' || hr_general.decode_lookup('BEN_EXT_AND_OR',where_clause.and_or_cd)
51: || fnd_global.local_chr(10);
52: END LOOP;
53:

Line 50: || ' ' || where_clause.val || ' ' || hr_general.decode_lookup('BEN_EXT_AND_OR',where_clause.and_or_cd)

46: fetch get_data_element into l_cond_data_elmt;
47: close get_data_element;
48: l_where_flag := TRUE ;
49: l_where_clause := l_where_clause || l_cond_data_elmt || ' ' || hr_general.decode_lookup('BEN_EXT_OPER',where_clause.oper_cd)
50: || ' ' || where_clause.val || ' ' || hr_general.decode_lookup('BEN_EXT_AND_OR',where_clause.and_or_cd)
51: || fnd_global.local_chr(10);
52: END LOOP;
53:
54: if l_where_flag then

Line 71: l_where_clause := l_where_clause || l_cond_data_elmt || ' ' || hr_general.decode_lookup('BEN_EXT_OPER',where_clause.oper_cd)

67: open get_data_element(where_clause.cond_ext_data_elmt_id);
68: fetch get_data_element into l_cond_data_elmt;
69: close get_data_element;
70: l_where_flag := TRUE ;
71: l_where_clause := l_where_clause || l_cond_data_elmt || ' ' || hr_general.decode_lookup('BEN_EXT_OPER',where_clause.oper_cd)
72: || ' ' || where_clause.val || ' ' || hr_general.decode_lookup('BEN_EXT_AND_OR',where_clause.and_or_cd)
73: || fnd_global.local_chr(10);
74: END LOOP;
75:

Line 72: || ' ' || where_clause.val || ' ' || hr_general.decode_lookup('BEN_EXT_AND_OR',where_clause.and_or_cd)

68: fetch get_data_element into l_cond_data_elmt;
69: close get_data_element;
70: l_where_flag := TRUE ;
71: l_where_clause := l_where_clause || l_cond_data_elmt || ' ' || hr_general.decode_lookup('BEN_EXT_OPER',where_clause.oper_cd)
72: || ' ' || where_clause.val || ' ' || hr_general.decode_lookup('BEN_EXT_AND_OR',where_clause.and_or_cd)
73: || fnd_global.local_chr(10);
74: END LOOP;
75:
76: if l_where_flag then