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 1799: SELECT user_name from fnd_user

1795: SELECT contract_number from okc_k_headers_b
1796: WHERE id = p_id;
1797:
1798: CURSOR user_info(p_id NUMBER) IS
1799: SELECT user_name from fnd_user
1800: WHERE user_id = p_id;
1801:
1802: user_info_rec user_info%rowtype;
1803:

Line 1909: SELECT user_name from fnd_user

1905: FROM OKC_K_HEADERS_all_b --modified by rajnisku for getting org_id
1906: WHERE id = l_chr_id;
1907:
1908: CURSOR user_info(l_user_id NUMBER) IS
1909: SELECT user_name from fnd_user
1910: WHERE user_id = l_user_id;
1911:
1912: CURSOR format_cur(l_format_id NUMBER) IS
1913: SELECT name

Line 2164: l_username fnd_user.user_name%type;

2160: l_current_billing_site okx_cust_site_uses_v.name%type;
2161: l_current_billing_address okx_cust_site_uses_v.description%type;
2162: l_new_billing_site okx_cust_site_uses_v.name%type;
2163: l_new_billing_address okx_cust_site_uses_v.description%type;
2164: l_username fnd_user.user_name%type;
2165: l_respString VARCHAR2(50);
2166: l_respId NUMBER;
2167: l_resp_key VARCHAR2(30);
2168:

Line 2201: SELECT user_name from fnd_user

2197:
2198: new_billing_info_rec new_billing_info%rowtype;
2199:
2200: CURSOR user_info(l_user_id NUMBER) IS
2201: SELECT user_name from fnd_user
2202: WHERE user_id = l_user_id;
2203: user_info_rec user_info%rowtype;
2204:
2205: begin

Line 2513: SELECT user_name from fnd_user

2509: from OKL_INS_POLICIES_B
2510: WHERE id = p_pol_id;
2511:
2512: CURSOR requestor_info_cur(p_requestor_id IN NUMBER) IS
2513: SELECT user_name from fnd_user
2514: WHERE user_id = p_requestor_id;
2515:
2516: CURSOR fnd_lookup_cur(p_code IN VARCHAR2, p_type IN VARCHAR2) IS
2517: SELECT meaning from fnd_lookups

Line 2971: SELECT user_name from fnd_user

2967: SELECT object_version_number, currency_code from okc_k_headers_b
2968: WHERE id = p_id;
2969:
2970: CURSOR user_info(p_id NUMBER) IS
2971: SELECT user_name from fnd_user
2972: WHERE user_id = p_id;
2973:
2974:
2975:

Line 3068: SELECT user_name from fnd_user

3064: SELECT object_version_number, currency_code from okc_k_headers_b
3065: WHERE id = p_id;
3066:
3067: CURSOR user_info(p_id NUMBER) IS
3068: SELECT user_name from fnd_user
3069: WHERE user_id = p_id;
3070:
3071:
3072:

Line 3336: SELECT user_name from fnd_user

3332: FROM hz_cust_accounts
3333: WHERE cust_account_id = p_cust_id;
3334:
3335: CURSOR requestor_info_cur(p_requestor_id IN NUMBER) IS
3336: SELECT user_name from fnd_user
3337: WHERE user_id = p_requestor_id;
3338:
3339:
3340: l_payment_id VARCHAR2(40);

Line 3459: SELECT email_address from fnd_user

3455: AND chr_id = dnz_chr_id
3456: and rle_code='LESSEE';
3457:
3458: CURSOR email_address_cur(p_user_id IN NUMBER) IS
3459: SELECT email_address from fnd_user
3460: WHERE user_id = p_user_id;
3461:
3462: begin
3463:

Line 3620: SELECT user_name from fnd_user

3616: from okl_am_quotes_uv
3617: WHERE id = p_qte_id;
3618:
3619: CURSOR requestor_info_cur(p_requestor_id IN NUMBER) IS
3620: SELECT user_name from fnd_user
3621: WHERE user_id = p_requestor_id;
3622:
3623:
3624: l_chr_id VARCHAR2(40);