DBA Data[Home] [Help]

APPS.FUN_NET_EXTRACT_PKG dependencies on FUN_NET_BATCHES

Line 7: p_batch_id IN fun_net_batches_all.batch_id%TYPE)

3:
4: PROCEDURE extract_data
5: (errbuf OUT NOCOPY VARCHAR2,
6: retcode OUT NOCOPY VARCHAR2,
7: p_batch_id IN fun_net_batches_all.batch_id%TYPE)
8: IS
9:
10: CURSOR c_get_batch_details IS
11: SELECT batch_number,

Line 19: FROM fun_net_batches

15: settlement_date,
16: org_id,
17: batch_currency,
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,

Line 29: CURSOR c_get_functional_currency(cp_org_id fun_net_batches_all.org_id%TYPE) IS

25: agreement_end_date
26: FROM fun_net_agreements
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;