APPS.OKL_ACCRUAL_SEC_PVT dependencies on OKC_K_HEADERS_B

Line 180: FROM okc_k_headers_b k,

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

Line 229: FROM okc_k_headers_b

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

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

941: l_revenue_share NUMBER := 0;
942: l_sty_id NUMBER;
943:
944: stream_type_purpose VARCHAR2(30);
945: l_khr_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;
946: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := NULL;
947: /*
948: l_investor_rental_accrual CONSTANT VARCHAR2(2000) := 'INVESTOR RENTAL ACCRUAL';
949: l_investor_pre_tax_income CONSTANT VARCHAR2(2000) := 'INVESTOR PRE-TAX INCOME';

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

942: l_sty_id NUMBER;
943:
944: stream_type_purpose VARCHAR2(30);
945: l_khr_num OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;
946: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := NULL;
947: /*
948: l_investor_rental_accrual CONSTANT VARCHAR2(2000) := 'INVESTOR RENTAL ACCRUAL';
949: l_investor_pre_tax_income CONSTANT VARCHAR2(2000) := 'INVESTOR PRE-TAX INCOME';
950: l_investor_interest_income CONSTANT VARCHAR2(2000) := 'INVESTOR INTEREST INCOME';

Line 1053: FROM OKC_K_HEADERS_B K,

1049: CURSOR get_adv_arr_csr(p_khr_id NUMBER, p_kle_id NUMBER)
1050: IS
1051: SELECT decode(sll.rule_information10, NULL, 'N', 'Y', 'Y', 'N') arrears_yn,
1052: decode(sll.object1_id1, 'A',12,'S',6,'Q',3,'M',1) frequency
1053: FROM OKC_K_HEADERS_B K,
1054: OKC_RULE_GROUPS_B RG,
1055: OKC_RULES_B SLH,
1056: OKC_RULES_B SLL,
1057: OKL_STRM_TYPE_B STRM

Line 1109: FROM OKC_K_HEADERS_B

1105: -- cursor to get contract number
1106: CURSOR contract_number_csr (p_khr_id NUMBER) IS
1107: SELECT contract_number,
1108: scs_code
1109: FROM OKC_K_HEADERS_B
1110: WHERE id = p_khr_id;
1111:
1112:
1113: