DBA Data[Home] [Help]

APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKL_SYS_ACCT_OPTS

Line 373: FROM okl_sys_acct_opts;

369: ORDER BY ste.stream_element_date;
370:
371: /* CURSOR l_sec_rep_method_csr IS
372: SELECT secondary_rep_method
373: FROM okl_sys_acct_opts;
374: l_sec_rep_method VARCHAR2(30);
375: */
376: lx_rep_product OKL_PRODUCTS_V.NAME%TYPE;
377: lx_rep_product_id NUMBER;

Line 1581: FROM okl_sys_acct_opts;

1577: --sechawla 9-mar-09 MG Impact on IA
1578: -- Get secondary_rep_method
1579: /* CURSOR l_sec_rep_method_csr IS
1580: SELECT secondary_rep_method
1581: FROM okl_sys_acct_opts;
1582: l_sec_rep_method VARCHAR2(30);
1583: */
1584: lx_rep_product OKL_PRODUCTS_V.NAME%TYPE;
1585: lx_rep_product_id NUMBER;

Line 2965: FROM okl_sys_acct_opts;

2961:
2962: --sechawla 10-mar-09 MG Impact
2963: CURSOR l_sec_rep_method_csr IS
2964: SELECT secondary_rep_method
2965: FROM okl_sys_acct_opts;
2966:
2967:
2968: CURSOR accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE) IS
2969: SELECT ste.id

Line 4137: SELECT secondary_rep_method FROM okl_sys_acct_opts;

4133:
4134: --sechawla 10-mar-09 MG Impact
4135: CURSOR l_sec_rep_method_csr
4136: IS
4137: SELECT secondary_rep_method FROM okl_sys_acct_opts;
4138: CURSOR accrued_streams_csr(p_khr_id NUMBER, p_sty_code VARCHAR2, p_date DATE)
4139: IS
4140: SELECT ste.id
4141: FROM OKL_STRM_TYPE_B sty,