APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKC_LINE_STYLE_SOURCES

Line 3461: , okc_line_style_sources lss

3457: select count(1)
3458:
3459: from okc_k_items cim
3460: , okc_k_lines_b cle
3461: , okc_line_style_sources lss
3462: , okc_line_styles_b lse
3463: where nvl(lss.start_date,sysdate) <= sysdate
3464: and nvl(lss.end_date,sysdate + 1) > sysdate
3465: and lse.id = lss.lse_id

Line 3480: , okc_line_style_sources lss

3476: CURSOR get_item_csr(p_chr_id NUMBER, p_cle_id NUMBER) IS
3477: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
3478: from okc_k_items cim
3479: , okc_k_lines_b cle
3480: , okc_line_style_sources lss
3481: , okc_line_styles_b lse
3482: where nvl(lss.start_date,sysdate) <= sysdate
3483: and nvl(lss.end_date,sysdate + 1) > sysdate
3484: and lse.id = lss.lse_id

Line 5034: , okc_line_style_sources lss

5030: select count(1)
5031:
5032: from okc_k_items cim
5033: , okc_k_lines_b cle
5034: , okc_line_style_sources lss
5035: , okc_line_styles_b lse
5036: where nvl(lss.start_date,sysdate) <= sysdate
5037: and nvl(lss.end_date,sysdate + 1) > sysdate
5038: and lse.id = lss.lse_id

Line 5054: , okc_line_style_sources lss

5050:
5051: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
5052: from okc_k_items cim
5053: , okc_k_lines_b cle
5054: , okc_line_style_sources lss
5055: , okc_line_styles_b lse
5056: where nvl(lss.start_date,sysdate) <= sysdate
5057: and nvl(lss.end_date,sysdate + 1) > sysdate
5058: and lse.id = lss.lse_id