APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_SUBSIDIES_B

Line 6298: FROM okl_subsidies_b subb,

6294: --smoduga modified to set 0 when sub_kle.amount is null
6295: -- passing accounting method as input parameter
6296: CURSOR l_sub_csr(c_contract_id IN NUMBER,c_accounting_method IN VARCHAR2) IS
6297: SELECT NVL(SUM(NVL(sub_kle.subsidy_override_amount, sub_kle.amount)),0)
6298: FROM okl_subsidies_b subb,
6299: okl_k_lines sub_kle,
6300: okc_k_lines_b sub_cle,
6301: okc_line_styles_b sub_lse
6302: WHERE subb.id = sub_kle.subsidy_id

Line 6313: l_accounting_method okl_subsidies_b.accounting_method_code%TYPE;

6309: AND subb.customer_visible_yn = 'Y'
6310: ;
6311:
6312: -- START: cklee bug#4437995 if p_accounting_method has G_MISS then make it NULL
6313: l_accounting_method okl_subsidies_b.accounting_method_code%TYPE;
6314: -- END: cklee bug#4437995 if p_accounting_method has G_MISS then make it NULL
6315: l_subsidy_cle_id NUMBER;
6316: BEGIN
6317:

Line 10049: okl_subsidies_b sub,

10045: --TO_NUMBER(sgn.value) sty_id
10046: sub_kle.sty_id sty_id, /* Bug 6353756 */
10047: top_cle.dnz_chr_id chr_id
10048: FROM --okl_sgn_translations sgn,
10049: okl_subsidies_b sub,
10050: okl_k_lines sub_kle,
10051: okc_k_lines_b sub_cle,
10052: okc_k_lines_b top_cle
10053: WHERE --sgn.jtot_object1_code = 'OKL_STRMTYP'

Line 14813: FROM okl_subsidies_b subb,

14809: CURSOR l_sub_csr(p_contract_id IN NUMBER,
14810: p_fin_asset_line_id IN NUMBER,
14811: p_accounting_method IN VARCHAR2) IS
14812: SELECT NVL(SUM(sub_kle.amount),0)
14813: FROM okl_subsidies_b subb,
14814: okl_k_lines sub_kle,
14815: okc_k_lines_b sub_cle,
14816: okc_line_styles_b sub_lse
14817: WHERE subb.id = sub_kle.subsidy_id

Line 14828: l_accounting_method okl_subsidies_b.accounting_method_code%TYPE;

14824: AND sub_cle.cle_id = p_fin_asset_line_id
14825: AND subb.customer_visible_yn = 'Y'
14826: ;
14827:
14828: l_accounting_method okl_subsidies_b.accounting_method_code%TYPE;
14829: l_subsidy_cle_id NUMBER;
14830:
14831: BEGIN
14832:

Line 14933: FROM okl_subsidies_b subb,

14929: CURSOR l_sub_csr(p_contract_id IN NUMBER,
14930: p_fin_asset_line_id IN NUMBER,
14931: p_accounting_method IN VARCHAR2) IS
14932: SELECT NVL(SUM(sub_kle.subsidy_override_amount),0)
14933: FROM okl_subsidies_b subb,
14934: okl_k_lines sub_kle,
14935: okc_k_lines_b sub_cle,
14936: okc_line_styles_b sub_lse
14937: WHERE subb.id = sub_kle.subsidy_id

Line 14948: l_accounting_method okl_subsidies_b.accounting_method_code%TYPE;

14944: AND sub_cle.cle_id = p_fin_asset_line_id
14945: AND subb.customer_visible_yn = 'Y'
14946: ;
14947:
14948: l_accounting_method okl_subsidies_b.accounting_method_code%TYPE;
14949: l_subsidy_cle_id NUMBER;
14950:
14951: BEGIN
14952: