APPS.PA_WORKPLAN_WORKFLOW dependencies on FND_USER

Line 476: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,

472: --get all project member who has edit privileges
473: CURSOR getProjMemberEditPerson IS
474: select distinct fu.user_id, fu.user_name, papf.email_address,
475: papf.full_name person_name
476: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
477: pa_project_role_types pprt
478: where object_type = 'PA_PROJECTS'
479: and object_id = l_project_id
480: and ppp.resource_type_id = 101

Line 497: from fnd_user fu, per_all_people_f papf

493: and f2.function_id = f1.function_id)
494: UNION /*Added this clause for 4482957 */
495: select distinct fu.user_id, fu.user_name, papf.email_address,
496: papf.full_name person_name
497: from fnd_user fu, per_all_people_f papf
498: where fu.user_id = fnd_global.USER_ID
499: and papf.person_id = fu.employee_id
500: and trunc(sysdate) between papf.effective_start_date
501: and nvl(papf.effective_end_date, sysdate+1)

Line 512: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,

508: /*
509: CURSOR getProjMemberEditParty IS
510: select distinct fu.user_id, fu.user_name, papf.email_address,
511: papf.full_name person_name
512: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
513: pa_project_role_types pprt
514: where object_type = 'PA_PROJECTS'
515: and object_id = l_project_id
516: and ppp.resource_type_id = 112

Line 535: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,

531:
532: CURSOR getProjMemberEditParty IS
533: select distinct fu.user_id, fu.user_name, papf.email_address,
534: papf.full_name person_name
535: from fnd_user fu, per_all_people_f papf, pa_project_parties ppp,
536: pa_project_role_types pprt
537: where object_type = 'PA_PROJECTS'
538: and object_id = l_project_id
539: and ppp.resource_type_id = 112