APPS.OKL_PROP_TAX_ADJ_PVT dependencies on OKC_K_HEADERS_B

Line 66: okc_k_headers_b khr,

62: SELECT NVL(SUM(ste.amount),0) amount
63: FROM okl_strm_elements ste,
64: okl_streams stm,
65: okl_strm_type_v sty,
66: okc_k_headers_b khr,
67: okl_k_headers khl,
68: okc_k_lines_b kle,
69: okc_statuses_b khs,
70: okc_statuses_b kls

Line 97: okc_k_headers_b khr,

93: SELECT NVL(SUM(ste.amount),0) amount
94: FROM okl_strm_elements ste,
95: okl_streams stm,
96: okl_strm_type_v sty,
97: okc_k_headers_b khr,
98: okl_k_headers khl,
99: okc_k_lines_b kle,
100: okc_statuses_b khs,
101: okc_statuses_b kls

Line 120: FROM okc_k_headers_b khr,

116: AND kls.code (+) = kle.sts_code
117: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
118: UNION
119: SELECT NVL(SUM(til.amount),0) amount
120: FROM okc_k_headers_b khr,
121: okl_trx_ar_invoices_v tai,
122: okl_txl_ar_inv_lns_v til,
123: okl_strm_type_v sty
124: WHERE khr.id = p_khr_id

Line 157: l_prev_contract okc_k_headers_b.contract_number%TYPE;

153: l_stm_id NUMBER;
154: l_max_line_num NUMBER;
155: l_actual_tax_count NUMBER;
156: l_adjust_flag okc_rules_b.rule_information3%TYPE;
157: l_prev_contract okc_k_headers_b.contract_number%TYPE;
158: l_display_contract okc_k_headers_b.contract_number%TYPE;
159:
160: -- -------------------------------------------------
161: -- Streams Record

Line 158: l_display_contract okc_k_headers_b.contract_number%TYPE;

154: l_max_line_num NUMBER;
155: l_actual_tax_count NUMBER;
156: l_adjust_flag okc_rules_b.rule_information3%TYPE;
157: l_prev_contract okc_k_headers_b.contract_number%TYPE;
158: l_display_contract okc_k_headers_b.contract_number%TYPE;
159:
160: -- -------------------------------------------------
161: -- Streams Record
162: -- -------------------------------------------------