APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKC_LINE_STYLE_SOURCES

Line 3477: , okc_line_style_sources lss

3473: select count(1)
3474:
3475: from okc_k_items cim
3476: , okc_k_lines_b cle
3477: , okc_line_style_sources lss
3478: , okc_line_styles_b lse
3479: where nvl(lss.start_date,sysdate) <= sysdate
3480: and nvl(lss.end_date,sysdate + 1) > sysdate
3481: and lse.id = lss.lse_id

Line 3496: , okc_line_style_sources lss

3492: CURSOR get_item_csr(p_chr_id NUMBER, p_cle_id NUMBER) IS
3493: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
3494: from okc_k_items cim
3495: , okc_k_lines_b cle
3496: , okc_line_style_sources lss
3497: , okc_line_styles_b lse
3498: where nvl(lss.start_date,sysdate) <= sysdate
3499: and nvl(lss.end_date,sysdate + 1) > sysdate
3500: and lse.id = lss.lse_id

Line 5050: , okc_line_style_sources lss

5046: select count(1)
5047:
5048: from okc_k_items cim
5049: , okc_k_lines_b cle
5050: , okc_line_style_sources lss
5051: , okc_line_styles_b lse
5052: where nvl(lss.start_date,sysdate) <= sysdate
5053: and nvl(lss.end_date,sysdate + 1) > sysdate
5054: and lse.id = lss.lse_id

Line 5070: , okc_line_style_sources lss

5066:
5067: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
5068: from okc_k_items cim
5069: , okc_k_lines_b cle
5070: , okc_line_style_sources lss
5071: , okc_line_styles_b lse
5072: where nvl(lss.start_date,sysdate) <= sysdate
5073: and nvl(lss.end_date,sysdate + 1) > sysdate
5074: and lse.id = lss.lse_id