DBA Data[Home] [Help]

APPS.OKL_LA_PAYMENTS_PVT dependencies on OKL_STRM_TYPE_B

Line 221: okl_strm_type_b sty,

217: CURSOR c_principal_pymts_yn(p_chr_id IN NUMBER) IS
218: SELECT 'Y'
219: FROM okc_rule_groups_b rgp,
220: okc_rules_b rul,
221: okl_strm_type_b sty,
222: okc_k_lines_b cle
223: WHERE rgp.rgd_code = 'LALEVL'
224: AND rgp.dnz_chr_id = p_chr_id
225: AND rul.dnz_chr_id = rgp.dnz_chr_id

Line 628: OKL_STRM_TYPE_B STRM

624: cursor PAYMENT_TYPE_CSR(P_SLH_ID IN VARCHAR2) is
625: -- SELECT STRM.CODE
626: SELECT STRM.STREAM_TYPE_PURPOSE
627: FROM OKC_RULES_B RUL,
628: OKL_STRM_TYPE_B STRM
629: WHERE RUL.ID = TO_NUMBER(P_SLH_ID)
630: AND STRM.ID = TO_NUMBER(RUL.OBJECT1_ID1);
631:
632: BEGIN

Line 2569: x_primary_sty_id okl_strm_type_b.ID%TYPE;

2565: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
2566: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
2567:
2568: -- x_return_status varchar2(1);
2569: x_primary_sty_id okl_strm_type_b.ID%TYPE;
2570:
2571: /*
2572: *CURSOR VIR_PAYMENT (P_CHR_ID IN NUMBER) IS
2573: *SELECT 'Y', K.TERM_DURATION

Line 3396: x_primary_sty_id okl_strm_type_b.ID%TYPE;

3392: l_slh_id OKC_RULES_V.ID%TYPE := OKL_API.G_MISS_NUM;
3393: l_rgp_id OKC_RULE_GROUPS_V.ID%TYPE := OKL_API.G_MISS_NUM;
3394: l_cle_id OKC_K_LINES_B.ID%TYPE := OKL_API.G_MISS_NUM;
3395:
3396: x_primary_sty_id okl_strm_type_b.ID%TYPE;
3397:
3398: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
3399: l_interest_calculation_basis VARCHAR2(30);
3400: l_revenue_recognition_method VARCHAR2(30);