DBA Data[Home] [Help]

APPS.OKL_ACC_CALL_PVT dependencies on OKL_STRM_TYPE_B

Line 422: FROM okl_strm_type_b

418:
419: --Start code changes for rev rec by fmiao on 10/05/2004
420: CURSOR l_get_accrual_csr (cp_sty_id IN NUMBER) IS
421: SELECT NVL(accrual_yn, '1')
422: FROM okl_strm_type_b
423: WHERE id = cp_sty_id;
424:
425: -- stmathew BUG#4547180/ 4573599 start
426: CURSOR l_dstrs_count_csr (cp_source_id IN NUMBER, cp_source_table IN VARCHAR2) IS

Line 433: l_rev_rec_basis okl_strm_type_b.accrual_yn%type;

429: WHERE source_id = cp_source_id
430: AND source_table = cp_source_table;
431: -- stmathew BUG#4547180/ 4573599 end
432:
433: l_rev_rec_basis okl_strm_type_b.accrual_yn%type;
434: l_count NUMBER;
435: --End code changes for rev rec by fmiao on 10/05/2004
436:
437: --Bug# 4488818: Changes for Upfront Tax Billing: Start

Line 1843: FROM okl_strm_type_b

1839:
1840: --Start code changes for rev rec by fmiao on 10/05/2004
1841: CURSOR l_get_accrual_csr (cp_sty_id IN NUMBER) IS
1842: SELECT NVL(accrual_yn, '1')
1843: FROM okl_strm_type_b
1844: WHERE id = cp_sty_id;
1845:
1846: -- stmathew BUG#4547180/ 4573599 start
1847: CURSOR l_dstrs_count_csr (cp_source_id IN NUMBER, cp_source_table IN VARCHAR2) IS

Line 1854: l_rev_rec_basis okl_strm_type_b.accrual_yn%type;

1850: WHERE source_id = cp_source_id
1851: AND source_table = cp_source_table;
1852: -- stmathew BUG#4547180/ 4573599 end
1853:
1854: l_rev_rec_basis okl_strm_type_b.accrual_yn%type;
1855: l_count NUMBER;
1856: --End code changes for rev rec by fmiao on 10/05/2004
1857:
1858: --Bug# 4488818: Changes for Upfront Tax Billing: Start