APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKC_K_HEADERS_B

Line 182: FROM okc_k_headers_b k,

178: p_kle_id NUMBER)
179: IS
180: SELECT DECODE(sll.rule_information10, NULL, 'N', 'Y', 'Y', 'N') arrears_yn,
181: DECODE(sll.object1_id1, 'A',12,'S',6,'Q',3,'M',1) frequency
182: FROM okc_k_headers_b k,
183: okc_rule_groups_b rg,
184: okc_rules_b slh,
185: okc_rules_b sll,
186: okl_strm_type_b strm

Line 231: FROM okc_k_headers_b

227: -- cursor to get contract number
228: CURSOR contract_number_csr (p_khr_id NUMBER)
229: IS
230: SELECT contract_number
231: FROM okc_k_headers_b
232: WHERE id = p_khr_id
233: AND scs_code = 'LEASE';
234: -- cursor to get investor Agreement contract id
235: -- for a given Lease contract id

Line 1410: l_khr_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;

1406: l_revenue_share NUMBER := 0;
1407: l_sty_id NUMBER;
1408:
1409: stream_type_purpose VARCHAR2(30);
1410: l_khr_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;
1411: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := NULL;
1412: /*
1413: l_investor_rental_accrual CONSTANT VARCHAR2(2000) := 'INVESTOR RENTAL ACCRUAL';
1414: l_investor_pre_tax_income CONSTANT VARCHAR2(2000) := 'INVESTOR PRE-TAX INCOME';

Line 1411: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := NULL;

1407: l_sty_id NUMBER;
1408:
1409: stream_type_purpose VARCHAR2(30);
1410: l_khr_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;
1411: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := NULL;
1412: /*
1413: l_investor_rental_accrual CONSTANT VARCHAR2(2000) := 'INVESTOR RENTAL ACCRUAL';
1414: l_investor_pre_tax_income CONSTANT VARCHAR2(2000) := 'INVESTOR PRE-TAX INCOME';
1415: l_investor_interest_income CONSTANT VARCHAR2(2000) := 'INVESTOR INTEREST INCOME';

Line 1518: FROM OKC_K_HEADERS_B K,

1514: CURSOR get_adv_arr_csr(p_khr_id NUMBER, p_kle_id NUMBER)
1515: IS
1516: SELECT decode(sll.rule_information10, NULL, 'N', 'Y', 'Y', 'N') arrears_yn,
1517: decode(sll.object1_id1, 'A',12,'S',6,'Q',3,'M',1) frequency
1518: FROM OKC_K_HEADERS_B K,
1519: OKC_RULE_GROUPS_B RG,
1520: OKC_RULES_B SLH,
1521: OKC_RULES_B SLL,
1522: OKL_STRM_TYPE_B STRM

Line 1574: FROM OKC_K_HEADERS_B

1570: -- cursor to get contract number
1571: CURSOR contract_number_csr (p_khr_id NUMBER) IS
1572: SELECT contract_number,
1573: scs_code
1574: FROM OKC_K_HEADERS_B
1575: WHERE id = p_khr_id;
1576:
1577: --sechawla 9-mar-09 MG Impact on IA
1578: -- Get secondary_rep_method

Line 4176: FROM OKC_K_HEADERS_B K,

4172: CURSOR get_adv_arr_csr(p_khr_id NUMBER, p_kle_id NUMBER)
4173: IS
4174: SELECT DECODE(sll.rule_information10, NULL, 'N', 'Y', 'Y', 'N') arrears_yn,
4175: DECODE(sll.object1_id1, 'A',12,'S',6,'Q',3,'M',1) frequency
4176: FROM OKC_K_HEADERS_B K,
4177: OKC_RULE_GROUPS_B RG,
4178: OKC_RULES_B SLH,
4179: OKC_RULES_B SLL,
4180: OKL_STRM_TYPE_B STRM