APPS.OKS_TAX_UTIL_PVT dependencies on OKC_K_LINES_B

Line 58: FROM OKC_K_LINES_B

54: CLE_ID,
55: --npalepu added lse_id for bug # 5223699
56: LSE_ID
57: --end npalepu
58: FROM OKC_K_LINES_B
59: WHERE dnz_chr_id = p_chr_id
60: AND id = p_line_id
61: AND chr_id IS NOT NULL;
62:

Line 1250: FROM OKC_K_LINES_B

1246: AND b.chr_id = a.id;
1247:
1248: CURSOR cur_okc_lines(cp_chr_id IN NUMBER) IS
1249: SELECT CUST_ACCT_ID
1250: FROM OKC_K_LINES_B
1251: WHERE CHR_ID = cp_chr_id;
1252:
1253: l_batch_source_id NUMBER;
1254: l_legal_entity_id NUMBER;

Line 1552: FROM okc_k_lines_b

1548: PRICE_NEGOTIATED,
1549: --npalepu added start_date on 28-jun-2006 for bug # 5223699
1550: START_DATE
1551: --end npalepu
1552: FROM okc_k_lines_b
1553: WHERE dnz_chr_id = p_chr_id
1554: AND lse_id IN (7, 8, 9, 10, 11, 13, 18, 25, 35)
1555: AND id = cp_sub_line_id;
1556: SUB_LINE_REC cur_sub_lines%ROWTYPE;

Line 1607: l_subline_start_date okc_k_lines_b.start_date%TYPE;

1603: l_need_header_tax VARCHAR2(1);
1604: l_op_unit_name hr_all_organization_units_tl.name%TYPE; --Bug 5036523 hr_operating_units.name%TYPE;
1605:
1606: --npalepu added on 28-jun-2006 for bug # 5223699
1607: l_subline_start_date okc_k_lines_b.start_date%TYPE;
1608: --end npalepu
1609:
1610: --npalepu added on 11-jul-2006 for bug # 5380881
1611: CURSOR Cur_Batch_Source_Id(p_org_id IN NUMBER)