APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on FND_USER

Line 3138: -- FROM fnd_user fu, hr_employees he

3134: BEGIN
3135: -- Performance Tuning, Replaced the following query
3136: -- with the one below.
3137: -- SELECT fu.user_id INTO l_user_id
3138: -- FROM fnd_user fu, hr_employees he
3139: -- WHERE fu.user_id = P_Cc_Owner_User_Id
3140: -- AND sysdate BETWEEN NVL(fu.start_date, sysdate)
3141: -- AND NVL(fu.end_date, sysdate)
3142: -- AND fu.employee_id IS NOT NULL

Line 3147: FROM fnd_user fu,

3143: -- AND fu.employee_id = he.employee_id;
3144:
3145: SELECT fu.user_id
3146: INTO l_user_id
3147: FROM fnd_user fu,
3148: per_all_people_f p,
3149: per_all_assignments_f a,
3150: per_assignment_status_types past
3151: WHERE fu.user_id = P_Cc_Owner_User_Id

Line 3188: -- FROM fnd_user fu, hr_employees he

3184:
3185: -- Validate Cc Preparer User Id
3186: BEGIN
3187: -- SELECT fu.user_id INTO l_user_id
3188: -- FROM fnd_user fu, hr_employees he
3189: -- WHERE fu.user_id = P_Cc_Preparer_User_Id
3190: -- AND sysdate BETWEEN NVL(fu.start_date, sysdate)
3191: -- AND NVL(fu.end_date, sysdate)
3192: -- AND fu.employee_id IS NOT NULL

Line 3197: FROM fnd_user fu,

3193: -- AND fu.employee_id = he.employee_id;
3194:
3195: SELECT fu.user_id
3196: INTO l_user_id
3197: FROM fnd_user fu,
3198: per_all_people_f p,
3199: per_all_assignments_f a,
3200: per_assignment_status_types past
3201: WHERE fu.user_id = P_Cc_Preparer_User_Id

Line 3305: FROM fnd_user

3301: -- Validate Created By
3302: IF P_Created_By IS NOT NULL THEN
3303: BEGIN
3304: SELECT user_id INTO l_user_id
3305: FROM fnd_user
3306: WHERE user_id = P_Created_By;
3307: EXCEPTION WHEN NO_DATA_FOUND THEN
3308: l_error_message := NULL;
3309: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_CREATED_BY');

Line 3328: -- FROM fnd_user fu, hr_employees he

3324: -- Validate Cc Current User Id
3325: IF P_Cc_Current_User_Id IS NOT NULL THEN
3326: BEGIN
3327: -- SELECT fu.user_id INTO l_user_id
3328: -- FROM fnd_user fu, hr_employees he
3329: -- WHERE fu.user_id = P_Cc_Current_User_Id
3330: -- AND sysdate BETWEEN NVL(fu.start_date, sysdate)
3331: -- AND NVL(fu.end_date, sysdate)
3332: -- AND fu.employee_id IS NOT NULL

Line 3337: FROM fnd_user fu,

3333: -- AND fu.employee_id = he.employee_id;
3334:
3335: SELECT fu.user_id
3336: INTO l_user_id
3337: FROM fnd_user fu,
3338: per_all_people_f p,
3339: per_all_assignments_f a,
3340: per_assignment_status_types past
3341: WHERE fu.user_id = P_Cc_Current_User_Id

Line 4438: FROM fnd_user

4434: -- Validate Created By
4435: IF P_Created_By IS NOT NULL THEN
4436: BEGIN
4437: SELECT user_id INTO l_user_id
4438: FROM fnd_user
4439: WHERE user_id = P_Created_By;
4440: EXCEPTION WHEN NO_DATA_FOUND THEN
4441: l_error_message := NULL;
4442: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_CREATED_BY');

Line 5032: FROM fnd_user

5028: -- Validate Created By
5029: IF P_Created_By IS NOT NULL THEN
5030: BEGIN
5031: SELECT user_id INTO l_user_id
5032: FROM fnd_user
5033: WHERE user_id = P_Created_By;
5034: EXCEPTION WHEN NO_DATA_FOUND THEN
5035: l_error_message := NULL;
5036: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_INVALID_CREATED_BY');