DBA Data[Home] [Help]

APPS.FUN_NET_EXTRACT_PKG dependencies on FUN_NET_BATCHES_ALL

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 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;