APPS.FUN_NET_APPROVAL_WF dependencies on FND_USER

Line 69: CURSOR c_get_preparer_id(cp_user_id IN fnd_user.user_id%TYPE) IS

65: batch_currency
66: FROM fun_net_batches_all
67: WHERE batch_id = cp_batch_id;
68:
69: CURSOR c_get_preparer_id(cp_user_id IN fnd_user.user_id%TYPE) IS
70: SELECT employee_id
71: FROM FND_USER
72: WHERE user_id = cp_user_id;
73:

Line 71: FROM FND_USER

67: WHERE batch_id = cp_batch_id;
68:
69: CURSOR c_get_preparer_id(cp_user_id IN fnd_user.user_id%TYPE) IS
70: SELECT employee_id
71: FROM FND_USER
72: WHERE user_id = cp_user_id;
73:
74: CURSOR c_get_approver_name(cp_agreement_id fun_net_agreements_all.agreement_id%TYPE) IS
75: SELECT approver_name

Line 85: l_netting_analyst_id fnd_user.user_id%TYPE;

81: l_batch_name fun_net_batches_all.batch_name%TYPE;
82: l_response_date fun_net_batches_all.response_date%TYPE;
83: l_created_by fun_net_batches_all.created_by%TYPE;
84: l_netting_amount fun_net_batches_all.total_netted_amt%TYPE;
85: l_netting_analyst_id fnd_user.user_id%TYPE;
86: l_analyst_name wf_users.name%type;
87: l_analyst_display_name wf_users.display_name%type;
88: l_agreement_id fun_net_agreements_all.agreement_id%TYPE;
89: l_approver_name fun_net_agreements_all.approver_name%TYPE;