APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKL_SUBSIDIES_B

Line 1966: okl_subsidies_b subb

1962: subb.maximum_subsidy_amount maximum_subsidy_amount
1963: from okc_k_lines_b sub_cle,
1964: okl_k_lines sub_kle,
1965: okl_k_lines ast_kle,
1966: okl_subsidies_b subb
1967: where subb.id = sub_kle.subsidy_id
1968: and ast_kle.id = sub_cle.cle_id
1969: and sub_kle.id = sub_cle.id
1970: and sub_cle.id = p_subsidy_cle_id

Line 2867: from okl_subsidies_b subb,

2863: ,subb.termination_refund_basis termination_refund_basis
2864: ,subb.refund_formula_id refund_formula_id
2865: ,subb.receipt_method_code receipt_method_code
2866: ,subb.customer_visible_yn customer_visible_yn
2867: from okl_subsidies_b subb,
2868: okc_k_lines_b sub_cleb,
2869: okc_k_lines_tl sub_clet,
2870: okl_k_lines sub_kle,
2871: okc_k_party_roles_b cplb,

Line 3046: from okl_subsidies_b subb,

3042:
3043: --cursor to fetch all the subsidies attached to financial asset
3044: cursor l_sub_csr(p_asset_cle_id in number) is
3045: select sub_cle.id
3046: from okl_subsidies_b subb,
3047: okl_k_lines sub_kle,
3048: okc_k_lines_b sub_cle,
3049: okc_line_styles_b sub_lse
3050: where subb.id = sub_kle.subsidy_id

Line 3843: okl_subsidies_b subb,

3839: from
3840: okl_k_lines sub_kle,
3841: okc_k_lines_b sub_cle,
3842: okc_line_styles_b sub_lse,
3843: okl_subsidies_b subb,
3844: okc_k_party_roles_b sub_vend,
3845: okc_k_party_roles_b asst_vend,
3846: okc_k_lines_b model_cle,
3847: okc_line_styles_b model_lse,

Line 4065: okl_subsidies_b subb,

4061: sub_cle.dnz_chr_id
4062: from okl_k_lines sub_kle,
4063: okc_k_lines_b sub_cle,
4064: okc_line_styles_b sub_lse,
4065: okl_subsidies_b subb,
4066: okc_k_party_roles_b sub_vend,
4067: okc_k_party_roles_b asst_vend,
4068: okc_k_lines_b model_cle,
4069: okc_line_styles_b model_lse,

Line 7397: from okl_subsidies_b subb

7393:
7394: --cursor to read subsidy setup
7395: cursor l_tsfr_basis_csr (p_subsidy_id in number) is
7396: select subb.transfer_basis_code
7397: from okl_subsidies_b subb
7398: where id = p_subsidy_id;
7399:
7400: l_transfer_basis okl_subsidies_b.transfer_basis_code%TYPE;
7401: Begin

Line 7400: l_transfer_basis okl_subsidies_b.transfer_basis_code%TYPE;

7396: select subb.transfer_basis_code
7397: from okl_subsidies_b subb
7398: where id = p_subsidy_id;
7399:
7400: l_transfer_basis okl_subsidies_b.transfer_basis_code%TYPE;
7401: Begin
7402:
7403: x_return_status := OKL_API.G_RET_STS_SUCCESS;
7404: -- Call start_activity to create savepoint, check compatibility