DBA Data[Home] [Help]

APPS.OKC_LSQ_PVT dependencies on OKC_K_SEQ_HEADER

Line 60: from okc_k_seq_header

56: p_lsqv_rec IN lsqv_rec_type) is
57:
58: /* cursor c (p_line_code okc_k_seq_lines.line_code%TYPE) is
59: select 'x'
60: from okc_k_seq_header
61: where line_code = p_line_code;
62: This cursor will be replaced by the fnd_document */
63: l_dummy Varchar2(1);
64: l_row_notfound Boolean := False;

Line 658: CURSOR cur_ksq (p_line_code OKC_K_SEQ_HEADER.LINE_CODE%TYPE) is

654: p_lsqv_rec IN lsqv_rec_type
655: ) RETURN VARCHAR2 IS
656:
657: -- Cursor to get all the header information
658: CURSOR cur_ksq (p_line_code OKC_K_SEQ_HEADER.LINE_CODE%TYPE) is
659: SELECT SITE_YN,
660: BG_OU_NONE,
661: CLS_SCS_NONE,
662: USER_FUNCTION_YN,

Line 664: FROM OKC_K_SEQ_HEADER

660: BG_OU_NONE,
661: CLS_SCS_NONE,
662: USER_FUNCTION_YN,
663: PDF_ID
664: FROM OKC_K_SEQ_HEADER
665: WHERE LINE_CODE = p_line_code;
666:
667: -- Cursor to make sure there is only 1 detail for site
668: CURSOR cur_lsq is