APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on FND_USER

Line 1344: -- FROM fnd_user fu, hr_employees he

1340: -- Performance Tuning, Replaced the following query with
1341: -- the one below.
1342: -- SELECT fu.user_id
1343: -- INTO l_user_id
1344: -- FROM fnd_user fu, hr_employees he
1345: -- WHERE fu.user_id = p_cc_header_rec.cc_owner_user_id
1346: -- AND sysdate BETWEEN NVL(fu.start_date, sysdate)
1347: -- AND NVL(fu.end_date, sysdate)
1348: -- AND fu.employee_id IS NOT NULL

Line 1352: FROM fnd_user fu,

1348: -- AND fu.employee_id IS NOT NULL
1349: -- AND fu.employee_id = he.employee_id;
1350: SELECT fu.user_id
1351: INTO l_user_id
1352: FROM fnd_user fu,
1353: per_people_f p, /* per_all_people_f p, --Commented during MOAC uptake for bug#6341012*/
1354: per_all_assignments_f a,
1355: per_assignment_status_types past
1356: WHERE fu.user_id = p_cc_header_rec.cc_owner_user_id

Line 1396: -- FROM fnd_user fu, hr_employees he

1392: -- Performance tuning, Replaced the following sql
1393: -- with the one below.
1394: -- SELECT fu.user_id
1395: -- INTO l_user_id
1396: -- FROM fnd_user fu, hr_employees he
1397: -- WHERE fu.user_id = p_cc_header_rec.cc_preparer_user_id
1398: -- AND sysdate BETWEEN NVL(fu.start_date, sysdate)
1399: -- AND NVL(fu.end_date, sysdate)
1400: -- AND fu.employee_id IS NOT NULL

Line 1405: FROM fnd_user fu,

1401: -- AND fu.employee_id = he.employee_id;
1402:
1403: SELECT fu.user_id
1404: INTO l_user_id
1405: FROM fnd_user fu,
1406: per_people_f p, /* per_all_people_f p, --Commented for Bug#6341012
1407: during MOAC uptake*/
1408: per_all_assignments_f a,
1409: per_assignment_status_types past

Line 1787: FROM fnd_user

1783:
1784: BEGIN
1785: SELECT user_id
1786: INTO l_user_id
1787: FROM fnd_user
1788: WHERE user_id = p_cc_header_rec.created_by;
1789:
1790: EXCEPTION
1791:

Line 1832: FROM fnd_user

1828:
1829: BEGIN
1830: SELECT user_id
1831: INTO l_user_id
1832: FROM fnd_user
1833: WHERE user_id = p_cc_header_rec.last_updated_by;
1834:
1835: EXCEPTION
1836:

Line 2398: FROM fnd_user

2394:
2395: BEGIN
2396: SELECT user_id
2397: INTO l_user_id
2398: FROM fnd_user
2399: WHERE user_id = l_current_user_id;
2400:
2401: EXCEPTION
2402:

Line 3656: FROM fnd_user

3652:
3653:
3654: CURSOR l_user_csr IS
3655: SELECT 'x'
3656: FROM fnd_user
3657: WHERE user_id = p_user_id;
3658: l_resp_csr_rec l_resp_csr%ROWTYPE;
3659:
3660: BEGIN