DBA Data[Home] [Help]

APPS.BEN_CWB_AUDIT_API dependencies on BEN_CWB_UTILS

Line 151: select DECODE (ben_cwb_utils.get_profile ('BEN_DISPLAY_EMPLOYEE_NAME'),

147:
148: if(ben_cwb_audit_api.return_lookup_validity('MG')=true) then
149:
150: begin
151: select DECODE (ben_cwb_utils.get_profile ('BEN_DISPLAY_EMPLOYEE_NAME'),
152: 'BN', empinfo.brief_name,
153: 'CN', empinfo.custom_name,
154: empinfo.full_name
155: )

Line 165: select DECODE (ben_cwb_utils.get_profile ('BEN_DISPLAY_EMPLOYEE_NAME'),

161: l_old_ws_mgr_name := p_per_record_old.ws_mgr_id;
162: end;
163:
164: begin
165: select DECODE (ben_cwb_utils.get_profile ('BEN_DISPLAY_EMPLOYEE_NAME'),
166: 'BN', empinfo.brief_name,
167: 'CN', empinfo.custom_name,
168: empinfo.full_name
169: )

Line 353: (ben_cwb_utils.get_profile ('BEN_DISPLAY_EMPLOYEE_NAME'),

349:
350: begin
351:
352: select distinct ppf.person_id, DECODE
353: (ben_cwb_utils.get_profile ('BEN_DISPLAY_EMPLOYEE_NAME'),
354: 'BN', trim(ppf.first_name ||' '||ppf.last_name||' '||ppf.suffix),
355: 'CN', nvl(ben_cwb_custom_person_pkg.get_custom_name
356: (ppf.person_id
357: ,pil.assignment_id

Line 386: (ben_cwb_utils.get_profile ('BEN_DISPLAY_EMPLOYEE_NAME'),

382:
383: begin
384:
385: select distinct ppf.person_id, DECODE
386: (ben_cwb_utils.get_profile ('BEN_DISPLAY_EMPLOYEE_NAME'),
387: 'BN', trim(ppf.first_name ||' '||ppf.last_name||' '||ppf.suffix),
388: 'CN', nvl(ben_cwb_custom_person_pkg.get_custom_name
389: (ppf.person_id
390: ,pil.assignment_id