DBA Data[Home] [Help]

APPS.BEN_CWB_MASS_NOTIFN_PKG dependencies on BEN_CWB_UTILS

Line 92: SELECT DISTINCT max(DECODE (ben_cwb_utils.get_profile ('BEN_DISPLAY_EMPLOYEE_NAME'),

88: , v_target_pop IN VARCHAR2
89: , v_req_acc_lvl IN VARCHAR2
90: )
91: IS
92: SELECT DISTINCT max(DECODE (ben_cwb_utils.get_profile ('BEN_DISPLAY_EMPLOYEE_NAME'),
93: 'BN', per.brief_name,
94: 'CN', per.custom_name,
95: per.full_name)) full_name
96: ,max(bg.name)