APPS.FUN_NET_CONC_PROG_PKG dependencies on FUN_NET_AGREEMENTS_ALL

Line 184: FROM FUN_NET_BATCHES_ALL B, FUN_NET_AGREEMENTS_ALL A

180: p_review_netting_batch_flag IN fun_net_batches_all.REVIEW_NETTING_BATCH_FLAG%TYPE) IS
181:
182: CURSOR c_batch(p_batch_id NUMBER) IS
183: SELECT B.BATCH_NUMBER, B.BATCH_NAME, A.AGREEMENT_NAME, B.BATCH_CURRENCY, B.BATCH_STATUS_CODE
184: FROM FUN_NET_BATCHES_ALL B, FUN_NET_AGREEMENTS_ALL A
185: WHERE B.AGREEMENT_ID = A.AGREEMENT_ID
186: AND B.BATCH_NAME = nvl(p_batch_name, p_batch_id||'')
187: AND B.BATCH_ID >= p_batch_id;
188:

Line 194: l_allow_disc_flag fun_net_agreements_all.ALLOW_DISC_FLAG%TYPE;

190: l_msg_count NUMBER;
191: l_msg_data VARCHAR2(2000);
192: l_request_id NUMBER;
193: l_batch_id NUMBER;
194: l_allow_disc_flag fun_net_agreements_all.ALLOW_DISC_FLAG%TYPE;
195: l_transaction_due_date VARCHAR2(30);
196: l_agreement_name fun_net_agreements_all.agreement_name%TYPE;
197: l_org_name hr_operating_units.name%TYPE;
198: l_batch_currency fun_net_batches_all.batch_currency%TYPE;

Line 196: l_agreement_name fun_net_agreements_all.agreement_name%TYPE;

192: l_request_id NUMBER;
193: l_batch_id NUMBER;
194: l_allow_disc_flag fun_net_agreements_all.ALLOW_DISC_FLAG%TYPE;
195: l_transaction_due_date VARCHAR2(30);
196: l_agreement_name fun_net_agreements_all.agreement_name%TYPE;
197: l_org_name hr_operating_units.name%TYPE;
198: l_batch_currency fun_net_batches_all.batch_currency%TYPE;
199: l_batch_name fun_net_batches_all.batch_name%TYPE;
200: l_batch_status fun_net_batches_all.batch_status_code%TYPE;

Line 216: FROM FUN_NET_AGREEMENTS_ALL

212: IF p_agreement_id is not NULL THEN
213:
214: SELECT agreement_name, ALLOW_DISC_FLAG
215: INTO l_agreement_name, l_allow_disc_flag
216: FROM FUN_NET_AGREEMENTS_ALL
217: WHERE AGREEMENT_ID = p_agreement_id;
218:
219: END IF;
220: