APPS.FUN_NET_EXTRACT_PKG dependencies on FUN_NET_AGREEMENTS_ALL

Line 22: CURSOR c_get_agreement_details(cp_agreement_id fun_net_agreements_all.agreement_id%TYPE) IS

18: total_netted_amt
19: FROM fun_net_batches
20: WHERE batch_id = p_batch_id;
21:
22: CURSOR c_get_agreement_details(cp_agreement_id fun_net_agreements_all.agreement_id%TYPE) IS
23: SELECT agreement_name,
24: agreement_start_date,
25: agreement_end_date
26: FROM fun_net_agreements

Line 35: CURSOR c_get_ap_invoices(cp_agreement_id fun_net_agreements_all.agreement_id%TYPE) IS

31: FROM gl_ledgers l,hr_operating_units ou
32: WHERE ou.organization_id = cp_org_id
33: AND ou.set_of_books_id = l.ledger_id;
34:
35: CURSOR c_get_ap_invoices(cp_agreement_id fun_net_agreements_all.agreement_id%TYPE) IS
36: SELECT pv.vendor_name supplier ,
37: pv.segment1 supplier_number ,
38: pvs.vendor_site_code supplier_site ,
39: ai.invoice_num invoice_number ,

Line 63: CURSOR c_get_ar_transactions(cp_agreement_id fun_net_agreements_all.agreement_id%TYPE) IS

59: AND ai.org_id = pvs.org_id
60: AND nai.netted_amt <> 0
61: ORDER BY ns.supplier_priority, nai.ap_txn_rank;
62:
63: CURSOR c_get_ar_transactions(cp_agreement_id fun_net_agreements_all.agreement_id%TYPE) IS
64: SELECT hp.party_name customer ,
65: hca.account_number customer_number ,
66: hcs.location location ,
67: rct.trx_number transaction_number ,