APPS.CS_KNOWLEDGE_AUDIT_PVT dependencies on FND_USER

Line 142: -- Get sysdate, fnd user AND login

138: END Get_Missing_Ele_Type;
139:
140:
141: --
142: -- Get sysdate, fnd user AND login
143: --
144: PROCEDURE Get_Who(
145: x_sysdate OUT NOCOPY DATE,
146: x_user_id OUT NOCOPY NUMBER,

Line 3347: FROM FND_USER fu

3343: AS
3344:
3345: Cursor Get_Emp_User IS
3346: SELECT P.FULL_NAME
3347: FROM FND_USER fu
3348: ,PER_ALL_PEOPLE_F P
3349: WHERE sysdate BETWEEN nvl(fu.start_date, sysdate-1)
3350: AND nvl(fu.end_date, sysdate+1)
3351: AND fu.employee_id = P.person_id

Line 3359: ,fnd_user fu

3355:
3356: Cursor Get_B2C_User IS
3357: SELECT hp.party_name
3358: FROM hz_parties hp
3359: ,fnd_user fu
3360: WHERE hp.party_type = 'PERSON'
3361: AND sysdate BETWEEN nvl(fu.start_date, sysdate-1)
3362: AND nvl(fu.end_date, sysdate+1)
3363: AND fu.customer_id = hp.party_id

Line 3372: ,fnd_user fu

3368: Cursor Get_B2B_User IS
3369: SELECT hp.party_name
3370: from hz_parties hp
3371: ,hz_relationships hr
3372: ,fnd_user fu
3373: WHERE hr.party_id = fu.customer_id
3374: AND hr.subject_id = hp.party_id
3375: AND hr.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
3376: AND hp.party_type = 'PERSON'

Line 3385: CURSOR GET_FND_USER IS

3381: AND fu.customer_id is not null
3382: AND fu.employee_id is null
3383: AND fu.User_id = V_USER_ID;
3384:
3385: CURSOR GET_FND_USER IS
3386: SELECT fu.user_name
3387: FROM FND_USER fu
3388: WHERE fu.User_id = V_USER_ID;
3389:

Line 3387: FROM FND_USER fu

3383: AND fu.User_id = V_USER_ID;
3384:
3385: CURSOR GET_FND_USER IS
3386: SELECT fu.user_name
3387: FROM FND_USER fu
3388: WHERE fu.User_id = V_USER_ID;
3389:
3390: l_full_name VARCHAR2(200) := null;
3391: BEGIN

Line 3407: OPEN GET_FND_USER;

3403: FETCH GET_B2B_USER INTO l_full_name;
3404: CLOSE GET_B2B_USER;
3405:
3406: IF l_full_name IS NULL THEN
3407: OPEN GET_FND_USER;
3408: FETCH GET_FND_USER INTO l_full_name;
3409: CLOSE GET_FND_USER;
3410: END IF;
3411: END IF;

Line 3408: FETCH GET_FND_USER INTO l_full_name;

3404: CLOSE GET_B2B_USER;
3405:
3406: IF l_full_name IS NULL THEN
3407: OPEN GET_FND_USER;
3408: FETCH GET_FND_USER INTO l_full_name;
3409: CLOSE GET_FND_USER;
3410: END IF;
3411: END IF;
3412:

Line 3409: CLOSE GET_FND_USER;

3405:
3406: IF l_full_name IS NULL THEN
3407: OPEN GET_FND_USER;
3408: FETCH GET_FND_USER INTO l_full_name;
3409: CLOSE GET_FND_USER;
3410: END IF;
3411: END IF;
3412:
3413: END IF;