APPS.FUN_NET_EXTRACT_PKG dependencies on GL_LEDGERS

Line 31: FROM gl_ledgers l,hr_operating_units ou

27: WHERE agreement_id = cp_agreement_id;
28:
29: CURSOR c_get_functional_currency(cp_org_id fun_net_batches_all.org_id%TYPE) IS
30: SELECT l.currency_code
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

Line 109: l_func_currency gl_ledgers.currency_code%TYPE;

105: l_supplier_site po_vendor_sites_all.vendor_site_code%TYPE;
106: l_invoice_count NUMBER;
107: l_transaction_count NUMBER;
108: l_output_string VARCHAR2(2000);
109: l_func_currency gl_ledgers.currency_code%TYPE;
110: l_ledger_id gl_ledgers.ledger_id%TYPE;
111: l_ledger_name gl_ledgers.name%TYPE;
112:
113: BEGIN

Line 110: l_ledger_id gl_ledgers.ledger_id%TYPE;

106: l_invoice_count NUMBER;
107: l_transaction_count NUMBER;
108: l_output_string VARCHAR2(2000);
109: l_func_currency gl_ledgers.currency_code%TYPE;
110: l_ledger_id gl_ledgers.ledger_id%TYPE;
111: l_ledger_name gl_ledgers.name%TYPE;
112:
113: BEGIN
114:

Line 111: l_ledger_name gl_ledgers.name%TYPE;

107: l_transaction_count NUMBER;
108: l_output_string VARCHAR2(2000);
109: l_func_currency gl_ledgers.currency_code%TYPE;
110: l_ledger_id gl_ledgers.ledger_id%TYPE;
111: l_ledger_name gl_ledgers.name%TYPE;
112:
113: BEGIN
114:
115: OPEN c_get_batch_details;

Line 130: FROM gl_ledgers

126: l_ledger_name);
127:
128: SELECT currency_code
129: INTO l_func_currency
130: FROM gl_ledgers
131: WHERE ledger_id = l_ledger_id;
132:
133: fnd_file.put_line(fnd_file.output,'Data Extract File');
134: