APPS.FUN_NET_APPROVAL_WF dependencies on FUN_NET_AGREEMENTS_ALL

Line 74: CURSOR c_get_approver_name(cp_agreement_id fun_net_agreements_all.agreement_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
76: FROM fun_net_agreements_all
77: WHERE agreement_id = cp_agreement_id;
78:

Line 76: FROM fun_net_agreements_all

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
76: FROM fun_net_agreements_all
77: WHERE agreement_id = cp_agreement_id;
78:
79: l_batch_id fun_net_batches_all.batch_id%TYPE;
80: l_batch_number fun_net_batches_all.batch_number%TYPE;

Line 88: l_agreement_id fun_net_agreements_all.agreement_id%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;
90: l_batch_currency fun_net_batches_all.batch_currency%TYPE;
91: l_path varchar2(100);
92: BEGIN

Line 89: l_approver_name fun_net_agreements_all.approver_name%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;
90: l_batch_currency fun_net_batches_all.batch_currency%TYPE;
91: l_path varchar2(100);
92: BEGIN
93: l_path := g_path || 'Initialize';

Line 209: FROM fun_net_agreements_all a

205: p_result OUT NOCOPY VARCHAR2) IS
206:
207: CURSOR c_get_nonresponse_code(cp_batch_id fun_net_batches_all.batch_id%TYPE) IS
208: SELECT a.non_response_action_code
209: FROM fun_net_agreements_all a
210: WHERE a.agreement_id = (SELECT b.agreement_id
211: FROM fun_net_batches_all b
212: WHERE b.batch_id = cp_batch_id);
213:

Line 215: l_nonresponse_code fun_net_agreements_all.non_response_action_code%TYPE;

211: FROM fun_net_batches_all b
212: WHERE b.batch_id = cp_batch_id);
213:
214: l_batch_id fun_net_batches_all.batch_id%TYPE;
215: l_nonresponse_code fun_net_agreements_all.non_response_action_code%TYPE;
216: l_path VARCHAR2(100);
217: BEGIN
218: l_path := g_path||'Get_NoResponse_Action';
219: fun_net_util.Log_String(g_state_level,l_path,'Start of Get_NoResponse_Action');