Line 229: FND_USER FU, FND_USER_RESP_GROUPS FURG WHERE
225:
226: IF (l_employee_id IS NOT NULL) THEN
227: BEGIN
228: select PROFILE_OPTION_VALUE INTO l_notify FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO, 229: FND_USER FU, FND_USER_RESP_GROUPS FURG WHERE 230: fu.employee_id = l_employee_id
231: and fu.user_id = furg.user_id
232: and fpo.profile_option_name = 'SSE_CC_PAYMENT_NOTIFY'
233: and fpov.profile_option_id = fpo.profile_option_id