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 3252: -- Ignore the p_to_email value and get the salesrep email and FND username again

3248: p_item_type => G_ITEM_TYPE,
3249: p_item_key => l_item_key,
3250: p_activity_name => G_CUST_ACTION ) THEN
3251:
3252: -- Ignore the p_to_email value and get the salesrep email and FND username again
3253: -- Due to big impact of changing the signature we r taking this route
3254: -- This changes are done due to the requirement to send notification to Salesrep
3255: -- and an email to cc'ed guys
3256: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 4270: select user_id from fnd_user

4266:
4267: l_ntf_type varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'NTF_TYPE');
4268: l_user_name varchar2(100) := wf_engine.GetItemAttrText(itemtype,itemkey,'PERFORMER');
4269: cursor c1(p_name varchar2) is
4270: select user_id from fnd_user
4271: where user_name=p_name;
4272: l_user_id number;
4273: l_p_value varchar2(3);
4274:

Line 5188: FROM oks_k_headers_b oksh, fnd_user fndu

5184: l_api_name CONSTANT VARCHAR2(30) := 'get_old_wf_status';
5185:
5186: CURSOR l_rru_csr(p_chr_id NUMBER) IS
5187: SELECT oksh.renewal_type_used, fndu.user_name
5188: FROM oks_k_headers_b oksh, fnd_user fndu
5189: WHERE oksh.chr_id = p_chr_id
5190: AND oksh.renewal_notification_to = fndu.user_id(+);
5191:
5192: CURSOR l_user_dtls_csr(p_chr_id NUMBER) IS