APPS.BEN_BENLESUM_XMLP_PKG dependencies on HR_GENERAL

Line 25: select hr_general.decode_organization(p_organization_id),hr_general.decode_location(p_location_id),hr_general.decode_organization(p_business_group_id) from dual;

21: cursor c_ler_type is
22: Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_LER_TYPE' and lookup_code = p_ler_type;
23:
24: cursor c_BG_info is
25: select hr_general.decode_organization(p_organization_id),hr_general.decode_location(p_location_id),hr_general.decode_organization(p_business_group_id) from dual;
26:
27: cursor c_benefit_group_name is
28: Select name from BEN_BENFTS_GRP where benfts_grp_id=p_benefit_group_id and business_group_id=p_business_group_id;
29:

Line 273: p_user_sort:=hr_general.decode_lookup('BEN_LESUM_SORT_ORDR', 'PERNAME');

269:
270: if p_sort is null then
271: p_sort :=' order by '||' PERNAME';
272: p_sort1 :=' order by '||' PERNAME'; --Added during DT Fixes
273: p_user_sort:=hr_general.decode_lookup('BEN_LESUM_SORT_ORDR', 'PERNAME');
274: else
275: p_sort:=' order by '||p_sort;
276: p_sort1:=' order by '||p_sort1; --Added during DT Fixes
277: end if;

Line 293: p_user_sort:=p_user_sort||' , '||hr_general.decode_lookup('BEN_LESUM_SORT_ORDR',colname);

289: BEGIN
290:
291: if colname is not null and p_sort is not null then
292: p_sort :=p_sort||' , '||colname;
293: p_user_sort:=p_user_sort||' , '||hr_general.decode_lookup('BEN_LESUM_SORT_ORDR',colname);
294: --Added for DT Fixes
295: p_sort1 :=p_sort1||' , '||colname||'1';
296: p_sort_dff2 := p_sort_dff2||' , '||colname||'2';
297: p_sort_dff3 := p_sort_dff3||' , '||colname||'3';

Line 306: p_user_sort:=hr_general.decode_lookup('BEN_LESUM_SORT_ORDR',colname);

302: p_sort1 :=colname||'1';
303: p_sort_dff2 :=colname||'2';
304: p_sort_dff3 :=colname||'3';
305: --End of add during DT Fixes
306: p_user_sort:=hr_general.decode_lookup('BEN_LESUM_SORT_ORDR',colname);
307: end if;
308: END;
309:
310: FUNCTION FIND_COL(col_name varchar2) RETURN varchar2 IS