APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_STRM_TYPE_V

Line 1360: l_stream_type_name OKL_STRM_TYPE_V.NAME%TYPE := NULL;

1356: l_var_int_schedule_defined BOOLEAN := FALSE;
1357:
1358: --Added by bkatraga for bug 14111538
1359: l_var_int_amount_non_zero BOOLEAN := FALSE;
1360: l_stream_type_name OKL_STRM_TYPE_V.NAME%TYPE := NULL;
1361:
1362: --Added OKL_STRM_TYPE_V and stty.name by bkatraga for bug 13478101
1363: CURSOR l_pmnt_strm_hdr(
1364: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

Line 1362: --Added OKL_STRM_TYPE_V and stty.name by bkatraga for bug 13478101

1358: --Added by bkatraga for bug 14111538
1359: l_var_int_amount_non_zero BOOLEAN := FALSE;
1360: l_stream_type_name OKL_STRM_TYPE_V.NAME%TYPE := NULL;
1361:
1362: --Added OKL_STRM_TYPE_V and stty.name by bkatraga for bug 13478101
1363: CURSOR l_pmnt_strm_hdr(
1364: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
1365: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
1366: chrId NUMBER) IS

Line 1382: OKL_STRM_TYPE_V stty

1378: crl.RULE_INFORMATION11,
1379: stty.name
1380: FROM OKC_RULE_GROUPS_B crg,
1381: OKC_RULES_B crl,
1382: OKL_STRM_TYPE_V stty
1383: WHERE stty.id = crl.object1_id1
1384: AND stty.stream_type_purpose IN (
1385: 'RENT', 'PRINCIPAL_PAYMENT', 'VARIABLE_INTEREST_SCHEDULE',
1386: 'LOAN_PAYMENT'

Line 1458: l_rent_strm_name OKL_STRM_TYPE_V.NAME%TYPE;

1454: l_frequency OKC_RULES_B.OBJECT1_ID1%TYPE;
1455: l_factor NUMBER := 0;
1456: l_pymnt_end_date DATE := NULL;
1457: l_rent_amt_zero BOOLEAN := FALSE;
1458: l_rent_strm_name OKL_STRM_TYPE_V.NAME%TYPE;
1459: l_principal_basis OKL_K_RATE_PARAMS.PRINCIPAL_BASIS_CODE%TYPE;
1460: l_contract_end_date DATE;
1461: l_var_int_strm_name OKL_STRM_TYPE_V.NAME%TYPE;
1462:

Line 1461: l_var_int_strm_name OKL_STRM_TYPE_V.NAME%TYPE;

1457: l_rent_amt_zero BOOLEAN := FALSE;
1458: l_rent_strm_name OKL_STRM_TYPE_V.NAME%TYPE;
1459: l_principal_basis OKL_K_RATE_PARAMS.PRINCIPAL_BASIS_CODE%TYPE;
1460: l_contract_end_date DATE;
1461: l_var_int_strm_name OKL_STRM_TYPE_V.NAME%TYPE;
1462:
1463: CURSOR get_principal_basis(p_khr_id NUMBER) IS
1464: SELECT PRINCIPAL_BASIS_CODE
1465: FROM OKL_K_RATE_PARAMS

Line 4369: FROM okl_strm_type_v strm,

4365: --Bug#3931587
4366: CURSOR stream_csr (p_slh_id VARCHAR2) IS
4367: SELECT strm.stream_type_purpose
4368: --SELECT strm.name
4369: FROM okl_strm_type_v strm,
4370: okc_rules_b rule
4371: WHERE rule.id = p_slh_id
4372: AND rule.rule_information_category = 'LASLH'
4373: AND rule.object1_id1 = strm.id;

Line 4422: l_strm_type okl_strm_type_v.name%TYPE;

4418: AND rule2.rgp_id = rgp.id
4419: AND rule2.object2_id1 = rule.object2_id1
4420: );
4421:
4422: l_strm_type okl_strm_type_v.name%TYPE;
4423:
4424: BEGIN
4425:
4426: x_return_status := Okl_Api.G_RET_STS_SUCCESS;