77: , line.id line_id
78: FROM
79: OKC_K_GRPINGS okg
80: ,OKC_K_PARTY_ROLES_B okp
81: ,OKC_K_HEADERS_B Hdr
82: ,OKC_STATUSES_B st
83: ,OKC_K_LINES_B line
84: Where Hdr.scs_code = 'SUBSCRIPTION'
85: And Hdr.Template_yn = 'N'
106: CURSOR chr_csr_no_para IS
107: SELECT hdr.id id
108: , line.id line_id
109: FROM
110: OKC_K_HEADERS_B Hdr
111: ,OKC_STATUSES_B st
112: ,OKC_K_LINES_B line
113: Where Hdr.scs_code = 'SUBSCRIPTION'
114: And Hdr.Template_yn = 'N'
356: count(*) total
357: From
358: OKC_K_GRPINGS okg
359: ,OKC_K_PARTY_ROLES_B okp
360: ,OKC_K_HEADERS_B Hdr
361: ,OKC_STATUSES_B ST
362: Where Hdr.scs_code = 'SUBSCRIPTION'
363: And Hdr.Template_yn = 'N'
364: And Hdr.sts_code = st.CODE
380: avg(hdr.id) avgid,
381: stddev(hdr.id) stdid,
382: count(*) total
383: From
384: OKC_K_HEADERS_B Hdr
385: ,OKC_STATUSES_B ST
386: Where Hdr.scs_code = 'SUBSCRIPTION'
387: And Hdr.Template_yn = 'N'
388: And Hdr.sts_code = st.CODE