24: -- changed to go of users directly JEG 11/30/2000
25: --
26: cursor nls_csr is
27: select
28: NVL(wf_pref.get_pref(USR.USER_NAME, 'LANGUAGE'), FNDL.NLS_LANGUAGE) language,
29: NVL(wf_pref.get_pref(USR.USER_NAME, 'TERRITORY'), FNDL.NLS_TERRITORY) territory,
30: NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')
31: notification_preference
32: from fnd_languages fndl,
25: --
26: cursor nls_csr is
27: select
28: NVL(wf_pref.get_pref(USR.USER_NAME, 'LANGUAGE'), FNDL.NLS_LANGUAGE) language,
29: NVL(wf_pref.get_pref(USR.USER_NAME, 'TERRITORY'), FNDL.NLS_TERRITORY) territory,
30: NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')
31: notification_preference
32: from fnd_languages fndl,
33: fnd_user usr
26: cursor nls_csr is
27: select
28: NVL(wf_pref.get_pref(USR.USER_NAME, 'LANGUAGE'), FNDL.NLS_LANGUAGE) language,
29: NVL(wf_pref.get_pref(USR.USER_NAME, 'TERRITORY'), FNDL.NLS_TERRITORY) territory,
30: NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')
31: notification_preference
32: from fnd_languages fndl,
33: fnd_user usr
34: where usr.user_name = p_recipient
1041: -- changed to go of users directly JEG 11/30/2000
1042: --
1043: cursor pref_csr is
1044: select
1045: NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')
1046: notification_preference
1047: from fnd_user usr
1048: where usr.user_name = p_recipient;
1049: