DBA Data[Home] [Help]

APPS.PA_PO_INTEGRATION_UTILS dependencies on FND_USER

Line 410: -- Bug 8937044 joined with fnd_user

406: l_user_c NUMBER :=0;
407: begin
408:
409: /*To check if employee has key member access for a project*/
410: -- Bug 8937044 joined with fnd_user
411: select count(*)
412: into l_user_c
413: from per_all_people_f papf
414: where papf.person_id=(select max(employee_id) from fnd_user where user_id = x_proj_user_id)

Line 414: where papf.person_id=(select max(employee_id) from fnd_user where user_id = x_proj_user_id)

410: -- Bug 8937044 joined with fnd_user
411: select count(*)
412: into l_user_c
413: from per_all_people_f papf
414: where papf.person_id=(select max(employee_id) from fnd_user where user_id = x_proj_user_id)
415: and trunc(sysdate) between papf.EFFECTIVE_START_DATE
416: and Nvl(papf.effective_end_date, Sysdate + 1)
417: and papf.person_id in
418: (