APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_SUBSIDIES_B

Line 6896: FROM okl_subsidies_b subb,

6892: --smoduga modified to set 0 when sub_kle.amount is null
6893: -- passing accounting method as input parameter
6894: CURSOR l_sub_csr(c_contract_id IN NUMBER,c_accounting_method IN VARCHAR2) IS
6895: SELECT NVL(SUM(NVL(sub_kle.subsidy_override_amount, sub_kle.amount)),0)
6896: FROM okl_subsidies_b subb,
6897: okl_k_lines sub_kle,
6898: okc_k_lines_b sub_cle,
6899: okc_line_styles_b sub_lse
6900: WHERE subb.id = sub_kle.subsidy_id

Line 6911: l_accounting_method okl_subsidies_b.accounting_method_code%TYPE;

6907: AND subb.customer_visible_yn = 'Y'
6908: ;
6909:
6910: -- START: cklee bug#4437995 if p_accounting_method has G_MISS then make it NULL
6911: l_accounting_method okl_subsidies_b.accounting_method_code%TYPE;
6912: -- END: cklee bug#4437995 if p_accounting_method has G_MISS then make it NULL
6913: l_subsidy_cle_id NUMBER;
6914: BEGIN
6915:

Line 10906: okl_subsidies_b sub,

10902: --TO_NUMBER(sgn.value) sty_id
10903: sub_kle.sty_id sty_id, /* Bug 6353756 */
10904: top_cle.dnz_chr_id chr_id
10905: FROM --okl_sgn_translations sgn,
10906: okl_subsidies_b sub,
10907: okl_k_lines sub_kle,
10908: okc_k_lines_b sub_cle,
10909: okc_k_lines_b top_cle
10910: WHERE --sgn.jtot_object1_code = 'OKL_STRMTYP'

Line 16045: FROM okl_subsidies_b subb,

16041: CURSOR l_sub_csr(p_contract_id IN NUMBER,
16042: p_fin_asset_line_id IN NUMBER,
16043: p_accounting_method IN VARCHAR2) IS
16044: SELECT NVL(SUM(sub_kle.amount),0)
16045: FROM okl_subsidies_b subb,
16046: okl_k_lines sub_kle,
16047: okc_k_lines_b sub_cle,
16048: okc_line_styles_b sub_lse
16049: WHERE subb.id = sub_kle.subsidy_id

Line 16060: l_accounting_method okl_subsidies_b.accounting_method_code%TYPE;

16056: AND sub_cle.cle_id = p_fin_asset_line_id
16057: AND subb.customer_visible_yn = 'Y'
16058: ;
16059:
16060: l_accounting_method okl_subsidies_b.accounting_method_code%TYPE;
16061: l_subsidy_cle_id NUMBER;
16062:
16063: BEGIN
16064:

Line 16165: FROM okl_subsidies_b subb,

16161: CURSOR l_sub_csr(p_contract_id IN NUMBER,
16162: p_fin_asset_line_id IN NUMBER,
16163: p_accounting_method IN VARCHAR2) IS
16164: SELECT NVL(SUM(sub_kle.subsidy_override_amount),0)
16165: FROM okl_subsidies_b subb,
16166: okl_k_lines sub_kle,
16167: okc_k_lines_b sub_cle,
16168: okc_line_styles_b sub_lse
16169: WHERE subb.id = sub_kle.subsidy_id

Line 16180: l_accounting_method okl_subsidies_b.accounting_method_code%TYPE;

16176: AND sub_cle.cle_id = p_fin_asset_line_id
16177: AND subb.customer_visible_yn = 'Y'
16178: ;
16179:
16180: l_accounting_method okl_subsidies_b.accounting_method_code%TYPE;
16181: l_subsidy_cle_id NUMBER;
16182:
16183: BEGIN
16184: