APPS.OKL_SSC_WF dependencies on FND_USER

Line 98: SELECT user_name from fnd_user

94:
95: IS
96:
97: CURSOR user_info(p_id NUMBER) IS
98: SELECT user_name from fnd_user
99: WHERE user_id = p_id;
100:
101:
102: CURSOR approver_cur(respKey varchar2) IS

Line 315: SELECT user_name from fnd_user

311:
312: IS
313:
314: CURSOR user_info(p_id NUMBER) IS
315: SELECT user_name from fnd_user
316: WHERE user_id = p_id;
317:
318: CURSOR approver_cur(respKey varchar2) IS
319: SELECT responsibility_id

Line 587: SELECT user_name from fnd_user

583:
584: IS
585:
586: CURSOR user_info(p_id NUMBER) IS
587: SELECT user_name from fnd_user
588: WHERE user_id = p_id;
589:
590: CURSOR approver_cur(respKey varchar2) IS
591: SELECT responsibility_id

Line 756: FROM FND_USER

752:
753: -- Added for Bug 7538507
754: CURSOR get_user_id_csr IS
755: SELECT user_id
756: FROM FND_USER
757: WHERE User_Name = FND_GLOBAL.user_name;
758:
759: disptype VARCHAR2(30); -- Bug 8974540
760:

Line 1885: SELECT user_name from fnd_user

1881: SELECT contract_number from okc_k_headers_b
1882: WHERE id = p_id;
1883:
1884: CURSOR user_info(p_id NUMBER) IS
1885: SELECT user_name from fnd_user
1886: WHERE user_id = p_id;
1887:
1888: user_info_rec user_info%rowtype;
1889:

Line 1995: SELECT user_name from fnd_user

1991: FROM OKC_K_HEADERS_all_b --modified by rajnisku for getting org_id
1992: WHERE id = l_chr_id;
1993:
1994: CURSOR user_info(l_user_id NUMBER) IS
1995: SELECT user_name from fnd_user
1996: WHERE user_id = l_user_id;
1997:
1998: CURSOR format_cur(l_format_id NUMBER) IS
1999: SELECT name

Line 2250: l_username fnd_user.user_name%type;

2246: l_current_billing_site okx_cust_site_uses_v.name%type;
2247: l_current_billing_address okx_cust_site_uses_v.description%type;
2248: l_new_billing_site okx_cust_site_uses_v.name%type;
2249: l_new_billing_address okx_cust_site_uses_v.description%type;
2250: l_username fnd_user.user_name%type;
2251: l_respString VARCHAR2(50);
2252: l_respId NUMBER;
2253: l_resp_key VARCHAR2(30);
2254:

Line 2287: SELECT user_name from fnd_user

2283:
2284: new_billing_info_rec new_billing_info%rowtype;
2285:
2286: CURSOR user_info(l_user_id NUMBER) IS
2287: SELECT user_name from fnd_user
2288: WHERE user_id = l_user_id;
2289: user_info_rec user_info%rowtype;
2290:
2291: begin

Line 2599: SELECT user_name from fnd_user

2595: from OKL_INS_POLICIES_B
2596: WHERE id = p_pol_id;
2597:
2598: CURSOR requestor_info_cur(p_requestor_id IN NUMBER) IS
2599: SELECT user_name from fnd_user
2600: WHERE user_id = p_requestor_id;
2601:
2602: CURSOR fnd_lookup_cur(p_code IN VARCHAR2, p_type IN VARCHAR2) IS
2603: SELECT meaning from fnd_lookups

Line 3057: SELECT user_name from fnd_user

3053: SELECT object_version_number, currency_code from okc_k_headers_b
3054: WHERE id = p_id;
3055:
3056: CURSOR user_info(p_id NUMBER) IS
3057: SELECT user_name from fnd_user
3058: WHERE user_id = p_id;
3059:
3060:
3061:

Line 3154: SELECT user_name from fnd_user

3150: SELECT object_version_number, currency_code from okc_k_headers_b
3151: WHERE id = p_id;
3152:
3153: CURSOR user_info(p_id NUMBER) IS
3154: SELECT user_name from fnd_user
3155: WHERE user_id = p_id;
3156:
3157:
3158:

Line 3422: SELECT user_name from fnd_user

3418: FROM hz_cust_accounts
3419: WHERE cust_account_id = p_cust_id;
3420:
3421: CURSOR requestor_info_cur(p_requestor_id IN NUMBER) IS
3422: SELECT user_name from fnd_user
3423: WHERE user_id = p_requestor_id;
3424:
3425:
3426: l_payment_id VARCHAR2(40);

Line 3545: SELECT email_address from fnd_user

3541: AND chr_id = dnz_chr_id
3542: and rle_code='LESSEE';
3543:
3544: CURSOR email_address_cur(p_user_id IN NUMBER) IS
3545: SELECT email_address from fnd_user
3546: WHERE user_id = p_user_id;
3547:
3548: begin
3549:

Line 3706: SELECT user_name from fnd_user

3702: from okl_am_quotes_uv
3703: WHERE id = p_qte_id;
3704:
3705: CURSOR requestor_info_cur(p_requestor_id IN NUMBER) IS
3706: SELECT user_name from fnd_user
3707: WHERE user_id = p_requestor_id;
3708:
3709:
3710: l_chr_id VARCHAR2(40);