APPS.DPP_APPROVAL_PVT dependencies on FND_USER

Line 88: from fnd_user fu

84: l_module CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_APPROVAL_PVT.UPDATE_USER_ACTION';
85:
86: CURSOR csr_person_user (p_source_id IN NUMBER )IS
87: select fu.user_id, fu.user_name
88: from fnd_user fu
89: where fu.employee_id = p_source_id;
90:
91:
92: CURSOR csr_curr_approver (p_object_type IN VARCHAR2, p_object_id IN NUMBER,

Line 96: FROM DPP_APPROVAL_ACCESS daa, FND_USER fu

92: CURSOR csr_curr_approver (p_object_type IN VARCHAR2, p_object_id IN NUMBER,
93: p_action_performed IN VARCHAR2 )IS
94:
95: SELECT daa.approval_access_id, fu.user_id, fu.user_name
96: FROM DPP_APPROVAL_ACCESS daa, FND_USER fu
97: WHERE daa.approval_access_flag = 'Y'
98: AND object_type = p_object_type
99: AND object_id = p_object_id
100: AND daa.approver_id = DECODE(daa.approver_type, 'PERSON', fu.employee_id, fu.user_id)

Line 1618: , fnd_user fu

1614:
1615: CURSOR csr_approvers (p_object_type varchar2, p_object_id number) IS
1616: SELECT fu.user_name
1617: FROM dpp_approval_access oaa
1618: , fnd_user fu
1619: WHERE oaa.object_type = p_object_type
1620: AND oaa.object_id = p_object_id
1621: AND oaa.approver_type = 'USER'
1622: AND oaa.approver_id = fu.user_id