APPS.OKS_WF_K_PROCESS_PVT dependencies on FND_USER

Line 414: FROM fnd_user fndu

410: l_api_name CONSTANT VARCHAR2(50) := 'is_template_defined';
411:
412: CURSOR l_acceptedby_csr(p_user_id NUMBER) IS
413: SELECT user_name
414: FROM fnd_user fndu
415: WHERE fndu.user_id = p_user_id;
416:
417: CURSOR l_party_csr(p_chr_id NUMBER) IS
418: SELECT b.party_name

Line 1381: -- Get quote To contact fnd user name

1377: SELECT source_name
1378: FROM jtf_rs_resource_extns
1379: WHERE user_name = p_user_name;
1380:
1381: -- Get quote To contact fnd user name
1382: CURSOR l_qto_name_csr(p_chr_id NUMBER) IS
1383: SELECT fu.user_name
1384: FROM oks_k_headers_b ks, fnd_user fu
1385: WHERE ks.chr_id = p_chr_id

Line 1384: FROM oks_k_headers_b ks, fnd_user fu

1380:
1381: -- Get quote To contact fnd user name
1382: CURSOR l_qto_name_csr(p_chr_id NUMBER) IS
1383: SELECT fu.user_name
1384: FROM oks_k_headers_b ks, fnd_user fu
1385: WHERE ks.chr_id = p_chr_id
1386: AND fu.person_party_id = ks.person_party_id;
1387:
1388: -- Get quote To contact name

Line 1960: FROM fnd_user fndu

1956: WHERE user_id = p_user_id;
1957:
1958: CURSOR l_acceptedby_csr(p_user_id NUMBER) IS
1959: SELECT user_name
1960: FROM fnd_user fndu
1961: WHERE fndu.user_id = p_user_id;
1962:
1963: CURSOR l_party_csr(p_chr_id NUMBER) IS
1964: SELECT b.party_name

Line 3136: -- Ignore the p_to_email value and get the salesrep email and FND username again

3132: p_item_type => G_ITEM_TYPE,
3133: p_item_key => l_item_key,
3134: p_activity_name => G_CUST_ACTION ) THEN
3135:
3136: -- Ignore the p_to_email value and get the salesrep email and FND username again
3137: -- Due to big impact of changing the signature we r taking this route
3138: -- This changes are done due to the requirement to send notification to Salesrep
3139: -- and an email to cc'ed guys
3140: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4152: select user_id from fnd_user

4148:
4149: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NTF_TYPE');
4150: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'PERFORMER');
4151: cursor c1(p_name varchar2) is
4152: select user_id from fnd_user
4153: where user_name=p_name;
4154: l_user_id number;
4155: l_p_value varchar2(3);
4156:

Line 5022: FROM oks_k_headers_b oksh, fnd_user fndu

5018: l_api_name CONSTANT VARCHAR2(30) := 'get_old_wf_status';
5019:
5020: CURSOR l_rru_csr(p_chr_id NUMBER) IS
5021: SELECT oksh.renewal_type_used, fndu.user_name
5022: FROM oks_k_headers_b oksh, fnd_user fndu
5023: WHERE oksh.chr_id = p_chr_id
5024: AND oksh.renewal_notification_to = fndu.user_id(+);
5025:
5026: CURSOR l_user_dtls_csr(p_chr_id NUMBER) IS