APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on FND_USER

Line 33: from per_all_people_f p, fnd_user f

29: l_dummy VARCHAR2(1);
30:
31: cursor get_person_id(p_user_id NUMBER) IS
32: select p.person_id
33: from per_all_people_f p, fnd_user f
34: where f.employee_id = p.person_id
35: and sysdate between p.effective_start_date and p.effective_end_date
36: and f.user_id = p_user_id;
37:

Line 892: from fnd_user f,

888: l_locked_person_id number;
889:
890: cursor get_person_id IS
891: select p.person_id
892: from fnd_user f,
893: per_all_people_f p
894: where p_user_id = f.user_id
895: and f.employee_id = p.person_id
896: and sysdate between p.effective_start_date and p.effective_end_date;

Line 964: -- p_user_id fnd_user.user_id%TYPE

960: -- Return Value : Y is locked by user,
961: -- N is not locked,
962: -- O is locked by other user.
963: -- Parameters
964: -- p_user_id fnd_user.user_id%TYPE
965: -- p_structure_version_id pa_proj_element_versions.element_version_id%TYPE
966: --
967: -- History
968: --

Line 973: function IS_STRUC_VER_LOCKED_BY_USER1(p_user_id fnd_user.user_id%TYPE,

969: -- 20-may-03 mrajput -Created
970: -- Added For bug 2964237
971:
972:
973: function IS_STRUC_VER_LOCKED_BY_USER1(p_user_id fnd_user.user_id%TYPE,
974: p_structure_version_id pa_proj_element_versions.element_version_id%TYPE)
975: return VARCHAR2
976: IS
977:

Line 981: from fnd_user f,

977:
978: --Cursor to get the persion id from the user id passed to thia api
979: cursor get_person_id IS
980: select p.person_id
981: from fnd_user f,
982: per_all_people_f p
983: where p_user_id = f.user_id
984: and f.employee_id = p.person_id
985: and sysdate between p.effective_start_date and p.effective_end_date;

Line 1045: pa_debug.g_err_stage := 'The person id of the fnd user passed is : ' || l_person_id;

1041: END IF;
1042: CLOSE get_person_id;
1043:
1044: IF l_debug_mode = 'Y' THEN
1045: pa_debug.g_err_stage := 'The person id of the fnd user passed is : ' || l_person_id;
1046: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1047: END IF;
1048:
1049: