DBA Data[Home] [Help]

APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_FORMULAE_B

Line 10041: FROM okl_formulae_b

10037:
10038: -- GET FORMULA NAME
10039: CURSOR l_formulae_csr(cp_fma_id IN NUMBER) IS
10040: SELECT name
10041: FROM okl_formulae_b
10042: WHERE id = cp_fma_id;
10043:
10044: TYPE prevtaxsrc_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
10045: TYPE prevtaxtrxdet_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 11041: FROM okl_formulae_b

11037:
11038: -- GET FORMULA NAME
11039: CURSOR l_formulae_csr(cp_fma_id IN NUMBER) IS
11040: SELECT name
11041: FROM okl_formulae_b
11042: WHERE id = cp_fma_id;
11043:
11044: CURSOR l_okltaxsources_csr(cp_app_id IN NUMBER, cp_trx_id IN NUMBER) IS
11045: SELECT entity_code, event_class_code

Line 13370: FROM Okl_formulae_b

13366:
13367: -- GET FORMULA NAME
13368: CURSOR l_formulae_csr(cp_fma_id IN NUMBER) IS
13369: SELECT name
13370: FROM Okl_formulae_b
13371: WHERE id = cp_fma_id;
13372:
13373: l_fetch_size NUMBER := 10000;
13374: l_bk_trx_type_id_det NUMBER;

Line 15885: FROM Okl_formulae_b

15881:
15882: -- GET FORMULA NAME
15883: CURSOR l_formulae_csr(cp_fma_id IN NUMBER) IS
15884: SELECT name
15885: FROM Okl_formulae_b
15886: WHERE id = cp_fma_id;
15887:
15888: -- Get the AR customer transaction type used by OKL
15889: CURSOR l_racusttrxtypes_csr IS

Line 19177: FROM okl_formulae_b

19173:
19174: -- get formula name
19175: CURSOR l_formulae_csr(cp_fma_id IN NUMBER) IS
19176: SELECT name
19177: FROM okl_formulae_b
19178: WHERE id = cp_fma_id;
19179:
19180: -- Funding / Debit Memo / Disbursement Cursors
19181: CURSOR l_disbdtls_csr(cp_line_id IN NUMBER) IS