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 1298: FROM OKC_K_LINES_B

1294: AND b.chr_id = a.id;
1295:
1296: CURSOR cur_okc_lines(cp_chr_id IN NUMBER) IS
1297: SELECT CUST_ACCT_ID
1298: FROM OKC_K_LINES_B
1299: WHERE CHR_ID = cp_chr_id;
1300:
1301: l_batch_source_id NUMBER;
1302: l_legal_entity_id NUMBER;

Line 1600: FROM okc_k_lines_b

1596: PRICE_NEGOTIATED,
1597: --npalepu added start_date on 28-jun-2006 for bug # 5223699
1598: START_DATE
1599: --end npalepu
1600: FROM okc_k_lines_b
1601: WHERE dnz_chr_id = p_chr_id
1602: AND lse_id IN (7, 8, 9, 10, 11, 13, 18, 25, 35)
1603: AND id = cp_sub_line_id;
1604: SUB_LINE_REC cur_sub_lines%ROWTYPE;

Line 1655: l_subline_start_date okc_k_lines_b.start_date%TYPE;

1651: l_need_header_tax VARCHAR2(1);
1652: l_op_unit_name hr_all_organization_units_tl.name%TYPE; --Bug 5036523 hr_operating_units.name%TYPE;
1653:
1654: --npalepu added on 28-jun-2006 for bug # 5223699
1655: l_subline_start_date okc_k_lines_b.start_date%TYPE;
1656: --end npalepu
1657:
1658: --npalepu added on 11-jul-2006 for bug # 5380881
1659: CURSOR Cur_Batch_Source_Id(p_org_id IN NUMBER)